Printable View
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.
Are u telling that toad/oem gives different result comparing to sqlplus>
Maybe u can play with this script:Quote:
Originally posted by mdash
Are u telling that toad/oem gives different result comparing to sqlplus>
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;
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.Quote:
Originally posted by mdash
Are u telling that toad/oem gives different result comparing to sqlplus>
set a max size for the fileQuote:
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 max file size maybe cause the system hanging
What are u talking about?Quote:
Originally posted by wengyan
set max file size maybe cause the system hanging