Re: Temporary tablespace usage

Max_sort_size is the number of extents. I think you should have used max_sort_blocks...

If you are using GTTs these also take up space in temp.

Ronan
On 26 Mar 2014 16:44, "Schauss, Peter (ESS)" <peter.schauss_at_ngc.com> wrote:

> 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-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l