OPTIMIZER_USE_SQL_PLAN_BASELINES
Hello,
Customer is on 11.2.0.3
Inadvetently one of the DBA's that was testing explain plans issues an Alter system...intestead of Alter session.
The command issued was alter system use_sql_baselines = 'False' instead of alter session.
This caused all of the stored baselines in the db not to be used and performance impact was seen....when we caught what happened the system was re enabled to use baselines and things went back to normal.
Question is twofold:
1) when the system was altered back to its initial valuse being true, would that take everything back the way it was prior to the bad command...and
Customer is on 11.2.0.3
Inadvetently one of the DBA's that was testing explain plans issues an Alter system...intestead of Alter session.
The command issued was alter system use_sql_baselines = 'False' instead of alter session.
This caused all of the stored baselines in the db not to be used and performance impact was seen....when we caught what happened the system was re enabled to use baselines and things went back to normal.
Question is twofold:
1) when the system was altered back to its initial valuse being true, would that take everything back the way it was prior to the bad command...and
0