12 lines
434 B
SQL
12 lines
434 B
SQL
SELECT ROUND(AVG(count(1))) "Avg Record (#)/ Snap"
|
|
FROM stats$sql_summary ss,
|
|
stats$statspack_parameter sp
|
|
WHERE (ss.EXECUTIONS > sp.EXECUTIONS_TH * 1
|
|
OR ss.parse_calls > sp.PARSE_CALLS_TH * 1
|
|
OR ss.disk_reads > sp.DISK_READS_TH * 1
|
|
OR ss.buffer_gets > sp.BUFFER_GETS_TH * 1
|
|
OR ss.sharable_mem > sp.SHARABLE_MEM_TH * 1
|
|
OR ss.version_count > sp.VERSION_COUNT_TH * 1
|
|
)
|
|
group by snap_id;
|