Re: Enq: ST contention during loading of tables
- From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Oct 2011 17:07:56 +0100
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@xxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Regards
Pete
--
//www.freelists.org/webpage/oracle-l
Other related posts:
