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 8E2FF36EDF1F79D2E0530100007F1FF2 DBA Module Type Y select 'Concurrent Request' value, null description from dual union all select 'Concurrent Manager' value, null description from dual union all select 'Form' value, null description from dual union all select 'Oracle Application Framework' value, null description from dual union all select 'Workflow' value, null description from dual union all select 'Business Event' value, null description from dual union all select 'Blitz Report' value, null description from dual union all select 'Discoverer' value, null description from dual US 8E2FF36EDEAC79D2E0530100007F1FF2 DBA Package Name select ao.object_name value, ao.owner description from all_objects ao where ao.object_type='PACKAGE BODY' and ao.status='VALID' order by ao.object_name US 8E2FF36EDF1379D2E0530100007F1FF2 DBA SQL Performance Summary Order By Y select 'Buffer IO' value, '' description from dual union all select 'CPU Time' value, '' description from dual union all select 'Elapsed Time' value, '' description from dual union all select 'Time Exec' value, '' description from dual union all select 'IO Exec' value, '' description from dual union all select 'Executions' value, '' description from dual union all select 'Last Active Time' value, '' description from dual US 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8036708ACE0530100007FEB91 select &column0 decode(x.row_number,null, &order_by/sum(decode(x.row_number,null,&order_by)) over ()*100 ) percentage, &column1 xxen_util.responsibility(x.module,x.action) responsibility, xxen_util.module_type(x.module,x.action) module_type, xxen_util.module_name(x.module) module_name, x.module, &column2 &bind_columns decode(x.row_number,null,x.executions) executions, xxen_util.time(x.elapsed_time) time, decode(x.row_number,null,x.elapsed_time) elapsed_time, decode(x.row_number,null,x.user_io_wait_time) user_io_wait_time, decode(x.row_number,null,x.cpu_time) cpu_time, decode(x.row_number,null,(x.user_io_wait_time+x.cpu_time)/xxen_util.zero_to_null(x.cpu_time)) io_factor, decode(x.row_number,null,x.plsql_exec_time) plsql_exec_time, decode(x.row_number,null,x.concurrency_wait_time) concurrency_wait_time, decode(x.row_number,null,x.application_wait_time) application_wait_time, x.time_exec, decode(x.row_number,null,x.buffer_io) buffer_io, decode(x.row_number,null,x.disk_io) disk_io, x.io_exec, x.blocks_exec, x.rows_processed, x.rows_exec, x.io_row, x.blocks_row, x.io_sec, case when x.executions>100 then x.buffer_io/(decode(x.last_load_time,x.first_load_time,to_date(null),x.last_load_time)-x.first_load_time)/24/3600 end io_sec_avg, x.buffer_rate, x.disk_rate, x.disk_percentage, case when x.executions>100 then x.executions/(decode(x.last_load_time,x.first_load_time,to_date(null),x.last_load_time)-x.first_load_time)/24/3600 end execs_per_sec, case when x.executions>100 then 100*x.elapsed_time/(decode(x.last_load_time,x.first_load_time,to_date(null),x.last_load_time)-x.first_load_time)/24/3600 end time_percentage, &column3 x.parsing_schema_name schema, x.parse_calls, x.sorts, xxen_util.client_time(x.first_load_time) first_load_time, xxen_util.client_time(x.last_load_time) last_load_time, &column4 x.action from ( select decode(row_number() over (partition by x0.inst_num, x0.date_, x0.sql_id, x0.plan_hash_value, x0.capture_date order by x0.position),1,null,2) row_number, x0.elapsed_time/xxen_util.zero_to_null(x0.executions) time_exec, x0.buffer_io/xxen_util.zero_to_null(x0.executions) io_exec, x0.buffer_gets/xxen_util.zero_to_null(x0.executions) blocks_exec, x0.rows_processed/xxen_util.zero_to_null(x0.executions) rows_exec, x0.buffer_io/xxen_util.zero_to_null(x0.rows_processed) io_row, x0.buffer_gets/xxen_util.zero_to_null(x0.rows_processed) blocks_row, x0.buffer_io/xxen_util.zero_to_null(x0.elapsed_time) io_sec, (x0.buffer_io-x0.disk_io)/xxen_util.zero_to_null(x0.cpu_time) buffer_rate, x0.disk_io/xxen_util.zero_to_null(x0.user_io_wait_time) disk_rate, 100*x0.disk_io/xxen_util.zero_to_null(x0.buffer_io) disk_percentage, x0.*, dhst.sql_text from ( select distinct case when :aggregate_level like '% instance' then dhss.instance_number end inst_num, case when :aggregate_level like '% per day%' then dhs.date_ end date_, case when :aggregate_level like 'SQL%' then max(dhss.module) over (&partition_by) else dhss.module end module, case when :aggregate_level like 'SQL%' then max(dhss.action) over (&partition_by) else dhss.action end action, sum(dhss.elapsed_time_delta) over (&partition_by)/1000000 elapsed_time, sum(dhss.iowait_delta) over (&partition_by)/1000000 user_io_wait_time, sum(dhss.cpu_time_delta) over (&partition_by)/1000000 cpu_time, sum(dhss.plsexec_time_delta) over (&partition_by)/1000000 plsql_exec_time, sum(dhss.ccwait_delta) over (&partition_by)/1000000 concurrency_wait_time, sum(dhss.apwait_delta) over (&partition_by)/1000000 application_wait_time, vp.value*sum(dhss.buffer_gets_delta) over (&partition_by)/1000000 buffer_io, sum(dhss.buffer_gets_delta) over (&partition_by) buffer_gets, sum(dhss.physical_read_bytes_delta) over (&partition_by)/1000000 disk_io, sum(dhss.executions_delta) over (&partition_by) executions, sum(dhss.rows_processed_delta) over (&partition_by) rows_processed, min(dhss.parsing_schema_name) over (&partition_by) parsing_schema_name, sum(dhss.parse_calls_delta) over (&partition_by) parse_calls, sum(dhss.sorts_delta) over (&partition_by) sorts, min(dhs.begin_interval_time_) over (&partition_by) first_load_time, max(dhs.end_interval_time_) over (&partition_by) last_load_time, case when :aggregate_level like 'SQL%' then dhss.sql_id end sql_id, case when :aggregate_level like 'SQL%' then dhss.plan_hash_value end plan_hash_value, case when :aggregate_level like 'SQL%' then decode(dhst.command_type,1,'create table',2,'insert',3,'select',6,'update',7,'delete',9,'create index',11,'alter index',26,'lock table',42,'alter session',44,'commit',45,'rollback',46,'savepoint',47,'pl/sql block',48,'set transaction',50,'explain',62,'analyze table',90,'set constraints',170,'call',189,'merge','other') end command_type, gsa.is_bind_sensitive, gsa.is_bind_aware, (select so.name from sys.obj$ so where gsa.program_id=so.obj#) code, case when gsa.program_line#>0 then gsa.program_line# end code_line#, dhsb.name bind, dhsb.value_string bind_value, dhsb.last_captured capture_date, dhsb.position, dhs.dbid from ( select trunc(dhs.begin_interval_time) date_, cast(dhs.begin_interval_time as date) begin_interval_time_, cast(dhs.end_interval_time as date) end_interval_time_, dhs.* from dba_hist_snapshot dhs ) dhs, dba_hist_sqlstat dhss, dba_hist_sqltext dhst, ( select wsbm.bind.last_captured last_captured, case when wsbm.bind.datatype_string like 'TIMESTAMP%' then to_char(anydata.accesstimestamp(wsbm.bind.value_anydata)) when wsbm.bind.datatype_string='DATE' then to_char(anydata.accessdate(wsbm.bind.value_anydata)) else wsbm.bind.value_string end value_string, wsbm.* from ( select ws.dbid, ws.snap_id, ws.instance_number, ws.sql_id, ws.plan_hash_value, wsbm.name, wsbm.position, dbms_sqltune.extract_bind(ws.bind_data, wsbm.position) bind from sys.wrh$_sqlstat ws, ( select distinct min(wsbm.position) over (partition by wsbm.dbid, wsbm.sql_id, wsbm.name) position, wsbm.dbid, wsbm.sql_id, wsbm.name from sys.wrh$_sql_bind_metadata wsbm where '&show_binds'='Y' ) wsbm where ws.dbid=wsbm.dbid and ws.sql_id=wsbm.sql_id ) wsbm where wsbm.bind is not null ) dhsb, ( select distinct gsa.sql_id, min(gsa.inst_id) keep (dense_rank first order by gsa.inst_id, gsa.plan_hash_value) over (partition by gsa.sql_id) inst_id, min(gsa.plan_hash_value) keep (dense_rank first order by gsa.inst_id, gsa.plan_hash_value) over (partition by gsa.sql_id) plan_hash_value from gv$sqlarea gsa where 2=2 and '&show_sql'='Y' ) gsa0, gv$sqlarea gsa, (select vp.value from v$parameter vp where vp.name like 'db_block_size') vp where 1=1 and dhs.dbid=dhss.dbid and dhs.instance_number=dhss.instance_number and dhs.snap_id=dhss.snap_id and dhss.dbid=dhst.dbid and dhss.sql_id=dhst.sql_id and dhss.sql_id=gsa0.sql_id(+) and gsa0.sql_id=gsa.sql_id(+) and gsa0.inst_id=gsa.inst_id(+) and gsa0.plan_hash_value=gsa.plan_hash_value(+) and dhss.dbid=dhsb.dbid(+) and dhss.instance_number=dhsb.instance_number(+) and dhss.snap_id=dhsb.snap_id(+) and dhss.sql_id=dhsb.sql_id(+) ) x0, dba_hist_sqltext dhst where x0.dbid=dhst.dbid and x0.sql_id=dhst.sql_id ) x order by case when :aggregate_level in ('Module per day','SQL per day') then x.date_ end desc, &order_by desc nulls last &bind_order Renamed &enable_ lexicals to &show_ Y #,##0.00 US DBA AWR SQL Performance Summary Database SQL performance summary from the Automatic Workload Repository (AWR) tables to give an overview of top SQL load and performance issues. The report shows the summarized execution stats such as elapsed time and IO figures for a certain timeframe for individual SQL_ID and plan hash value combinations. All IO figures are shown in MB. Parameter 'Level' can be switched to aggregate data either by Module or by individual SQL and to show summarised figures or to split them by day. The default sorting shows the most CPU intensive SQLs on top, as the tuning goal is usually server load optimization. Other performance bottlenecks, such as wait times caused by Network e.g. 'SQL*Net message from dblink', can be spotted when sorting by 'elapsed time' instead of CPU. Columns: - Responsibility: Derived from the SGA's action column for initialized EBS sessions. - Module Name: Derived from the SGA's module column for initialized EBS sessions. - Module: SGA's module. Please note that if the same SQL is executed by different modules, it appears only once in this report. Thus, the module name column could be misleading as it shows the name of the first module parsing the SQL only. -Code and Code Line#: Code package and line number of the SQL, in case it is still in the cursor cache -Sql Id: Hash identifier for an individual SQL. -Plan Hash Value: Hash identifier for one particular execution plan. Please note that similar but different SQLs might share exactly the same plan hash value if their execution path is identical. -Sql Text -Executions: Total number of executions -Elapsed Time: Total elapsed time in seconds -Time: Total elapsed time in a readable format split into days, hours, minutes and seconds -User Io Wait Time: Total elapsed time in seconds from wait event class 'User I/O' -Cpu Time: Total elapsed time in seconds that the SQL spent on CPU. High figures here usually indicate that massive amounts of data are read from the buffer cache -IO Factor: Indicates how much faster the query would execute without wait IO times or unlimited memory -Plsql Exec Time: Total elapsed time in seconds for PLSQL execution -Concurrency Wait Time: Total elapsed time in seconds from wait event class 'Concurrency' e.g. 'buffer busy waits' or 'enq: TX - index contention' -Application Wait Time: Total elapsed time in seconds from wait event class 'Application' e.g. 'enq: TX - row lock contention', an uncommitted session's update blocking another session. -Time Exec: Average elapsed time per execution -Buffer IO: Total buffer IO in megabtes. This is the most important figure to look at from a server load perspective. -Disk IO: Total physical IO -IO Exec: Total IO per execution. -Rows Exec: Average number of rows per execution -IO Row: Average IO per individual row retrieved. For data extraction SQLs without any sort of data aggregation, the average IO per row is a good indication if the IO spent is reasonable or if the SQL executes efficiently or not. -IO Sec: Average IO in MB per second during SQL execution time. -IO Sec Avg: Average IO in MB per second per overall server time (to indicate the average IO server load of the individual SQL). -Execs Per Hour: Number of SQL executions per hour -Time Percentage: Average percentage of the overall server time that the SQL is running. 50% indicates a SQL is running half of the server time, 400% means the same SQL is running constantly 4 times in parallel -Is Bind Sensitive: Indicates the DB's 'adaptive cursor sharing' feature. A value of 'Y' means, the DB might consider a different explainplan for different bind values. Note that for transactional SQLs such as the ones used by Oracle EBS, the execution path should usually not change. Thus, a value of 'Y' often indicates 'instable' SQLs or SQLs where the optimizer struggles to find the best execution path. -Is Bind Aware: 'adaptive cursor sharing' feature. A value of 'Y' means, the DB considers a differ ZHS DBA AWR SQL Performance Summary 数据库SQL性能摘要来自自动工作负载存储库(AWR)表，以概述顶级SQL负载和性能问题。 该报告显示了总结的执行统计信息，如个别SQL_ID和计划哈希值组合在一定时间范围内的耗时和IO数字。 所有的IO数据都以MB为单位显示。 参数 "级别 "可切换为按模块或按单个SQL汇总数据，并显示汇总数据或按日分列数据。 参数 "时间限制 "可以设置为只显示白天或夜间的数据。 对于SQL IO调整或数据库服务器负载优化，建议按IO进行排序，以显示最需要IO的SQL。 非服务器或SQL IO相关的性能瓶颈，如网络引起的等待时间，如 "SQL*Net消息来自dblink"，可以通过 "经过时间 "而不是IO排序来发现。 栏目： - 责任。源于SGA初始化EBS会话的行动栏。 - 模块名称：来自初始化EBS会话的SGA的模块栏。源自SGA初始化EBS会话的模块栏。 - 模块：SGA的模块。SGA的模块。请注意，如果相同的SQL被不同的模块执行，它在这个报告中只出现一次。因此，模块名称列可能会产生误导，因为它只显示了第一个解析SQL的模块的名称。 -代码和代码行#：SQL的代码包和行号，以防它仍然在游标缓存中。 -Sql Id:单个SQL的哈希值标识。 -计划散列值：一个特定的执行计划的散列标识。一个特定执行计划的散列标识符。请注意，如果它们的执行路径相同，相似但不同的SQL可能共享完全相同的计划哈希值。 -SQL文本 -执行情况。执行数：执行总数 -消耗时间：总消耗时间（秒）。 -时间：以可读格式显示的总时间，分为天、小时、分钟和秒。 -用户Io等待时间：等待事件类 "用户I/O "的总耗时，以秒为单位。 -CPU时间：SQL在CPU上花费的总时间，以秒为单位。这里的数字越高，通常表示从缓冲区缓存中读取了大量的数据。 -Plsql Exec Time：PLSQL执行的总耗时，以秒为单位。 -并发等待时间：等待事件类 "并发 "的总耗时，以秒为单位，例如 "缓冲区繁忙等待 "或 "enq: TX - index contention"。 -应用程序等待时间：等待事件类 "应用程序 "的总经过时间，以秒为单位，例如："enq: TX - row lock contention"，一个未提交的会话的更新阻塞了另一个会话。 -时间Exec:每次执行的平均耗时 -缓冲区IO：缓冲区IO总量，单位为兆字节。从服务器负载的角度看，这是最重要的数字。 -磁盘IO：物理IO总量，单位为兆字节。 -IO Exec:每次执行的总IO -Rows Exec：每次执行的平均行数。每次执行的平均行数。 -IO行。每行检索的平均IO。对于没有任何数据聚合的数据提取SQL来说，每行的平均IO可以很好地说明花费的IO是否合理，或者说SQL的执行效率是否高。 -IO Sec:在SQL执行时间内，每秒的平均IO，单位为MB。 -IO Sec Avg：整体服务器时间内每秒的平均IO，单位为MB（用来表示单个SQL的平均IO服务器负载）。 -Execs Per Hour：每小时执行次数。每小时的SQL执行次数 -时间百分比。SQL运行时间占整个服务器时间的平均百分比。50%表示一个SQL运行时间占服务器时间的一半，400%表示同一个SQL持续并行运行4次。 -是绑定敏感型。表示DB的 "自适应游标共享 "功能。值为'Y'意味着，DB可能会考虑对不同的绑定值使用不同的解释计划。请注意，对于事务性SQL，如Oracle EBS使用的SQL，执行路径通常不应该改变。因此，'Y'的值通常表示'不稳定'的SQL或优化器难以找到最佳执行路径的SQL。 -Is Bind Aware：'自适应游标共享'功能。值为'Y'意味着，DB认为一个不同的游标是可以共享的。 Diagnostic Pack Enginatics &bind_columns &bind_order &column0 &column1 &column2 &column3 &column4 &order_by &partition_by &show_binds &show_sql 1=1 2=2 :aggregate_level 1 10 1=1 lower(dhst.sql_text) like lower('%'||:sql_text||'%') Char F Le texte SQL contient US SQL Text contains 2 20 1=1 xxen_util.module_type(dhss.module,dhss.action)=:module_type LOV DBA Module Type 8E2FF36EDF1F79D2E0530100007F1FF2 Y select 'Concurrent Request' value, null description from dual union all select 'Concurrent Manager' value, null description from dual union all select 'Form' value, null description from dual union all select 'Oracle Application Framework' value, null description from dual union all select 'Workflow' value, null description from dual union all select 'Business Event' value, null description from dual union all select 'Blitz Report' value, null description from dual union all select 'Discoverer' value, null description from dual F Type de module US Module Type 3 30 1=1 lower(dhss.module) like '%'||lower(:module)||'%' LOV custom select /*+ no_merge(dhss)*/ distinct dhss.module value, xxen_util.module_name(dhss.module)||nvl2(xxen_util.module_type(dhss.module,dhss.action),' ('||xxen_util.module_type(dhss.module,dhss.action)||')',null) description from ( select distinct dhss.module, dhss.action from dba_hist_sqlstat dhss where trim(dhss.module) is not null and ( :$flex$.module_type is null or xxen_util.module_type(dhss.module,dhss.action)=:$flex$.module_type ) ) dhss order by dhss.module F Le module contient US Module contains 4 40 1=1 dhss.sql_id=:sql_id Char F Id. SQL US SQL Id 5 50 1=1 dhss.plan_hash_value=:plan_hash_value Number F Valeur de hachage du plan US Plan Hash Value 6 60 &show_binds Y LOV custom Y select 'Yes' value, '' description from dual where :$flex$.level like 'SQL%' F Afficher les valeurs de liaison US Show Bind Values 7 &bind_columns x.bind, x.bind_value, x.capture_date, F Afficher les valeurs de liaison US Show Bind Values 8 &bind_order ,x.capture_date desc, x.position F Afficher les valeurs de liaison US Show Bind Values 9 70 1=1 dhss.parsing_schema_name=:schema LOV DBA Username 8E2FF36EDEDA79D2E0530100007F1FF2 Y select du.username value, null description from dba_users du order by du.username F Schéma US Schema 10 80 2=2 gsa.program_id in (select do.object_id from dba_objects do where do.object_name like upper(:package_name)||'%') LOV DBA Package Name 8E2FF36EDEAC79D2E0530100007F1FF2 select ao.object_name value, ao.owner description from all_objects ao where ao.object_type='PACKAGE BODY' and ao.status='VALID' order by ao.object_name F Le nom du paquet commence par US Package Name starts with 11 1=1 dhss.sql_id=gsa0.sql_id F Le nom du paquet commence par US Package Name starts with 12 90 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 13 100 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 14 110 1=1 dhs.begin_interval_time<=(select fcr.actual_completion_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id) and dhs.end_interval_time>=(select fcr.actual_start_date from fnd_concurrent_requests fcr where fcr.request_id=:request_id) Number US Request Id (Time Restriction) 15 120 1=1 to_number(to_char(dhs.begin_interval_time,'HH24'))>=6 and to_number(to_char(dhs.end_interval_time,'HH24'))<=18 and to_char(dhs.begin_interval_time,'DAY','nls_date_language=american') not in ('SATURDAY','SUNDAY') LOV custom Y select 'Daytime hours on working days only' value, 'weekday working hours, Monday to Friday 6:00-18:00 only' description from dual union all select 'Night hours only' value, 'night hours, 18:00-6:00 only' description from dual Daytime hours on working days only F Heures de jour ou de nuit US Daytime or Night hours 16 1=1 ( to_number(to_char(dhs.begin_interval_time,'HH24'))>=0 and to_number(to_char(dhs.end_interval_time,'HH24'))<=6 or to_number(to_char(dhs.begin_interval_time,'HH24'))>=18 ) Night hours only F Heures de jour ou de nuit US Daytime or Night hours 17 130 1=1 trim(to_char(dhs.begin_interval_time,'Day'))=:day_of_week and trim(to_char(dhs.end_interval_time,'Day'))=:day_of_week LOV custom Y select x.day value, null description from ( select to_char(to_date('01.01.2000','dd.mm.yyyy')-level,'d') day_number, trim(to_char(to_date('01.01.2000','dd.mm.yyyy')-level,'Day')) day from dual connect by level<=7 ) x order by x.day_number F Jour de la semaine US Day of Week 18 140 :aggregate_level LOV custom Y select 'Module' value, '' description from dual union all select 'Module per day' value, '' description from dual union all select 'SQL' value, '' description from dual union all select 'SQL per day' value, '' description from dual union all select 'SQL per instance' value, '' description from dual union all select 'SQL per day and instance' value, '' description from dual SQL Y F Niveau US Level 19 &column0 x.inst_num, % instance F Niveau US Level 20 &column1 x.date_, to_char(x.date_,'Day') day_of_week, Module per day F Niveau US Level 21 &column1 x.date_, to_char(x.date_,'Day') day_of_week, SQL per day% F Niveau US Level 22 &column2 x.code, x.code_line#, x.sql_id, x.plan_hash_value, case when x.row_number is null then x.sql_text end sql_text, SQL% F Niveau US Level 23 &column3 x.is_bind_sensitive, x.is_bind_aware, SQL% F Niveau US Level 24 &column4 x.command_type, SQL% F Niveau US Level 25 &partition_by partition by dhss.module Module F Niveau US Level 26 &partition_by partition by dhs.date_, dhss.module Module per day F Niveau US Level 27 &partition_by partition by dhss.sql_id, dhss.plan_hash_value, dhsb.value_string, dhsb.last_captured, dhsb.position SQL F Niveau US Level 28 &partition_by partition by dhs.date_, dhss.sql_id, dhss.plan_hash_value, dhsb.value_string, dhsb.last_captured, dhsb.position SQL per day F Niveau US Level 29 &partition_by partition by dhss.instance_number, dhs.date_, dhss.sql_id, dhss.plan_hash_value, dhsb.value_string, dhsb.last_captured, dhsb.position SQL per day and instance F Niveau US Level 30 &partition_by partition by dhss.instance_number, dhss.sql_id, dhss.plan_hash_value, dhsb.value_string, dhsb.last_captured, dhsb.position SQL per instance F Niveau US Level 31 &partition_by2 partition by x.date_ SQL per day F Niveau US Level 32 &partition_by2 partition by x.inst_num, x.date_ SQL per day and instance F Niveau US Level 33 &partition_by2 partition by x.inst_num SQL per instance F Niveau US Level 34 &show_sql Y SQL% F Niveau US Level 35 150 &order_by select 'x.'||lower(translate(:oder_by_column,' ','_')) from dual LOV DBA SQL Performance Summary Order By 8E2FF36EDF1379D2E0530100007F1FF2 Y select 'Buffer IO' value, '' description from dual union all select 'CPU Time' value, '' description from dual union all select 'Elapsed Time' value, '' description from dual union all select 'Time Exec' value, '' description from dual union all select 'IO Exec' value, '' description from dual union all select 'Executions' value, '' description from dual union all select 'Last Active Time' value, '' description from dual CPU Time Y F Commander par US Order By 36 160 1=1 dhst.command_type not in (47) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select 'Y' from dual where :$flex$.sql_id is null F Exclure le code PLSQL US Exclude PLSQL Code 37 170 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 38 180 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 39 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 :$flex$.level Level Show Bind Values :$flex$.module_type Module Type Module contains :$flex$.sql_id SQL Id Exclude PLSQL Code