Input parameter time limit for DBMSADVISOR>SETTASKPARAMETER - Oracle Schema

Q.   The Input parameter time limit for DBMS_ADVISOR>SET_TASK_PARAMETER in which the time limit for the Segment Advisor run, specified in seconds the possible value is any number of seconds and default value will be _________.
TRUE

- Published on 12 Aug 15

a. TRUE
b. FALSE
c. UNLIMITED
d. None of the above

ANSWER: UNLIMITED
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - Input for DBMS_ADVISOR.SET_TASK_PARAMETER

    - time_limit - The time limit for the Segment Advisor run, specified in seconds.
    - The possible values are - Any number of seconds
    - Default value - UNLIMITED

    - recommend_all - Whether the Segment Advisor should generate findings for all segments.
    - Possible values are - TRUE: Findings are generated on all segments specified, whether or not space reclamation is recommended.
    FALSE: Findings are generated only for those objects that generate recommendations for space reclamation.
    - Default value - TRUE

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)