Oracle Database Parameters

This page documents how the pattern creates the Oracle Parameters detail node.

The pattern runs the following query to determine the audit mode:

  • SELECT name, value FROM v$parameter

The pattern sets the attribute of audit_mode to true or false based on the value of the record where the name is “audit_sys_operations”.

The pattern runs the following query to determine the log mode:

  • SELECT * FROM v$database

The pattern sets the value of log_mode based on the value of log_mode in the first returned entry.

All other attributes are obtained by parsing the name, and value pairs of the following query:

  • SELECT * FROM v$database

If database queries fail, the pattern attempts to get the same information from the <ora_home>/dbs/spfile<sid>.ora file.

Typically, the following attributes are reported:

  • archivelog_compression
  • cdb
  • con_dbid
  • controlfile_type
  • database_role
  • dataguard_broker
  • db_unique_name
  • dbid
  • force_logging
  • flashback_on
  • fs_failover_current_target
  • guard_status
  • log_archive_dest_<number>
  • log_mode
  • open_mode
  • protection_level
  • remote_archive
  • primary_db_unique_name
  • protection_mode
  • switchover_status

The pattern creates a Detail node with a key based of the Detail node (“Oracle Parameters”) and the related Oracle SoftwareInstance key.

Was this page helpful? Yes No Submitting... Thank you