Re: Maxbytes sifgnification
Date: Wed, 23 Jan 2008 06:45:42 -0800 (PST)
On 23 jan, 15:31, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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 BYTES
> -------------------------------------------------- ----------
> /d09/oradata/********/system01.dbf 367001600
> 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
no problem! I'm still puzzled since i do not have a zero value for
maxbytes but 10Go or 32Go or the same as the BYTES column for
tablespaces where autoextend is off.
I also cannot spot the difference between those tablespaces ! (creation method, modifications done, etc.). Received on Wed Jan 23 2008 - 08:45:42 CST