SQL> SELECT NAME,TYPE# FROM OBJ$ WHERE OBJ#=49;
NAME TYPE#
------------------------------ ----------
I_CON2 1
SQL> SELECT TABLE_NAME FROM DBA_INDEXES WHERE INDEX_NAME='I_CON2';
TABLE_NAME
------------------------------
CON$
SELECT OWNER#,NAME,CON# FROM CON$ WHERE NAME='_NEXT_CONSTRAINT';
SQL> SELECT OWNER#,NAME,CON# FROM CON$ WHERE NAME='_NEXT_CONSTRAINT';
OWNER# NAME CON#
---------- ------------------------------ ----------
0 _NEXT_CONSTRAINT 5213
--测试创建带有主键的表时con#值得变化
SQL> alter session set events '10046 trace name context forever,level 10';
Session altered.
SQL> create table test (id int primary key,value varchar2(20));
Table created.
SQL> select 'sunhailong' from dual;
'SUNHAILON
----------
sunhailong
SQL> SELECT OWNER#,NAME,CON# FROM CON$ WHERE NAME='_NEXT_CONSTRAINT';
OWNER# NAME CON#
---------- ------------------------------ ----------
0 _NEXT_CONSTRAINT 5214 --可以看到con#从5213增长为5214
SQL> oradebug tracefile_name
ORA-00074: no process has been specified
SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name
/oracle/app/admin/orcl/udump/orcl_ora_22472.trc
SQL> alter session set events '10046 trace name context off';
Session altered.
--dump block
SQL> SELECT OWNER#,NAME,CON#,
2 dbms_rowid.ROWID_RELATIVE_FNO(rowid) fno,
3 dbms_rowid.ROWID_BLOCK_NUMBER(rowid) bno,
4 dbms_rowid.ROWID_ROW_NUMBER(rowid) rno FROM CON$ WHERE NAME='_NEXT_CONSTRAINT';
OWNER# NAME CON# FNO BNO RNO
---------- ------------------------------ ---------- ---------- ---------- ----------
0 _NEXT_CONSTRAINT 5214 1 170 12
SQL> alter system dump datafile 1 block 170;
System altered.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug tracefile_name
/oracle/app/admin/orcl/udump/orcl_ora_22549.trc
Start dump data blocks tsn: 0 file#: 1 minblk 170 maxblk 170
buffer tsn: 0 rdba: 0x004000aa (1/170)
scn: 0x0000.000ac089 seq: 0x01 flg: 0x06 tail: 0xc0890601
frmt: 0x02 chkval: 0xf13c type: 0x06=trans data
Hex dump of block: st=0, typ_found=1
.........
Block header dump: 0x004000aa
Object id on Block? Y
seg/obj: 0x1c csc: 0x00.ac088 itc: 1 flg: - typ: 1 - DATA
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0002.022.00000145 0x008002cf.00c7.2c --U- 1 fsc 0x0000.000ac089
data_block_dump,data header at 0x1c1ba444
===============
tsiz: 0x1fb8
hsiz: 0x2ba
pbl: 0x1c1ba444
bdba: 0x004000aa
76543210
flag=--------
ntab=1
nrow=340
frre=-1
fsbo=0x2ba
f
seo=0x5a8
avsp=0x33a
tosp=0x33a
0xe:pti[0] nrow=340 offs=0
0x12:pri[0] offs=0x1fa7
0x14:pri[1] offs=0x1f95
0x16:pri[2] offs=0x1f84
0x18:pri[3] offs=0x1f70
0x1a:pri[4] offs=0x1f5c
0x1c:pri[5] offs=0x1f48
0x1e:pri[6] offs=0x1f36
0x20:pri[7] offs=0x1f24
0x22:pri[8] offs=0x1f10
0x24:pri[9] offs=0x1efc
0x26:pri[10] offs=0x1eea
0x28:pri[11] offs=0x1ed8
0x2a:pri[12] offs=0x5a8
0x2c:pri[13] offs=0x1ec4
0x2e:pri[14] offs=0x1eb0
0x30:pri[15] offs=0x1e9e
0x32:pri[16] offs=0x1e8c
... ...
0x2b8:pri[339] offs=0x60e
block_row_dump:
tab 0, row 0, @0x1fa7
tl: 17 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 8] 53 59 53 5f 43 30 30 33
col 2: [ 2] c1 04
tab 0, row 1, @0x1f95
tl: 18 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 9] 53 59 53 5f 43 30 30 37 31
col 2: [ 2] c1 48
tab 0, row 2, @0x1f84
tl: 17 fb: --H-FL-- lb: 0x0 cc: 3
col 0: [ 1] 80
col 1: [ 8] 53 59 53 5f 43 30 30 34
col 2: [ 2] c1 05
tab 0, row 3, @0 |