How to Interpret TOP SQL
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,
FROM v$sqlarea a
ORDER BY 2 DESC;
Following is the Output of above query -
(select /*+ALL_ROWS */ s . final_cust , g . locid,
select /*+ ALL_ROWS*/ s . final_cust , g . locid ,
But I'm unable to interpret the output. Can some advice how to understand this data...
From Qsoft ?
You can use Enterprise manager tool, and can use top session utility, where u will find good details, and sorting options.
Dilip, ATUL LTD.
Catch me online at Yahoo: ddpatel256
Basically I want to know what exactly these values mean and is there any bench mark to say the resources consumed is high, moderate or low etc.,
Also on what basis we infer that some queries require fine tuning and some not required etc.,
Click Here to Expand Forum to Full Width