Re: Temporary tablespace size

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F3A4589.BA3399ED_at_remove_spam.peasland.com>...
> > 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"

Thanks Brian.

I use tempfiles and I could not find any busy activities of SMON regarding this.

Gary Received on Wed Aug 13 2003 - 18:24:00 CDT