Re: Temporary tablespace usage
- From: Ronan Merrick <merrickronan1@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Wed, 26 Mar 2014 19:42:52 +0000
Peter,
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@xxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
