Home » RDBMS Server » Server Administration » Temp tablepace max size question
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



Previous Topic: Need Help Setting up Streams getting ORA-26687 error
Next Topic: hOW TO FIND TABLE SIZE
Goto Forum:
  


Current Time: Fri Dec 02 14:27:36 CST 2016

Total time taken to generate the page: 0.18538 seconds