TEMP Tablespace problem

From: Mostafa Eletriby <m_etrib@xxxxxxxxx>
To: Oracle DBAs Group <ora-apps-dba@xxxxxxxxxxxxx>
Date: Fri, 20 Feb 2009 13:54:57 -0800 (PST)

Hi DBAs
 
I have a problem in my Temp Tablespace which can cause to me a disaster.
This day I found my TEMP Tablespace in production system grows so large and 
exceeded the limits.
I dont know why this happened, it became so fast very large.
 
As You see in the print screen. It reached 12 GB for the two temp datafiles.
I need a scenario please to drop that tablespace and create it again with two 
temp datafiles each file is 1800 MB   Reusable and auto extend with 100 MB as 
It was before.
 
& what precautions should I take before I do the action plan.
 
Please rsend me a quick reply if possible before working hours start and these 
files grows larger and I can't manage the free space in drive.
 
we are working over Oracle Applications 11i.5.10.2
Database  9.2.0.8
Operating syatem windows 2000
 
Thanks alot
Regards,

Attachment: TEMP_TS_Psc.JPG
Description: image/pjpeg

Follow-Ups:

Re: TEMP Tablespace problem
From: Mohamed Ahmed Mostafa

TEMP Tablespace problem

Other related posts: