Re: How to clear UNDOTBS- Slightly OT
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Jan 2010 12:49:24 -0600 (CST)
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
