Previous Next JavaScript must be enabled to correctly display this content

## 5.15 Monitoring the Database

The reports available on the Database Monitor page provide a database-wide view of the database sessions, system statistics, SQL statements, and longer operations.

You can use these reports to identify poorly performing SQL and to better understand the workload of the database.

Tip:

To access any of the icons on the Database Monitor page, you must have a database account that has been granted a database administrator (DBA) role.

- About Database Monitor Access Requirements
  Ensure that your account has the database administrator (DBA) role, Database Monitoring is enabled in the instance, and your user name is uppercase at sign-in.
- Accessing Session Page Reports
  A session is the connection of a user to an Oracle database instance.
- System Statistics
  Displays the System Statistics page statistics.
- Viewing System Statistics
  Learn how to view the System Statistics page.
- About Top SQL Page
  The top SQL statements represent the SQL statements that are executed most often, that use more system resources than other SQL statements, or that use system resources more frequently than other SQL statements.
- Viewing Top SQL Page
  Use the Top SQL page to identify poorly performing SQL.
- About Long Operations Page
  The Long Operations page displays the status of various operations that run for longer than 6 seconds (in absolute time).
- Viewing the Long Operations Page
  Learn how to view the Long Operations page.

Parent topic: Using SQL Workshop Utilities