DBMSADVISOR package procedures - CREATETASK procedure use to create Segment Advisor task - Oracle Schema

Discussion

• Nirja Shah   -Posted on 25 Sep 15
  1. CREATE_TASK - This procedure creates a new Advisor task in the repository.
  - Syntax
  DBMS_ADVISOR.CREATE_TASK (
  advisor_name IN VARCHAR2,
  task_id OUT NUMBER,
  task_name IN OUT VARCHAR2,
  task_desc IN VARCHAR2 := NULL,
  template IN VARCHAR2 := NULL,
  is_template IN VARCHAR2 := 'FALSE',
  how_created IN VARCHAR2 := NULL);
  
  DBMS_ADVISOR.CREATE_TASK (
  advisor_name IN VARCHAR2,
  task_name IN VARCHAR2,
  task_desc IN VARCHAR2 := NULL,
  template IN VARCHAR2 := NULL,
  is_template IN VARCHAR2 := 'FALSE',
  how_created IN VARCHAR2 := NULL);
  
  2. EXECUTE_TASK - This procedure performs the Advisor analysis or evaluation for the specified task.
  - Syntax
  DBMS_ADVISOR.EXECUTE_TASK (
  task_name IN VARCHAR2);
  
  3. CREATE_OBJECT - This procedure creates a new task object.
  - Syntax
  DBMS_ADVISOR.CREATE_OBJECT (
  task_name IN VARCHAR2,
  object_type IN VARCHAR2,
  attr1 IN VARCHAR2 := NULL,
  attr2 IN VARCHAR2 := NULL,
  attr3 IN VARCHAR2 := NULL,
  attr4 IN CLOB := NULL,
  object_id OUT NUMBER);
  
  DBMS_ADVISOR.CREATE_OBJECT (
  task_name IN VARCHAR2,
  object_type IN VARCHAR2,
  attr1 IN VARCHAR2 := NULL,
  attr2 IN VARCHAR2 := NULL,
  attr3 IN VARCHAR2 := NULL,
  attr4 IN CLOB := NULL,
  attr5 IN VARCHAR2 := NULL,
  object_id OUT NUMBER);
  
  4. SET_TASK_PARAMETER - This procedure modifies a user parameter within an Advisor task or a template.
  - A user parameter is a simple variable that stores various attributes that affect workload collection, tuning decisions and reporting.
  - Syntax
  DBMS_ADVISOR.SET_TASK_PARAMETER (
  task_name IN VARCHAR2
  parameter IN VARCHAR2,
  value IN VARCHAR2);
  
  DBMS_ADVISOR.SET_TASK_PARAMETER (
  task_name IN VARCHAR2
  parameter IN VARCHAR2,
  value IN NUMBER);

➨ Post your comment / Share knowledge