Skip to main content

Oracle_SchemaChanges Job

The Oracle_SchemaChanges Job is designed to provide detailed information about changes in schema across all database objects.

Analysis Tasks for the Oracle_SchemaChanges Job​

Navigate to the Oracle > 2.Activity > Oracle_SchemaChanges > 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 Schema Change Details – Highlights activity involving schema changes in the audited Oracle Instances. Creates the SA_Oracle_SchemaChange_Details table accessible under the job’s Results node.
  • Schema Change Summary – Summarizes schema changes per instance. Creates the SA_Oracle_SchemaChange_Summary table accessible under the job’s Results node.

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

ReportDescriptionDefault TagsReport Elements
Schema Change ActivityThis report lists all schema change related Oracle events, and summarizes them by instance.NoneThis report is comprised of three elements: - Bar Chart – Displays top instances by schema change activity - Table –  Provides details on instances by schema change activity - Table – Provides details on schema change details