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
61BB2B9EA5F566DEE0530100007F997C
select
x.day_of_week,
x.end_interval_time,
x.instance_number,
xxen_util.time(x.user_io) user_io_,
xxen_util.time(x.application) application_,
xxen_util.time(x.network) network_,
xxen_util.time(x.concurrency) concurrency_,
xxen_util.time(x.commit) commit_,
xxen_util.time(x.other) other_,
xxen_util.time(x.configuration) configuration_,
xxen_util.time(x.scheduler) scheduler_,
xxen_util.time(x.system_io) system_io_,
xxen_util.time(x.administrative) administrative_,
x.user_io,
x.user_io_waits,
x.user_io_timeouts,
x.application,
x.application_waits,
x.application_timeouts,
x.network,
x.network_waits,
x.network_timeouts,
x.concurrency,
x.concurrency_waits,
x.concurrency_timeouts,
x.commit,
x.commit_waits,
x.commit_timeouts,
x.other,
x.other_waits,
x.other_timeouts,
x.configuration,
x.configuration_waits,
x.configuration_timeouts,
x.scheduler,
x.scheduler_waits,
x.scheduler_timeouts,
x.system_io,
x.system_io_waits,
x.system_io_timeouts,
x.administrative,
x.administrative_waits,
x.administrative_timeouts
from
(
select
to_char(xxen_util.client_time(dhs.end_interval_time),'Day') day_of_week,
xxen_util.client_time(dhs.end_interval_time) end_interval_time,
dhs.instance_number,
dhse.wait_class,
case when dhse.time_delta<0 then dhse.time_micro else dhse.time_delta end/1000000 seconds,
case when dhse.waits_delta<0 then dhse.waits else dhse.waits_delta end waits,
case when dhse.timeouts_delta<0 then dhse.timeouts else dhse.timeouts_delta end timeouts
from
dba_hist_snapshot dhs,
(
select
dhse.time_micro-lag(dhse.time_micro) over (partition by dhse.dbid, dhse.instance_number, dhse.wait_class, dhse.event_name order by dhse.snap_id) time_delta,
dhse.waits-lag(dhse.waits) over (partition by dhse.dbid, dhse.instance_number, dhse.wait_class, dhse.event_name order by dhse.snap_id) waits_delta,
dhse.timeouts-lag(dhse.timeouts) over (partition by dhse.dbid, dhse.instance_number, dhse.wait_class, 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_timeouts) timeouts,
dhse.*
from
dba_hist_system_event dhse
) dhse
) dhse
where
1=1 and
dhse.wait_class<>'Idle' and
dhs.dbid=dhse.dbid and
dhs.instance_number=dhse.instance_number and
dhs.snap_id=dhse.snap_id
)
pivot (
sum(case when seconds>0 then seconds end),
sum(case when waits>0 then waits end) waits,
sum(case when timeouts>0 then timeouts end) timeouts
for
wait_class in (
'User I/O' user_io,
'Application' application,
'Network' network,
'Concurrency' concurrency,
'Commit' commit,
'Other' other,
'Configuration' configuration,
'Scheduler' scheduler,
'System I/O' system_io,
'Administrative' administrative
)
) x
order by
x.end_interval_time desc,
x.instance_number
Y
#,##0
AR
DBA AWR System Wait Class by Time
أوقات انتظار الجلسات غير الخاملة بفئة الانتظار بمرور الوقت.
يعرض كل صف وقت الانتظار على مستوى النظام لكل فئة انتظار لفاصل زمني واحد للقطات AWR لتحديد أحداث الانتظار غير العادية التي حدثت في أوقات محددة.
استخدم معلمة نوع الجلسة لتقييد إما المقدمة أو الخلفية أو جميع عمليات الخادم.
D
DBA AWR System Wait Class by Time
Wartezeiten für nicht ungenutzte Sitzungen nach Warteklasse im Zeitverlauf.
Jede Zeile zeigt die systemweite Wartezeit pro Warteklasse eines AWR-Snapshot-Intervalls, um ungewöhnliche Warteereignisse zu identifizieren, die zu bestimmten Zeiten aufgetreten sind.
Verwenden Sie den Parameter "Session Type", um entweder auf Vordergrund-, Hintergrund- oder alle Serverprozesse einzuschränken.
E
DBA AWR System Wait Class by Time
Tiempos de espera de las sesiones no inactivas por clase de espera a lo largo del tiempo.
Cada fila muestra el tiempo de espera de todo el sistema por clase de espera de un intervalo de instantánea de AWR para identificar eventos de espera inusuales que se produjeron en momentos específicos.
Utilice el parámetro Tipo de sesión para restringir los procesos en primer plano, en segundo plano o todos los procesos del servidor.
F
DBA AWR System Wait Class by Time
Temps d'attente des sessions non oisives par classe d'attente au fil du temps.
Chaque ligne indique le temps d'attente à l'échelle du système par classe d'attente d'un intervalle d'instantanés AWR afin d'identifier les événements d'attente inhabituels qui se sont produits à des moments spécifiques.
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 Class by Time
Tempi di attesa delle sessioni non inattive per classe di attesa nel tempo.
Ogni riga mostra il tempo di attesa a livello di sistema per classe di attesa di un intervallo di snapshot AWR per identificare eventi di attesa insoliti che si sono verificati in momenti specifici.
Usa il parametro Session Type per restringere a foreground, background o tutti i processi del server.
JA
DBA AWR System Wait Class by Time
アイドルセッション以外の待ち時間を、待ちクラス別に表示しています。
各行は、特定の時間に発生した異常な待ちイベントを特定するために、AWRスナップショット間隔の待ちクラスごとのシステム全体の待ち時間を表示しています。
Session Typeパラメータを使用して、フォアグラウンド、バックグラウンド、全サーバプロセスのいずれかに制限することができます。
KO
DBA AWR System Wait Class by Time
시간 경과에 따른 대기 클래스 별 비유 휴 세션 대기 시간.
각 행은 특정 시간에 발생한 비정상적인 대기 이벤트를 식별하기 위해 하나의 AWR 스냅 샷 간격의 대기 클래스 당 시스템 전체 대기 시간을 보여줍니다.
세션 유형 매개 변수를 사용하여 포 그라운드, 백그라운드 또는 모든 서버 프로세스로 제한하십시오.
PTB
DBA AWR System Wait Class by Time
Tempos de espera não ociosos por aula de espera ao longo do tempo.
Cada linha mostra o tempo de espera em todo o sistema por classe de espera de um intervalo de instantâneos AWR para identificar eventos de espera incomuns que ocorreram em momentos específicos.
Use o parâmetro Tipo de Sessão para restringir tanto o primeiro plano, quanto o segundo plano ou todos os processos do servidor.
RU
DBA AWR System Wait Class by Time
Время ожидания не в режиме простоя на уроке ожидания с течением времени.
Каждая строка показывает общесистемное время ожидания по каждому классу ожидания одного интервала снимка AWR для выявления необычных событий ожидания, которые произошли в определенное время.
Используйте параметр Session Type (Тип сеанса) для ограничения либо переднего плана, либо фона, либо всех процессов сервера.
S
DBA AWR System Wait Class by Time
Väntetider utan passiv session efter vänteläge över tid.
Varje rad visar den systemomfattande väntetiden per väntklass för ett AWR-ögonblicksbildintervall för att identifiera ovanliga väntningshändelser som inträffade vid specifika tider.
Använd parametern Session Type för att begränsa antingen till förgrunds-, bakgrunds- eller alla serverprocesser.
TR
DBA AWR System Wait Class by Time
Zaman içinde bekleme sınıfına göre boşta olmayan oturum bekleme süreleri.
Her satır, belirli zamanlarda meydana gelen olağandışı bekleme olaylarını tanımlamak için bir AWR anlık görüntü aralığının her bir bekleme sınıfı için sistem genelinde bekleme süresini gösterir.
Ö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 Class by Time
Non idle session wait times by wait class over time.
Each row shows the system-wide wait time per wait class of one AWR snapshot interval to identify unusual wait events that occured at specific times.
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 Class by Time
按等待类别分列的非空闲会话等待时间随时间变化。
每一行都显示了一个AWR快照间隔的每个等待类别的全系统等待时间，以确定在特定时间发生的异常等待事件。
使用会话类型参数可限制前台、后台或所有服务器进程。
Diagnostic Pack
Enginatics
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
F
Type de session
US
Session Type
4
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
5
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
6
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