Re: so ok one of the users blew out temp during production flows last night

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Fri, 13 Mar 2009 08:26:44 +0200
Message-id: <49B9FCA4.8030502_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

Received on Fri Mar 13 2009 - 01:26:44 CDT