ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDF2C79D2E0530100007F1FF2 DBA AWR Snapshot Date From Y select distinct dhs.begin_interval_time value, trim(to_char(dhs.begin_interval_time,'Day'))||' '||to_char(dhs.begin_interval_time,'hh24:mi')||'-'||to_char(dhs.end_interval_time,'hh24:mi') description from ( select xxen_util.client_time(dhs.begin_interval_time) begin_interval_time, xxen_util.client_time(dhs.end_interval_time) end_interval_time from ( select distinct dhs.begin_interval_time, dhs.end_interval_time from v$database vd, dba_hist_snapshot dhs where case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end=dhs.dbid ) dhs ) dhs order by value desc US 8E2FF36EDF1E79D2E0530100007F1FF2 DBA AWR Snapshot Date To Y select distinct dhs.end_interval_time value, trim(to_char(dhs.end_interval_time,'Day'))||' '||to_char(dhs.begin_interval_time,'hh24:mi')||'-'||to_char(dhs.end_interval_time,'hh24:mi') description from ( select xxen_util.client_time(dhs.begin_interval_time) begin_interval_time, xxen_util.client_time(dhs.end_interval_time) end_interval_time from ( select distinct dhs.begin_interval_time, dhs.end_interval_time from v$database vd, dba_hist_snapshot dhs where (:$flex$.dba_awr_snapshot_date_from is null or dhs.begin_interval_time>to_date(:$flex$.dba_awr_snapshot_date_from)) and case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end=dhs.dbid ) dhs ) dhs order by value desc US 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 7B8BDBED155F17C8E0530100007F019F select x.seconds/xxen_util.zero_to_null(sum(x.seconds) over ())*100 percentage, &columns x.latch_name, x.seconds, xxen_util.time(x.seconds) time, x.misses, x.sleeps, x.immediate_gets, x.immediate_misses, x.spin_gets, x.level# from ( select distinct &columns dhl.latch_name, round(sum(case when dhl.wait_time_<0 then dhl.wait_time else dhl.wait_time_ end) over (partition by dhl.latch_name &partition_by)/1000000) seconds, sum(case when dhl.misses_<0 then dhl.misses else dhl.misses_ end) over (partition by dhl.latch_name &partition_by) misses, sum(case when dhl.sleeps_<0 then dhl.sleeps else dhl.sleeps_ end) over (partition by dhl.latch_name &partition_by) sleeps, sum(case when dhl.immediate_gets_<0 then dhl.immediate_gets else dhl.immediate_gets_ end) over (partition by dhl.latch_name &partition_by) immediate_gets, sum(case when dhl.immediate_misses_<0 then dhl.immediate_misses else dhl.immediate_misses_ end) over (partition by dhl.latch_name &partition_by) immediate_misses, sum(case when dhl.spin_gets_<0 then dhl.spin_gets else dhl.spin_gets_ end) over (partition by dhl.latch_name &partition_by) spin_gets, dhl.level# from ( select dhl.gets-lag(dhl.gets) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) gets_, dhl.misses-lag(dhl.misses) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) misses_, dhl.sleeps-lag(dhl.sleeps) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) sleeps_, dhl.immediate_gets-lag(dhl.immediate_gets) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) immediate_gets_, dhl.immediate_misses-lag(dhl.immediate_misses) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) immediate_misses_, dhl.spin_gets-lag(dhl.spin_gets) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) spin_gets_, dhl.wait_time-lag(dhl.wait_time) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) wait_time_, dhl.* from dba_hist_snapshot dhs, dba_hist_latch dhl where 1=1 and dhs.dbid=dhl.dbid and dhs.instance_number=dhl.instance_number and dhs.snap_id=dhl.snap_id ) dhl where dhl.wait_time_>=0 ) x where x.seconds>0 or x.misses>0 order by x.seconds desc, x.misses desc, x.latch_name Y #,##0 AR DBA AWR Latch Summary ملخص لإحصائيات المزلاج مثل الأخطاء وأوقات الانتظار لفترة زمنية محددة للقطة D DBA AWR Latch Summary Zusammenfassung der Latch-Statistiken wie Fehlversuche und Wartezeiten für ein bestimmtes Snapshot-Zeitintervall E DBA AWR Latch Summary Resumen de las estadísticas de los cierres, como los fallos y los tiempos de espera, para un intervalo de tiempo de instantánea especificado F DBA AWR Latch Summary Résumé des statistiques de verrouillage, telles que les échecs et les temps d'attente pour un intervalle de temps donné I DBA AWR Latch Summary Riepilogo delle statistiche sui latch, come le mancanze e i tempi di attesa per un intervallo di tempo specificato JA DBA AWR Latch Summary 指定されたスナップショットの時間間隔のミスや待ち時間などのラッチ統計情報のまとめ KO DBA AWR Latch Summary 지정된 스냅 샷 시간 간격 동안 누락 및 대기 시간과 같은 래치 통계 요약 PTB DBA AWR Latch Summary Resumo das estatísticas de travamento, tais como falhas e tempos de espera para um determinado intervalo de tempo de instantâneo RU DBA AWR Latch Summary Сводка статистики защелки, такой как пропуски и время ожидания для заданного временного интервала снимка S DBA AWR Latch Summary Sammanfattning av spärrstatistik som missningar och väntetider under ett angivet tidsintervall för ögonblicksbild TR DBA AWR Latch Summary Eksiklikler ve belirli bir anlık görüntü zaman aralığı için bekleme süreleri gibi mandal istatistiklerinin özeti US DBA AWR Latch Summary Summary of latch statistics such as misses and wait times for a specified snapshot time interval ZHS DBA AWR Latch Summary 指定快照时间间隔的锁存统计汇总，如错过和等待时间。 Diagnostic Pack Enginatics &columns &partition_by 1=1 1 10 1=1 dhs.end_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))-1/1440 LOV DBA AWR Snapshot Date From 8E2FF36EDF2C79D2E0530100007F1FF2 Y select distinct dhs.begin_interval_time value, trim(to_char(dhs.begin_interval_time,'Day'))||' '||to_char(dhs.begin_interval_time,'hh24:mi')||'-'||to_char(dhs.end_interval_time,'hh24:mi') description from ( select xxen_util.client_time(dhs.begin_interval_time) begin_interval_time, xxen_util.client_time(dhs.end_interval_time) end_interval_time from ( select distinct dhs.begin_interval_time, dhs.end_interval_time from v$database vd, dba_hist_snapshot dhs where case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end=dhs.dbid ) dhs ) dhs order by value desc 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.begin_interval_time>sysdate-7 and 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 F Date du US Date From 2 20 1=1 dhs.begin_interval_time<=xxen_util.server_time(fnd_date.displaydt_to_date(:date_to)) LOV DBA AWR Snapshot Date To 8E2FF36EDF1E79D2E0530100007F1FF2 Y select distinct dhs.end_interval_time value, trim(to_char(dhs.end_interval_time,'Day'))||' '||to_char(dhs.begin_interval_time,'hh24:mi')||'-'||to_char(dhs.end_interval_time,'hh24:mi') description from ( select xxen_util.client_time(dhs.begin_interval_time) begin_interval_time, xxen_util.client_time(dhs.end_interval_time) end_interval_time from ( select distinct dhs.begin_interval_time, dhs.end_interval_time from v$database vd, dba_hist_snapshot dhs where (:$flex$.dba_awr_snapshot_date_from is null or dhs.begin_interval_time>to_date(:$flex$.dba_awr_snapshot_date_from)) and case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end=dhs.dbid ) dhs ) dhs order by value desc F Date à US Date To 3 40 &columns instance_number, LOV custom Y select 'Latch' value, '' description from dual union all select 'Latch by Instance' value, '' description from dual Latch by Instance Latch Y F Niveau de détail US Level of Detail 4 &partition_by , dhl.instance_number Latch by Instance F Niveau de détail US Level of Detail 5 50 1=1 (dhs.begin_interval_time<=(select fcr.actual_completion_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id) and dhs.end_interval_time>=(select fcr.actual_start_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id)) Number US Request Id (Time Restriction) 6 60 1=1 to_number(to_char(dhs.begin_interval_time,'HH24')) between 6 and 18 and to_char(dhs.begin_interval_time,'DAY') not in ('SATURDAY','SUNDAY') LOV custom Y select 'Daytime hours on working days only' value, 'weekday working hours, Monday to Friday 6:00-18:00 only' description from dual union all select 'Night hours only' value, 'night hours, 18:00-6:00 only' description from dual Daytime hours on working days only F Restriction de temps US Time Restriction 7 1=1 (to_number(to_char(dhs.begin_interval_time,'HH24')) between 0 and 6 or to_number(to_char(dhs.begin_interval_time,'HH24'))>=18) Night hours only F Restriction de temps US Time Restriction 8 200 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 F Pack de diagnostic activé US Diagnostic Pack enabled 9 210 1=1 dhs.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 F Données sur les conteneurs US Container Data 10 1=1 dhs.dbid=(select vd.con_dbid from v$database vd) Current PDB F Données sur les conteneurs US Container Data :$flex$.container_data Container Data Date From :$flex$.container_data Container Data Date To :$flex$.dba_awr_snapshot_date_from Date From Date To