1. Using Oracle Database Actions for On-Premises Oracle Database
  2. The Monitoring Pages
  3. The Logins Page

8.4 The Logins Page

Note:

Available only if the following three conditions are met:

  • You are signed in as a database user with DBA and PDB_DBA roles for Oracle Database 12c and later releases.

  • Auditing is enabled in the database.

  • At least one of the four actions displayed on the Logins page must have an audit policy that is enabled. By default, Failed Logins is enabled.

The Logins page shows the number of successful logins, failed logins, timed-out logoffs, and logoffs that have occurred within the last hour.

To navigate to the Logins page, do either of the following:

  • In the Launchpad page, click Logins.

  • Click Selectorselector iconto display the navigation menu. Under Monitoring, select Logins.

The Last Hour Statistics widget only displays the actions being audited. If any of the tabs (succesful logins, failed logins, timedout logoffs or logoffs) are disabled, the database is currently not auditing that action. If you want to activate the action, you must create an audit policy with the desired action. To create an audit policy, see Auditing Activities.

Click a tab in Last Hour Statistics to view the corresponding entries in the table.

Figure 8-2 Tabs in Last Hour Statistics

Description of Figure 8-2 follows
Description of "Figure 8-2 Tabs in Last Hour Statistics"

You can search for results in the table by entering values in the Column, Operator and Value fields and clicking Filter Filter. You can also filter by selecting one or more of the available filter options for each action.

Click Refresh Refresh to refresh the data in the grid.

The following figure shows the three filters for the Failed Logins action.

Figure 8-3 Filters for Failed Logins

Description of Figure 8-3 follows
Description of "Figure 8-3 Filters for Failed Logins"

To return to the previous page, remove filters by clicking Remove Filter Remove Filter or refresh the browser.