Displaying Resources Used by a Database

View disk usage, running processes, unused indexes, and devices and segments associated with a database.

1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
2. In the left pane, select Databases.
   You can also display the Databases screen by clicking a Databases link from a different window in the monitor view.
3. Select a database in the Databases table.
   The tabs at the bottom of the screen are populated with information on the database you selected.

   Note: When you select a database, space usage is calculated before any data is shown; for a large database, this calculation may take 30 seconds or more.
4. Click a tab to see information about the resource you are interested in:
   • Details – shows disk usage, including the size of reserved and unreserved data and log segments.
   • Running Processes – shows the server process ID (spid), login, host, command, and transaction for each process that is currently using the database. Each spid number is a link; click it to see more information about that process.
   • Devices Used – shows the size and usage allocation (data or log) for each device that provides storage for this database. Each device name is a link; click it to see more information about that device.
   • Segments Used – shows the size and unused portion of each segment, in megabytes. Each segment name is a link; click it to see more information about that segment.
   • Unused Indexes – shows the name and table of each unused index.
   • Frequently Used Tables – shows usage statistics for frequently used tables.