If you were logged in you would be able to see more operations.
|
|
|
Product Version: |
10.1.0.3
|
Operating System: |
Generic
|
Other than SYSDBA, no new connections allowed to the database.
|
Description
|
Other than SYSDBA, no new connections allowed to the database. |
Show » |
|
An excerpt from SYSTEMSTATE dump:
The SYSTEMSTATE dump was generated in USER_DUMP_DEST as below:
There are many sessions in SYSTEMSTATE dump waiting for enq: SQ - contention as below:
The blocking session(0x4234f5b68):
Problem interpretation:
The blocker session waited for a RAC related wait event named gc cr request for the same file# and block#. Unfortunately, at the time of the problem happened, no SYSTEMSTATE dumps were generated for the other nodes. So, it was not possible to diagnose the root blocker on the other node to find why it holds same buffer too long.
The sessions were waiting for SQ enqueue on SYS.AUDSES$ sequence. During connection, the value of V$SESSION.AUDSID is obtained from SYS.AUDSES$ sequence. SYSDBA doesn't use this sequence in connection. So, it was not blocked.
Solution:
The default cache size of SYS.AUDSES$ was 20. It has been increased to 1000.