Locate important (resource-consuming) SQL statements

Locate important (resource-consuming) SQL statements
the
1. statspack– capture the 15-minute report when the business on your library is the busiest, and look at the top sql inside
1 top Find the pid that consumes more resources
the
2 Determine whether it is an oracle application process or a background process
the
3 Locate according to v$session, v$process, v$sqlarea
the
Top session with oem www.2cto.com
the
SELECT hash_value, executions, buffer_gets, disk_reads, parse_calls
the
FROM V$SQLAREA
the
WHERE buffer_gets > 10000000 OR disk_reads > 1000000
ORDER BY buffer_gets + 100 * disk_reads DESC
the
Author Guo Xuepeng