Temporary tablespace usage
- From: "Schauss, Peter (ESS)" <peter.schauss@xxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Mar 2014 16:41:46 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
