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'
#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'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2148394/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 靜態引數檔案配置
- Nginx 配置檔案引數詳解Nginx
- Redis配置檔案引數說明Redis
- redis配置檔案引數詳解Redis
- compose配置檔案引數詳解
- 部分Oracle 配置檔案引數含義Oracle
- LINUX 網路卡配置檔案引數Linux
- MySQL的配置檔案的引數設定MySql
- MongoDB啟動檔案配置引數詳解MongoDB
- Kafka - 配置檔案引數最佳化方案Kafka
- redis配置檔案中各引數詳解Redis
- 引數檔案
- 引數檔案/口令檔案
- Oracle11g資料庫引數檔案誤刪除恢復Oracle資料庫
- Oracle引數檔案解析——引數檔案分析獲取Oracle
- Linux網路卡配置檔案 引數詳解Linux
- MySQL配置檔案mysql.ini引數詳解MySql
- Oracle引數檔案解析——引數解析Oracle
- Oracle 引數檔案Oracle
- SAP引數檔案
- hadoop叢集搭建配置檔案優化引數Hadoop優化
- notes.ini檔案的配置引數詳解
- Oracle引數檔案 各引數解釋Oracle
- Oracle11g版本中未歸檔隱藏引數Oracle
- 引數檔案恢復
- oracle的引數檔案Oracle
- Oracle 引數檔案(轉)Oracle
- MySQL配置檔案my.ini引數註釋說明MySql
- notes.ini檔案的配置引數詳解(轉)
- 01_MyBatis EHCache整合及所需jar包,ehcache.xml配置檔案引數配置及mapper中的引數配置MyBatisJARXMLAPP
- Spingboot 讀取 yml 配置檔案裡的引數值boot
- Linux下vsftpd的配置檔案的引數詳解LinuxFTP
- 如何自定義 CI/CD 配置檔案中的輸入引數?
- oracle控制檔案及引數檔案問題Oracle
- Oracle RAC引數檔案管理Oracle
- Oracle引數檔案基礎Oracle
- oracle 關於--引數檔案Oracle
- 檔案的時間引數