Automatic Plan Capture 11G

posted Aug 9, 2011 7:55 AM by Sachchida Ojha
alter system set optimizer_capture_sql_plan_baselines=TRUE.
(default is false)

This parameter is dynamic and can also be set at the session level with the ALTER SESSION command.