RE: ?: ?Problem with resize

From: Trassens, Christian <CTrassens_at_uni2.es>
Date: Thu, 18 Jan 2001 12:17:41 +0100
Message-Id: <10745.126969@fatcity.com>

Yong,

V$datafile stores the size from block #1. In contrast OS does it from = block
#0. Use the Oracle utility dbfsize to verify the amount of blocks. So = then
compare it with the result from v$datafile.

Regards.

> -----Mensaje original-----
> De: yong huang [SMTP:yong321_at_yahoo.com]
> Enviado el: mi=E9rcoles 17 de enero de 2001 17:08
> Para: Multiple recipients of list ORACLE-L
> Asunto: Re: ?: ?Problem with resize

>=20
> Adding to what you say, the BYTES column may not be exactly equal to =
the
> actual
> size on the file system. For example, on my Solaris 2.6 ufs file =
system,
> one
> datafile is 1073758208 bytes from ls -l output. In the database,
> v$datafile.bytes is 1073741824. The difference is 16384, exactly one =
block
> size. I'm not sure how to explain.

>=20

> Yong Huang
> yong321_at_yahoo.com

>=20

> Arvind wrote:

>=20

> This is not a bug.

>=20

> Create_bytes referes to the size when initially
> created the datafile. It never changes even when u
> resize the datafile. On the other hand bytes refers to
> the existing size of the datafile. Whenever u resize
> the datafile only bytes column of v$datafile changes.

>=20

> Arvind

>=20


> __________________________________________________

> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.=20
> http://personal.mail.yahoo.com/
> --=20
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --=20
> Author: yong huang
> INET: yong321_at_yahoo.com

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Jan 18 2001 - 05:17:41 CST