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.
 
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


 

Other related posts: