Hi all,
I am a newbie to Oracle database administration.
I would like to remove the below mentioned obsolete parameters from my Oracle 10g database (wih SAP).
nls_length_semantics
db_file_multiblock_read_count
remote_os_authent
optimizer_features_enable
optimizer_mode
optimizer_index_caching
optimizer_dynamic_sampling
FIXCONTROL
I have tried the syntax "alter system reset <parameter> scope=<both|spfile|memory> sid='SID'; "
but this didn't work and the database is still showing the old default values for these obsolete parameters.
Can you please let me know the correct syntax/steps for this?
with regards,
Raja