RE: smon and cleanup temporary tablespaces in 9i R 2

From: Gogala, Mladen <MGogala_at_oxhp.com>
Date: Fri, 16 May 2003 11:34:38 -0800
Message-ID: <F001.0059B410.20030516113438@fatcity.com>

What exactly would you want SMON to do to temporary tablespaces? Temporary extents are being reused,
as of 8.1.7. V$SORT_USAGE is your best bet. If you're running out of temporary tablespace, allocate
some more, set autoextend on or let your files be managed by oracle.  

Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:mgogala_at_oxhp.com

-----Original Message-----
Sent: Friday, May 16, 2003 2:27 PM
To: Multiple recipients of list ORACLE-L    

Hi  

Is there anyone that knows how to put smon working to cleanup temporary tablespaces in 9i R 2?  

If so can u help me, please?  

thanks
PG

--

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

Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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 Fri May 16 2003 - 14:34:38 CDT