7.1 The Monitoring Overview Page

Availability icon Available only if you signed in as a database user with DBA and PDB_DBA roles.

The Monitoring Overview page displays general information about the database.

To navigate to the Overview page, click Selector Selectorto see the navigation pane, click the down arrow to expand Monitoring, and then click Overview.

The widgets on this page show snapshot information about the database status, online database storage, sessions, wait events, user accounts, alerts, and expiring passwords. Click a widget to go to its page where you can see a more detailed view of the data.

  • Database Status: Shows the status of the database.

  • Used Online Database Storage: Displays how much storage is being used by the database. You can click the title to open The Storage Page.

  • Sessions: Displays the number of sessions by session status. You can click the title to open The Sessions Page.

  • Waits: Displays how many wait events are occurring in the database by wait event class. When you click the title:

    • For Oracle Database 19c and later releases, the Performance Hub page is displayed.

    • For Oracle Database 18c and previous releases, the Activity-Waits page is displayed.

  • Users: Displays how many user accounts are in the open, locked and expired statuses. You can hover over a status to see a list of the user accounts with that status.

    • Open: This status indicates that the user’s account is unlocked and access to the database is enabled.

    • Locked: This status indicates that the user’s account is locked and access to the database is disabled. The account must be unlocked to enable access to the database.

    • Expired: This status indicates that the user’s password has expired and must be changed before the user can log in to the database.

  • Alerts: Displays a summary of alerts over the last 7 days. You can click the title to open The Alerts Page

  • Expiring Passwords: Shows a list of user accounts and whether a user account password has expired or the number of days before it will expire.