This is the third post of SQL Plan Management. In the previous post, Understanding SQL Plan Management– Part 2, I described the three main components of SPM, this time I want to show you how to manually capture plans from the cursor cache. In other words, manually capture plans that reside in memory.In order to manually… Continue reading Understanding Oracle SQL Plan Management SPM – Part 3
In my previous post Understanding SQL Plan Management – Part 1, I tried to cover some basic concepts of SQL Plan Management (SPM). This post will show you the main components of SPM and how they work in the different versions of Oracle. SQL plan management framework has three main components, plan capture, plan selection… Continue reading Understanding Oracle SQL Plan Management SPM – Part 2
This time I want to talk about SQL Plan Management, explain how this feature works and how to make the best use of it. As is a very extensive topic I will split it in three posts.IntroductionThe Oracle Cost Based Optimizer (CBO) introduced in Oracle version 7. It determines the most efficient way to execute… Continue reading Understanding Oracle SQL Plan Management SPM – Part 1
Today I want to share a personal story about IOUG’s Collaborate, a great conference that supports products from Engineered Systems, Oracle Databases to Fusion Middleware and Siebel. Last year was my first time as a speaker and was one of kind experience as I was able to share my knowledge in Oracle Database performance tuning… Continue reading Why you should attend to IOUG Collaborate 2015?