oracle11g參數(shù)文件如何配置

123次閱讀

共計 1436 個字符，預(yù)計需要花費 4 分鐘才能閱讀完成。

這篇文章主要為大家展示了“oracle11g 參數(shù)文件如何配置”，內(nèi)容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓丸趣 TV 小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“oracle11g 參數(shù)文件如何配置”這篇文章吧。

[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