Understand each field of AWR [ID 884046.1]
opt_estimate 2 - This is a note that was supposed to be a follow-up to an initial example of using the opt_estimate() hint to manipulate the optimizer’s statistical underst...
Acum 9 ore
This problem is introduced in 22.214.171.124 . 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 126.96.36.199 - 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 188.8.131.52.1 ( 11GR2 patchset 1, PSU1 )