RE: Drop Index takes longer in Prod than in Test

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Fri, 15 Sep 2006 23:55:52 +0800
Message-id: <038301c6d8df$6cc9d0f0$06000100@windows01>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Khemmanivanh, Somckit
Sent: Friday, September 15, 2006 01:01
To: Tanel Poder; mwf_at_rsiz.com; oracle-l_at_freelists.org 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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Sep 15 2006 - 10:55:52 CDT