oracle實驗記錄 (oracle 詳細分析redo（4）)

fufuh2o發表於2009-10-23

關於redo 結構:

SQL> conn xh/a831115;
已連線。
SQL> select * from test;

A
----------
a

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 CURRENT

SQL> col member format a40
SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------
         3 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
           REDO03.LOG

2 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO02.LOG

1 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO01.LOG

SQL> update test set a='b';

已更新 1 行。~~~~~~~~~~~~~~~~~~~~~~~~~~~~未commit

SQL>

SQL> select xidusn ,ubafil,UBABLK from v$transaction;

XIDUSN UBAFIL UBABLK
---------- ---------- ----------
3 2 2194

可以看到這個事務使用的 undo block 是 file 2,block 2194

SQL> select * from v$rollname where usn=3;

USN NAME
---------- ------------------------------
3 _SYSSMU3$

SQL> select header_block,header_file from dba_segments where segment_name='_SYSS
MU3$';

HEADER_BLOCK HEADER_FILE
------------ -----------
41 2
SQL> select object_id from user_objects where object_name='TEST';

OBJECT_ID
----------
54147

SQL> alter system dump logfile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\REDO03.L
og';

系統已更改。

根據 object_id找到相關資訊
可以看到這個redo record中有 3個 change vector（比如CHANGE #1）

REDO RECORD - Thread:1 RBA: 0x000003.00000beb.0010 LEN: 0x01c0 VLD: 0x0d
SCN: 0x0000.0045246b SUBSCN: 1 10/21/2009 09:23:22
CHANGE #1 TYP:0 CLS: 1 AFN:4 DBA:0x010001c4 OBJ:54147 SCN:0x0000.00445bbf SEQ: 1 OP:11.19
KTB Redo
op: 0x01 ver: 0x01
op: F xid: 0x0003.021.00000542 uba: 0x00800892.0281.18
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 2 ckix: 7
ncol: 1 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010001c4 hdba: 0x010001c3
itli: 2 ispac: 0 maxfr: 4858
vect = 0
col 0: [ 1] 62

CHANGE #2 TYP:0 CLS:21 AFN:2 DBA:0x00800029 OBJ:4294967295 SCN:0x0000.00452413 SEQ: 1 OP:5.2
ktudh redo: slt: 0x0021 sqn: 0x00000542 flg: 0x0012 siz: 152 fbi: 0
            uba: 0x00800892.0281.18    pxid: 0x0000.000.00000000
CHANGE #3 TYP:0 CLS:22 AFN:2 DBA:0x00800892 OBJ:4294967295 SCN:0x0000.00452412 SEQ: 2 OP:5.1
ktudb redo: siz: 152 spc: 4888 flg: 0x0012 seq: 0x0281 rec: 0x18
            xid: 0x0003.021.00000542
ktubl redo: slt: 33 rci: 0 opc: 11.1 objn: 54147 objd: 54147 tsn: 4
Undo type: Regular undo        Begin trans    Last buffer split: No
Temp Object: No
Tablespace Undo: No
             0x00000000 prev ctl uba: 0x00800892.0281.16
prev ctl max cmt scn: 0x0000.00451e95 prev tx cmt scn: 0x0000.00451e9b
txn start scn: 0x0000.004523eb logon user: 61 prev brb: 0 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 7
ncol: 1 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010001c4 hdba: 0x010001c3
itli: 2 ispac: 0 maxfr: 4858
vect = 0
col 0: [ 1] 61

分析可以從 AFN:看出是對那個檔案的修改,AFN 絕對檔案號

所以change#1 記錄對datafile 4的修改,dba是對應的塊
DBA:0x010001c4
SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('0001c4','xx
xxxxx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('0001c4','xx
xxxx'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
4

SQL> print blk#

BLK#
----------
452

SQL> select file#,block# from (select dbms_rowid.rowid_relative_fno(rowid) file#
,dbms_rowid.rowid_block_number(rowid) block# from xh.test);

FILE# BLOCK#
---------- ----------
4 452

可以看出這個 change vector記錄的是修改datafile 4,block 452的記錄正是，修改test 表的記錄

uba: 0x00800892.0281.18

0281是序號，18是條目號

uba 是記錄了這個塊修改後的 undo記錄放在undo 那個塊中
SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('00892','xxx
xxxx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('00892','xxx
xxx'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
2

SQL> print blk#

BLK#
----------
2194

可以看到修改test後的舊值（a）放在undo file 2 ,block 2194中

col 0: [ 1] 62 就是 undo記錄中，記錄修改後的值(upate test set a='b')

SQL> select chr(to_number(62,'xx')) from dual;

CH
--
b

KDO Op code: 21 d代表事務進行操作的型別程式碼 21 代表 update

xid: 0x0003.021.00000542 對應著

SQL> select to_number('21','xxxxxx') from dual;

TO_NUMBER('21','XXXXXX')
------------------------
33

SQL> select to_number('542','xxxxxx') from dual;

TO_NUMBER('542','XXXXXX')
-------------------------
1346

SQL>

SQL> select XIDUSN,XIDSLOT,XIDSQN from v$transaction;（user xh session執行）

XIDUSN XIDSLOT XIDSQN
---------- ---------- ----------
3 33 1346

XIDUSN NUMBER Undo segment number
XIDSLOT NUMBER Slot number
XIDSQN NUMBER Sequence number

Array Update of 1 rows: 也顯示了 update 1 rows

bdba: 0x010001c4 ：也表示修改的 test的資料塊與dba一樣（data block address）
是 file 4,block 452

hdba: 0x010001c3：表示的是test表的 segment header block

SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('1c3','xxxxx
xx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('1c3','xxxxx
x'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
4

SQL> print blk#

BLK#
----------
451

SQL> select header_file,header_block from dba_segments where segment_name='TEST'
;

HEADER_FILE HEADER_BLOCK
----------- ------------
4 451

基本change #1的重要資訊瞭解完了，可以清楚的看到redo中都記錄了些什麼

CHANGE #2 AFN:2可以看到是對 undo 的修改的記錄

DBA:0x00800029 OBJ:4294967295

SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('800029','xx
xxxxx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('800029','xx
xxxx'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
2

SQL> print blk#

BLK#
----------
41

這正是對undo segment header的修改，要修改事務表（存undo segment header）

uba: 0x00800892.0281.18 :記錄了放 test舊值的undo block 所在地址，與change#1中的一樣

change#3:
CHANGE #3 TYP:0 CLS:22 AFN:2 DBA:0x00800892
anf 表示這個還是記錄的undo file的資訊，DBA表示的是哪個undo 塊

SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('800892','xx
xxxxx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('800892','xx
xxxx'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
2

SQL> print blk#

BLK#
----------
2194

可以看到這個塊就是記錄test 舊值得塊，chang#3 記錄了對這個undo 塊的修改,所以redo是保護undo的

ktubl redo: slt: 33 rci: 0 opc: 11.1 objn: 54147 objd: 54147 tsn: 4

OBJD可以看到是記錄的物件是xh.test

slt: 33=XIDSLOT NUMBER Slot number

logon user: 61 登陸操作的user id

SQL> select username from dba_users where user_id=61;

USERNAME
------------------------------
XH

KDO Op code: 21：表示還是一個update操作

bdba: 0x010001c4 hdba: 0x010001c3
BDBA:記錄的是fil 4 block 452 表示是test表的資料塊地址,hdba 是file 4,block 451 表示是test segment header block

col 0: [ 1] 61：表示修改前的值

SQL> select chr(to_number(61,'xx')) from dual;

CH
--
a

SQL> alter system dump datafile 2 block 2194;

系統已更改。

根據object_id找
dump log file中 change#1中uba: 0x00800892.0281.18，change#3中dba 可以現在dump datablock trace中 rec 0x18 為uba中18 表示slot號

* Rec #0x18 slt: 0x21 objn: 54147(0x0000d383) objd: 54147 tblspc: 4(0x00000004)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000
*-----------------------------
uba: 0x00800892.0281.16 ctl max scn: 0x0000.00451e95 prv tx scn: 0x0000.00451e9b
txn start scn: scn: 0x0000.004523eb logon user: 61
prev brb: 0 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
op: Z
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 7
ncol: 1 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010001c4 hdba: 0x010001c3
itli: 2 ispac: 0 maxfr: 4858
vect = 0
col 0: [ 1] 61~~~~~~~~~~~~~~~~~~~~~~~記錄舊得值 a

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

關於redo 結構補充（使用者commit 時間）

1.update 後馬上commit

SQL> conn xh/a831115;
已連線。
SQL> select * from test;

A
----------
b

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 CURRENT
         3 INACTIVE

SQL> col member format a40
SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------
         3 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
           REDO03.LOG

2 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO02.LOG

1 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO01.LOG

SQL> update test set a='e';

已更新 1 行。

SQL> commit;~~~~~~~~~~~~如果update 後，緊接著 commit

SQL> alter system dump logfile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\REDO01.L
og';

系統已更改。

SQL> select object_id from user_objects where object_name='TEST';

OBJECT_ID
----------
     54147
SCN: 0x0000.0047ea28 SUBSCN: 8 10/22/2009 13:24:26
CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x010001c4 OBJ:54147 SCN:0x0000.0047e97c SEQ: 2 OP:11.19
KTB Redo
op: 0x11 ver: 0x01
op: F xid: 0x0002.010.00000572    uba: 0x008006cc.04e3.1a
Block cleanout record, scn: 0x0000.0047ea22 ver: 0x01 opt: 0x02, entries follow...
itli: 2 flg: 2 scn: 0x0000.0047e97c
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 1 ckix: 8
ncol: 1 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010001c4 hdba: 0x010001c3
itli: 1 ispac: 0 maxfr: 4858
vect = 0
col 0: [ 1] 65～～～～～新值
CHANGE #2 TYP:0 CLS:19 AFN:2 DBA:0x00800019 OBJ:4294967295 SCN:0x0000.0047e9e1 SEQ: 2 OP:5.2
ktudh redo: slt: 0x0010 sqn: 0x00000572 flg: 0x0012 siz: 176 fbi: 0
            uba: 0x008006cc.04e3.1a    pxid: 0x0000.000.00000000
CHANGE #3 TYP:0 CLS:19 AFN:2 DBA:0x00800019 OBJ:4294967295 SCN:0x0000.0047ea28 SEQ: 1 OP:5.4
ktucm redo: slt: 0x0010 sqn: 0x00000572 srt: 0 sta: 9 flg: 0x2
ktucf redo: uba: 0x008006cc.04e3.1a ext: 2 spc: 4558 fbi: 0
CHANGE #4 TYP:0 CLS:20 AFN:2 DBA:0x008006cc OBJ:4294967295 SCN:0x0000.0047e9e1 SEQ: 3 OP:5.1
ktudb redo: siz: 176 spc: 4736 flg: 0x0012 seq: 0x04e3 rec: 0x1a
            xid: 0x0002.010.00000572
ktubl redo: slt: 16 rci: 0 opc: 11.1 objn: 54147 objd: 54147 tsn: 4
Undo type: Regular undo        Begin trans    Last buffer split: No
Temp Object: No
Tablespace Undo: No
             0x00000000 prev ctl uba: 0x008006cc.04e3.17
prev ctl max cmt scn: 0x0000.0047e4f2 prev tx cmt scn: 0x0000.0047e52f
txn start scn: 0x0000.00000000 logon user: 61 prev brb: 8390340 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x000a.014.00000453 uba: 0x00800bc0.037a.2a
                      flg: C---    lkc: 0     scn: 0x0000.0047e8e8
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 8
ncol: 1 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x010001c4 hdba: 0x010001c3
itli: 1 ispac: 0 maxfr: 4858
vect = 0
col 0: [ 1] 64～～～～～～～～～=舊值

具體內容就不解釋了，可以看到這個redo record 產生了 4個 change vector，其中 change#2 ,chang#3都是修改 undo segment header 產生的 change vector
可以清楚的看到change#3是commit後的記錄( sta: 9 提交標記為9 代表已經提交)

2.實驗 update後過一會commit

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 UNUSED~~~~~~~~~~~~~~做了clear
         2 CURRENT
         3 UNUSED~~~~~~~~~~~~~~做了clear

SQL> alter system switch logfile;

系統已更改。

SQL> alter system checkpoint;

系統已更改。

SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CURRENT
         2 INACTIVE
         3 UNUSED

SQL> col member format a40
SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- ----------------------------------------
         3 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
           REDO03.LOG

2 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO02.LOG

1 F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\
REDO01.LOG

SQL> update test set a='bbb';

已更新 1 行。

SQL> select object_id from user_objects where object_name='TEST';

OBJECT_ID
----------
54147

SQL> select xidusn ,ubafil,UBABLK from v$transaction;

XIDUSN UBAFIL UBABLK
---------- ---------- ----------
9 2 523

SQL> select * from v$rollname where usn=9;

USN NAME
---------- ------------------------------
9 _SYSSMU9$

SQL> select header_block,header_file from dba_segments where segment_name='_SYSS
MU9$';

HEADER_BLOCK HEADER_FILE
------------ -----------
137 2

事務表儲存在 undo segment header file 2,block 137

SQL> alter system dump logfile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\REDO01.L
og';

系統已更改。

REDO RECORD - Thread:1 RBA: 0x00003e.00000019.0010 LEN: 0x01d0 VLD: 0x0d
SCN: 0x0000.0047effc SUBSCN: 13 10/22/2009 14:05:25
CHANGE #1 TYP:2 CLS: 1 AFN:4 DBA:0x010001c4 OBJ:54147 SCN:0x0000.0047efa0 SEQ: 1 OP:11.5
KTB Redo
op: 0x11 ver: 0x01
op: F xid: 0x0009.005.0000058e    uba: 0x0080020b.0209.26
Block cleanout record, scn: 0x0000.0047efe2 ver: 0x01 opt: 0x02, entries follow...
itli: 2 flg: 2 scn: 0x0000.0047efa0
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010001c4 hdba: 0x010001c3
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 1 ckix: 8
ncol: 1 nnew: 1 size: 1
col 0: [ 3] 62 62 62
CHANGE #2 TYP:0 CLS:33 AFN:2 DBA:0x00800089 OBJ:4294967295 SCN:0x0000.0047efb5 SEQ: 2 OP:5.2
ktudh redo: slt: 0x0005 sqn: 0x0000058e flg: 0x0012 siz: 152 fbi: 0
            uba: 0x0080020b.0209.26    pxid: 0x0000.000.00000000
CHANGE #3 TYP:0 CLS:34 AFN:2 DBA:0x0080020b OBJ:4294967295 SCN:0x0000.0047efb5 SEQ: 28 OP:5.1
ktudb redo: siz: 152 spc: 3380 flg: 0x0012 seq: 0x0209 rec: 0x26
            xid: 0x0009.005.0000058e
ktubl redo: slt: 5 rci: 0 opc: 11.1 objn: 54147 objd: 54147 tsn: 4
Undo type: Regular undo        Begin trans    Last buffer split: No
Temp Object: No
Tablespace Undo: No
             0x00000000 prev ctl uba: 0x0080020b.0209.0a
prev ctl max cmt scn: 0x0000.0047e801 prev tx cmt scn: 0x0000.0047e80c
txn start scn: 0x0000.0047ee52 logon user: 61 prev brb: 8388965 prev bcl: 0 KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
op: L itl: xid: 0x0002.010.00000572 uba: 0x008006cc.04e3.1a
                      flg: C---    lkc: 0     scn: 0x0000.0047ea28
KDO Op code: URP row dependencies Disabled
xtype: XA flags: 0x00000000 bdba: 0x010001c4 hdba: 0x010001c3
itli: 1 ispac: 0 maxfr: 4858
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 8
ncol: 1 nnew: 1 size: -1
col 0: [ 2] 62 62

此時 commit

SQL> alter system dump logfile 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\XHTEST\REDO01.L
og';

系統已更改。

SQL> commit;

檢視dump 多了一個 record

REDO RECORD - Thread:1 RBA: 0x00003e.000001c5.0010 LEN: 0x008c VLD: 0x05
SCN: 0x0000.0047f11a SUBSCN: 1 10/22/2009 14:06:59
CHANGE #1 TYP:0 CLS:33 AFN:2 DBA:0x00800089 OBJ:4294967295 SCN:0x0000.0047effc SEQ: 1 OP:5.4
ktucm redo: slt: 0x0005 sqn: 0x0000058e srt: 0 sta: 9 flg: 0x2
ktucf redo: uba: 0x0080020b.0209.26 ext: 2 spc: 3226 fbi: 0

這個 record 只有一個change vector 是針對undo segment header的當commit時記錄事務表tnb中 sta:9 表示提交

SQL> variable file# number;
SQL> variable blk# number;
SQL> execute :file#:=dbms_utility.data_block_address_file(to_number('800089','xx
xxxx'));

PL/SQL 過程已成功完成。

SQL> execute :blk#:=dbms_utility.data_block_address_block(to_number('800089','x
xxxxxxx'));

PL/SQL 過程已成功完成。

SQL> print file#

FILE#
----------
2

SQL> print block#
SP2-0552: 未宣告繫結變數 "BLOCK#"。
SQL> print blk#

BLK#
----------
137

如果要再進一步深入可以 dump下 undo segment header 檢視下事務表

state 9代表提交，10代表active
index就是 slot號碼
dba :對應的undo block address

TRN TBL::
index state cflags wrap#    uel         scn            dba            parent-xid    nub     stmt_num    cmt
------------------------------------------------------------------------------------------------
   0x00    9    0x00 0x058e 0x0017 0x0000.0047ef60 0x0080020b 0x0000.000.00000000 0x00000001   0x00000000 1256191265
   0x01    9    0x00 0x058e 0x0020 0x0000.0047ecce 0x00800166 0x0000.000.00000000 0x00000001   0x00000000 1256190197

.............................................................................................................................
0x2f 9 0x00 0x058d 0x000d 0x0000.0047ef0d 0x00800168 0x0000.000.00000000 0x00000002 0x00000000 1256191257

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

oracle實驗記錄 (oracle 詳細分析redo（1）)
2009-10-23
Oracle
oracle實驗記錄 (oracle 詳細分析redo（2）)
2009-10-23
Oracle
oracle實驗記錄 (oracle 詳細分析redo（3）)
2009-10-23
Oracle
oracle實驗記錄 (oracle 詳細分析redo（5）)
2009-10-23
Oracle
oracle實驗記錄 (oracle 10G 詳細分析undo)
2009-11-02
Oracle
oracle實驗記錄（恢復-redo）
2009-08-21
Oracle
oracle實驗記錄 (oracle 10G dataguard(4)redo傳輸&程式)
2009-11-16
Oracle
oracle實驗記錄(buffer_cache分析(4)dbwr,lgwr,ckpt)
2009-12-10
Oracle
oracle實驗記錄 (oracle 分析shared pool(1))
2009-10-08
Oracle
oracle實驗記錄（oracle 分析shared pool(2)）
2009-10-10
Oracle
oracle實驗記錄（dump undo4）
2009-06-26
Oracle
oracle實驗記錄（精細策略dbms_rls）
2009-07-28
Oracle
oracle實驗記錄 (buffer_cache分析（1）)
2009-11-26
Oracle
oracle實驗記錄 (oracle reset parameter)
2009-11-02
Oracle
oracle實驗記錄（flashback）
2009-07-31
Oracle
oracle實驗記錄（OMF）
2009-08-06
Oracle
oracle實驗記錄（NET）
2009-08-12
Oracle
oracle實驗記錄（audit）
2009-07-27
Oracle
oracle實驗記錄（分析oracle硬解析&軟解析&fast soft parse）
2009-09-29
OracleAST
oracle實驗記錄 (oracle 資料字典)
2009-09-24
Oracle
Oracle Data Redaction實驗記錄
2016-06-27
Oracle
oracle實驗記錄（block cleanout）
2009-06-26
OracleBloC
oracle實驗記錄（dump undo）
2009-06-26
Oracle
oracle實驗記錄（inlist card）
2009-08-05
Oracle
oracle實驗記錄 (分析oracle硬解析&軟解析&fast soft parse(2))
2009-10-18
OracleAST
oracle實驗記錄 (buffer_cache分析（2）cbc latch)
2009-11-26
Oracle
oracle實驗記錄（恢復-關於控制檔案(4)）
2009-09-11
Oracle
Oracle檔案改名實驗記錄
2013-04-22
Oracle
oracle實驗記錄（選擇率）
2009-06-26
Oracle
oracle實驗記錄（dump logfile）
2009-06-26
Oracle
oracle實驗記錄（事務控制）
2009-07-31
Oracle
oracle實驗記錄（函式index）
2009-08-05
Oracle函式Index
oracle實驗記錄（bigfile tablespace）
2009-07-28
Oracle
oracle實驗記錄（expdp/impdp使用）
2009-09-23
Oracle
oracle實驗記錄（transport tablespace(Rman)）
2009-09-24
Oracle
oracle實驗記錄（使用exp/imp）
2009-09-28
Oracle
oracle實驗記錄（oracle consistent gets 計算）
2009-10-02
Oracle
oracle redo檔案記錄的內容
2013-01-10
Oracle Redo

oracle實驗記錄 (oracle 詳細分析redo（4）)

相關文章