VIEW: SYS.DBA_ADVISOR_DEF_PARAMETERS

Source

View Text - Preformatted

select b.name as advisor_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,
             decode(bitand(a.flags,16), 0, 'N', 'Y') as is_system_task_only,
             dbms_advisor.format_message(a.description) as description,
             a.exec_type execution_type
      from wri$_adv_def_parameters a, wri$_adv_definitions b
      where a.advisor_id = b.id
        and bitand(a.flags,1) = 0

View Text - HTML Formatted

SELECT B.NAME AS ADVISOR_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
, DECODE(BITAND(A.FLAGS
, 16)
, 0
, 'N'
, 'Y') AS IS_SYSTEM_TASK_ONLY
, DBMS_ADVISOR.FORMAT_MESSAGE(A.DESCRIPTION) AS DESCRIPTION
, A.EXEC_TYPE EXECUTION_TYPE
FROM WRI$_ADV_DEF_PARAMETERS A
, WRI$_ADV_DEFINITIONS B
WHERE A.ADVISOR_ID = B.ID
AND BITAND(A.FLAGS
, 1) = 0