Hi,
Some sessions are waiting for 'library cache: mutex X' for long time. So I debug the database to find out which session is the holder?
Here is the trace.
| 0: waiting for 'library cache: mutex X' |
| idn=0xba56464a, value=0x5e200000000, where=0x6a |
| wait_id=139522 seq_num=8453 snap_id=1 |
| wait times: snap=8 min 22 sec, exc=8 min 22 sec, total=8 min 22 sec |
| wait times: max=infinite, heur=5300 min 55 sec |
| wait counts: calls=45564 os=45564 |
| in_wait=1 iflags=0x15b2 |
| There is at least one session blocking this session. |
| Dumping 1 direct blocker(s): |
| inst: 1, sid: 1506, ser: 60066 |
| Dumping final blocker: |
| inst: 1, sid: 1506, ser: 60066 |
| There are 2 sessions blocked by this session. |
SQL> select count(*) from v$session where sid=1506;
COUNT(*)
----------
0
I think the process is died and can't free the resource. So is it possiable to find out the process id associated with the sid 1506?
Thanks,
Siko.