Re: so ok one of the users blew out temp during production flows last night
From: Howard Latham <howard.latham_at_gmail.com>
Date: Fri, 13 Mar 2009 07:58:39 +0000
Message-ID: <713d96d10903130058y4090520bscd24d2e849538fde_at_mail.gmail.com>
Create a smallish emp_users and point all users at it.
Date: Fri, 13 Mar 2009 07:58:39 +0000
Message-ID: <713d96d10903130058y4090520bscd24d2e849538fde_at_mail.gmail.com>
Create a smallish emp_users and point all users at it.
2009/3/13 Yechiel Adar <adar666_at_inter.net.il>
> 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
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 13 2009 - 02:58:39 CDT