Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Another oracle resource goes down the drain

Re: Another oracle resource goes down the drain

From: <epokopac_at_excite.com>
Date: 10 Apr 2007 13:23:30 -0700
Message-ID: <1176236610.371720.297180@n33g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US