RE: Drop Index takes longer in Prod than in Test

  • From: Tanel Poder <tanel.poder.003@xxxxxxx>
  • To: somckit.khemmanivanh@xxxxxxxxxxxxxxxx, mwf@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 15 Sep 2006 23:55:52 +0800

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.


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
~~~~~~~~~~~~~~~~~~                                                     %
Event                                               Waits    Time (s) Ela
-------------------------------------------- ------------ -----------
CPU time                                                        1,094
rdbms ipc reply                                     8,549         927
enqueue                                               772         404


Other related posts: