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

Home -> Community -> Usenet -> c.d.o.server -> Re: Large size of TEMP01.DBF

Re: Large size of TEMP01.DBF

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Mon, 16 May 2005 11:02:03 -0400
Message-ID: <Dy2ie.1777$g4.31331@tor-nn1.netcom.ca>


<anandmohans_at_gmail.com> a écrit dans le message de news:1116254907.783050.298410_at_g44g2000cwa.googlegroups.com...
> Hi All,
>
> I was taking cold backup of my database by simply copying and archiving
> the dbf files when I noticed that TEMP01.DBF has grown upto 8 GB.
>
> For now, I've two queries:
> - How can I determine the operation that caused this file to grow?
> - I know that this file is used for temporary operations; so can I
> simply skip (or maybe delete) this file and archive rest of the files?
>
>
> Regards,
> Anand

I don't think you can tell what operation caused it to grow, but you can prevent it in the future (provided that you want to allow some job to fail in your application). Otherwise you'll have to monitor the usage (V$TEMPSEG_USAGE / V$SORT_USAGE) probably using a DBMS_JOB.

If you want to prevent it from growing, disable auto extend from the file.

Don't backup this file. Just recreate it after a restore. The instructions for that are included in the ALTER DATABASE BACKUP CONTROLFILE TO TRACE output.

HTH

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
Received on Mon May 16 2005 - 10:02:03 CDT

Original text of this message

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