Re: Enq: ST contention during loading of tables

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Thu, 6 Oct 2011 17:07:56 +0100
Message-ID: <CAPMSPxNGjyGMgvS=-66X6b8NaROzXbbPUObhyUzBaNaSGs6AWg_at_mail.gmail.com>

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_at_gmail.com> 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

Received on Thu Oct 06 2011 - 11:07:56 CDT