Re: How to clear UNDOTBS- Slightly OT

From: Rich Jesse <>
Date: Mon, 18 Jan 2010 12:49:24 -0600 (CST)
Message-ID: <>

> Very cooll, Rich!  I have a shell script that monitors temp and undo usage
> in the main systems and if it hits a certain threshold I've set for that
> database, it sends an email alert to the appropriate folks.  The developers
> on that list do NOT like to see their names on the email alert, as it means
> they may be impacting production and it means our boss may be coming over to
> their desk in a short period of time to visit... :)

I saw the writing on the wall one day after and did the following:

ALTER USER developer TEMPORARY TABLESPACE developer_temp;

Takes at least one worry away from this solo DBA. :)


Received on Mon Jan 18 2010 - 12:49:24 CST

Original text of this message