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