SQL plan baseline management - 12.2
HI
SNAPSHOT INTERVAL (MINS) RETENTION INTERVAL (MINS) RETENTION INTERVAL (DAYS) TOPNSQL DBID DB_NAME
------------------------ ------------------------- ------------------------- ---------- ---------- ---------
60 11520 8 DEFAULT 2194268642 M2KQA
CLIENT_NAME STATUS
----------------------------------- --------
sql tuning advisor ENABLED
auto optimizer stats collection ENABLED
auto space advisor ENABLED
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
optimizer_capture_sql_plan_baselines boolean FALSE
optimizer_use_sql_plan_baselines boolean TRUE
From oracle document:
You enable automatic initial plan capture by setting the initialization parameter OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to true (the default is false). When enabled, the database automatically creates a SQL plan baseline for any repeatable SQL statement executed on the database.