oracle初始化引數
下面列舉pfile檔案裡的內容[@more@]*.background_dump_dest='d:oracleadmine3bdump'
*.compatible='9.2.0.0.0'
*.control_files='f:oradatae3CONTROL01.CTL','f:oradatae3CONTROL02.CTL','f:oradatae3CONTROL03.CTL'
*.core_dump_dest='d:oracleadmine3cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=48
*.db_name='e3'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=e3XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='e3'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=f:oradatae3archive'
*.log_archive_dest_2='SERVICE=dbstandby reopen=300'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='d:oracleadmine3udump'
*.utl_file_dir='d:oraclelogs'
*.compatible='9.2.0.0.0'
*.control_files='f:oradatae3CONTROL01.CTL','f:oradatae3CONTROL02.CTL','f:oradatae3CONTROL03.CTL'
*.core_dump_dest='d:oracleadmine3cdump'
*.db_block_size=8192
*.db_cache_size=25165824
*.db_domain=''
*.db_file_multiblock_read_count=48
*.db_name='e3'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=e3XDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='e3'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=8388608
*.log_archive_dest_1='LOCATION=f:oradatae3archive'
*.log_archive_dest_2='SERVICE=dbstandby reopen=300'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.open_cursors=300
*.pga_aggregate_target=25165824
*.processes=150
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=50331648
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='d:oracleadmine3udump'
*.utl_file_dir='d:oraclelogs'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14377/viewspace-903587/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle初始化引數的來源Oracle
- 16 初始化引數
- 2.6 指定初始化引數
- 2.7.5 SPFILE初始化引數
- Oracle 核心引數Oracle
- 0607-引數初始化策略
- Oracle:PDB 引數管理Oracle
- 2.6.9.1 關於 COMPATIBLE初始化引數
- 2.6.8.2 UNDO_TABLESPACE 初始化引數
- 2.6.8.1 UNDO_MANAGEMENT 初始化引數
- 2.6.2.2 初始化引數DB_DOMAINAI
- 2.6.2.1 初始化引數DB_NAME
- 2.6.1.1 初始化引數檔案示例
- 2.7.7 清除初始化引數的值
- 2.7.6 改變初始化引數值
- 所有初始化引數說明(轉)
- MogDB 2.1.1 初始化引數概要說明
- 2.6.5.1 DB_BLOCK_SIZE 初始化引數BloC
- 4.2.1.3 學習如何管理初始化引數
- PyTorch常用引數初始化方法詳解PyTorch
- webpack 流程解析(2):引數初始化完成Web
- ORACLE並行相關的引數Oracle並行
- Oracle GoldenGate常用引數詳解OracleGo
- oracle rac 核心引數詳解Oracle
- Oracle Table建立引數說明Oracle
- Oracle JDBC ResultSet引數測試OracleJDBC
- 使用 XmlCommand 對Oracle傳引數XMLOracle
- Oracle RAC引數檔案管理Oracle
- java 執行緒池的初始化引數解釋和引數設定Java執行緒
- 2.4.5 Step 4: 建立初始化引數檔案
- 2.6.1.2 平文字初始化引數檔案格式
- 初始化引數遊標之cursor_sharing
- oracle O7_DICTIONARY_ACCESSIBILITY 引數Oracle
- [20190917]oracle引數deferred屬性.txtOracle
- Oracle面試寶典-引數篇Oracle面試
- Oracle RAC修改引數檔案位置Oracle
- Oracle ENABLE=broken引數與TCP KeepAliveOracleTCP
- 未初始化變數引發執行時故障變數
- 2.7.6.2 設定或修改初始化引數的值