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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Drop view takes long time => how/where to find why ?

Re: Drop view takes long time => how/where to find why ?

From: David Sharples <davidsharples_at_gmail.com>
Date: Mon, 18 Jul 2005 13:36:57 +0100
Message-ID: <be592d55050718053661780b4c@mail.gmail.com>


well something did change.

What is it waiting on?

On 7/18/05, Prem <premjhere_at_gmail.com> wrote:
> we drop 600 views and it takes 5 ~ 10 mins usually .
> today, inspite of no changes being done , the same job takes about 1 hour.

> How and where can i find , why it takes so long ?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 18 2005 - 07:38:52 CDT

Original text of this message

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