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 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 49A8B1A803A808ACE0530100007FEB91 select x.seconds/xxen_util.zero_to_null(sum(x.seconds) over ())*100 percentage, x.seconds/x.days/86400 active_sessions, x.* from ( select distinct &columns2 dhse.wait_class, &columns xxen_util.time(sum(case when dhse.time_delta<0 then dhse.time_micro else dhse.time_delta end) over (partition by dhse.wait_class &partition_by)/1000000) time, sum(case when dhse.time_delta<0 then dhse.time_micro else dhse.time_delta end) over (partition by dhse.wait_class &partition_by)/1000000 seconds, sum(case when dhse.waits_delta<0 then dhse.waits else dhse.waits_delta end) over (partition by dhse.wait_class &partition_by) waits, sum(case when dhse.timeouts_delta<0 then dhse.timeouts else dhse.timeouts_delta end) over (partition by dhse.wait_class &partition_by) timeouts, dhse.days from ( select dhse.time_micro-lag(dhse.time_micro) over (partition by dhse.dbid, dhse.instance_number, dhse.event_name order by dhse.snap_id) time_delta, dhse.waits-lag(dhse.waits) over (partition by dhse.dbid, dhse.instance_number, dhse.event_name order by dhse.snap_id) waits_delta, dhse.timeouts-lag(dhse.timeouts) over (partition by dhse.dbid, dhse.instance_number, dhse.event_name order by dhse.snap_id) timeouts_delta, dhse.* from ( select decode(:session_type,'Foreground',dhse.time_waited_micro_fg,'Background',dhse.time_waited_micro-dhse.time_waited_micro_fg,dhse.time_waited_micro) time_micro, decode(:session_type,'Foreground',dhse.total_waits_fg,'Background',dhse.total_waits-dhse.total_waits_fg,dhse.total_waits) waits, decode(:session_type,'Foreground',dhse.total_timeouts_fg,'Background',dhse.total_timeouts-dhse.total_timeouts_fg,dhse.total_waits) timeouts, dhs.days, dhse.* from (select sum(cast(dhs.end_interval_time as date)-cast(dhs.begin_interval_time as date)) over (partition by dhs.dbid) days, dhs.* from dba_hist_snapshot dhs) dhs, dba_hist_system_event dhse where 1=1 and dhs.dbid=dhse.dbid and dhs.instance_number=dhse.instance_number and dhs.snap_id=dhse.snap_id ) dhse ) dhse ) x where x.seconds>0 order by x.seconds desc, x.wait_class Added active sessions count Y #,##0 AR DBA AWR System Wait Event Summary ملخص أوقات الانتظار حسب حدث الانتظار وفئة الحدث لفترة زمنية محددة للقطة. استخدم معلمة نوع الجلسة لتقييد إما المقدمة أو الخلفية أو جميع عمليات الخادم. D DBA AWR System Wait Event Summary Zusammenfassung der Wartezeiten nach Warteereignis und Ereignisklasse für ein angegebenes Snapshot-Zeitintervall. Verwenden Sie den Parameter "Session Type", um entweder auf Vordergrund-, Hintergrund- oder alle Serverprozesse zu beschränken. E DBA AWR System Wait Event Summary Resumen de los tiempos de espera por evento de espera y clase de evento para un intervalo de tiempo de instantánea especificado. Utilice el parámetro Tipo de sesión para restringir a los procesos en primer plano, en segundo plano o a todos los procesos del servidor. F DBA AWR System Wait Event Summary Résumé des temps d'attente par événement et par classe d'événement pour un intervalle de temps donné. Utilisez le paramètre Type de session pour vous limiter soit au premier plan, soit à l'arrière-plan, soit à tous les processus du serveur. I DBA AWR System Wait Event Summary Riepilogo dei tempi di attesa per evento di attesa e classe di evento per un intervallo di tempo specificato. Usa il parametro Session Type per limitare i processi in primo piano, in background o tutti i processi del server. JA DBA AWR System Wait Event Summary 指定されたスナップショットの時間間隔の待ちイベントとイベントクラス別の待ち時間の概要。 セッションタイプパラメータを使用して、フォアグラウンド、バックグラウンド、またはすべてのサーバープロセスに制限します。 KO DBA AWR System Wait Event Summary 지정된 스냅 샷 시간 간격 동안 대기 이벤트 및 이벤트 클래스 별 대기 시간 요약. 세션 유형 매개 변수를 사용하여 포 그라운드, 백그라운드 또는 모든 서버 프로세스로 제한하십시오. PTB DBA AWR System Wait Event Summary Resumo dos tempos de espera por evento de espera e classe de evento para um intervalo de tempo especificado. Use o parâmetro Tipo de Sessão para restringir tanto para primeiro plano, fundo ou todos os processos do servidor. RU DBA AWR System Wait Event Summary Сводка времени ожидания по событию ожидания и классу события для заданного интервала времени снимка. Используйте параметр "Тип сеанса" для ограничения либо переднего плана, либо фона, либо всех процессов сервера. S DBA AWR System Wait Event Summary Sammanfattning av väntetider efter väntethändelse och händelseklass för ett angivet ögonblicksintervall. Använd parametern Session Type för att begränsa antingen till förgrunds-, bakgrunds- eller alla serverprocesser. TR DBA AWR System Wait Event Summary Belirli bir anlık görüntü zaman aralığı için bekleme olayı ve olay sınıfına göre bekleme sürelerinin özeti. Ön plan, arka plan veya tüm sunucu işlemlerini kısıtlamak için Oturum Türü parametresini kullanın. US DBA AWR Wait Event Summary Summary of wait times by wait event and event class for a specified snapshot time interval. Use the Session Type parameter to restrict either to foreground, background or all server processes. To see data in this report based on dba_hist_system_event, set the following: alter session set container=PDB1; alter system set awr_pdb_autoflush_enabled=true; https://www.enginatics.com/blog/updated-dba-awr-blitz-reports-now-work-with-plugglable-databases/ ZHS DBA AWR System Wait Event Summary 按指定快照时间间隔的等待事件和事件类别汇总等待时间。 使用会话类型参数来限制前台、后台或所有服务器进程。 Diagnostic Pack Enginatics &columns &columns2 &partition_by 1=1 :session_type 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 30 :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 F Type de session US Session Type 4 40 &columns dhse.event_name, LOV custom Y select 'Class' value, '' description from dual union all select 'Class by Instance' value, '' description from dual union all select 'Event' value, '' description from dual union all select 'Event by Instance' value, '' description from dual Event% Event Y F Niveau de détail US Level of Detail 5 &columns2 dhse.instance_number, %Instance F Niveau de détail US Level of Detail 6 &partition_by , dhse.instance_number Class by Instance F Niveau de détail US Level of Detail 7 &partition_by , dhse.event_name Event F Niveau de détail US Level of Detail 8 &partition_by , dhse.event_name, dhse.instance_number Event by Instance F Niveau de détail US Level of Detail 9 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) 10 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 11 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 12 70 1=1 dhse.wait_class<>'Idle' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N N Y F Inclure les événements inactifs US Include Idle Events 13 80 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 14 90 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 15 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