c oracle 数组参数,19c-19c数据库参数调整

SELECT a.ksppinm "Parameter", b.ksppstvl

"Session Value", c.ksppstvl "Instance Value"

FROM x$ksppi a, x$ksppcv b, x$ksppsv

c

WHERE a.indx = b.indx AND a.indx =

c.indx

AND

SUBSTR(ksppinm,1,1)='_'

ORDER BY a.ksppinm;

alter system set db_file_multiblock_read_count=32 scope=spfile

sid='*';

alter system set max_dump_file_size = '500M' scope=spfile

sid='*';

alter system set "_memory_imm_mode_without_autosga"=FALSE

scope=spfile sid='*';

alter system set job_queue_processes=100 scope=spfile

sid='*';

alter system set DB_FILES=4096 scope=spfile sid='*';

alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS'

scope=spfile sid='*';

alter system set open_cursors=3000 scope=spfile sid='*';

alter system set open_links_per_instance=48 scope=spfile

sid='*';

alter system set open_links=100 scope=spfile sid='*';

alter system set parallel_max_servers=20 scope=spfile

sid='*';

alter system set session_cached_cursors=200 scope=spfile

sid='*';

alter system set undo_retention=10800 scope=spfile

sid='*';

alter system set "_undo_autotune"=false scope=spfile

sid='*';

alter system set "_partition_large_extents"=false scope=spfile

sid='*';

alter system set "_use_adaptive_log_file_sync"=false

scope=spfile sid='*';

alter system set "_optimizer_use_feedback"=false scope=spfile

sid='*';

alter system set deferred_segment_creation=false scope=spfile

sid='*';

alter system set "_external_scn_logging_threshold_seconds"=600

scope=spfile sid='*';

alter system set "_external_scn_rejection_threshold_hours"=24

scope=spfile sid='*';

alter system set result_cache_max_size=0 scope=spfile

sid='*';

alter system set "_cleanup_rollback_entries"=2000 scope=spfile

sid='*';

alter system set parallel_force_local=true scope=spfile

sid='*'; --rac

alter system set "_gc_policy_time"=0 scope=spfile

sid='*';

alter system set "_clusterwide_global_transactions"=false

scope=spfile sid='*';

alter system set "_library_cache_advice"=false scope=both

sid='*';

alter system set db_cache_advice=off scope=both sid='*';

alter system set filesystemio_options=setall scope=spfile

sid='*';

alter system set fast_start_mttr_target=300 scope=spfile

sid='*';

alter profile default limit

PASSWORD_LIFE_TIME UNLIMITED;

alter profile ORA_STIG_PROFILE

limit PASSWORD_LIFE_TIME UNLIMITED;

begin

DBMS_AUTO_TASK_ADMIN.DISABLE(

client_name => 'sql tuning

advisor',

operation => NULL,

window_name => NULL);

end;

/

begin

DBMS_AUTO_TASK_ADMIN.DISABLE(

client_name => 'auto space

advisor',

operation => NULL,

window_name => NULL);

end;

/