Re: Drop Index takes longer in Prod than in Test

look at statspack for the affected time period, see if anything pops out.

Else you are stuck with tracing - i dont seem the problem in enabling it, multi tiered isnt a problem, just start a trace at the database level

On 13/09/06, Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com> wrote:
>
> 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.
>

--
http://www.freelists.org/webpage/oracle-l