method_opt parameter in oraclr 9i nd 10g
Hi all,
I need to know the global level preference set for method_opt parameter on the database for oracle 9i and oracle 10g.
Like in Oracle 11g we can query the following query
=================================================================
SELECT DBMS_STATS.GET_PREFS(PNAME=>'METHOD_OPT') FROM DUAL;
=================================================================
and we can find out whether there is global level preference set for the method_opt parameter which determines whether histogram will get created on the columns or not.
Any help in this direction is appreciated.
Regards,
Rohan
I need to know the global level preference set for method_opt parameter on the database for oracle 9i and oracle 10g.
Like in Oracle 11g we can query the following query
=================================================================
SELECT DBMS_STATS.GET_PREFS(PNAME=>'METHOD_OPT') FROM DUAL;
=================================================================
and we can find out whether there is global level preference set for the method_opt parameter which determines whether histogram will get created on the columns or not.
Any help in this direction is appreciated.
Regards,
Rohan
0