Re: Row cache lock wait issue in RAC

Luca,

HWM and extents are not directly related except the fact that HWM is in some extent. So try something like
ALTER TABLE ... ALLOCATE EXTENT;

That won't work for parallel direct loads though, as parallel processes insert data into separate temporary segments, which then are 'assigned' to main segment.

HTH
- Andrey


Luca Canali wrote: 
Hi Dimitre,

I am using direct path insert, which writes above the HWM. I cannot
preallocate space in the table for that.

Regards,
L.

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


Other related posts: