DBA Data[Home] [Help]

SYS.DBMS_SQLTUNE dependencies on DBMS_ADVISOR

Line 492: -- dbms_advisor.arglist('time_limit', 12,

488: -- parameters are real task parameters that
489: -- have effect only on the execution they
490: -- specified for.
491: -- Example:
492: -- dbms_advisor.arglist('time_limit', 12,
493: -- 'username', 'foo')
494: -- execution_desc (IN) - A 256-length string describing the execution.
495: --
496: -- RETURNS:

Line 505: execution_params IN dbms_advisor.argList := NULL,

501: -----------------------------------------------------------------------------
502: FUNCTION execute_tuning_task(
503: task_name IN VARCHAR2,
504: execution_name IN VARCHAR2 := NULL,
505: execution_params IN dbms_advisor.argList := NULL,
506: execution_desc IN VARCHAR2 := NULL)
507: RETURN VARCHAR2;
508: --
509: PROCEDURE execute_tuning_task(

Line 512: execution_params IN dbms_advisor.argList := NULL,

508: --
509: PROCEDURE execute_tuning_task(
510: task_name IN VARCHAR2,
511: execution_name IN VARCHAR2 := NULL,
512: execution_params IN dbms_advisor.argList := NULL,
513: execution_desc IN VARCHAR2 := NULL);
514:
515:
516: ----------------------------- interrupt_tuning_task -------------------------

Line 675: -- Wrap with a call to dbms_advisor.create_file to put it into a file.

671: -- to be executed to implement the subset of recommendations dictated by
672: -- the arguments. This script should then by checked by the DBA and
673: -- executed.
674: --
675: -- Wrap with a call to dbms_advisor.create_file to put it into a file.
676: --
677: -- PARAMETERS:
678: -- task_name (IN) - name of the task to get a script for
679: -- rec_type (IN) - filter the script by types of recommendations