DBA_HIST_ACTIVE_SESS_HISTORY library cache pin waits
From: McPeak, Matt <vxsmimmcp_at_subaru.com>
Date: Wed, 26 Feb 2014 19:39:53 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE7D2A8471_at_S7041VA005.soa.soaad.com>
Hi,
Date: Wed, 26 Feb 2014 19:39:53 +0000
Message-ID: <D7864FA3E7830B428CB2A5A5301B63EE7D2A8471_at_S7041VA005.soa.soaad.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 26 2014 - 20:39:53 CET