select max(sql_text) sql_text
, sum(sharable_mem) sharable_mem
, sum(sorts) sorts
, min(module) module
, sum(loaded_versions) loaded_versions
, sum(executions) executions
, sum(loads) loads
, sum(invalidations) invalidations
, sum(parse_calls) parse_calls
, sum(disk_reads) disk_reads
, sum(buffer_gets) buffer_gets
, sum(rows_processed) rows_processed
, address address
, hash_value hash_value
, count(1) version_count
from v$sql
group by hash_value, address
SELECT MAX(SQL_TEXT) SQL_TEXT
, SUM(SHARABLE_MEM) SHARABLE_MEM
, SUM(SORTS) SORTS
, MIN(MODULE) MODULE
, SUM(LOADED_VERSIONS) LOADED_VERSIONS
, SUM(EXECUTIONS) EXECUTIONS
, SUM(LOADS) LOADS
, SUM(INVALIDATIONS) INVALIDATIONS
, SUM(PARSE_CALLS) PARSE_CALLS
, SUM(DISK_READS) DISK_READS
, SUM(BUFFER_GETS) BUFFER_GETS
, SUM(ROWS_PROCESSED) ROWS_PROCESSED
, ADDRESS ADDRESS
, HASH_VALUE HASH_VALUE
, COUNT(1) VERSION_COUNT
FROM V$SQL
GROUP BY HASH_VALUE
, ADDRESS
|
|
|