Database Administration (MOSC)

MOSC Banner

What about autoextend on UNDO and TEMP tablespaces

edited Jan 10, 2013 9:03PM in Database Administration (MOSC) 5 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center