Re: problem in temp tablespace
Originally posted by elibz
i have a problem with a oracle 8i 8.1.7
my temp tablespace grow and dont stop to grow untill i shutdown the database and start it again.
after i restart the database the temp is empty
how can i check what is the problem???
the temp dont clean even the session is closed.
regrads,
eli
set a max size for the file
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"