Re: Another oracle resource goes down the drain

Nothing but good statements/good advice in your response:

"This application should be completely re-engineered."

"An attempt to emulate the SQL Server behavior is not only a sign of
terminal stupidity, it will create a horrible application that will invalidate dependent procedure and itself, create dictionary and parsing locks, cause checkpoints and waste CPU on reparsing."

"Oracle is not a SQL server and one should never make it behave
like that. That is how suboptimal applications are created." (kind of like one of our applications that we have running here - it IS horribly suboptimal; designed in a hurry by a SQL*Server "wizard" who eventually quit)

Sometimes the truth hurts. One must learn to deal with it.

Regards,

    Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA) Received on Tue Apr 10 2007 - 15:23:30 CDT