Re: More Ammo Against Dynamic SQL?
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: kjped1313@xxxxxxxxx
- Date: Mon, 23 Nov 2009 21:23:30 +0100
Do you have this one?
Inability to perform impact analysis using DBA_DEPENDENCIES...
On Mon, Nov 23, 2009 at 9:01 PM, Kellyn Pedersen <kjped1313@xxxxxxxxx>wrote:
> I am working on a presentation to convince my company against some of the
> dastardly dynamic SQL that we have in our code. We perform everything from
> inserts, updates, deletes, selects and CTAS' all with dynamic SQL and it's
> killing me!
> I would love any new reasons NOT to use it, as I have all the standard
> reasons like, inability to reuse sql in the buffer, parsing issues, bind
> peeking issues, execution plan instability, etc..
> Thanks for the assist! :)
>
> Kellyn Pedersen
> Multi-Platform DBA
> I-Behavior Inc.
> http://www.linkedin.com/in/kellynpedersen
>
> "Go away before I replace you with a very small and efficient shell
> script..."
>
>
--
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.RuleGen.com/pls/apex/f?p=14265:13
Other related posts:
