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.
07-05-2002, 04:20 AM
Comment out those entries in init.ora and bounce your db.
07-05-2002, 04:22 AM
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.