RE: How to clear UNDOTBS- Slightly OT

From: Michael McMullen <>
Date: Mon, 18 Jan 2010 12:56:13 -0500
Message-ID: <SNT130-ds421A65592E5297D0E9398A6660_at_phx.gbl>

I never set my undo or temp to autoextend. It's the easiest database "tell" that somebody has written something screwy if the tablespaces blow up  

From: [] On Behalf Of Kellyn Pedersen
Sent: Monday, January 18, 2010 12:26 PM
Subject: Re: How to clear UNDOTBS- Slightly OT    

How many DBA's inspect what is utilizing temp and undo? How many DBA's see a large temp and/or UNDO tablespace as a red flag in a database?

Kellyn Pedersen

Multi-Platform DBA

I-Behavior Inc. <>  

"Go away before I replace you with a very small and efficient shell script..."

  • On Mon, 1/18/10, Roger Xu <> wrote:


Received on Mon Jan 18 2010 - 11:56:13 CST

Original text of this message