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...