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 49A8B1A8039908ACE0530100007FEB91 select * from ( select &pivot_time1 y.stat_name, nvl(100*y.delta/xxen_util.zero_to_null(sum(y.delta) over (&pivot_partition1)),0) percentage from ( select distinct &pivot_time2 x.stat_name, greatest(0, max(x.value) over (partition by x.stat_id, x.dbid, x.instance_number &pivot_partition2)- &delta_prev_value) delta 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, dhstm.stat_id, dhstm.dbid, dhstm.instance_number, case when dhstm.stat_name='parse time elapsed' then 'soft parse elapsed time' when dhstm.stat_name='background elapsed time' then 'background elapsed other' when dhstm.stat_name='background cpu time' then 'background cpu other' else dhstm.stat_name end stat_name, case when dhstm.stat_name='parse time elapsed' then greatest(0,dhstm.value-sum(case when dhstm.stat_name in ('hard parse elapsed time','failed parse elapsed time') then dhstm.value end) over (partition by dhstm.snap_id,dhstm.dbid,dhstm.instance_number)) when dhstm.stat_name='background elapsed time' then greatest(0,dhstm.value-sum(case when dhstm.stat_name='background cpu time' then dhstm.value end) over (partition by dhstm.snap_id,dhstm.dbid,dhstm.instance_number)) when dhstm.stat_name='background cpu time' then greatest(0,dhstm.value-sum(case when dhstm.stat_name='RMAN cpu time (backup/restore)' then dhstm.value end) over (partition by dhstm.snap_id,dhstm.dbid,dhstm.instance_number)) else dhstm.value end value from dba_hist_snapshot dhs, dba_hist_sys_time_model dhstm where 1=1 and dhstm.stat_name not in ( 'DB time', 'DB CPU', 'hard parse (sharing criteria) elapsed time', 'hard parse (bind mismatch) elapsed time', 'failed parse (out of shared memory) elapsed time' ) and dhs.snap_id=dhstm.snap_id and dhs.dbid=dhstm.dbid and dhs.instance_number=dhstm.instance_number ) x ) y order by percentage desc ) &pivot Y #,##0.00;[Red]-#,##0.00 AR DBA AWR System Time Summary Percentages تُظهر قيم نموذج وقت النظام التاريخي من مستودع عبء العمل الآلي تفصيلًا للنسبة المئوية التي تم إنفاقها من وقت قاعدة البيانات ، على سبيل المثال حول استبعاد كود SQL أو PL / SQL أو Java ، أو تحليل العبارات ، إلخ .. D DBA AWR System Time Summary Percentages Historische Systemzeitmodellwerte aus dem automatisierten Workload-Repository, die eine Aufschlüsselung darüber zeigen, wie viel Prozent der Datenbankzeit z. B. für das Ausführen von SQL-, PL/SQL- oder Java-Code, das Parsen von Anweisungen usw. aufgewendet wurde. E DBA AWR System Time Summary Percentages Valores históricos del modelo de tiempo del sistema desde el repositorio de carga de trabajo automatizado que muestra un desglose de cuánto porcentaje del tiempo de la base de datos se gastó, por ejemplo, en la ejecución de código SQL, PL/SQL o Java, en el análisis sintáctico de declaraciones, etc. F DBA AWR System Time Summary Percentages Valeurs historiques du modèle temporel du système provenant du dépôt de charge de travail automatisé, montrant la répartition du pourcentage du temps passé dans la base de données, par exemple pour l'extraction du code SQL, PL/SQL ou Java, l'analyse des instructions, etc. I DBA AWR System Time Summary Percentages Valori storici del modello temporale del sistema dal repository automatizzato del carico di lavoro che mostra una ripartizione di quanta percentuale del tempo del database è stata spesa, ad esempio per l'esecuzione di codice SQL, PL/SQL o Java, per l'analisi delle dichiarazioni ecc. JA DBA AWR System Time Summary Percentages 自動化されたワークロードリポジトリからのシステム時間モデルの過去の値は、SQL、PL/SQL、Javaコードの解析、ステートメントの解析などにデータベース時間の何パーセントが費やされたかの内訳を示しています。 KO DBA AWR System Time Summary Percentages 자동화 된 워크로드 리포지토리의 과거 시스템 시간 모델 값은 사용 된 데이터베이스 시간 비율의 분석을 보여줍니다. SQL, PL / SQL 또는 Java 코드, 구문 분석 등 PTB DBA AWR System Time Summary Percentages Valores históricos do modelo de tempo do sistema a partir do repositório de carga de trabalho automatizado, mostrando uma quebra de quanto tempo do banco de dados foi gasto, por exemplo, em excutar código SQL, PL/SQL ou Java, instruções de análise, etc. RU DBA AWR System Time Summary Percentages Исторические значения системной модели времени из репозитория автоматизированной рабочей нагрузки, показывающие, сколько процентов времени было потрачено БД, например, на извлечение SQL, PL/SQL или Java кода, операторы синтаксического анализа и т.д.. S DBA AWR System Time Summary Percentages Historiska systemtidsmodellvärden från det automatiska arbetsbelastningsförvaret som visar en fördelning av hur mycket procent av databastiden som användes t.ex. om att exkludera SQL-, PL / SQL- eller Java-kod, analysera uttalanden etc. TR DBA AWR System Time Summary Percentages Veritabanı zamanının yüzde ne kadarının harcandığının bir dökümünü gösteren otomatik iş yükü havuzundan alınan geçmiş sistem zaman modeli değerleri, örn. SQL, PL / SQL veya Java kodunun çıkarılması, ifadelerin ayrıştırılması vb. US DBA AWR System Time Percentages Historic system time model values from the automated workload repository showing a breakdown of how much percent of the database time was spent e.g. on excuting SQL, PL/SQL or Java code, parsing statements etc.. 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 Time Summary Percentages 来自自动化工作量库的历史系统时间模型值，显示了数据库时间的百分比，例如，用于摘录SQL、PL/SQL或Java代码、解析语句等。 Diagnostic Pack Enginatics &delta_prev_value &pivot &pivot_partition1 &pivot_partition2 &pivot_time1 &pivot_time2 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 &pivot pivot ( sum(percentage) "%" for stat_name in ( 'sql execute elapsed time' sql_execute, 'PL/SQL execution elapsed time' plsql_execution, 'inbound PL/SQL rpc elapsed time' inbound_plsql_rpc, 'Java execution elapsed time' java_execution, 'hard parse elapsed time' hard_parse, 'failed parse elapsed time' failed_parse, 'soft parse elapsed time' soft_parse, 'repeated bind elapsed time' repeated_bind, 'connection management call elapsed time' conn_management, 'PL/SQL compilation elapsed time' plsql_compilation, 'sequence load elapsed time' sequence_load, 'background elapsed other' background_elapsed_other, 'background cpu other' background_cpu_other, 'RMAN cpu time (backup/restore)' rman_cpu ) ) order by time desc LOV custom Y select 'per snapshot' value, '' description from dual union all select 'per day' value, '' description from dual union all select 'none' value, '' description from dual per snapshot per snapshot Y F Partage du temps US Time Split 4 &pivot pivot ( sum(percentage) "%" for stat_name in ( 'sql execute elapsed time' sql_execute, 'PL/SQL execution elapsed time' plsql_execution, 'inbound PL/SQL rpc elapsed time' inbound_plsql_rpc, 'Java execution elapsed time' java_execution, 'hard parse elapsed time' hard_parse, 'failed parse elapsed time' failed_parse, 'soft parse elapsed time' soft_parse, 'repeated bind elapsed time' repeated_bind, 'connection management call elapsed time' conn_management, 'PL/SQL compilation elapsed time' plsql_compilation, 'sequence load elapsed time' sequence_load, 'background elapsed other' background_elapsed_other, 'background cpu other' background_cpu_other, 'RMAN cpu time (backup/restore)' rman_cpu ) ) order by time desc per day F Partage du temps US Time Split 5 &delta_prev_value min(x.value) over (partition by x.stat_id, x.dbid, x.instance_number) none F Partage du temps US Time Split 6 &delta_prev_value min(x.value) over (partition by x.stat_id, x.dbid, x.instance_number, trunc(x.end_interval_time)) per day F Partage du temps US Time Split 7 &delta_prev_value lag(x.value) over (partition by x.stat_id, x.dbid, x.instance_number order by x.end_interval_time) per snapshot F Partage du temps US Time Split 8 &pivot_partition1 partition by y.time per day F Partage du temps US Time Split 9 &pivot_partition1 partition by y.time per snapshot F Partage du temps US Time Split 10 &pivot_partition2 , trunc(x.end_interval_time) per day F Partage du temps US Time Split 11 &pivot_partition2 , x.end_interval_time per snapshot F Partage du temps US Time Split 12 &pivot_time1 y.day_of_week, y.time, per day F Partage du temps US Time Split 13 &pivot_time1 y.day_of_week, y.time, per snapshot F Partage du temps US Time Split 14 &pivot_time2 x.day_of_week, trunc(x.end_interval_time) time, per day F Partage du temps US Time Split 15 &pivot_time2 x.day_of_week, x.end_interval_time time, per snapshot F Partage du temps US Time Split 16 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 17 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 18 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