-
problem in temp tablespace
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
-
Are you looking at the TEMP through OEM/TOAD, if so this is normal behaviour. The segments are not automatically deallocated unless you shutdown.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
Are u telling that toad/oem gives different result comparing to sqlplus>
-
Originally posted by mdash
Are u telling that toad/oem gives different result comparing to sqlplus>
Maybe u can play with this script:
SELECT tablespace_name, extent_size, total_extents, used_extents, free_extents, max_used_size
FROM v$sort_segment;
or this :
SELECT s.username, u.tablespace, u.contents, u.extents,u.blocks FROM v$session s, v$sort_usage u
WHERE s.saddr=u.session_addr;
---------------
-
Originally posted by mdash
Are u telling that toad/oem gives different result comparing to sqlplus>
OEM will show you the extents allocated in the tablespace, once these extents have been allocated they are reused by other sessions. OEM cannot always provide an acurate picture of the segments in use.
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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"
-
set max file size maybe cause the system hanging
-
Originally posted by wengyan
set max file size maybe cause the system hanging
What are u talking about?
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"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|