VIEW: SYS.DBA_ADVISOR_PARAMETERS

Source

View Text - Preformatted

select b.owner_name as owner,
             a.task_id as task_id,
             b.name as task_name,
             a.name as parameter_name,
             a.value as parameter_value,
             decode(a.datatype, 1, 'NUMBER',
                                2, 'STRING',
                                3, 'STRINGLIST',
                                4, 'TABLE',
                                5, 'TABLELIST',
                                'UNKNOWN')
                 as parameter_type,
             decode(bitand(a.flags,2), 0, 'Y', 'N') as is_default,
             decode(bitand(a.flags,4), 0, 'N', 'Y') as is_output,
             decode(bitand(a.flags,8), 0, 'N', 'Y') as is_modifiable_anytime,
             dbms_advisor.format_message(a.description) as description,
             c.exec_type execution_type
      from wri$_adv_parameters a, wri$_adv_tasks b, wri$_adv_def_parameters c
      where a.task_id = b.id
        and a.name = c.name
        and (b.advisor_id = c.advisor_id or c.advisor_id = 0)
        and bitand(b.property,4) = 4        /* task property */
        and bitand(a.flags,1) = 0           /* invisible parameter */
        and (bitand(b.property, 32) = 32 or /* system task only parameter */
             bitand(c.flags, 16)    = 0)

View Text - HTML Formatted

SELECT B.OWNER_NAME AS OWNER
, A.TASK_ID AS TASK_ID
, B.NAME AS TASK_NAME
, A.NAME AS PARAMETER_NAME
, A.VALUE AS PARAMETER_VALUE
, DECODE(A.DATATYPE
, 1
, 'NUMBER'
, 2
, 'STRING'
, 3
, 'STRINGLIST'
, 4
, 'TABLE'
, 5
, 'TABLELIST'
, 'UNKNOWN') AS PARAMETER_TYPE
, DECODE(BITAND(A.FLAGS
, 2)
, 0
, 'Y'
, 'N') AS IS_DEFAULT
, DECODE(BITAND(A.FLAGS
, 4)
, 0
, 'N'
, 'Y') AS IS_OUTPUT
, DECODE(BITAND(A.FLAGS
, 8)
, 0
, 'N'
, 'Y') AS IS_MODIFIABLE_ANYTIME
, DBMS_ADVISOR.FORMAT_MESSAGE(A.DESCRIPTION) AS DESCRIPTION
, C.EXEC_TYPE EXECUTION_TYPE
FROM WRI$_ADV_PARAMETERS A
, WRI$_ADV_TASKS B
, WRI$_ADV_DEF_PARAMETERS C
WHERE A.TASK_ID = B.ID
AND A.NAME = C.NAME
AND (B.ADVISOR_ID = C.ADVISOR_ID OR C.ADVISOR_ID = 0)
AND BITAND(B.PROPERTY
, 4) = 4 /* TASK PROPERTY */
AND BITAND(A.FLAGS
, 1) = 0 /* INVISIBLE PARAMETER */
AND (BITAND(B.PROPERTY
, 32) = 32 OR /* SYSTEM TASK ONLY PARAMETER */ BITAND(C.FLAGS
, 16) = 0)