> 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@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"

Brian Peasland <dba@remove_spam.peasland.com> wrote in message news:<3F3A4589.BA3399ED@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@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