Skip to Main Content

Query on V$lock returns fast with /*+rule*/ hint

user4924437May 2 2013 — edited May 2 2013
Hello,

Below query goes in hang mode if run without /*+rule*/ hint.
By using this hint query returns immediately.

select count(*) from v$Lock;

My database version is 10.2.0.4 and optimizer_mode is ALL_ROWS.
Pls help us to identify why this is happening.

With same database version and optimizer mode query (without hint) runs fine on other databases.



Regards
sysdba
Comments
Post Details
Added on May 2 2013
4 comments
1,687 views