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 206CCDE091A6BACAE063F8383C0A19CAY 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, dhics.name, decode(dhics.name,'ipq','Parallel query communications','dlm','Database lock management','cache','Global cache communications') description, (dhics.bytes_sent-lag(dhics.bytes_sent) over (partition by dhs.instance_number, dhics.name order by dhs.snap_id))/dhs.seconds/1000000 mb_sent_sec, (dhics.bytes_received-lag(dhics.bytes_received) over (partition by dhs.instance_number, dhics.name order by dhs.snap_id))/dhs.seconds/1000000 mb_received_sec from (select (cast(dhs.end_interval_time as date)-cast(dhs.begin_interval_time as date))*86400 seconds, dhs.* from dba_hist_snapshot dhs) dhs, dba_hist_ic_client_stats dhics where 1=1 and dhs.dbid=dhics.dbid and dhs.instance_number=dhics.instance_number and dhs.snap_id=dhics.snap_id order by dhs.instance_number, dhics.name, dhs.end_interval_time desc #,##0.00 US DBA AWR Interconnect Traffic Displays information about the usage of an interconnect device by instance in a RAC configuration. ipq - Parallel query communications dlm - Database lock management cache - Global cache communications All other values are internal to Oracle and are not expected to have high usage. 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 30 1=1 dhics.name=:name LOV custom Y select distinct dhics.name value, decode(dhics.name,'ipq','Parallel query communications','dlm','Database lock management','cache','Global cache communications') description from dba_hist_ic_client_stats dhics order by description, value ipq;dlm;cache US Name 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') 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