HOW TO find disk intensive SQLThis is a featured page

Platform: Oracle App:
Tool:
DB Ver: 9.2 App Ver:
Tool Ver:
Revision Date: 29-Nov-2005 Keywords: HOWTO, PERFORMANCE

Goal
Find SQL that have unusually large numbers of disk reads

Facts


Solution
The following script will find SQL with many disk reads:

-- ------------------------
-- Find SQL Statements that
-- require a lot of disk
-- reads.
-- ------------------------
SELECT *
FROM v$sql
WHERE 1=1
AND disk_reads / (0.001 + executions) > 10000
/



consultium
consultium 		Latest page update: made by consultium , Oct 7 2009, 3:59 AM EDT (about this update About This Update consultium Edited by consultium


view changes
- complete history)
Keyword tags: None
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.