Skip to Content

Configuring Global Custom Query for monitoring Oracle Enterprise Database

As a system administrator, configure Global Custom Query to manage SQL-based monitoring across environments, eliminating the need for repetitive configurations. This capability improves operational efficiency and streamlines monitoring. 

To configure Global Custom Query for monitoring Oracle Enterprise Database

  1. In BMC Helix Operations Management, select Configuration > Monitor Policies > Create Policy.
  2. Click Add Monitoring Configuration.
  3. From the Monitoring Solution list, select Oracle Enterprise. 
  4. From the Monitor Type list, select Oracle Global. 
  5. Add the monitoring configuration as described in the following table:
FieldDescription
Global ConfigurationExpand Oracle Custom SQL Queries. 
Oracle Custom SQL Queries

Select one of the following options:

  • Oracle Standalone Database
  • Oracle RAC Database
  • Oracle DataGuard Database
  • All (Standalone, RAC, DataGuard)
Oracle Standalone DatabaseExpand Oracle Standalone Database. 
Enable global Custom SQL queriesSelect this checkbox to enable the global custom SQL queries configuration. 
Configuration option

Select one of the following options: 

  • Merge with local configuration— The global SQL queries are added to the existing custom SQL queries across Oracle environments. 
  • Override local configuration— Custom SQL queries override the environment-specific configurations.
Custom SQL Query

Click Add. 

 The following options are available: 

  • Query name— Identifies the purpose of the custom SQL query used for monitoring.
  • SQL query— Defines the specific query to retrieve data from the Oracle database.  
Query nameEnter the SQL query name. 
SQL queryEnter the SQL query.
Collection time (min)

The collection cycle time of the SQL query in minutes. 

Enable number of records annotationSelect this checkbox to annotate the number of records metric with the query result.
Oracle RAC DatabaseExpand Oracle RAC Database.
Enable global Custom SQL queriesSelect this checkbox to enable the global custom SQL queries configuration. 
Configuration option

Select one of the following options: 

  • Merge with local configuration— The global SQL queries are added to the existing custom SQL queries across the Oracle monitoring environments. 
  • Override local configuration— Custom SQL queries override the environment-specific configurations.
Custom SQL QueryClick Add to view the following options: 
  • Query name— Identifies the purpose of the custom SQL query used for monitoring.
  • SQL query— Defines the specific query to retrieve data from the Oracle database.  
Query nameEnter the SQL query name. 
SQL queryEnter the SQL query.
Collection time (min)

The collection cycle time of the SQL query in minutes. 

Enable number of records annotationSelect this checkbox to annotate the number of records metric with the query result.
Oracle DataGuard DatabaseExpand Oracle DataGuard Database.
Enable global Custom SQL queriesSelect this checkbox to enable the global custom SQL queries configuration. 
Configuration option

Select one of the following options: 

  • Merge with local configuration— The global SQL queries are added to the existing custom SQL queries across Oracle environments. 
  • Override local configuration— Custom SQL queries override the environment-specific configurations.
Custom SQL QueryClick Add to view the following options: 
  • Query name— Identifies the purpose of the custom SQL query used for monitoring.
  • SQL query— Defines the specific query to retrieve data from the Oracle database.  
Query nameEnter the SQL query name. 
SQL queryEnter the SQL query.
Collection time (min)

The collection cycle time of the SQL query in minutes. 

Enable number of records annotationSelect this checkbox to annotate the number of records metric with the query result.
All (Standalone, RAC, DataGuard)
Enable global Custom SQL queriesSelect this checkbox to enable the global custom SQL queries configuration. 
Custom SQL QueryClick Add to view the following options: 
  • Query name— Identifies the purpose of the custom SQL query used for monitoring.
  • SQL query— Defines the specific query to retrieve data from the Oracle database.  
Query nameEnter the SQL query name. 
SQL queryEnter the SQL query.
Collection time (min)

The collection cycle time of the SQL query in minutes. 

Enable number of records annotationSelect this checkbox to annotate the number of records metric with the query result.
Additional configuration for DataGuard SQL queriesExpand Additional configuration for DataGuard SQL queries. 
Execute query on

Select one of the following databases to determine where the query is executed: 

  • All database instances— The query is executed on all nodes
  • Primary— The query is executed on the primary database instance
  • Standby— The query is executed on the standby database instance

6. Click Save.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Oracle Enterprise Database 25.4