DBA_HIST_ACTIVE_SESS_HISTORY library cache pin waits

  • From: "McPeak, Matt" <vxsmimmcp@xxxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 26 Feb 2014 19:39:53 +0000

Hi,

I have been asked what a process on Monday (2/24) timed out.

Going to DBA_HIST_ACTIVE_SESS_HISTORY, I can see that the process in question 
spent all its time waiting for a library cache pin.

I can see a lot written on how to get more information about current library 
cache pin waits.  But does anyone know how to find out more about a library 
cache pin wait showing up only in ASH?

Thanks in advance!

Matt

Other related posts: