Mark Leith wrote: > > Hi list people :) > > We have a customer who has been running a particular delete statement > against a table for a while now, which usually ran within minutes. All of a > sudden this table has suddenly gone from a few minutes right up to 50! He > wants to diagnose why.. > > Where would you start? > > I have a few ideas of my own - like stale stats, small rollback segments > etc. - but am after some of your advice also before I get back to him > tomorrow morning.. Not sure on the Oracle version, OS, or even amount of > rows he is deleting or size of the table (yet, I'll find this out tomorrow), > but there has to be a pretty standard way of diagnosing this.. > > All help appreciated. > > Mark > > =================================================== > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > ===================================================
'We have done nothing and suddenly it's slow' is a well known tune. Usual suspects : 1) Stats, computed or deleted 2) Dropped index 3) Newly created trigger 4) Locks. Nobody doing DML on the same table during the delete ? -- Regards, Stephane Faroult Oriole Corporation Voice: +44 (0) 7050-696-269 Fax: +44 (0) 7050-696-449 Performance Tools & Free Scripts -------------------------------------------------------------- http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs -------------------------------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).