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 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, 
	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?

Peter Schauss

Received on Wed Mar 26 2014 - 17:41:46 CET

Original text of this message