On Wed, Apr 24, 2002 at 05:33:25AM -0800, Connor McDonald wrote: > 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
It doesn't. What should I be seeing from the stats, if you don't mind elaborating? Sorry, just a little slow on the uptake, but very interested. =============================================================== Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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).
