The customized SQL feature provides the capability to define and run your own SQL-based monitoring with the Oracle Database Extended agent.
The customized SQL feature supports only SELECT statements that you can run in an on-demand mode or at an interval.
The SQL_ID variable is case sensitive, and can consist of uppercase letters (A-Z), lowercase letters (a-z), the underscore character (_), and the hyphen (-).
If multiple SELECTSQL entries exist with the same SQL_ID, only the last entry takes effect.
For the SQL_TEXT variable, only SELECT statements are supported. INSERT, UPDATE, or DELETE statements are not supported.
The SQL_TEXT variable supports multiple lines and valid Oracle double dash comment characters (--).
SQL statements can be executed in an on-demand mode or in an interval mode.
SQL statements can be executed in an interval mode by creating a situation. To execute the SQL statements at a regular interval, create a situation for the KRZ RDB CUSTOMIZED SQL DETAIL attribute group.
(SQL ID == 'DualTest') OR SQL ID == 'EMPTEST' OR SQL ID == 'JOBTEST'
Select the interval you want to use for the situation. The SQL ID matches the SQL ID variable that is defined in the krzcussql.properties file. After starting the situation, the SQL statements run by situation interval.