DBA Data[Home] [Help]

SYS.DBMS_SQLPA dependencies on DBMS_ADVISOR

Line 294: -- dbms_advisor.arglist('time_limit',

290: -- Note that execution parameters are real
291: -- task parameters that have effect only on
292: -- the execution they specified for.
293: -- Example:
294: -- dbms_advisor.arglist('time_limit',
295: -- 1000,
296: -- 'COMPARE_METRIC',
297: -- 'buffer_gets * 10')
298: -- execution_desc (IN) - A 256-length string

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

304: FUNCTION execute_analysis_task(
305: task_name IN VARCHAR2,
306: execution_type IN VARCHAR2 := 'test execute',
307: execution_name IN VARCHAR2 := NULL,
308: execution_params IN dbms_advisor.argList := NULL,
309: execution_desc IN VARCHAR2 := NULL)
310: RETURN VARCHAR2;
311:
312: -- procedure flavor

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

313: PROCEDURE execute_analysis_task(
314: task_name IN VARCHAR2,
315: execution_type IN VARCHAR2 := 'test execute',
316: execution_name IN VARCHAR2 := NULL,
317: execution_params IN dbms_advisor.argList := NULL,
318: execution_desc IN VARCHAR2 := NULL);
319:
320: ----------------------------- interrupt_analysis_task -----------------------
321: -- NAME: