Re: Convert table into partitioned table (Fast)

On Mar 6, 11:13 pm, mc..._at_hotmail.com wrote:
> > The writes to the controlfile to indicate
> > it was an unrecoverable operation were taking about 30-40% of our
> > total elapsed time. Once we set it, we gained all that time back.
>
> What event name was it waiting on....?

Hi,

IIRC, it was control file sequential read and control file parallel write, but I would check for any event like 'control file%'

HTH, Steve Received on Fri Mar 07 2008 - 06:42:01 CST