The SQL control table (oraEffSQLControlTable) provides a mechanism to determine the least efficient SQL statements that are running on a given database instance. The oraEffSQLControlTable enables you to select the database instance you want to monitor by specifying the InstanceIdx parameter. This value corresponds to the index in the oraInstanceTable for the database instance that you wish to monitor.
The SortBy parameter enables you to select one of four variables to use for sorting the results in the oraEffSQLDataTable. The RequestSize parameter allows you to specify the number of top SQL statements that you want displayed in the oraEffSQLDataTable.
Table 1 lists the row objects in oraEffSQLControlTable.
Object |
Description |
---|---|
ActivateTime |
The time that this entry was activated. |
DataControl |
Controls the monitoring status of the control row: on(1) - Monitoring is enabled off(2) - Monitoring is disabled |
Description |
A description for this entry. |
GrantedSize |
The maximum number of SQL statements that will be retrieved. |
Index |
The unique index for this entry. |
InstanceIdx |
The index of the oracle instance that will be monitored. |
Owner |
The owner of this entry. |
RequestSize |
The desired maximum number of statements to retrieve. |
SampleInterval |
The interval at which the agent polls the instance for SQL statements. |
SortBy |
The parameter that will be used to sort SQL statements to determine those that are least efficient. |
Status |
The SNMPv2 row status for this entry. |
StmtType |
Currently all statement types are monitored. |