I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the database. SQL plan management helps preserving efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc …). SQL plan management (SPM) is a proactive way to guarantee stable performance when system changes.This article doesn’t cover all the SPM functions. But, it is a good start to understand some of the SPM capabilities.

You can find the complete article on my website: oracle-class.com

I hope you like it.

Regards,
Wissem