Re: RE: enq: TM contention
- From: Thomas Roach <troach@xxxxxxxxx>
- To: rajaram.subramanian@xxxxxxxxx
- Date: Fri, 16 Dec 2011 17:01:28 -0500
How about actually trying to find the SQL waiting on this wait? That might
tell you something. Also, do you know who is holding the lock? What is that
process running? That should give you a much better idea what the problem
is.
On Fri, Dec 16, 2011 at 4:38 PM, Rajaram Subramanian <
rajaram.subramanian@xxxxxxxxx> wrote:
> One other possibility which I have experienced is performing direct path
> insert on a table when there is already an existing uncommitted transaction
> on the same table and a direct path insert has been performed. In my case
> I was able to resolve it by explicitly inserting to the subpartition.
> Regards
>
> Sent from Yahoo! Mail on Android
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Thomas Roach
813-404-6066
troach@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
