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: Tablespaces - datafiles

RE: Tablespaces - datafiles

From: Nick Wagner <Nick.Wagner_at_quest.com>
Date: Tue, 11 Mar 2003 14:43:58 -0800
Message-ID: <F001.00567000.20030311144358@fatcity.com> 





there was an old (as in it's now fixed) VxFS bug that sparse files did not
actually free up the space after they were deleted.  It will also cause df,
du, and ls to show different values.  
 


Nick
 
 


-----Original Message-----


Sent: Tuesday, March 11, 2003 1:51 PM


To: Multiple recipients of list ORACLE-L




Not on that machine...  Although we do have VxFS here and the behavior is
the same as UFS...  As others have pointed out, it is using sparse files for
temporary tablespaces and these can "bite you" if you are not careful...
 


Out of curiosity, why did you ask?
 


Tim



-----Original Message-----


Sent: Tuesday, March 11, 2003 3:57 PM


To: Multiple recipients of list ORACLE-L





are you using VxFS? 



-----Original Message----- 


<mailto:TJohnston_at_quallaby.com> ] 



Sent: Tuesday, March 11, 2003 12:14 PM 


To: Multiple recipients of list ORACLE-L 




Create the tablespace and look at it with ls and du... 



$ ls -lrt /export/home0/oradata/PV408/temp3.dbf 
-rw-r-----   1 oracle   dba      524304384 Mar 11 15:05 
/export/home0/oradata/PV408/temp3.dbf 



$ du -sk /export/home0/oradata/PV408/temp3.dbf 
104     /export/home0/oradata/PV408/temp3.dbf 



This is Solaris 8 



Tim 



-----Original Message----- 


Sent: Tuesday, March 11, 2003 2:43 PM 


To: Multiple recipients of list ORACLE-L 




Tom, 



Do you have that doc ref handy? 



Using this SQL: 



create temporary tablespace temp3 tempfile '/u01/oradata/dv03/temp3.dbf' 
size 500m 


extent management local uniform size 1m 
/ 



On both 8.1.7.0 and 9.2.0.1 on RH 7.2 I found that the file was 
immediately created full size. 



Platform dependencies maybe? 



Jared 








"Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us> 
Sent by: root_at_fatcity.com 


 03/11/2003 06:19 AM 


 Please respond to ORACLE-L 



        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
        cc: 
        Subject:        RE: Tablespaces - datafiles 






LeRoy, 



I just struggled with this last week.  You can't move Temporary Data 
files. 


You need to drop and recreate the TEMP tablespace - creating the data 
files 


in the correct directories. 



On a side note - here is an interesting feature.  When Oracle creates 
files 


for the TEMP tablespace, it does not create the files full sized like it 
does for normal data files.  It creates them smaller for speed purposes 
(it 


creates the TEMP tablespace very fast) and will allow the TEMP data files 
to 


grow as needed. 



Now here is the kicker.  Let's say you have a disk that is 9 gig is size. 
You can create 10-1 Gig Temp data files on that disk.  Since Oracle does 
not 


create the files full-sized, there is nothing to stop this from happening. 
Sometime later, as the TEMP tablespace gets used, the files grow until 
eventually the disk fills up, and a sql query crashes with an obscure disk 
io error.  Oracle is trying to expand the TEMP datafiles to the size it's 
been told they should be.  But there is no physical space left on disk. 



Documentation in 817 does not mention this.  But 92 doc's are up to date. 



nice surprise, eh? 



Tom Mercadante 


Oracle Certified Professional 




-----Original Message----- 


Sent: Tuesday, March 11, 2003 8:39 AM 


To: Multiple recipients of list ORACLE-L 




All - 



I am having a problem with the datafiles in a temporary tablespace.  I 
need to move and rename three different datafiles in the tablespace.  I 
am able to take them offline - no problem.  I cna make the changes at 
the OS level.  I am running on Unix.  But I can't get the changes to 
show up in the OEM inorder to bring them back on-line. 



Do I need to remove all users from this tablespace before making these 
changes?  The tablespace is temporary so does that make a difference? 
Any suggestions? 



LeRoy 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net


<http://www.orafaq.net>  

-- 
Author: LeRoy Kemnitz 
  INET: lkemnitz_at_uwsa.edu 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
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.net


<http://www.orafaq.net>  

-- 
Author: Mercadante, Thomas F 
  INET: NDATFM_at_labor.state.ny.us 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
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.net


<http://www.orafaq.net>  

-- 
Author: 
  INET: Jared.Still_at_radisys.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
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.net


<http://www.orafaq.net>  

-- 
Author: Johnston, Tim 
  INET: TJohnston_at_quallaby.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com


<http://www.fatcity.com>  

San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
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.net
-- 
Author: Nick Wagner
  INET: Nick.Wagner_at_quest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).


Received on Tue Mar 11 2003 - 16:43:58 CST












Original text of this message













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