-
How to Interpret TOP SQL
Hi,
I'm using this query in our Prodn database to find the Most Resource Intensive SQL(TOP SQL).
SELECT Substr(a.sql_text,1,50) sql_text,
Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution,
a.buffer_gets,
a.disk_reads,
a.executions,
a.sorts,
a.address
FROM v$sqlarea a
ORDER BY 2 DESC;
Following is the Output of above query -
(select /*+ALL_ROWS */ s . final_cust , g . locid,
1224149,
1169483,
6120749,
5,
21,
238FA568
select /*+ ALL_ROWS*/ s . final_cust , g . locid ,
4687,
369533,
4687,
1,
3,
237EE8E8
But I'm unable to interpret the output. Can some advice how to understand this data...
Thanks.
Soma
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|