Re: dropping indexes
- From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
- To: haroon.qureshi@xxxxxxxxx
- Date: Thu, 12 Aug 2010 20:04:52 -0400
Can you provide the wait events for the long running index drop? That
should give you the insight you need to determine why it's taking so long.
On Thu, Aug 12, 2010 at 6:16 PM, Haroon Qureshi <haroon.qureshi@xxxxxxxxx>wrote:
> Hello,
>
> I have two indentical partitioned tables. The volume of data is the
> same in both tables and the indexes are identical as well. When I
> drop the indexes (all of them) on the tables, one of the tables takes
> less than 5 minutes to do so (about 30 indexes). The other table
> would take about 20 minutes to do so.
>
> Can anyone help explain this or point me in the right direction to
> figure out what is going on?
>
> Thanks in advance for your help.
>
> Haroon
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Rumpi Gravenstein
Other related posts:
