RE: How to clear UNDOTBS- Slightly OT
Date: Mon, 18 Jan 2010 12:56:13 -0500
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?
"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,Received on Mon Jan 18 2010 - 11:56:13 CST