Re: Maxbytes sifgnification
Date: Wed, 23 Jan 2008 06:31:07 -0800 (PST)
Message-ID: <56b41508-91fc-4839-8c94-50bbe11041e6@z17g2000hsg.googlegroups.com>
On Jan 23, 8:12 am, teddyber <teddy..._at_gmail.com> wrote:
> On 23 jan, 15:01, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > Comments embedded.
> > On Jan 23, 7:25 am, teddyber <teddy..._at_gmail.com> wrote:
>
> > > Hello,
>
> > > I understand what this MAXBYTES column (DBA_DATA_FILES) means for an
> > > autoextensible datafile. What I don't know is the meaning of this
> > > column when the datafile is NOT autoextensible.
>
> > It's the current size of the datafile.
>
> not exactly. Actually I fell upon this question because I had (and
> still have!) different values for BYTES and MAXBYTES columns for
> datafiles not autoextensible.
> BYTES is the size of the file on the filesystem.
>
>
>
> > > Also, how is this
> > > value initialized/changed by Oracle for this kind of datafile?
>
> > alter database datafile '.......' resize [some number here];
>
> this only affects the filesize and the changes the BYTES column on my
> server...
>
>
>
>
>
> > which sets the maxbytes to the newly adjusted size.
>
> > > I can't find any clue in Oracle doc or groups or any Oracle related-
> > > page. Anyone can tell?
> > > Thanks.
>
> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
Looking at 10.2.0.3 I see the following:
FILE_NAME BYTESMAXBYTES
-------------------------------------------------- ---------- ---------- /d09/oradata/********/system01.dbf 3670016000
So I stand corrected (teaches me to answer from memory). MAXBYTES is 0 which indicates the file is not autoextensible. It won't change until you activate autoextend for that file.
My apologies for answering without the aid of investigation.
David Fitzjarrell Received on Wed Jan 23 2008 - 08:31:07 CST