VIEW: SYS.USER_ADDM_FDG_BREAKDOWN

Source

View Text - Preformatted

select a.task_id as task_id,
             a.finding_id as finding_id,
             a.instance_number as instance_number,
             a.impact as database_time,
             a.impact /
               greatest(1,
                        (cast(t.end_time as date) - cast(t.begin_time as date))
                         * 86400000000
                        ) as active_sessions,
             a.perc_impact as perc_active_sessions
      from  user_advisor_fdg_breakdown a, wri$_adv_addm_tasks t
      where a.task_id = t.task_id

View Text - HTML Formatted

SELECT A.TASK_ID AS TASK_ID
, A.FINDING_ID AS FINDING_ID
, A.INSTANCE_NUMBER AS INSTANCE_NUMBER
, A.IMPACT AS DATABASE_TIME
, A.IMPACT / GREATEST(1
, (CAST(T.END_TIME AS DATE) - CAST(T.BEGIN_TIME AS DATE)) * 86400000000 ) AS ACTIVE_SESSIONS
, A.PERC_IMPACT AS PERC_ACTIVE_SESSIONS
FROM USER_ADVISOR_FDG_BREAKDOWN A
, WRI$_ADV_ADDM_TASKS T
WHERE A.TASK_ID = T.TASK_ID