Skip to Content
0
May 31, 2011 at 11:43 AM

Note 830576 - Parameter recommendations for Oracle 10g

135 Views

hi all DBA experts.

I am not good familiar with Oracle database while i read a Note 830576 - Parameter recommendations for Oracle 10g. in which SAP General Recommendation:

You should delete obsolete initialization parameters from the profile. 
To determine which obsolete parameters are currently set, proceed as follows:
SQL> SELECT NAME FROM V$OBSOLETE_PARAMETER WHERE ISSPECIFIED = 'TRUE';

when i execute above command then result is no rows selected

while there are many parameters in above SAP Note which are already obsolete and not set in initSID.ora file.

for exp. the parameter OPTIMIZER_INDEX_COST_ADJ is showing

#### OPTIMIZER MODE
#optimizer_index_cost_adj = 10

as you know that this parameter is very important regarding System Performance.

now please guide me . I have to set these parameter or no need while there is not showing any parameters against obsolete command.

waiting you valuable reply.

Regards,