【文章內(nèi)容簡介】 ....................................................................................................................52 1. 在關(guān)閉狀態(tài)下執(zhí)行...........................................................................................................53 2. 切換命令：不能跳級切換...................................................................................................53 3. 關(guān)閉過程與啟動逆向；...................................................................................................53 ：...............................................................................................................................53 TRACE FILES 后臺進(jìn)程跟蹤文件............................................................................53 TRACE FILES 用戶跟蹤文件................................................................................................54 ................................................... ..................................................................................54 1. 創(chuàng)建前的準(zhǔn)備：...............................................................................................................54 2. 創(chuàng)建方法：.......................................................................................................................55 1UNIX 操作系統(tǒng)環(huán)境變量...........................................................................................................55 1手動創(chuàng)建數(shù)據(jù)庫...........................................................................................................................55 1使用數(shù)據(jù)字典和動態(tài)性能視圖...................................................................................................56 1. 數(shù)據(jù)字典...........................................................................................................................56 2. 數(shù)據(jù)字典的分類：............................................ ...............................................................56 3. 動態(tài)性能表：...................................................................................................................56 1維護(hù)重做日志文件.......................................................................................................................57 1管理表空間和數(shù)據(jù)文件...............................................................................................................59 1表空間的空間管理（區(qū)的管理）：.............................................................................................61 本地管理：.............................................................................................................................61 數(shù)據(jù)字典管理表空間：.........................................................................................................61 存儲參數(shù)：.......................................................... ...................................................................61 表空間狀態(tài)：.........................................................................................................................61 查看表空間信息：.................................................................................................................62 重定義表空間的大小.............................................................................................................62 操作表空間：.........................................................................................................................62 移動數(shù)據(jù)文件：.....................................................................................................................62 刪除表空間：.........................................................................................................................63 1存儲結(jié)構(gòu)和關(guān)系................................................... ........................................................................63 段類型：.................................................................................................................................63 區(qū)：.........................................................................................................................................64 數(shù)據(jù)庫塊.................................................................................................................................64 9I提供非標(biāo)準(zhǔn)塊 .....................................................................................................................64 標(biāo)準(zhǔn)塊大小.............................................................................................................................64 非標(biāo)準(zhǔn)塊的大小.....................................................................................................................64 數(shù)據(jù)塊的內(nèi)容：.................................. ...................................................................................65 塊的空間利用參數(shù)：.............................................................................................................65 數(shù)據(jù)塊管理：.........................................................................................................................65 管理回滾段（Undo）的數(shù)據(jù)...............................................................................................65 Undo段的類型：...........................................................................................................................66 ：...................................................................................................................66 ：...........................................................................................................................66 ：.................................. .............................................................67 2管理表...........................................................................................................................................67 ：...........................................................................................................................67 ...............................................................................................................................68 資源來自網(wǎng)絡(luò)，僅供學(xué)習(xí)！ Oracle 從入門到精通第 4 頁，共 106 頁：.............