Thats fine for expensive sql...but waits can be a whole lot more than that...
(Trivial example) session 1: delete from blah where x = 1; session 2: delete from blah where x = 1; session 3: delete from blah where x = 1; etc The wait stats will quickly show up the problem here... hth connor --- Greg Moore <[EMAIL PROTECTED]> wrote: > There's something I don't understand. Why use the > wait interface to investigate "db file scattered > read" or "db file sequential read"? > > The end result is finding an SQL statement that does > a lot of reads. There's no guarantee it's a poorly > tuned SQL statement, just that it does a lot of > reads. > > If that's what you want, why not just query v$sql > and order by physical reads? Doing this is a whole > lot easier. Also, unlike the hit and miss results > from v$session_wait, v$sql provides a comprehensive > picture. > > Thanks for your input. Cheers! > > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).