Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2013
Added on May 2 2013
#general-database-discussions
4 comments
2,068 views