oracle初始化引數

pentium發表於2007-03-09
下面列舉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'

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/14377/viewspace-903587/,如需轉載,請註明出處,否則將追究法律責任。

相關文章