DB Optimizer vs OEM

Oracle OEM is slower, more complicated and it if it breaks, which has plenty, it’s super hard to fix.

OEM has nothing like visual sql tuning diagrams. If OEM can’t tune a query they you are at a dead end street with no way out. With DBO you’ve got the VST diagrams which explain tons about what is going on with the query

• http://www.youtube.com/watch?v=EoDnR02S2WA - VST demo from webinar with Jonathan Lewis
• http://db-optimizer.blogspot.com/2010/09/db-optimizer-251-released.html
• http://db-optimizer.blogspot.com/2010/09/sql-tuning-best-practice-visualizing.html
• http://db-optimizer.blogspot.com/2010/07/product-design.html

There is no load testing or SQL IDE in OEM

• http://db-optimizer.blogspot.com/2010/07/14-minute-video-overview-of-db.html

OEM’s SQL Tuining Advisor (STA) has a solid history of not being able to tune queries or worse still “tuning” the query and making it run slower

• http://db-optimizer.blogspot.com/2010/07/oracles-sql-tuning-pack-how-well-does.html
• http://db-optimizer.blogspot.com/2010/07/oracles-sql-tuning-pack-part-2.html
• http://db-optimizer.blogspot.com/2010/07/oracles-sql-tuning-pack-part-3.html