Message-Id: <10625.117436@fatcity.com> From: "Deshpande, Kirti" Date: Wed, 20 Sep 2000 07:55:04 -0500 Subject: RE: File Size on OS & v$datafile Differ ? I don't think so. Haven't seen any.. yet ! - Kirti > -----Original Message----- > From: VIVEK_SHARMA [SMTP:VIVEK_SHARMA@infy.com] > Sent: Wednesday, September 20, 2000 7:50 AM > To: 'kirti.deshpande@verizon.com' > Cc: 'ORACLE-L@fatcity.com'; 'oracledba@lazydba.com' > Subject: RE: File Size on OS & v$datafile Differ ? > > > Can it Differ by values GREATER than Block - size e.g. 1-2 MB ? > If so under what conditions ? > > > > -----Original Message----- > > From: Deshpande, Kirti [SMTP:kirti.deshpande@verizon.com] > > Sent: Tuesday, September 19, 2000 7:47 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: File Size on OS & v$datafile Differ ? > > > > UNIX reports the real size taken up by the file, but dba_data_files > report > > the size EXCLUDING 1 db_block_size, since Oracle keeps 1 block for its > > file > > header information that is not available for user data. > > HTH.. > > - Kirti > > > > > -----Original Message----- > > > From: VIVEK_SHARMA [SMTP:VIVEK_SHARMA@infy.com] > > > Sent: Tuesday, September 19, 2000 3:15 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: File Size on OS & v$datafile Differ ? > > > > > > > > > ls -al of a Datafile on the Unix O.S. prompt shows a File Size which > > > DIFFERS > > > from the "BYTES" Size shown in v$datafile (oe sys.dba_data_files . > > > > > > Why ? > > > > > > To what MAX Limit can they Differ ? > > > > > > -- > > > Author: VIVEK_SHARMA > > > INET: VIVEK_SHARMA@infy.com > > > > > > 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@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). > > -- > > Author: Deshpande, Kirti > > INET: kirti.deshpande@verizon.com > > > > 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@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).