【1】pfile：初始化參數(shù)文件
包含了init.ora文件，該文件定義了幾個(gè)非常重要的參數(shù)：
·db_domain：數(shù)據(jù)庫域名
·db_name：數(shù)據(jù)庫名
·control_files：控制文件的路徑，通常有3個(gè)文件
·shared_pool_size=共享池的大小
·background_dump_dest=后臺(tái)進(jìn)程日志、跟蹤文件路徑
·core_dump_dest=操作系統(tǒng)崩潰的日志、跟蹤文件路徑
·user_dump_dest=用戶進(jìn)程的跟蹤文件路徑
【2】budmp：存放由后臺(tái)進(jìn)程所生成的數(shù)據(jù)庫Alert日志文件和跟蹤文件
典型的包含了一個(gè).log文件和一個(gè).trc文件。
打開.log文件我們可以看到里面有很多后臺(tái)進(jìn)程的啟動(dòng)及運(yùn)行信息，其中最關(guān)鍵的就是加載init.ora文件和起點(diǎn)后臺(tái)進(jìn)程的日志了
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = C:\oracle\oradata\paullin\control01.ctl, C:\oracle\oradata\paullin\control02.ctl, C:\oracle\oradata\paullin\control03.ctl
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = paullin
dispatchers = (PROTOCOL=TCP)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\paullin\bdump
user_dump_dest = C:\oracle\admin\paullin\udump
core_dump_dest = C:\oracle\admin\paullin\cdump
sort_area_size = 524288
db_name = paullin
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
而.trc文件里面則保存了當(dāng)前會(huì)話的ID
【3】cdump：存放發(fā)生崩潰的操作系統(tǒng)的系統(tǒng)進(jìn)程信息
【4】create：存儲(chǔ)創(chuàng)建數(shù)據(jù)庫的SQL腳本
【5】udmp：存儲(chǔ)用戶進(jìn)程所生成的跟蹤文件
-------------------------------------------------------------
生活就像打牌，不是要抓一手好牌，而是要盡力打好一手爛牌。
posted on 2008-05-04 17:41
Paul Lin 閱讀(578)
評(píng)論(0) 編輯 收藏 所屬分類:
Oracle Concept