ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 56115705E2503548E0530100007F8B68Y select x.* from ( select to_char(xxen_util.client_time(to_date(dhtsu.rtime,'MM/DD/YYYY HH24:MI:SS')),'Day') day_of_week, xxen_util.client_time(to_date(dhtsu.rtime,'MM/DD/YYYY HH24:MI:SS')) end_interval_time, decode(ts.contents$,0,(decode(bitand (ts.flags, 16),16,'UNDO','PERMANENT')),1,'TEMPORARY') contents, ts.name tablespace, dhtsu.tablespace_usedsize*vp.value/1000000 used_size, dhtsu.tablespace_size*vp.value/1000000 size_, dhtsu.tablespace_maxsize*vp.value/1000000 max_size, sys_context('userenv','db_name') db_name from (select vp.value from v$parameter vp where vp.name like 'db_block_size') vp, v$database vd, dba_hist_tbspc_space_usage dhtsu, sys.ts$ ts where dhtsu.tablespace_id=ts.ts# and 2=2 ) x where 1=1 order by x.contents desc, x.tablespace, x.end_interval_time desc #,##0.00 US DBA AWR Tablespace Usage Tablespace usage over time from the AWR Enginatics 1=1 2=2 1 10 1=1 end_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 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 3 210 2=2 vd.dbid=dhtsu.dbid 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 4 2=2 vd.con_dbid=dhtsu.dbid Current PDB F Données sur les conteneurs US Container Data