Re: How to clear UNDOTBS- Slightly OT
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 18 Jan 2010 12:49:24 -0600 (CST)
Message-ID: <0b036226ef0cc0339956136e43dbdfe2.squirrel_at_society.servebeer.com>
> 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... :)
Date: Mon, 18 Jan 2010 12:49:24 -0600 (CST)
Message-ID: <0b036226ef0cc0339956136e43dbdfe2.squirrel_at_society.servebeer.com>
> 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. :)
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 18 2010 - 12:49:24 CST