As it's statspack output, which gathers system-wide statistics, some other sessions could be contributing to these stats too. Check whether the rdbms ipc reply wait events parameter1 value is the same as Oracle PID (not SPID) of CKPT's session. If it is, then your session is waiting for CKPT. Tanel. _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Khemmanivanh, Somckit Sent: Friday, September 15, 2006 01:01 To: Tanel Poder; mwf@xxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: Drop Index takes longer in Prod than in Test Tanel, I think you found it. Here's a 12 minute statspack report's top Timed Events during the time period of the drop index slowdown. Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Ela Time -------------------------------------------- ------------ ----------- -------- CPU time 1,094 39.63 rdbms ipc reply 8,549 927 33.59 enqueue 772 404 14.63