Enq: ST contention during loading of tables

From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Thu, 6 Oct 2011 08:39:15 -0700
Message-ID: <CAJ-BTpzU5i2Wc26i+Mr7d2QuTy375eKG=t_HO3jU_QKyt6HZtA_at_mail.gmail.com>

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

Received on Thu Oct 06 2011 - 10:39:15 CDT