IBM Tivoli Composite Application Manager for Applications, Version 7.2.1

Configuring Top SQL monitoring

The Top SQL workspace is used to monitor the Oracle Top SQL statements. All four columns must be specified as filters in the situation or historical collection.

Specify the following four filters:

Begin Hour Before Current: The hour before the current time for the begin time. v value is equal to 2.
End Hour Before Current: The hour before the current time for the end time. The sample value is equal to 0.
Order By: The sorting column for the Top SQL. All candidate values are listed in Table 1.
Row Order: The order of the SQL statements. The sample value is less than 21 for the Top 20 SQL statements.

Table 1. All valid Order By values for the Top SQL monitoring
Workspace	Order By value
Top SQL by Elapse Time	elapse_time_delta
Top SQL by CPU Time	cpu_time_delta
Top SQL by buffer gets	buffer_gets_delta
Top SQL by disk reads	disk_reads_delta
Top SQL by executions	executions_delta
Top SQL by parse calls	parse_calls_delta
Top SQL by sharable memory	sharable_mem
Top SQL by version count	version_count
Top SQL by cluster wait	clwait_delta

Historical collection example:

Figure 1. Sample filter setting in the historical collection configure panel

Situation example:

Figure 2. Sample Formula setting in the situation configure panel

Feedback