What about autoextend on UNDO and TEMP tablespaces
Autoextend datafiles are the epitome of 'low maintenance' if configured correctly.
Should they be used for UNDO, TEMP, SYSTEM, and SYSAUX tablespaces?
SYSTEM and SYSAUX act like regular application-owned tablespaces, are generally slow-growing, and can affect database uptime, so I can see the advantages of setting them to autoextend.
What about UNDO and TEMP?
Inadequately sized UNDO and TEMP can obviously affect the user experience, but out-of-control queries, joins, sorts, and index-rebuilds can quickly grow them beyond anyone's expectation. TEMP can be rebuilt with smaller files without affecting database uptime but a bloated UNDO datafile is more difficult to correct.
0