Re: initrans for table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 10 Oct 2002 14:23:02 +0100
Message-ID: <ao3v1p$2ig$1$8302bc10@news.demon.co.uk>

In general, data blocks are not formatted until they are about to be used. (This isn't 100% true, though).

Note the seg/obj entries on the datablocks you have dumped:

>buffer tsn: 7 rdba: 0x02004892 (8/18578)
> seg/obj: 0x336e
>buffer tsn: 7 rdba: 0x02004894 (8/18580)
> seg/obj: 0x1a41

You have two different object numbers here - You are dumping blocks which used to belong to other data segments - not 'empty' blocks belonging to the new data segment.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Harry Sheng wrote in message ...


>3. alter system dump datafile 8 block min 18577 block max 18582

>




>buffer tsn: 7 rdba: 0x02004892 (8/18578)

>scn: 0x0000.00089559 seq: 0x01 flg: 0x02 tail: 0x95590601

>frmt: 0x02 chkval: 0x0000 type: 0x06=trans data

>

>Block header dump:  0x02004892

> Object id on Block? Y

> seg/obj: 0x336e  csc: 0x00.7fcd9  itc: 2  flg: O  typ: 1 - DATA

>     fsl: 0  fnx: 0x0 ver: 0x01

>

> Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

>0x01   xid:  0x0004.04d.00000123    uba: 0x00802853.003b.09  --U-    1  fsc

>0x0000.00089559

>0x02   xid:  0x0005.00c.00000128    uba: 0x00c015b3.003d.07  --U-    1  fsc

>0x0000.00089557

>

>data_block_dump

>===============

>tsiz: 0x1fa0

>hsiz: 0x16

>pbl: 0x018a909c

>bdba: 0x02004892

>flag=-----------

>ntab=1

>nrow=2

>

>

>

>buffer tsn: 7 rdba: 0x02004894 (8/18580)

>scn: 0x0000.0003334b seq: 0x02 flg: 0x00 tail: 0x334b0602

>frmt: 0x02 chkval: 0x0000 type: 0x06=trans data

>

>Block header dump:  0x02004894

> Object id on Block? Y

> seg/obj: 0x1a41  csc: 0x00.3334b  itc: 1  flg: -  typ: 1 - DATA

>     fsl: 0  fnx: 0x0 ver: 0x01

>

> Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

>0x01   xid:  0x0003.011.0000007a    uba: 0x01000503.0018.04  C---    0  scn

>0x0000.0003334a

>

>data_block_dump

>===============

>tsiz: 0x1fb8

>hsiz: 0x2c

>pbl: 0x018a9084

>bdba: 0x02004894

>flag=-----------

>ntab=1

>nrow=13

>

>

>

>buffer tsn: 7 rdba: 0x02004895 (8/18581)

>scn: 0x0000.00033365 seq: 0x02 flg: 0x00 tail: 0x33650602

>frmt: 0x02 chkval: 0x0000 type: 0x06=trans data

>

>Block header dump:  0x02004895

> Object id on Block? Y

> seg/obj: 0x1a41  csc: 0x00.33365  itc: 1  flg: -  typ: 1 - DATA

>     fsl: 0  fnx: 0x0 ver: 0x01

>

> Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

>0x01   xid:  0x0007.008.0000006b    uba: 0x00802d89.0018.2f  C---    0  scn

>0x0000.00033364

>

>data_block_dump

>===============

>tsiz: 0x1fb8

>hsiz: 0x2c

>pbl: 0x018a9084

>bdba: 0x02004895

>flag=-----------

>ntab=1

>nrow=13

>frre=-1

>

Received on Thu Oct 10 2002 - 08:23:02 CDT