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: gmei <gmei_at_incyte.com>
Date: Tue, 11 Mar 2003 06:59:20 -0800
Message-ID: <F001.00565FE6.20030311065920@fatcity.com>


Tom:

You are absolutely right. What I do is to have a nightly script to check the available disk space (using "df -k" and awk) and total sum of dba_temp_files to make sure there always enough disk space for the LMT temp tablespace.

Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> Mercadante,
> Thomas F
> Sent: Tuesday, March 11, 2003 9:19 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tablespaces - datafiles
>

.....
> 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
> --
> Author: LeRoy Kemnitz
> INET: lkemnitz_at_uwsa.edu
>
> 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).
> --
> Please see the official ORACLE-L FAQ: 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
> 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: gmei
  INET: gmei_at_incyte.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 - 08:59:20 CST

Original text of this message

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