I'm having the same thing, ls shows the good size but
when adding the sizes I'm getting from du -k ,it
doesn't match. Solaris 2.7 Oracle 8.1.6 32 bits.
I'm installing Oracle 8.1.6 64 bits right now and I'll
check the behavior.
By the way, can I just shutdown a db move it to
another server running Oracle 8.1.6 64 bits and
started it ? Any conversion process when moving from a
32 bits to 64 bits Oracle software ?
TIA
- "Lewis, Ed" <Ed_Lewis_at_PremierInc.com> a écrit : >
I've experienced the same behavior.
> An "ls" on the file shows the correct size,
> but a "dk" on the filesystem doesn't.
> I came across this when trying to create
> another datafile on the same filesystem,
> but ran out of space, when there was enough
> space (at least via "dk") to create the file.
> It was only with "temp" files that I saw this
> behavior.
> I still don't have an explanation.
>
> solaris 2.7, oracle 8.1.6.2.1
>
> -----Original Message-----
> Sent: Friday, November 03, 2000 4:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> We're running 8.1.6 and 8.1.7 on Sun Sparc/Solaris.
>
> Not observing this. When we create the tablespace
> the data file space
> immediately
> shows up. Since Oracle is not formatting the files,
> the create happens very
> fast.
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Friday, November 03, 2000 12:30 PM
>
>
> > Hi,
> >
> > I cteated a Temporary Tablespace in 8.1.6.2 with
> the followinf statement.
> >
> > CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_21' SIZE 2000M
> > EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M
> >
> > and subsequently added more datafiles
> >
> > ALTER TABLESPACE TEMP1 add TEMPFILE
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_25' SIZE 2000M
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_26' SIZE 2000M
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_27' SIZE 2000M
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_28' SIZE 2000M
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_29' SIZE 2000M
> > '/data/YIPEEIA/u08/p03_ss02_d06_2g_10' SIZE 2000M
> > /
> >
> > When i query the datadictionary tables i get
> >
> > SQL> select FILE_NAME from dba_data_files where
> TABLESPACE_NAME = 'TEMP1';
> > no rows selected
> >
> > and
> >
> > select
> TABLESPACE_NAME,EXTENT_MANAGEMENT,STATUS,CONTENTS
> from
> dba_tablespaces;
> >
> > SAM_T_SPLY_TYPE_T LOCAL ONLINE
> PERMANENT
> > SAM_T_SPLY_TYPE_I LOCAL ONLINE
> PERMANENT
> > TEMP1 LOCAL ONLINE
> TEMPORARY
> >
> > which i think is as per the Docs
> >
> > But the Strange part is that the datafiles doesnt
> consume any space in the
> filesystem unless i do some activity (Index builds)
> in
> the TEMP1 tablespace.
> >
> > This Can become a problem if at a time of
> Temporary tablespace inactivity
> , other DBA's may try to add datafiles to other
> Tablespaces since there is Free (virtual) space
> available.
> >
> > Please advise....
> >
> >
> > Cheers
> >
> > Arun Jacob M
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
> > Be someone_at_0racledba.com - get your free mail from
> Oriole Corporation
> > http://www.oriolecorp.com - Performance tools
> for Oracle DBAs
> >
> > Get email for your site --->
> http://www.everyone.net
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Arun J Muthalaly
> > INET: arunjacob_at_0racledba.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_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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Tom Pall
> INET: tom_at_cdproc.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_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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Lewis, Ed
> INET: Ed_Lewis_at_PremierInc.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_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).
Stephane Paquette
DBA Oracle
Received on Tue Nov 07 2000 - 01:32:09 CST
