Re: Enq: ST contention during loading of tables

From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Fri, 7 Oct 2011 13:27:01 +0800
Message-ID: <CAM_ddu_vPTN-r3Q6aj+RaTkLqXoK8C_Jx9y-xKeLFzmdn7JqHw_at_mail.gmail.com>

how the table is partitioned, range/list/hash or composite? segment space management of the tablespace is Auto or Manual? bigger extent size may help the huge data loading.

please post the insert sql and 10046 trace for analyis.

On Fri, Oct 7, 2011 at 10:26 AM, dd yakkali <dd.yakkali_at_gmail.com> wrote:

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

-- 
Regards
Sidney Chen


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

Received on Fri Oct 07 2011 - 00:27:01 CDT