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

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Fri, 13 Mar 2009 08:26:44 +0200

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


Other related posts: