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 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 3F7511D8976338DDE0630100007FB4A6 select 100*dhash.seconds/xxen_util.zero_to_null(sum(dhash.seconds) over (partition by &dhash_instance_number 1)) percentage, dhash.seconds/dhash.total_seconds active_sessions, xxen_util.time(dhash.seconds) time, &dhash_instance_number dhash.seconds, dhash.wait_class, &dhash_event xxen_util.time(dhash.total_seconds) time_window from ( select distinct &dhash_instance_number count(*) over (partition by &dhash_instance_number dhash.wait_class,&dhash_event 1)*10 seconds, nvl(dhash.wait_class,'ON CPU') wait_class, &dhash_event (max(cast(dhash.sample_time as date)) over (partition by &dhash_instance_number 1)-min(cast(dhash.sample_time as date)) over (partition by &dhash_instance_number 1))*86400 total_seconds from dba_hist_active_sess_history dhash where 1=1 ) dhash order by &dhash_instance_number seconds desc Y US DBA AWR Wait Event Summary (active session history) Wait event and CPU usage summary from the AWR active session history. Enginatics &dhash_event &dhash_instance_number 1=1 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) ) dhs US From Time 2 20 1=1 dhash.sample_time<=:to_time DateTime select xxen_util.client_time(sysdate) from dual US To Time 3 30 &dhash_instance_number dhash.instance_number, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US By Instance 4 40 &dhash_event dhash.event, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US By Event 5 50 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 Foreground US Session Type 6 60 1=1 1=1 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 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') Y 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