Re: so ok one of the users blew out temp during production flows last night
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: adar666@xxxxxxxxxxxx
- Date: Fri, 13 Mar 2009 07:58:39 +0000
Create a smallish emp_users and point all users at it.
2009/3/13 Yechiel Adar <adar666@xxxxxxxxxxxx>
> I will second that.
> I work in a bank and the holy grail is: Production night run MUST finish
> ok.
> So, I am not surprised about the knee jerk reaction.
>
> My motto is: One problem a year I can let go.
> More often and I need to find a solution.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
>
> Rich Jesse wrote:
>
>> 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
>
>
>
--
Howard A. Latham
Other related posts:
