ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
In alert log, below entries were found:
Deprecated system parameters with specified values:
log_archive_start
Fix: alter system reset log_archive_start scope=spfile sid='*' ;
======
Performance Tunning with SPFILE
alter system set processes=20000 scope=spfile;
alter system set open_cursors=8000 scope=spfile;
alter system set pga_aggregate_target=13G scope=spfile;
alter system set sga_target=11G scope=spfile;
alter system set sga_max_size=11G scope=spfile;
alter system set memory_target=24G scope=spfile;
alter system set memory_max_target=24G scope=spfile;
alter system set recyclebin=OFF scope=spfile;
alter system set filesystemio_options=setall scope=spfile;
begin
for c in (select sid, serial# from v$session) loop
dbms_system.set_int_param_in_session(c.sid,c.serial#,'session_cached_cursors', 200);
end loop;
end;
/
No comments:
Post a Comment