Temporary tablespace usage
From: Schauss, Peter (ESS) <"Schauss,>
Date: Wed, 26 Mar 2014 16:41:46 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0D272C0B_at_XMBVAG74.northgrum.com>
This is Oracle 11.2.0.3 running on 32 bit Windows. We have had an "ORA-1652 - Unable to extend temp segment ..." and I am trying to get an idea of how much larger the temp tablespace needs to be based on previous use.
from v$sort_segment
where tablespace_name='TEMP';
Date: Wed, 26 Mar 2014 16:41:46 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C0D272C0B_at_XMBVAG74.northgrum.com>
This is Oracle 11.2.0.3 running on 32 bit Windows. We have had an "ORA-1652 - Unable to extend temp segment ..." and I am trying to get an idea of how much larger the temp tablespace needs to be based on previous use.
When I run this query:
select total_blocks*8192/1000000000 Total,
free_blocks*8192/1000000000 Free, current_users, max_sort_size*8192/1000000000 Max
from v$sort_segment
where tablespace_name='TEMP';
I get:
TOTAL FREE CURRENT_USERS MAX 35.06962432 35.060187136 9 0.273932288
Does this mean that the high water mark in TEMP since the last database restart is 35 gb and the maximum use by any session is .27 gb?
Is there anything other than the sort segment which uses space in TEMP?
Thanks,
Peter Schauss
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 26 2014 - 17:41:46 CET