Re: so ok one of the users blew out temp during production flows last night
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Mar 2009 11:14:13 -0500 (CDT)
> Some panic has set it in.
>
> One of the ideas thrown out is to boot all users (except batch flowid) out
> of the database as say 6P, or not allow login from users starting at 6P,
>
> what would be the best way (or can we) to do the above concepts.
>
> thanks, joe
Have you considered giving your "batch flowid" it's own TEMP TS? I do that
for our ad-hoc userids so when they attempt to sort all rows in our largest
table and fills TEMP_AD_HOC, it only potentially affects other ad-hoc
transactions.
Rich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
