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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
1,979 views