oracle_参数_SQL> show parameter

本文详细介绍了 Oracle 数据库的各项参数设置,包括内存管理、进程配置、安全性设置等多个方面,为数据库管理员提供了实用的配置指南。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

NAMETYPEVALUE
-----------------------------------------------------------------------------
O7_DICTIONARY_ACCESSIBILITYbooleanFALSE
active_instance_countinteger 
aq_tm_processesinteger0
archive_lag_targetinteger0
asm_diskgroupsstring 
asm_diskstringstring 
asm_power_limitinteger1
asm_preferred_read_failure_groupsstring 
audit_file_deststring/u2/app/oracle/admin/testdw/ad
  ump
audit_sys_operationsbooleanFALSE
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
audit_syslog_levelstring 
audit_trailstringDB
background_core_dumpstringpartial
background_dump_deststring/u2/app/oracle/diag/rdbms/test
  dw/testdw/trace
backup_tape_io_slavesbooleanFALSE
bitmap_merge_area_sizeinteger1048576
blank_trimmingbooleanFALSE
buffer_pool_keepstring 
buffer_pool_recyclestring 
cell_offload_compactionstringADAPTIVE
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
cell_offload_decryptionbooleanTRUE
cell_offload_parametersstring 
cell_offload_plan_displaystringAUTO
cell_offload_processingbooleanTRUE
cell_partition_large_extentsstringDEFAULT
circuitsinteger 
client_result_cache_lagbig integer3000
client_result_cache_sizebig integer0
cluster_databasebooleanFALSE
cluster_database_instancesinteger1
cluster_interconnectsstring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
commit_loggingstring 
commit_point_strengthinteger1
commit_waitstring 
commit_writestring 
compatiblestring11.2.0.0.0
control_file_record_keep_timeinteger7
control_filesstring/u2/app/oracle/oradata/testdw/
  control01.ctl, /u2/app/oracle/
  oradata/testdw/control02.ctl
control_management_pack_accessstringDIAGNOSTIC+TUNING
core_dump_deststring/u2/app/oracle/diag/rdbms/test
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
  dw/testdw/cdump
cpu_countinteger4
create_bitmap_area_sizeinteger8388608
create_stored_outlinesstring 
cursor_sharingstringEXACT
cursor_space_for_timebooleanFALSE
db_16k_cache_sizebig integer0
db_2k_cache_sizebig integer0
db_32k_cache_sizebig integer0
db_4k_cache_sizebig integer0
db_8k_cache_sizebig integer0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_block_buffersinteger0
db_block_checkingstringFALSE
db_block_checksumstringTYPICAL
db_block_sizeinteger8192
db_cache_advicestringON
db_cache_sizebig integer0
db_create_file_deststring 
db_create_online_log_dest_1string 
db_create_online_log_dest_2string 
db_create_online_log_dest_3string 
db_create_online_log_dest_4string 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_create_online_log_dest_5string 
db_domainstring 
db_file_multiblock_read_countinteger83
db_file_name_convertstring 
db_filesinteger200
db_flash_cache_filestring 
db_flash_cache_sizebig integer0
db_flashback_retention_targetinteger1440
db_keep_cache_sizebig integer0
db_lost_write_protectstringNONE
db_namestringtestdw
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
db_recovery_file_deststring 
db_recovery_file_dest_sizebig integer0
db_recycle_cache_sizebig integer0
db_securefilestringPERMITTED
db_ultra_safestringOFF
db_unique_namestringtestdw
db_writer_processesinteger1
dbwr_io_slavesinteger0
ddl_lock_timeoutinteger0
deferred_segment_creationbooleanFALSE
dg_broker_config_file1string/u2/app/oracle/product/11.2.0/
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
  dbhome_1/dbs/dr1testdw.dat
dg_broker_config_file2string/u2/app/oracle/product/11.2.0/
  dbhome_1/dbs/dr2testdw.dat
dg_broker_startbooleanFALSE
diagnostic_deststring/u2/app/oracle
disk_asynch_iobooleanTRUE
dispatchersstring(PROTOCOL=TCP) (SERVICE=testdw
  XDB)
distributed_lock_timeoutinteger60
dml_locksinteger9996
dst_upgrade_insert_convbooleanTRUE
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
enable_ddl_loggingbooleanFALSE
eventstring 
fal_clientstring 
fal_serverstring 
fast_start_io_targetinteger0
fast_start_mttr_targetinteger0
fast_start_parallel_rollbackstringLOW
file_mappingbooleanFALSE
fileio_network_adaptersstring 
filesystemio_optionsstringnone
fixed_datestring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
gcs_server_processesinteger0
global_context_pool_sizestring 
global_namesbooleanFALSE
global_txn_processesinteger1
hash_area_sizeinteger131072
hi_shared_memory_addressinteger0
hs_autoregisterbooleanTRUE
ifilefile 
instance_groupsstring 
instance_namestringtestdw
instance_numberinteger0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
instance_typestringRDBMS
java_jit_enabledbooleanTRUE
java_max_sessionspace_sizeinteger0
java_pool_sizebig integer0
java_soft_sessionspace_limitinteger0
job_queue_processesinteger1000
large_pool_sizebig integer0
ldap_directory_accessstringNONE
ldap_directory_sysauthstringno
license_max_sessionsinteger0
license_max_usersinteger0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
license_sessions_warninginteger0
listener_networksstring 
local_listenerstring 
lock_name_spacestring 
lock_sgabooleanFALSE
log_archive_configstring 
log_archive_deststring 
log_archive_dest_1string 
log_archive_dest_10string 
log_archive_dest_11string 
log_archive_dest_12string 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_13string 
log_archive_dest_14string 
log_archive_dest_15string 
log_archive_dest_16string 
log_archive_dest_17string 
log_archive_dest_18string 
log_archive_dest_19string 
log_archive_dest_2string 
log_archive_dest_20string 
log_archive_dest_21string 
log_archive_dest_22string 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_23string 
log_archive_dest_24string 
log_archive_dest_25string 
log_archive_dest_26string 
log_archive_dest_27string 
log_archive_dest_28string 
log_archive_dest_29string 
log_archive_dest_3string 
log_archive_dest_30string 
log_archive_dest_31string 
log_archive_dest_4string 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_5string 
log_archive_dest_6string 
log_archive_dest_7string 
log_archive_dest_8string 
log_archive_dest_9string 
log_archive_dest_state_1stringenable
log_archive_dest_state_10stringenable
log_archive_dest_state_11stringenable
log_archive_dest_state_12stringenable
log_archive_dest_state_13stringenable
log_archive_dest_state_14stringenable
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_state_15stringenable
log_archive_dest_state_16stringenable
log_archive_dest_state_17stringenable
log_archive_dest_state_18stringenable
log_archive_dest_state_19stringenable
log_archive_dest_state_2stringenable
log_archive_dest_state_20stringenable
log_archive_dest_state_21stringenable
log_archive_dest_state_22stringenable
log_archive_dest_state_23stringenable
log_archive_dest_state_24stringenable
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_state_25stringenable
log_archive_dest_state_26stringenable
log_archive_dest_state_27stringenable
log_archive_dest_state_28stringenable
log_archive_dest_state_29stringenable
log_archive_dest_state_3stringenable
log_archive_dest_state_30stringenable
log_archive_dest_state_31stringenable
log_archive_dest_state_4stringenable
log_archive_dest_state_5stringenable
log_archive_dest_state_6stringenable
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_archive_dest_state_7stringenable
log_archive_dest_state_8stringenable
log_archive_dest_state_9stringenable
log_archive_duplex_deststring 
log_archive_formatstring%t_%s_%r.dbf
log_archive_local_firstbooleanTRUE
log_archive_max_processesinteger4
log_archive_min_succeed_destinteger1
log_archive_startbooleanFALSE
log_archive_traceinteger0
log_bufferinteger33472512
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
log_checkpoint_intervalinteger0
log_checkpoint_timeoutinteger1800
log_checkpoints_to_alertbooleanFALSE
log_file_name_convertstring 
max_dispatchersinteger 
max_dump_file_sizestringunlimited
max_enabled_rolesinteger150
max_shared_serversinteger 
memory_max_targetbig integer6464M
memory_targetbig integer6464M
nls_calendarstring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
nls_compstringBINARY
nls_currencystring 
nls_date_formatstring 
nls_date_languagestring 
nls_dual_currencystring 
nls_iso_currencystring 
nls_languagestringAMERICAN
nls_length_semanticsstringBYTE
nls_nchar_conv_excpstringFALSE
nls_numeric_charactersstring 
nls_sortstring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
nls_territorystringAMERICA
nls_time_formatstring 
nls_time_tz_formatstring 
nls_timestamp_formatstring 
nls_timestamp_tz_formatstring 
object_cache_max_size_percentinteger10
object_cache_optimal_sizeinteger102400
olap_page_pool_sizebig integer0
open_cursorsinteger300
open_linksinteger4
open_links_per_instanceinteger4
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring11.2.0.1
optimizer_index_cachinginteger0
optimizer_index_cost_adjinteger100
optimizer_modestringALL_ROWS
optimizer_secure_view_mergingbooleanTRUE
optimizer_use_invisible_indexesbooleanFALSE
optimizer_use_pending_statisticsbooleanFALSE
optimizer_use_sql_plan_baselinesbooleanTRUE
os_authent_prefixstringops$
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
os_rolesbooleanFALSE
parallel_adaptive_multi_userbooleanTRUE
parallel_automatic_tuningbooleanFALSE
parallel_degree_limitstringCPU
parallel_degree_policystringMANUAL
parallel_execution_message_sizeinteger16384
parallel_force_localbooleanFALSE
parallel_instance_groupstring 
parallel_io_cap_enabledbooleanFALSE
parallel_max_serversinteger40
parallel_min_percentinteger0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
parallel_min_serversinteger0
parallel_min_time_thresholdstringAUTO
parallel_serverbooleanFALSE
parallel_server_instancesinteger1
parallel_servers_targetinteger16
parallel_threads_per_cpuinteger2
permit_92_wrap_formatbooleanTRUE
pga_aggregate_targetbig integer0
plscope_settingsstringIDENTIFIERS:NONE
plsql_ccflagsstring 
plsql_code_typestringINTERPRETED
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
plsql_debugbooleanFALSE
plsql_optimize_levelinteger2
plsql_v2_compatibilitybooleanFALSE
plsql_warningsstringDISABLE:ALL
pre_page_sgabooleanFALSE
processesinteger1500
query_rewrite_enabledstringTRUE
query_rewrite_integritystringenforced
rdbms_server_dnstring 
read_only_open_delayedbooleanFALSE
recovery_parallelisminteger0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
recyclebinstringon
redo_transport_userstring 
remote_dependencies_modestringTIMESTAMP
remote_listenerstring 
remote_login_passwordfilestringEXCLUSIVE
remote_os_authentbooleanFALSE
remote_os_rolesbooleanFALSE
replication_dependency_trackingbooleanTRUE
resource_limitbooleanFALSE
resource_manager_cpu_allocationinteger4
resource_manager_planstring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
result_cache_max_resultinteger5
result_cache_max_sizebig integer16576K
result_cache_modestringMANUAL
result_cache_remote_expirationinteger0
resumable_timeoutinteger0
rollback_segmentsstring 
sec_case_sensitive_logonbooleanTRUE
sec_max_failed_login_attemptsinteger10
sec_protocol_error_further_actionstringCONTINUE
sec_protocol_error_trace_actionstringTRACE
sec_return_server_release_bannerbooleanFALSE
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
serial_reusestringdisable
service_namesstringtestdw
session_cached_cursorsinteger50
session_max_open_filesinteger10
sessionsinteger2272
sga_max_sizebig integer6464M
sga_targetbig integer0
shadow_core_dumpstringpartial
shared_memory_addressinteger0
shared_pool_reserved_sizebig integer110729625
shared_pool_sizebig integer0
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
shared_server_sessionsinteger 
shared_serversinteger1
skip_unusable_indexesbooleanTRUE
smtp_out_serverstring 
sort_area_retained_sizeinteger0
sort_area_sizeinteger65536
spfilestring/u2/app/oracle/product/11.2.0/
  dbhome_1/dbs/spfiletestdw.ora
sql92_securitybooleanFALSE
sql_tracebooleanFALSE
sqltune_categorystringDEFAULT
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
standby_archive_deststring?/dbs/arch
standby_file_managementstringMANUAL
star_transformation_enabledstringFALSE
statistics_levelstringTYPICAL
streams_pool_sizebig integer0
tape_asynch_iobooleanTRUE
threadinteger0
timed_os_statisticsinteger0
timed_statisticsbooleanTRUE
trace_enabledbooleanTRUE
tracefile_identifierstring 
   
NAMETYPEVALUE
-----------------------------------------------------------------------------
transactionsinteger2499
transactions_per_rollback_segmentinteger5
undo_managementstringAUTO
undo_retentioninteger900
undo_tablespacestringUNDOTBS1
use_indirect_data_buffersbooleanFALSE
user_dump_deststring/u2/app/oracle/diag/rdbms/test
  dw/testdw/trace
utl_file_dirstring 
workarea_size_policystringAUTO
xml_db_eventsstringenable
xml_db_eventsstringenable

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值