V$sql and statspack would qualify. :)=20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh Sent: Friday, October 29, 2004 4:28 PM To: oracle-l@xxxxxxxxxxxxx Subject: RESOURCE INTENSIVE QUERIES Does any one know any free tools thru which we can capture more resource intensive queries? thanks _________________________________________________________________ Don't just search. Find. Check out the new MSN Search!=20 http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l