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 526C64EC464970F7E0530100007FF13F select * from ( select &pivot_time1 y.instance_number, y.stat_name, &elapsed_time case when y.stat_name in ('active sessions','active CPU sessions') then to_char(y.delta/1000000/y.time_interval,'fm999g990d00') else xxen_util.time(nvl(y.delta/1000000,0)) end time_ from ( select distinct &pivot_time2 x.instance_number, x.stat_name, greatest(0, max(x.value) over (partition by x.stat_name, x.dbid, x.instance_number &pivot_partition2)- &delta_prev_value) delta, sum(x.time_interval) over (partition by x.stat_name, x.dbid, x.instance_number &time_partition_by) time_interval 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, (cast(dhs.end_interval_time as date)-cast(dhs.begin_interval_time as date))*86400 time_interval, 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, ( select dhstm.dbid, dhstm.instance_number, dhstm.snap_id, dhstm.stat_name, dhstm.value from dba_hist_sys_time_model dhstm union all select dhstm.dbid, dhstm.instance_number, dhstm.snap_id, decode(dhstm.stat_name,'DB time','active sessions','active CPU sessions') stat_name, dhstm.value from dba_hist_sys_time_model dhstm where dhstm.stat_name in ('DB time','DB CPU') ) dhstm where 1=1 and dhstm.stat_name not in ( '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 nvl(y.delta,0) desc ) &pivot Y #,##0.00;[Red]-#,##0.00 AR DBA AWR System Time Summary قيم نموذج وقت النظام التاريخي من مستودع عبء العمل الآلي توضح تفاصيل كيفية قضاء وقت قاعدة البيانات على سبيل المثال حول استبعاد كود SQL أو PL / SQL أو Java ، أو تحليل العبارات ، إلخ .. D DBA AWR System Time Summary Historische Systemzeitmodellwerte aus dem automatisierten Workload-Repository, die eine Aufschlüsselung darüber zeigen, wie die Datenbankzeit verbraucht wurde, z. B. für die Ausführung von SQL-, PL/SQL- oder Java-Code, das Parsen von Anweisungen usw. E DBA AWR System Time Summary Valores históricos del modelo de tiempo del sistema desde el repositorio de carga de trabajo automatizado que muestra un desglose de cómo se gastó el tiempo de la base de datos, por ejemplo, en la excusión de código SQL, PL/SQL o Java, el análisis sintáctico de declaraciones, etc. F DBA AWR System Time Summary Valeurs historiques du modèle temporel du système provenant du dépôt de charge de travail automatisé, montrant la répartition du temps passé dans la base de données, par exemple pour l'exécution du code SQL, PL/SQL ou Java, l'analyse des instructions, etc. I DBA AWR System Time Summary Valori storici del modello temporale del sistema dal repository automatizzato del carico di lavoro che mostra una ripartizione di come il tempo del database è stato speso, ad esempio per l'estrazione di codice SQL, PL/SQL o Java, per l'analisi delle dichiarazioni, ecc. JA DBA AWR System Time Summary 自動化されたワークロードリポジトリからの過去のシステム時間モデル値は、SQL、PL/SQL、またはJavaコードの解析、ステートメントの解析など、データベースの時間がどのように費やされたかの内訳を示しています。 KO DBA AWR System Time Summary 자동화 된 워크로드 저장소의 과거 시스템 시간 모델 값은 데이터베이스 시간이 어떻게 소비되었는지에 대한 분석을 보여줍니다. SQL, PL / SQL 또는 Java 코드, 구문 분석 등 PTB DBA AWR System Time Summary Valores históricos do modelo de tempo do sistema a partir do repositório de carga de trabalho automatizado mostrando uma quebra de como o 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 Исторические значения системной модели времени из репозитория автоматизированной рабочей нагрузки, показывающие разбивку времени, затраченного БД, например, на извлечение SQL, PL/SQL или Java кода, операторы синтаксического анализа и т.д.. S DBA AWR System Time Summary Historiska systemtidsmodellvärden från det automatiska arbetsbelastningsförvaret som visar en sammanfattning av hur databastiden spenderades, t.ex. om att exkludera SQL-, PL / SQL- eller Java-kod, analysera uttalanden etc. TR DBA AWR System Time Summary Veritabanı zamanının nasıl 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 Summary Historic system time model values from the automated workload repository showing how 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 来自自动化工作量库的历史系统时间模型值，显示了数据库时间的分类，例如，在摘录SQL、PL/SQL或Java代码、解析语句等方面的时间。 Diagnostic Pack Enginatics &delta_prev_value &elapsed_time &pivot &pivot_partition2 &pivot_time1 &pivot_time2 &time_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 40 &pivot pivot ( max(time_) " " for stat_name in ( 'active sessions' active_sessions, 'active CPU sessions' active_cpu_sessions, 'DB time' db_time, 'DB CPU' cpu_time, '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 end_interval_time desc, instance_number LOV custom Y select 'per snapshot' value, '' description from dual union all select 'per day' value, '' description from dual union all select 'total' value, '' description from dual per snapshot per snapshot Y F Mode d'affichage US Display Mode 4 &pivot pivot ( max(time_) " " for stat_name in ( 'active sessions' active_sessions, 'active CPU sessions' active_cpu_sessions, 'DB time' db_time, 'DB CPU' cpu_time, '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 end_interval_time desc, instance_number per day F Mode d'affichage US Display Mode 5 &delta_prev_value min(x.value) over (partition by x.stat_name, x.dbid, x.instance_number, trunc(x.end_interval_time)) per day F Mode d'affichage US Display Mode 6 &delta_prev_value lag(x.value) over (partition by x.stat_name, x.dbid, x.instance_number order by x.end_interval_time) per snapshot F Mode d'affichage US Display Mode 7 &delta_prev_value min(x.value) over (partition by x.stat_name, x.dbid, x.instance_number) total F Mode d'affichage US Display Mode 8 &elapsed_time nvl(y.delta/1000000,0) elapsed_time, total F Mode d'affichage US Display Mode 9 &pivot_partition1 partition by y.end_interval_time per day F Mode d'affichage US Display Mode 10 &pivot_partition1 partition by y.end_interval_time per snapshot F Mode d'affichage US Display Mode 11 &pivot_partition2 , trunc(x.end_interval_time) per day F Mode d'affichage US Display Mode 12 &pivot_partition2 , x.end_interval_time per snapshot F Mode d'affichage US Display Mode 13 &pivot_time1 y.day_of_week, y.end_interval_time, per day F Mode d'affichage US Display Mode 14 &pivot_time1 y.day_of_week, y.end_interval_time, per snapshot F Mode d'affichage US Display Mode 15 &pivot_time2 x.day_of_week, trunc(x.end_interval_time) end_interval_time, per day F Mode d'affichage US Display Mode 16 &pivot_time2 x.day_of_week, x.end_interval_time, per snapshot F Mode d'affichage US Display Mode 17 &time_partition_by , trunc(x.end_interval_time) per day US Display Mode 18 &time_partition_by , x.end_interval_time per snapshot US Display Mode 19 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 20 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 21 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