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 49A8B1A803A908ACE0530100007FEB91 select * from ( select xxen_util.client_time(dhs.end_interval_time) end_interval_time, dhs.instance_number, dhp.name, case when dhp.name in ( 'recompute count (total)', 'cache hit percentage', 'max processes count', 'process count' ) then dhp.value else dhp.value/1000000 end value_ from dba_hist_snapshot dhs, dba_hist_pgastat dhp where 1=1 and dhs.dbid=dhp.dbid and dhs.instance_number=dhp.instance_number and dhs.snap_id=dhp.snap_id ) pivot ( sum(value_) val for name in ( 'aggregate PGA target parameter' aggr_pga_target, 'aggregate PGA auto target' aggr_pga_auto_target, 'bytes processed' bytes_processed, 'global memory bound' glob_mem_bound, 'total PGA allocated' total_pga_alloc, 'maximum PGA allocated' max_pga_alloc, 'PGA memory freed back to OS' pga_freed_back, 'total PGA inuse' total_pga_inuse, 'total freeable PGA memory' total_freeable_pga, 'maximum PGA used for auto workareas' max_pga_used_auto_workareas, 'recompute count (total)' recompute_count, 'cache hit percentage' "CACHE_HIT_%", 'max processes count' max_process_count, 'process count' process_count ) ) order by end_interval_time desc, instance_number Y #,##0.00 AR DBA AWR PGA History تاريخ حجم قاعدة البيانات PGA وإحصائيات أخرى من v $ pgastat بالميجابايت D DBA AWR PGA History Historie der Datenbank-PGA-Größe und andere Statistiken aus v$pgastat in Megabytes E DBA AWR PGA History Historial del tamaño de la base de datos PGA y otras estadísticas de v$pgastat en megabytes F DBA AWR PGA History Historique de la taille de la base de données PGA et autres statistiques de v$pgastat en mégaoctets I DBA AWR PGA History Storia della dimensione PGA del database e altre statistiche da v$pgastat in megabyte JA DBA AWR PGA History v$pgastatからのデータベースPGAサイズとその他の統計情報の履歴をメガバイト単位で表示します。 KO DBA AWR PGA History v $ pgastat의 데이터베이스 PGA 크기 및 기타 통계 기록 (MB) PTB DBA AWR PGA History História do banco de dados tamanho PGA e outras estatísticas da v$pgastat em megabytes RU DBA AWR PGA History История размеров PGA базы данных и другая статистика из v$pgastat в мегабайтах S DBA AWR PGA History Historik över databasens PGA-storlek och annan statistik från v $ pgastat i megabyte TR DBA AWR PGA History Veritabanı PGA boyutunun geçmişi ve v $ pgastat'tan megabayt cinsinden diğer istatistikler US DBA AWR PGA History History of database PGA size and other statistics from v$pgastat in megabytes ZHS DBA AWR PGA History 数据库PGA大小的历史记录和其他来自v$pgastat的统计数据，单位为兆字节。 Diagnostic Pack Enginatics 1=1 1 10 1=1 dhs.begin_interval_time>=xxen_util.server_time(fnd_date.displaydt_to_date(:date_from)) 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 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 4 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 5 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