[Oracle-l] Enq: ST contention during loading of tables

On Thu, Oct 6, 2011 at 4:39 PM, dd yakkali 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

On Thu, Oct 6, 2011 at 9:07 AM, Peter Hitchman 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


--
Regards

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

On Fri, Oct 7, 2011 at 10:26 AM, dd yakkali 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
loads
details

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