Working on Windows NT 4.0 + Oracle 8i
When starting my database I get these warning messages:
ORA-25138: SEQUENCE_CACHE_ENTRIES initialization parameter has been made obsolete
ORA-25138: SEQUENCE_CACHE_HASH_BUCKETS initialization parameter has been made obsolete
ORA-25138: SNAPSHOT_REFRESH_PROCESSES initialization parameter has been made obsolete
select name, isspecified from v$obsolete_parameter;
In order to confirm this. And, in effect, I have these three parameters into my init.ora:
sequence_cache_entries = 10
snapshot_refresh_processes = 1
sequence_cache_hash_buckets = 10
I would be extremely obliged if anybody could help me about the steps I must follow or if it's not important.
Comment out those entries in init.ora and bounce your db.
As these params are made obsolete from 8.1.5, you can ignore these errors (in the alert log also) as the db starts 'ok'; or better still remove them from your init.ora.
The ISSPECIFIED Column is set to TRUE if any of these parameters has been set in v$OBSOLETE_PARAMETER.