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