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