SQL> show parameter OPTIMIZER_FEATURES_ENABLE
user4924437 wrote:Known problem - lack of statistics on a few of the X$ structures.
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.