-
Hi,
When I do the query below, there is no value for max_extents for the temporary tablespace. Why is that? Does it mean there could be unlimited number of extents in a temporary sort segment?
Thank you!
-------------------------
SQL>select tablespace_name ts, initial_extent init,
next_extent next, min_extents min, max_extents max
from dba_tablespaces
where tablespace_name = 'TEMP'
TS INIT NEXT MIN MAX
------ ---------- ---------- ---------- ----------
TEMP 65536 65536 1
-
Yes as far as i think when sorting exceeds SORT_ARE_SIZE
and user has been asigned temporary tablespace then only one segment is created in the temp tablespace and it will do sorting for all users untill the instance shutdown..The MAX_EXTENTS are unlimited (to the size of temp tablespace).
Please anyone if i am wrong.
-
temp tablespaces will have unlimited extents which is fine since sort segments are shared
datafile growth is controlled by autoextend on/off