Enq: ST contention during loading of tables
- From: dd yakkali <dd.yakkali@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 6 Oct 2011 08:39:15 -0700
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
