Skip to main content

Oracle_Logons Job

The Oracle_Logons Job is designed to provide insight into failed and successful Oracle database login activity across all targeted Oracle database servers.

Analysis Tasks for the Oracle_Logons Job

Navigate to the Oracle > 2.Activity > Oracle_Logons > Configure node and select Analysis to view the analysis tasks.

CAUTION: Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Oracle Logons – Reports on all Oracle logon events. Creates the SA_Oracle_Logons_Details table accessible under the job’s Results node.
  • Logons Summary – Provides a summary of logons by Instance. Creates the SA_Oracle_Logons_Summary table accessible under the job’s Results node.

In addition to the tables and views created by the analysis tasks, the Oracle_Logons Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Logon SummaryThis report outlines successful and failed logins over the last 30 daysNoneThis report is comprised of three elements: - Bar Chart – Displays top instances by failed logons - Table – Provides details on logon summary - Table – Provides details on logon details