My Oracle Support Banner

Verify DBA Advisor Parameters For 'SYS_AUTO_SPM_EVOLVE_TASK' (Doc ID 2853998.1)

Last updated on MARCH 17, 2022

Applies to:

Oracle Database - Standard Edition - Version 19.11.0.0.0 and later
Information in this document applies to any platform.

Goal

Can you verify if these are the recommended parameters for our database. This database is currently on Oracle 19.11.0.0

column parameter_value format a45
column parameter_name format a25
set pages 200

SELECT PARAMETER_NAME, PARAMETER_VALUE
  FROM DBA_ADVISOR_PARAMETERS
  WHERE TASK_NAME = 'SYS_AUTO_SPM_EVOLVE_TASK'
  AND PARAMETER_VALUE <> 'UNUSED'
  ORDER BY 1;


PARAMETER_NAME PARAMETER_VALUE
------------------------- ---------------------------------------------
ACCEPT_PLANS TRUE
ALTERNATE_PLAN_BASELINE EXISTING
ALTERNATE_PLAN_LIMIT UNLIMITED
ALTERNATE_PLAN_SOURCE AUTO
DAYS_TO_EXPIRE UNLIMITED
DEFAULT_EXECUTION_TYPE SPM EVOLVE
EXECUTION_DAYS_TO_EXPIRE 30
JOURNALING INFORMATION
MODE COMPREHENSIVE
TARGET_OBJECTS 1
TIME_LIMIT 3600
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.