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.
Related tasks
Determining the Backup Status of a Database
Displaying Information About Segments Used by a Database
Related reference
Database Statistics and Details