16.6.09
SQL Plan Management in Oracle 11g
Okay here's a more professional posting. As an Oracle DBA I have often experienced situations where stored procs suddenly become very slow. They've switched to a sub-optimal execution plan. Often it's because the Stats have changed on the objects referred to by the SQL. But how do you stop this happening without having to use hints or worse without having to stop gathering stats (you really wouldn't want to do that). Well I'd try to tell you myself but why bother when Arup Nanda has written such a useful article on a solution to this problem in the Mar\Apr edition of Oracle Magazine. The answer is to use SQL Plan Management if you have Oracle 11g. Here's the link to his article: http://www.oracle.com/technology/oramag/oracle/09-mar/o29spm.html
Subscribe to:
Post Comments (Atom)
I love Arup Nanda. Always there to solve your plan management issues. TGFT.
ReplyDeleteKeep writing this stuff Dave, it's ace.
Who do you think would win in a fight between Arup Nanda and Jonathan Lewis? My money's on Nanda - the guy looks like a psycho, and he probably fights dirty. Plus his top 10 11g features articles were ace.
ReplyDelete