ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CD9C5E45FE03F6AEE05362FB09053404 DBA Container Data Y select 'All' value,'Return data from both, the PDB and the CDB' description from v$parameter vp where vp.name='container_data' and vp.value='ALL' union all select 'Current PDB' value, 'Return data only from the current PDB' description from v$parameter vp where vp.name='container_data' union all select 'N/A' value,'Not applicable for non CDB databases' from dual where not exists (select null from v$parameter vp where vp.name='container_data') US 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 4045FE4CD14CC2AEE0630100007F9FC3 select xxen_util.client_time(dhash.sample_time_) sample_time, dhash.instance_number, dhash.sessions, xxen_util.zero_to_null(dhash.cpu_sessions) cpu_sessions, xxen_util.zero_to_null(dhash.waiting_sessions) waiting_sessions from ( select distinct cast(dhash.sample_time as date) sample_time_, dhash.instance_number, count(*) over (partition by dhash.sample_id) sessions, count(decode(dhash.session_state,'ON CPU',1)) over (partition by dhash.sample_id) cpu_sessions, count(decode(dhash.session_state,'WAITING',1)) over (partition by dhash.sample_id) waiting_sessions from dba_hist_active_sess_history dhash where 1=1 ) dhash where 2=2 order by sample_time, instance_number Y US DBA AWR 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 dhash.sample_time>=:from_time DateTime select xxen_util.client_time(dhs.begin_interval_time) from ( select min(dhs.begin_interval_time) begin_interval_time from dba_hist_snapshot dhs where dhs.dbid=(select case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end dbid from v$database vd) and :$flex$.request_id is null and :$flex$.sid_serial is null ) dhs F Du temps US From Time 2 20 1=1 dhash.sample_time<:to_time+1/86400 DateTime xxen_util.client_time(sysdate) F Au temps US To Time 3 30 2=2 dhash.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 dhash.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 dhash.instance_number=: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 7 70 1=1 dhash.dbid=(select vd.dbid from v$database vd) LOV DBA Container Data CD9C5E45FE03F6AEE05362FB09053404 Y select 'All' value,'Return data from both, the PDB and the CDB' description from v$parameter vp where vp.name='container_data' and vp.value='ALL' union all select 'Current PDB' value, 'Return data only from the current PDB' description from v$parameter vp where vp.name='container_data' union all select 'N/A' value,'Not applicable for non CDB databases' from dual where not exists (select null from v$parameter vp where vp.name='container_data') % coalesce((select 'Current PDB' from v$parameter vp where vp.name='awr_pdb_autoflush_enabled' and vp.value='TRUE'),(select 'All' from v$parameter vp where vp.name='container_data'),'N/A') US Container Data 8 1=1 dhash.dbid=(select vd.con_dbid from v$database vd) Current PDB US Container Data :$flex$.container_data Container Data From Time