oracle 9i pfileECOM.ora
*.aq_tm_processes=1
*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'
*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'[@more@]*.aq_tm_processes=1
*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'
*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'
*.db_block_size=8192
*.db_cache_size=395313152
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ECOM'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ECOMXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ECOM'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=97517568
*.open_cursors=300
*.pga_aggregate_target=351272960
*.processes=150
*.query_rewrite_enabled='FALSE'
#*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=131072000
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/export/home/oracle/admin/ECOM/udump'
*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'
*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'[@more@]*.aq_tm_processes=1
*.background_dump_dest='/export/home/oracle/admin/ECOM/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/export/home/oracle/oradata/ECOM/control01.ctl','/export/home/oracle/oradata/ECOM/control02.ctl','/export/home/oracle/oradata/ECOM/control03.ctl'
*.core_dump_dest='/export/home/oracle/admin/ECOM/cdump'
*.db_block_size=8192
*.db_cache_size=395313152
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ECOM'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ECOMXDB)'
*.fast_start_mttr_target=300
*.hash_join_enabled=TRUE
*.instance_name='ECOM'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=97517568
*.open_cursors=300
*.pga_aggregate_target=351272960
*.processes=150
*.query_rewrite_enabled='FALSE'
#*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=131072000
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/export/home/oracle/admin/ECOM/udump'
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8806316/viewspace-897033/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 9i安裝Oracle
- Uninstall Oracle 9iOracle
- oracle 9i 閃回Oracle
- oracle 9i index bug?OracleIndex
- ORACLE 9i statspack使用Oracle
- Oracle 9I dataguard(standby)Oracle
- oracle 9i 開啟autotrace onOracle
- Oracle 9I FlashBack 測試Oracle
- oracle 9i init.oraOracle
- oracle 9i 建庫模板Oracle
- Oracle 9I 下的AutoTraceOracle
- ORACLE 9I not exists的bugOracle
- ORACLE 9I TURNING SQLOracleSQL
- KB-Oracle 9i NVarcharOracle
- oracle 9i 手動建庫Oracle
- Oracle 9i配置Statspack工具(下)Oracle
- Oracle 9i配置Statspack工具(上)Oracle
- Oracle 9i RAC on PowerHA5.5Oracle
- oracle 9i啟用Execution PlanOracle
- Oracle 9i效能調整 [ZT]Oracle
- Oracle 9I恢復實戰Oracle
- Oracle 9i RAC 互聯效能Oracle
- Oracle 9i statspack 使用手冊Oracle
- Oracle 9i Online DocumentationOracle
- Oracle 9i閃回測試。Oracle
- oracle 9i stream配置備記Oracle
- 全新感受Oracle 9i(轉)Oracle
- Oracle 9i產品文件(轉)Oracle
- oracle 9i升級到oracle9208Oracle
- oracle 9i資料庫做spaOracle資料庫
- Oracle 9i備份和恢復Oracle
- oracle 9i statspack詳細講解Oracle
- Plan Stability in Oracle 8i/9iOracle
- Oracle 9i中監視索引的使用Oracle索引
- Oracle 9i RAC enqueue等待測試OracleENQ
- oracle 9i DBCA建庫報錯Oracle
- oracle 9i for linux的安裝OracleLinux
- ORACLE 9i完全完美解除安裝Oracle