Re: Enq: ST contention during loading of tables

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Thu, 6 Oct 2011 19:26:00 -0700
Message-ID: <CAJ-BTpwJ=n3MaDmn-NyQqhF=9Xj7j-jZGprVGZ-1FdmLnpXO-w_at_mail.gmail.com>

Pete,
thanks a lot for the tip. Most of my loads are direct path so preallocating does not help much. Also all our tablespaces are LMT big file tablespaces in the order of 15 to 20 Terabytes.

I am curious to understanding how the ST works.

thanks
Deen

On Thu, Oct 6, 2011 at 9:07 AM, Peter Hitchman <pjhoraclel_at_gmail.com> wrote:

> 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
>
>
>

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

Received on Thu Oct 06 2011 - 21:26:00 CDT