oracle11g参数文件如何配置

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

以上是“oracle11g参数文件如何配置”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注行业资讯频道！