oracle11g参数文件如何配置

57次阅读

共计 1436 个字符，预计需要花费 4 分钟才能阅读完成。

这篇文章主要为大家展示了“oracle11g 参数文件如何配置”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让丸趣 TV 小编带领大家一起研究并学习一下“oracle11g 参数文件如何配置”这篇文章吧。

[oracle@test dbs]$ vi initshdb.ora
#shwmsdb.__db_cache_size=14361296896
#shwmsdb.__java_pool_size=67108864
#shwmsdb.__large_pool_size=67108864
#shwmsdb.__oracle_base= /u01/app/oracle #ORACLE_BASE set from environment
##shwmsdb.__pga_aggregate_target=4294967296
#shwmsdb.__sga_target=21474836480
#shwmsdb.__shared_io_pool_size=0
#shwmsdb.__shared_pool_size=6845104128
#shwmsdb.__streams_pool_size=0
*._kill_controlfile_enqueue_blocker=FALSE
*._kill_enqueue_blocker=1
*.audit_file_dest= /u01/app/oracle/admin/shwmsdb/adump
*.audit_trail= db
*.cluster_database=false
*.compatible= 11.2.0.0.0
*.control_files= /mnt/data/shwmsdb/control01.ctl
*.db_block_size=8192
*.db_domain=
*.db_file_name_convert= +DATA/shwmsdb/datafile/ , /mnt/data/shwmsdb/
*.db_name= shwmsdb
*.db_unique_name= shwmsdb
*.diagnostic_dest= /u01/app/oracle
*.log_archive_dest_1= LOCATION=/mnt/data/archivelog/
*.LOG_ARCHIVE_DEST_STATE_1= ENABLE
*.log_archive_format= arc_%t_%s_%r.arc
*.log_file_name_convert= +DATA/shwmsdb/onlinelog/ , /mnt/data/shwmsdb/ , +FRA/shwmsdb/onlinelog/ , /mnt/data/shwmsdb/
*.open_cursors=20000
*.pga_aggregate_target=500M
*.processes=1000
*.remote_listener= 10.0.40.98:1521
*.remote_login_passwordfile= exclusive
*.sga_max_size=6G
*.sga_target=6G
*.standby_file_management= auto
shwmsdb.undo_tablespace= UNDOTBS1