Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!nntp2.aus1.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!kibo.news.demon.net!news.demon.co.uk!demon!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: initrans for table
Date: Thu, 10 Oct 2002 14:23:02 +0100
Lines: 122
Message-ID: <ao3v1p$2ig$1$8302bc10@news.demon.co.uk>
References: <xo%o9.15131$H67.68419@tor-nn1.netcom.ca> <ao28fv$2g$1$8302bc10@news.demon.co.uk> <jYep9.15184$H67.68691@tor-nn1.netcom.ca>
NNTP-Posting-Host: jlcomp.demon.co.uk
X-Trace: news.demon.co.uk 1034256250 2640 158.152.75.41 (10 Oct 2002 13:24:10 GMT)
X-Complaints-To: abuse@demon.net
NNTP-Posting-Date: Thu, 10 Oct 2002 13:24:10 +0000 (UTC)
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163721
X-Received-Date: Thu, 10 Oct 2002 06:24:06 MST (news.easynews.com)


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
>