Library cache pin waits

I am see this wait in my database under high load. There are a number of sessions executing identical code. I have session_cache_cursors set to 1000.

So for example I have 10 sessions and they all call

select ename
from emp
where emp_no = :EMPNO;

Does this wait indicate that there is contention when pinning that one SQL statement?

If that is the case then would this make a difference?

select /*some session identifier string*/ ename from emp
where emp_no = :EMPNO;

If not, is there something else to look at to fix the waits. Received on Sat Apr 10 2004 - 19:04:53 CDT