RE: How to clear UNDOTBS- Slightly OT
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
- 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kellyn Pedersen
Sent: Monday, January 18, 2010 12:26 PM
To: ecandrietta@xxxxxxxxx; wellmetus@xxxxxxxxx
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@xxxxxxxxx> wrote:
Hi,
Other related posts:
