Sundaramurthy Blog

January 23, 2010

Oracle Block

Filed under: Oracle internals — sundar5 @ 7:19 pm

CREATE TABLE test
(col1 NUMBER, col2 VARCHAR2(200)) storage (freelists 4);

Start dump data blocks tsn: 4 file#: 5 minblk 18 maxblk 18
buffer tsn: 4 rdba: 0x01400012 (5/18)
scn: 0x0000.000c786e seq: 0x02 flg: 0x00 tail: 0x786e1002
frmt: 0x02 chkval: 0x0000 type: 0x10=DATA SEGMENT HEADER – UNLIMITED
Extent Control Header
—————————————————————–
Extent Header:: spare1: 0 space2: 0 #extents: 1 #blocks: 15
last map 0x00000000 #maps: 0 offset: 4128
Highwater:: 0x01400013 ext#: 0 blk#: 0 ext size: 15
#blocks in seg. hdr’s freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 1 obj#: 27042 flag: 0x40000000
Extent Map
—————————————————————–
0x01400013 length: 15
nfl = 4, nfb = 1 typ = 1 nxf = 0
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
SEG LST:: flg: UNUSED lhd: 0x00000000 ltl: 0x00000000
End dump data blocks tsn: 4 file#: 5 minblk 18 maxblk

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: