Understand each field of AWR [ID 884046.1]
Cursor_sharing force - Prompted by a recent ODC (OTN) question I’ve just written up an example of one case where setting the cursor_sharing parameter to force doesn’t work as you...
Acum 15 ore
This problem is introduced in 220.127.116.11 . Shortly after or during instance startup in RAC, one or many of the instances end up in a hang state waiting for a LB or NB DLM resource. Rediscovery Notes: - RAC on 18.104.22.168 - a hang occurs shortly after instance startup where there is no blocking session to be found from system state or hang analysis - Alert messages like below may be seen; "ORA-32701: Possible hangs up to hang ID=0 detected"
This bug is fixed in 22.214.171.124.1 ( 11GR2 patchset 1, PSU1 )