Re: library cache pin waits

In addition to what Mark said:

Check out v$lock. If you have OEM, look at the locking screens it has.

google catblock (and see it on your system in $ORACLE_HOME/rdbms/admin).

What exactly is your code doing? Are you shooting yourself in the foot with too many commits or parallelization? Not using bind variables? Tracing or timed_statistics on (yes, that can make this problem happen, metalink Note:287059.1)?

Are you seeing any errors? How big is your shared pool?

See metalink notes: 34579.1, 2997330.8, 262946.1, 115656.1, 169139.1 (haven't tried it in 9 to see if it works right).

jg

--
@home.com is bogus.
My hero!
http://www.betanews.com/article/CrossSite_Scripting_Worm_Hits_MySpace/1129232391