Re: Enq: ST contention during loading of tables

Hi,
Could you work around the problem by pre-allocating extents to the
tables involved?
Sorry no detail on how the ST enque works.

Regards
Pete

On Thu, Oct 6, 2011 at 4:39 PM, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:
> We do a bunch of direct path insert into partitions and also merge loads
> into partitioned tables and we are seeing long waits on ST enq.
>
> 22 node 11.1.0.7 RAC on RHEL5
>
>
> All the tablespaces are LMT.
>
> I want to understand how this enque works, could not get a lot of details
> other than it is a space transaction enq, usually a problem on Non LMT
> tablespaces.
>
> Any details/info is greatly appreciated.
>
>
> thanks
> Deen
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>



-- 
Regards

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


Other related posts: