Oracle Server Monitoring And Maintenance Jobs

  AUDITING                  - Monitor what queries are running.
  BLOCKED_PROCESSES  - Monitor Blocked Processes.
  CONFIG_CHANGES       - Audit server configuration changes.
  CACHE_HIT_RATIO      - Monitor Cache Hit Ratio
  CHECK_SERVER_UP      - Verify server availability.
  CHECK_ALERT_LOG      - Check Error Log for errors and warning messages.
  CONFIGURATION          - Generate DDLs for modified configuration parameters only.
  CREATE_TABLESPACE   - Generate DDLs for create tablespace .
  CONNECTIONS_USED    - Monitor maximum number of connections used.
  EXPORT                     - Automate table level exports with option to suffix timestamp.
  IMPORT                     - Automate table level exports with option to suffix timestamp.
  FILELIST                    - Keep track of tablespace files.
  INDEX_CHANGES         - Monitor changes made to index (es).
  INDEX_REBUILD           - Automate index rebuild.
  LONG_RUNNING_TRANS - Monitor long running queries .
  PASSWORD_CHANGES  - Track changed passwords.
  SCHEMA                    - Generate DDLs for schema creation.
  SQL_SCRIPT               - Execute SQL script .
  SERVER_UPTIME          - Monitor how long the server is up.
  SHUTDOWN_SERVER     - Automate server shutdown.
  TOP10_TABLE_GROWTH - Monitor top 10 table growth in terms of size and rows.
  TABLE_CHANGES          - Monitor changes made to the table structure.
  TABLESPACE_GROWTH  - Monitor tablespace growth in terms of size and percentage (%).
  TABLESPACE_FULL        - Monitor current tablespace space usage.
  TBLSPCSIZE_CHANGES  - Audit tablespace size changes.
  UPDATE_STATISTICS    - Automate Update Statistics.