Re: Temporary tablespace size

> Sorry it still there after shutdown the instance twice, I mean on
> Enterprise Manager (I am Oracle newbie and I started to be "Oracle
> DBA" 3 months ago), it still shows the 3253M out of 4000M of temporary
> space IS USED. Initially the word "USED" confused me. I am pretty sure
> it is actually a HWM as identified on space header after I did these
> search (I am the only use and no user seesion is connected when I did
> the query):

Are you using tempfiles or datafiles? IIRC, if you are using datafiles, then SMON has to clean up the temp space after the database is started. It can take a long time for SMON to perform this. Do a 'ps -ef|grep smon' and see if SMON is getting large amounts of CPU time. If so, then this can be an indication that SMON is trying to clean this stuff up.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"