Re: library cache: mutex x on table and index objects
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 7 Jan 2013 14:30:40 -0000
Message-ID: <43D27B424D61495D9D2F811753CA5101_at_Primary>
Date: Mon, 7 Jan 2013 14:30:40 -0000
Message-ID: <43D27B424D61495D9D2F811753CA5101_at_Primary>
It looks as if this bug may apply:
Bug 9239863 : "LIBRARY CACHE: MUTEX X" FOR OBJECTS HIGHLY CONTENDED FOR - PART I Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Tony Hasler" <tony_at_aberdour.demon.co.uk> To: <oracle-l_at_freelists.org> Sent: Monday, January 07, 2013 1:27 PM Subject: library cache: mutex x on table and index objects
| Folks,
|
|
| I have a multi-threaded JAVA application that repeatedly executes a
PL/SQL
| procedure that in turns calls a static (i.e. not dynamic SQL) MERGE
| statement of the form:
|
|
|
| MERGE INTO t1
|
| USING DUAL
|
| ON (primary_key = :b1)
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 07 2013 - 15:30:40 CET