</p> 7、DUMP出数据文件(只能是alter system)5 f- W1 S+ R# Q
alter system dump datafile n block m
( |; j3 o; b9 E. ^2 b 如, l$ u4 H( U7 B Y$ s
select file_id,block_id,blocks from dba_extents where segment_name='EMPLOYEES'
3 N" d1 a" Z& v$ ~0 k FILE_ID BLOCK_ID BLOCKS3 ~9 t8 P4 ]3 u E7 f1 X& J( n8 N
---------- ---------- ------------------
( i3 h/ N0 Q9 ~" b% i 5 81 8
" X* ]0 P9 J- y# w; s4 O; D SQL>alter system dump datafile 5 block 81;
6 k1 Q: P8 D4 b) }: J4 Z5 I System altered.: r Q$ p O( V" P" _
此外是做很具体的针对某行地址的BLOCK 并DUMP出来研究,可以用如下体例* y! T4 }9 i& d: @8 p
1、取BLOCK号 l4 T; F, i" o0 Q% T& R
select dbms_rowid.rowid_block_number(rowid) from wdjk1999;. F- y( b% ?1 o, d! K. o2 w
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
e0 B2 R% h" K1 r2 I 78
8 [6 u2 y0 i7 w& r, `2 ^4 v, o 2、取文件号9 M7 Z& p M5 n) E6 o
select file_id from dba_data_files where tablespace_name='WDJK1999'
; k6 x) \8 A' L, Q- T; E- O FILE_ID( m- r% A* c- S8 l( k; p5 S+ W& O
----------
* S' O' g9 ~& e& w1 w" @, k 16
0 h! D0 z( L8 k7 Z& K; E SQL>alter system dump datafile 16 block 78;( W0 t+ ?" b: O
System altered.
; ~$ a- _, F7 H* W3 r —————————————————————————
1 j6 n4 Z. X' P 8、DUMP出索引9 h- S G o9 T+ X" _. C
SQL> select object_id from dba_objects where object_name=upper('index_name');
/ n" V4 y/ ~6 c. x) {. |/ h OBJECT_ID+ }( N! m" w/ J& Z& [
----------
! K% f( [" P. n, {4 v 70591
* j1 v$ K% n7 h1 Y0 @ x SQL> alter session set events 'immediate trace name TREEDUMP level 70591';4 t$ r% w7 W8 M$ i8 m% b
—————————————————————————————
8 V) ^! k, D* @( G 9、DUMP出回滚段信息2 _" [5 v% ~3 [6 N, d0 v& A6 C0 q+ X
select xidusn,xidslot,xidsqn,ubafil,ubablk,ubasqn,ubarec from v$transaction;
5 K& x3 v3 X0 @( }% G# r5 V- N XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC/ J1 R% x8 ^; I+ U. f7 j
----------- ------------ ------------ ---------- ------------ ------------ -------------3 P e' {; F+ y* R5 ~, b
1 31 442 2 21 242 52- L- L E$ k R) |
dump对应的undo block
# f! t6 M* a2 G3 | alter">SYS@ning>alter system dump datafile 2 block 21;
" }2 c8 v! f, L1 s) Z d i" G, T K System altered.
: R: \. x; ~, b+ a ——————————————————————————
; k4 v' d' ~0 h 10、 DUMP出系统状况剖析 (只能是SYSTEM)' R- w* Z. n: x/ U
alter system set events 'immediate trace name systemdate level 10'
9 x( T0 K, I9 C$ h; y: z1 O. p' b/ V5 v* E6 a. u" ]
—————————————————————————— |