Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large size of TEMP01.DBF
<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