RE: How to clear UNDOTBS- Slightly OT

From: Kellyn Pedersen <kjped1313_at_yahoo.com>
Date: Mon, 18 Jan 2010 10:20:29 -0800 (PST)
Message-ID: <127887.30835.qm_at_web32002.mail.mud.yahoo.com>

And anybody who would be concerned that if they set their temp and undo to set sizes, folks would be less than understanding if they were to hit the threshold, (even when it's poor coding as the problem...)  have you considered using dbms_resumable?  We have it set in all our databases and a script that monitors for it.  If anything does go awry, the transaction simply goes into a time out until we can take a quick look and address the problem, (like kill the query that is using all the temp) allowing the rest of the transactions to "resume" once temp or undo issues are resolved.

Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen www.dbakevlar.blogspot.com
 
"Go away before I replace you with a very small and efficient shell script..."

• On Mon, 1/18/10, Michael McMullen <ganstadba_at_hotmail.com> wrote:

From: Michael McMullen <ganstadba_at_hotmail.com> Subject: RE: How to clear UNDOTBS- Slightly OT To: "'Oracle-L Freelists'" <oracle-l_at_freelists.org> Date: Monday, January 18, 2010, 10:56 AM

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

 

"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 - 12:20:29 CST