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 B03EBE80A5542344E0530100007F06BF select &instance_number y.seconds/xxen_util.zero_to_null(sum(decode(y.status,'Total DB time',y.seconds)) over ())*100 percentage, y.status, xxen_util.time(y.seconds) time, y.seconds, y.seconds/y.total_seconds average_active_sessions from ( select &instance_number nvl(x.stat_name,'WAITING') status, abs(sum(decode(x.stat_name,'ON CPU',-x.seconds,x.seconds))) seconds, x.total_seconds from ( select distinct &instance_number dhstm.stat_name, sum(case when dhstm.time_delta<0 then dhstm.time_micro else dhstm.time_delta end) over (partition by dhstm.stat_name &partition_by)/1000000 seconds, (max(dhstm.end_interval_time) over (partition by dhstm.stat_name &partition_by)-min(dhstm.end_interval_time) over (partition by dhstm.stat_name &partition_by))*86400 total_seconds from ( select dhstm.instance_number, cast(dhs.end_interval_time as date) end_interval_time, decode(dhstm.stat_name,'DB CPU','ON CPU','Total DB time') stat_name, dhstm.value time_micro, dhstm.value-lag(dhstm.value) over (partition by dhstm.dbid, dhstm.instance_number, dhstm.stat_name order by dhstm.snap_id) time_delta from dba_hist_snapshot dhs, dba_hist_sys_time_model dhstm where 1=1 and dhstm.stat_name in ('DB CPU','DB time') and dhs.dbid=dhstm.dbid and dhs.instance_number=dhstm.instance_number and dhs.snap_id=dhstm.snap_id ) dhstm ) x where x.seconds>0 group by &instance_number x.total_seconds, rollup(x.stat_name) ) y order by instance_number, seconds desc Y #,##0 AR DBA AWR System Wait Time Summary ملخص وحدة المعالجة المركزية لقاعدة البيانات مقابل أوقات الانتظار ومتوسط الجلسات النشطة لإطار زمني محدد D DBA AWR System Wait Time Summary Zusammenfassung der Datenbank-CPU im Vergleich zu den Wartezeiten und den durchschnittlichen aktiven Sitzungen für einen bestimmten Zeitrahmen E DBA AWR System Wait Time Summary Resumen de la CPU de la base de datos frente a los tiempos de espera y el promedio de sesiones activas para un periodo de tiempo determinado F DBA AWR System Wait Time Summary Résumé du CPU de la base de données par rapport aux temps d'attente et aux sessions actives moyennes pour une période donnée I DBA AWR System Wait Time Summary Riepilogo della CPU del database rispetto ai tempi di attesa e alla media delle sessioni attive per un determinato periodo di tempo JA DBA AWR System Wait Time Summary 指定された時間枠のデータベースのCPU対待ち時間と平均アクティブセッションの概要 KO DBA AWR System Wait Time Summary 지정된 시간 프레임에 대한 데이터베이스 CPU 대 대기 시간 및 평균 활성 세션 요약 PTB DBA AWR System Wait Time Summary Resumo da CPU do banco de dados vs. tempos de espera e média de sessões ativas por um período de tempo especificado RU DBA AWR System Wait Time Summary Сводка по процессору базы данных в сравнении с временем ожидания и средними значениями активных сессий за указанный промежуток времени S DBA AWR System Wait Time Summary Sammanfattning av databasens CPU jämfört med väntetider och genomsnittliga aktiva sessioner under en angiven tidsram TR DBA AWR System Wait Time Summary Veritabanı CPU'sunun özeti ile bekleme süreleri ve belirli bir zaman dilimi için ortalama aktif oturumlar US DBA AWR CPU vs Wait Time Summary Summary of database CPU vs. wait times and average active sessions for a specified time frame To see data in this report based on dba_hist_sys_time_model, 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 Time Summary 数据库CPU与等待时间和指定时间段内的平均活动会话的摘要 Enginatics &instance_number &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 30 &instance_number instance_number, LOV custom Y select 'Total' value, '' description from dual union all select 'By Instance' value, '' description from dual By Instance By Instance Y F Niveau de détail US Level of Detail 4 &partition_by , dhstm.instance_number By Instance F Niveau de détail US Level of Detail 5 40 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 50 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 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 F Pack de diagnostic activé US Diagnostic Pack enabled 9 70 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