Oracle 10g和Oracle 11g数据库参数比较

Allen at 2021-12-27 16:57:04 32 0 0 0 0
#0. (Normal)

今天碰到一个问题,比较一下10g和11g的参数:

SELECT * FROM V$PARAMETER
ORDER BY NAME

CREATE TABLE SYDBA.PARM_10G AS SELECT * FROM V$PARAMETER
CREATE TABLE SYDBA.PARM_11G AS SELECT * FROM V$PARAMETER
SELECT * FROM SYDBA.PARM_10G FOR UPDATE
DELETE FROM SYDBA.PARM_10G
--258

SELECT * FROM SYDBA.PARM_10G FOR UPDATE
SELECT * FROM SYDBA.PARM_11G
--351

--新增的参数:104个
SELECT E.NAME,E.TYPE,E.VALUE,E.DISPLAY_VALUE
FROM SYDBA.PARM_10G T,SYDBA.PARM_11G E
WHERE T.NAME(+)=E.NAME AND T.NAME IS NULL
--104

--删除的参数:11个
SELECT t.NAME,t.TYPE,t.VALUE,t.DISPLAY_VALUE
FROM SYDBA.PARM_10G T,SYDBA.PARM_11G E
WHERE T.NAME=E.NAME(+) AND e.NAME IS NULL
--11

--相同的参数:247个
SELECT t.NAME,t.TYPE,t.VALUE,t.DISPLAY_VALUE,e.value,e.display_value
FROM SYDBA.PARM_10G T,SYDBA.PARM_11G E
WHERE T.NAME=E.NAME
--247

合计:258-11+104=351

新增参数104个

NAMETYPEVALUEDISPLAY_VALUE
asm_preferred_read_failure_groups2
awr_snapshot_time_offset300
cell_offload_compaction2ADAPTIVEADAPTIVE
cell_offload_decryption1TRUETRUE
cell_offload_parameters2
cell_offload_plan_display2AUTOAUTO
cell_offload_processing1TRUETRUE
cell_offloadgroup_name2
client_result_cache_lag630003000
client_result_cache_size600
clonedb1FALSEFALSE
commit_logging2
commit_wait2
control_management_pack_access2DIAGNOSTIC+TUNINGDIAGNOSTIC+TUNING
cursor_bind_capture_destination2memory+diskmemory+disk
db_flash_cache_file2
db_flash_cache_size600
db_lost_write_protect2NONENONE
db_securefile2PERMITTEDPERMITTED
db_ultra_safe2OFFOFF
db_unrecoverable_scn_tracking1TRUETRUE
ddl_lock_timeout300
deferred_segment_creation1TRUETRUE
diagnostic_dest2D:ORACLED:ORACLE
dnfs_batch_size340964096
dst_upgrade_insert_conv1TRUETRUE
enable_ddl_logging1FALSEFALSE
enable_goldengate_replication1FALSEFALSE
global_txn_processes311
instant_restore1FALSEFALSE
java_jit_enabled1TRUETRUE
java_restrict2nonenone
ldap_directory_sysauth2nono
listener_networks2
log_archive_dest_112
log_archive_dest_122
log_archive_dest_132
log_archive_dest_142
log_archive_dest_152
log_archive_dest_162
log_archive_dest_172
log_archive_dest_182
log_archive_dest_192
log_archive_dest_202
log_archive_dest_212
log_archive_dest_222
log_archive_dest_232
log_archive_dest_242
log_archive_dest_252
log_archive_dest_262
log_archive_dest_272
log_archive_dest_282
log_archive_dest_292
log_archive_dest_302
log_archive_dest_312
log_archive_dest_state_112enableenable
log_archive_dest_state_122enableenable
log_archive_dest_state_132enableenable
log_archive_dest_state_142enableenable
log_archive_dest_state_152enableenable
log_archive_dest_state_162enableenable
log_archive_dest_state_172enableenable
log_archive_dest_state_182enableenable
log_archive_dest_state_192enableenable
log_archive_dest_state_202enableenable
log_archive_dest_state_212enableenable
log_archive_dest_state_222enableenable
log_archive_dest_state_232enableenable
log_archive_dest_state_242enableenable
log_archive_dest_state_252enableenable
log_archive_dest_state_262enableenable
log_archive_dest_state_272enableenable
log_archive_dest_state_282enableenable
log_archive_dest_state_292enableenable
log_archive_dest_state_302enableenable
log_archive_dest_state_312enableenable
memory_max_target600
memory_target600
optimizer_capture_sql_plan_baselines1FALSEFALSE
optimizer_use_invisible_indexes1FALSEFALSE
optimizer_use_pending_statistics1FALSEFALSE
optimizer_use_sql_plan_baselines1TRUETRUE
parallel_degree_limit2CPUCPU
parallel_degree_policy2MANUALMANUAL
parallel_force_local1FALSEFALSE
parallel_io_cap_enabled1FALSEFALSE
parallel_min_time_threshold2AUTOAUTO
parallel_servers_target3128128
permit_92_wrap_format1TRUETRUE
plscope_settings2identifiers:noneidentifiers:none
processor_group_name2
redo_transport_user2
resource_manager_cpu_allocation388
result_cache_max_result355
result_cache_max_size6107380736104864K
result_cache_mode2MANUALMANUAL
result_cache_remote_expiration300
sec_case_sensitive_logon1FALSEFALSE
sec_max_failed_login_attempts31010
sec_protocol_error_further_action2CONTINUECONTINUE
sec_protocol_error_trace_action2TRACETRACE
sec_return_server_release_banner1FALSEFALSE
use_large_pages2TRUETRUE
xml_db_events2enableenable

--删除参数:11个

NAMETYPEVALUEDISPLAY_VALUE
ddl_wait_for_locks1FALSEFALSE
drs_start1FALSEFALSE
gc_files_to_locks2
logmnr_max_persistent_sessions311
max_commit_propagation_delay300
plsql_compiler_flags2INTERPRETED, NON_DEBUGINTERPRETED, NON_DEBUG
plsql_native_library_dir2
plsql_native_library_subdir_count300
pre_11g_enable_capture1FALSEFALSE
remote_archive_enable2truetrue
sql_version2NATIVENATIVE

end


【版权声明】
本文为原创,遵循CC 4.0 BY-SA版权协议!转载请附上原文出处链接及本声明。
原文链接:https://tdlib.com/am.php?t=I7Ct7ZpFaOCC
Tag:   Oracle   Oracle基础   
未登录,请先 [ 注册 ] or [ 登录 ]
(一分钟即可完成注册!)
返回顶部  返回首页