Temp tablepace max size question [message #215779] |
Tue, 23 January 2007 21:35 |
honeybee
Messages: 4 Registered: September 2006 Location: Malaysia
|
Junior Member |
|
|
Hi,
I understand that we can get information on temp tablespace by looking at v$sort_segment. I also understand that sometimes space information in temp tablespace is 100%(full) not because it is really full but due to space allocation to the temp tablespace. As for my case, i query v$sort_segment and here is the result
select TABLESPACE_NAME, TOTAL_EXTENTS,USED_EXTENTS, FREE_EXTENTS,MAX_SIZE from v$sort_segment
TABLESPACE_NAME TOTAL_EXTENTS USED_EXTENTS FREE_EXTENTS MAX_SIZE
--------------- ------------- ------------ ------------ --------
TEMP 3511 0 3511 3511
From the documentation from oracle, i see that the MAX_SIZE is the maximum number of extents ever used. As for my case, I think I have already reached the max. So how can i determine the size of the temp so that it will not reach max? Will there be any problem if the max is exceeded?? Thank you
|
|
|