ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A7DFBD038AC2042AE0530100007F6181 DBA Diagnostic Pack Enabled Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from v$parameter vp where vp.name='control_management_pack_access' and vp.value like 'DIAGNOSTIC%' US 8E2FF36EDF1279D2E0530100007F1FF2 DBA Instance Id Y select gi.inst_id value, gi.instance_name||' '||gi.host_name||' '||gi.startup_time description from gv$instance gi US 8E2FF36EDEF079D2E0530100007F1FF2 DBA Session Type Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual US 3F5E280EAAF628C8E0630100007F128E select xxen_util.client_time(gash.sample_time_) sample_time, gash.inst_id, gash.sessions, xxen_util.zero_to_null(gash.cpu_sessions) cpu_sessions, xxen_util.zero_to_null(gash.waiting_sessions) waiting_sessions from ( select distinct cast(gash.sample_time as date) sample_time_, gash.inst_id, count(*) over (partition by gash.sample_id) sessions, count(decode(gash.session_state,'ON CPU',1)) over (partition by gash.sample_id) cpu_sessions, count(decode(gash.session_state,'WAITING',1)) over (partition by gash.sample_id) waiting_sessions from gv$active_session_history gash where 1=1 ) gash where 2=2 order by sample_time, inst_id Y US DBA SGA CPU Load (active session history) Aggregates active sessions by snapshot time to identify times with high CPU load over a specific 'CPU Sessions From' threshold value. Enginatics 1=1 2=2 1 10 1=1 gash.sample_time>=:from_time DateTime select xxen_util.client_time(gash.sample_time) from ( select min(gash.sample_time) sample_time from gv$active_session_history gash where gash.session_type='FOREGROUND' and :$flex$.request_id is null and :$flex$.sid_serial is null ) gash F Du temps US From Time 2 20 1=1 gash.sample_time<:to_time+1/86400 DateTime select xxen_util.client_time(sysdate) from dual where :$flex$.request_id is null and :$flex$.sid_serial is null F Au temps US To Time 3 30 2=2 gash.cpu_sessions>=:cpu_sessions_from Number select go.value from gv$osstat go where go.stat_name='NUM_CPUS' and rownum=1 F La procédure d'entrée contient US CPU Sessions From 4 40 1=1 gash.session_type=upper(:session_type) LOV DBA Session Type 8E2FF36EDEF079D2E0530100007F1FF2 Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual F Type de session US Session Type 5 50 1=1 gash.inst_id=:inst_id LOV DBA Instance Id 8E2FF36EDF1279D2E0530100007F1FF2 Y select gi.inst_id value, gi.instance_name||' '||gi.host_name||' '||gi.startup_time description from gv$instance gi F Id de l'instance US Instance Id 6 60 1=1 0=0 LOV DBA Diagnostic Pack Enabled A7DFBD038AC2042AE0530100007F6181 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from v$parameter vp where vp.name='control_management_pack_access' and vp.value like 'DIAGNOSTIC%' Y Y F Pack de diagnostic activé US Diagnostic Pack enabled