Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ***8i Temporary Tablespace -Tempfile * Locally Managed

RE: ***8i Temporary Tablespace -Tempfile * Locally Managed

From: Lewis, Ed <Ed_Lewis_at_PremierInc.com>
Date: Mon, 6 Nov 2000 09:14:43 -0500
Message-Id: <10672.121222@fatcity.com>


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-----
From: Tom Pall [mailto:tom_at_cdproc.com]
Sent: Friday, November 03, 2000 4:00 PM
To: Multiple recipients of list ORACLE-L Subject: Re: ***8i Temporary Tablespace -Tempfile * Locally Managed

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
Received on Mon Nov 06 2000 - 08:14:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US