Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Drop Index takes longer in Prod than in Test

Drop Index takes longer in Prod than in Test

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Wed, 13 Sep 2006 10:16:31 -0700
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B9022F1B4F@wafedixm10.corp.weyer.pri>


Hi,  

We have a DW nightly load that drops indexes as part of the load.  

The index drops can sometimes take minutes in prod -- whereas as test of the same drop, in the test environment, takes seconds. Now minutes might not seem like much, but there are many indexes so the times add up.  

I can't easily enable tracing on the Oracle side (prod server, multi-tiered env, etc...) so I'm looking for some tips for where/what else I can look for.  

Oh, the other constraint is that I can't modify the DW load process -- so I'm restricted solely to looking at the Oracle side.  

Your help is much appreciated.  

Thank you!

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 13 2006 - 12:16:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US