select sid, event, p1raw, seconds_in_wait,wait_time
 from v$session_wait
 where event = 'library cache pin'
 and state = 'WAITING';