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
7B8E20B1ECD0257BE0530100007F56D5
select
x.day_of_week,
x.end_interval_time,
x.instance_number,
&columns
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,
dhl.latch_name,
case when dhl.time_delta<0 then dhl.wait_time else dhl.time_delta end/1000000 seconds
from
dba_hist_snapshot dhs,
(
select
dhl.wait_time-lag(dhl.wait_time) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id) time_delta,
dhl.*
from
dba_hist_latch dhl
) dhl
where
1=1 and
dhs.dbid=dhl.dbid and
dhs.instance_number=dhl.instance_number and
dhs.snap_id=dhl.snap_id
)
pivot (
sum(case when seconds>0 then seconds end)
for
latch_name in (
&pivot_columns
)
) x
order by
x.end_interval_time desc,
x.instance_number
Y
#,##0.00
AR
DBA AWR Latch by Time
مزلاج الخلاف سجل وقت الانتظار.
يعرض كل صف وقت انتظار تنازع المزلاج على مستوى النظام لكل اسم مزلاج لفترة لقطة AWR واحدة لتحديد تنازع المزلاج العالي في أوقات محددة.
D
DBA AWR Latch by Time
Verlauf der Wartezeit bei Latch-Konkurrenz.
Jede Zeile zeigt die systemweite Latch-Contention-Wartezeit pro Latch-Name eines AWR-Snapshot-Intervalls, um hohe Latch-Contention zu bestimmten Zeiten zu identifizieren.
E
DBA AWR Latch by Time
Historial de tiempo de espera de contención de latches.
Cada fila muestra el tiempo de espera de contención de latches de todo el sistema por nombre de latch de un intervalo de instantáneas de AWR para identificar la alta contención de latches en momentos específicos.
F
DBA AWR Latch by Time
L'historique des temps d'attente de Latch Contingent.
Chaque ligne indique le temps d'attente de la contention de verrou à l'échelle du système par nom de verrou d'un intervalle d'instantané AWR pour identifier une contention de verrou élevée à des moments spécifiques.
I
DBA AWR Latch by Time
Storia del tempo di attesa dei latch.
Ogni riga mostra il tempo di attesa della contesa dei latch a livello di sistema per nome del latch di un intervallo di snapshot AWR per identificare un'alta contesa dei latch in momenti specifici.
JA
DBA AWR Latch by Time
ラッチ競合待ち時間の履歴。
各行は、特定の時間に高いラッチ競合を識別するために、1つのAWRスナップショット間隔のラッチ名ごとのシステム全体のラッチ競合待ち時間を示しています。
KO
DBA AWR Latch by Time
경합 대기 시간 기록을 래치합니다.
각 행은 특정 시간에 높은 래치 경합을 식별하기 위해 하나의 AWR 스냅 샷 간격의 래치 이름 당 시스템 전체 래치 경합 대기 시간을 보여줍니다.
PTB
DBA AWR Latch by Time
História do tempo de espera de contenção.
Cada linha mostra o tempo de espera de contenção da trava em todo o sistema por cada nome de trava de um intervalo de instantâneo AWR para identificar a contenção alta da trava em momentos específicos.
RU
DBA AWR Latch by Time
История времени ожидания.
Каждая строка показывает общесистемное время ожидания для каждого имени защелки одного интервала снимка AWR, чтобы идентифицировать высокое содержание защелки в определенное время.
S
DBA AWR Latch by Time
Spärr väntetid historik.
Varje rad visar den systemomfattande spärrväntetiden per spärrnamn för ett AWR-ögonblicksbildintervall för att identifiera högt spärrfäste vid specifika tidpunkter.
TR
DBA AWR Latch by Time
Mandal çekişmesi bekleme süresi geçmişi.
Her satır, belirli zamanlarda yüksek mandal çekişmesini tanımlamak için bir AWR anlık görüntü aralığının mandal adı başına sistem genelinde mandal çekişmesi bekleme süresini gösterir.
US
DBA AWR Latch by Time
Latch contention wait time history.
Each row shows the system-wide latch contention wait time per latch name of one AWR snapshot interval to identify high latch contention at specific times.
ZHS
DBA AWR Latch by Time
闩锁争用等待时间历史。
每一行都显示了一个AWR快照间隔的每个锁存名的全系统锁存竞争等待时间，以识别特定时间的高锁存竞争。
Diagnostic Pack
Enginatics
&columns
&pivot_columns
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
Y
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
select xxen_util.client_time(dhs.end_interval_time) from
(
select
max(dhs.end_interval_time) end_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
Y
F
Date à
US
Date To
3
&columns
with x as
(
select * from
(
select
substr(translate(lower(dhl.latch_name),' .-:/','_____'),1,29) column_name
from
(
select
dhl.wait_time-nvl(lag(dhl.wait_time) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id),0) wait_time_,
dhl.*
from
dba_hist_snapshot dhs,
dba_hist_latch dhl
where
dhs.end_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))-1/1440 and
dhs.begin_interval_time<=xxen_util.server_time(fnd_date.displaydt_to_date(:date_to)) and
1=1 and
dhs.dbid=(select vd.con_dbid from v$database vd) 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
group by
dhl.latch_name
having
sum(dhl.wait_time_)>0
order by
sum(dhl.wait_time_) desc
)
where
rownum<=30
)
select 'xxen_util.time(x.'||x.column_name||') '||x.column_name||',' from x union all
select 'x.'||x.column_name||',' from x union all
select 'null x' pivot_text from dual
F
Date à
US
Date To
4
&pivot_columns
select * from
(
select * from
(
select
'''' ||dhl.latch_name||''' '||substr(translate(lower(dhl.latch_name),' .-:/','_____'),1,29)||',' pivot_text
from
(
select
dhl.wait_time-nvl(lag(dhl.wait_time) over (partition by dhl.dbid, dhl.instance_number, dhl.latch_name order by dhl.snap_id),0) wait_time_,
dhl.*
from
dba_hist_snapshot dhs,
dba_hist_latch dhl
where
dhs.end_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from))-1/1440 and
dhs.begin_interval_time<=xxen_util.server_time(fnd_date.displaydt_to_date(:date_to)) and
1=1 and
dhs.dbid=(select vd.con_dbid from v$database vd) 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
group by
dhl.latch_name
having
sum(dhl.wait_time_)>0
order by
sum(dhl.wait_time_) desc
)
where
rownum<=30
)
union all
select '''dummy'' dummy' pivot_text from dual
F
Date à
US
Date To
5
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
6
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
7
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