Oracle para perranganos
Thursday, September 15, 2011
Which SQL are using excesive i/O
SELECT *
FROM
(SELECT parsing_schema_name, direct_writes, SUBSTR(sql_text,1,75), disk_reads
FROM v$sql
ORDER BY disk_reads DESC)
WHERE rownum < 20;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment