RE: How to clear UNDOTBS- Slightly OT

From: Michael McMullen <ganstadba_at_hotmail.com>
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pedersen
Sent: Monday, January 18, 2010 12:26 PM
To: ecandrietta_at_gmail.com; wellmetus_at_gmail.com Cc: ORACLE-L
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.

http://www.linkedin.com/in/kellynpedersen

www.dbakevlar.blogspot.com <http://www.dbakevlar.blogspot.com/>  

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

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

Hi,    

--
http://www.freelists.org/webpage/oracle-l

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