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
- Oracle RAC初始化引數管理Oracle
- oracle 常見初始化引數Oracle
- ORACLE初始化引數的配置Oracle
- Oracle初始化引數的來源Oracle
- ORACLE初始化引數:AUDIT_TRAILOracleAI
- Oracle FILESYSTEMIO_OPTIONS初始化引數Oracle
- ORACLE初始化引數檔案介紹Oracle
- Oracle 並行相關的初始化引數Oracle並行
- Oracle USE_LARGE_PAGES初始化引數Oracle
- Oracle SQL92_SECURITY初始化引數OracleSQL
- Oracle初始化引數設定new(轉)Oracle
- Oracle 9i初始化引數檔案Oracle
- oracle10g初始化引數說明Oracle
- 【原創】Oracle 初始化引數&效能檢視Oracle
- Oracle建庫必備的核心初始化引數Oracle
- Oracle 9i初始化引數檔案(轉)Oracle
- 搭建Oracle DataGurad需要的常用初始化引數Oracle
- Oracle修改初始化引數(initialization parameter)scope的選項Oracle
- Oracle Database 11gR2初始化引數知多少OracleDatabase
- 2 Day DBA-管理Oracle例項-檢視和修改初始化引數-練習:檢視和修改初始化引數Oracle
- ORACLE 25個需要深思熟慮重要的初始化引數Oracle
- Oracle9i初始化引數中文說明[轉貼]Oracle
- 最影響Oracle系統效能的初始化引數(zt)Oracle
- 2 Day DBA-管理Oracle例項-關於初始化引數Oracle
- ORACLE RAC資料庫中的初始化引數的設定Oracle資料庫
- Oracle引數-隱藏引數Oracle
- 2.6.2.2 初始化引數DB_DOMAINAI
- 2.6.1.1 初始化引數檔案示例
- 初始化引數REMOTE_OS_AUTHENTREM
- 【SQL優化器】初始化引數SQL優化
- oracle 引數Oracle
- Linux系統初始化*引數初始化(指令碼)Linux指令碼
- Oracle 11G 資料庫重要的初始化引數設定Oracle資料庫
- oracle11g中的幾個記憶體初始化引數Oracle記憶體
- 區分oracle的初始化引數為靜態還是動態Oracle
- [Oracle]由於初始化引數檔案修改錯誤導致oracle無法startupOracle
- 4.2.1.3 學習如何管理初始化引數