ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDEF079D2E0530100007F1FF2 DBA Session Type Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual US 8E2FF36EDEDA79D2E0530100007F1FF2 DBA Username Y select du.username value, null description from dba_users du order by du.username US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A803A608ACE0530100007FEB91 select xxen_util.client_time(x.sample_time) sample_time, x.instance_number inst_id, x.active_sessions, x.active_cpu_sessions, x.active_waiting_sessions, x.sid_serial#, xxen_util.user_name(x.module,x.action,x.client_id) user_name, xxen_util.responsibility(x.module,x.action) responsibility, xxen_util.module_type(x.module,x.action) module_type, xxen_util.module_name(x.module,x.program) module_name, case when lower(x.module) like '%frm%' then 'Forms' when lower(x.module) like '%fwk%' then 'OAF' end ui_type, x.code, x.code_line#, x.sql_id, x.plan_hash_value, &sql_text xxen_util.time(case when x.count_sql_id>1 then 10*x.count_sql_id end) time_per_sql, round(100*x.count_sql_id/x.count,2) percentage, x.execution_count, xxen_util.client_time(x.sql_exec_start) sql_exec_start, x.entry_procedure, x.procedure, xxen_util.time(x.sess_duration) sess_duration, xxen_util.time(x.sess_active*10) sess_active, xxen_util.client_time(x.sess_first_time) sess_first_time, xxen_util.client_time(x.sql_first_time) sql_first_time, x.session_state, x.event, x.wait_class, x.time_model, x.in_parse, x.in_hard_parse, x.qc_instance_id, x.qc_sid_serial#, x.sql_plan_operation, x.sql_plan_options, x.object, x.blocked_status, x.blocking_inst_id, x.blocking_sid_serial#, &blocking_cols2 x.file_id, x.block_id, x.pga_allocated, x.pga_total, x.pga_percentage, x.temp_space_allocated, x.temp_space_total, x.temp_space_percentage, x.active_sessions, x.machine, x.command_type, x.schema, x.action, x.module, x.program, x.p1text, x.p1, x.p2text, x.p2, x.p3text, x.p3 from ( select dhash.sample_time_ sample_time, dhash.instance_number, count(*) over (partition by dhash.sample_id) active_sessions, xxen_util.zero_to_null(count(decode(dhash.session_state,'ON CPU',1)) over (partition by dhash.sample_id)) active_cpu_sessions, xxen_util.zero_to_null(count(decode(dhash.session_state,'WAITING',1)) over (partition by dhash.sample_id)) active_waiting_sessions, dhash.session_id||' - '||dhash.session_serial# sid_serial#, dhash.client_id, xxen_util.instring(dhash.code_and_line,'|',1) code, xxen_util.instring(dhash.code_and_line,'|',2) code_line#, dhash.sql_id, dhash.sql_plan_hash_value plan_hash_value, count(*) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#, dhash.sql_id) count_sql_id, count(*) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#) count, dhst.sql_text, dhash.sql_exec_id-16777216 execution_count, dhash.sql_exec_start, dp0.object_name||case when dp0.procedure_name is not null then '.'||dp0.procedure_name end entry_procedure, dp.object_name||case when dp.procedure_name is not null then '.'||dp.procedure_name end procedure, (max(dhash.sample_time_) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#)-min(dhash.sample_time_) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#))*86400 sess_duration, count(*) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#) sess_active, min(dhash.sample_time_) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#) sess_first_time, min(dhash.sample_time_) over (partition by dhash.instance_number, dhash.session_id, dhash.session_serial#, dhash.sql_id) sql_first_time, dhash.session_type, dhash.session_state, nvl(dhash.event,dhash.session_state)|| case when dhash.event like 'enq%' and dhash.session_state='WAITING' then ' (mode='||bitand(dhash.p1,power(2,14)-1)||')' when dhash.event in ('buffer busy waits','gc buffer busy','gc buffer busy acquire','gc buffer busy release') then ' ('|| coalesce( (select vw.class from (select vw.class, rownum row_num from v$waitstat vw) vw where dhash.p3=vw.row_num), (select decode(mod(bitand(dhash.p3,to_number('FFFF','XXXX'))-17,2),0,'undo header',1,'undo data','error') from dual) )||')' end event, dhash.wait_class, rtrim( case when bitand(dhash.time_model,power(2,01))=power(2,01) then 'DBTIME ' end|| case when bitand(dhash.time_model,power(2,02))=power(2,02) then 'BACKGROUND ' end|| case when bitand(dhash.time_model,power(2,03))=power(2,03) then 'CONNECTION_MGMT ' end|| case when bitand(dhash.time_model,power(2,04))=power(2,04) then 'PARSE ' end|| case when bitand(dhash.time_model,power(2,05))=power(2,05) then 'FAILED_PARSE ' end|| case when bitand(dhash.time_model,power(2,06))=power(2,06) then 'NOMEM_PARSE ' end|| case when bitand(dhash.time_model,power(2,07))=power(2,07) then 'HARD_PARSE ' end|| case when bitand(dhash.time_model,power(2,08))=power(2,08) then 'NO_SHARERS_PARSE ' end|| case when bitand(dhash.time_model,power(2,09))=power(2,09) then 'BIND_MISMATCH_PARSE ' end|| case when bitand(dhash.time_model,power(2,10))=power(2,10) then 'SQL_EXECUTION ' end|| case when bitand(dhash.time_model,power(2,11))=power(2,11) then 'PLSQL_EXECUTION ' end|| case when bitand(dhash.time_model,power(2,12))=power(2,12) then 'PLSQL_RPC ' end|| case when bitand(dhash.time_model,power(2,13))=power(2,13) then 'PLSQL_COMPILATION ' end|| case when bitand(dhash.time_model,power(2,14))=power(2,14) then 'JAVA_EXECUTION ' end|| case when bitand(dhash.time_model,power(2,15))=power(2,15) then 'BIND ' end|| case when bitand(dhash.time_model,power(2,16))=power(2,16) then 'CURSOR_CLOSE ' end|| case when bitand(dhash.time_model,power(2,17))=power(2,17) then 'SEQUENCE_LOAD ' end|| case when bitand(dhash.time_model,power(2,18))=power(2,18) then 'INMEMORY_QUERY ' end|| case when bitand(dhash.time_model,power(2,19))=power(2,19) then 'INMEMORY_POPULATE ' end|| case when bitand(dhash.time_model,power(2,20))=power(2,20) then 'INMEMORY_PREPOPULATE ' end|| case when bitand(dhash.time_model,power(2,21))=power(2,21) then 'INMEMORY_REPOPULATE ' end|| case when bitand(dhash.time_model,power(2,22))=power(2,22) then 'INMEMORY_TREPOPULATE ' end|| case when bitand(dhash.time_model,power(2,23))=power(2,23) then 'TABLESPACE_ENCRYPTION ' end ) time_model, xxen_util.yes(dhash.in_parse) in_parse, xxen_util.yes(dhash.in_hard_parse) in_hard_parse, dhash.qc_instance_id, dhash.qc_session_id||nvl2(dhash.qc_session_serial#,' - '||dhash.qc_session_serial#,null) qc_sid_serial#, dhash.sql_plan_operation, dhash.sql_plan_options, (select do.owner||'.'||do.object_name||' ('||do.object_type||')' from dba_objects do where dhash.current_obj#=do.object_id) object, decode(dhash.blocking_session_status,'VALID','blocked') blocked_status, dhash.blocking_inst_id blocking_inst_id, nvl2(dhash.blocking_session,dhash.blocking_session||' - '||dhash.blocking_session_serial#,null) blocking_sid_serial#, &blocking_columns decode(dhash.p1text,'file#',dhash.p1) file_id, decode(dhash.p2text,'block#',dhash.p2) block_id, dhash.pga_allocated/1000000 pga_allocated, sum(dhash.pga_allocated) over (partition by dhash.sample_id)/1000000 pga_total, dhash.pga_allocated/xxen_util.zero_to_null(sum(dhash.pga_allocated) over (partition by dhash.sample_id))*100 pga_percentage, dhash.temp_space_allocated/1000000 temp_space_allocated, sum(dhash.temp_space_allocated) over (partition by dhash.sample_id)/1000000 temp_space_total, dhash.temp_space_allocated/xxen_util.zero_to_null(sum(dhash.temp_space_allocated) over (partition by dhash.sample_id))*100 temp_space_percentage, dhash.machine, lower(dhash.sql_opname) command_type, du.username schema, dhash.action, dhash.module, dhash.program, dhash.p1text, dhash.p1, dhash.p2text, dhash.p2, dhash.p3text, dhash.p3 from ( select (select so.name||'|'||case when gsa.program_line#>0 then gsa.program_line# end from gv$sqlarea gsa, sys.obj$ so where dhash.sql_id=gsa.sql_id and gsa.program_id=so.obj#(+) and rownum=1) code_and_line, cast(dhash.sample_time as date) sample_time_, dhash.* from dba_hist_active_sess_history dhash where 1=1 ) dhash &dynamic_tables left join dba_hist_sqltext dhst on dhash.dbid=dhst.dbid and dhash.sql_id=dhst.sql_id left join dba_procedures dp0 on dhash.plsql_entry_object_id=dp0.object_id and dhash.plsql_entry_subprogram_id=dp0.subprogram_id left join dba_procedures dp on dhash.plsql_object_id=dp.object_id and dhash.plsql_subprogram_id=dp.subprogram_id left join dba_users du on dhash.user_id=du.user_id where 2=2 ) x order by sample_time, sess_first_time desc, percentage desc, sql_first_time desc Y AR DBA AWR Active Session History محفوظات الجلسة النشطة من مخزن حمل العمل التلقائي D DBA AWR Active Session History Aktiver Sitzungsverlauf aus dem automatischen Arbeitslast-Repository E DBA AWR Active Session History Historial de sesiones activas del repositorio automático de cargas de trabajo F DBA AWR Active Session History Historique des sessions actives à partir du dépôt automatique de la charge de travail I DBA AWR Active Session History Cronologia delle sessioni attive dal repository automatico del carico di lavoro JA DBA AWR Active Session History 自動ワークロードリポジトリからのアクティブなセッション履歴 KO DBA AWR Active Session History 자동 워크로드 저장소의 활성 세션 기록 PTB DBA AWR Active Session History Histórico ativo da sessão a partir do repositório automático de carga de trabalho RU DBA AWR Active Session History История активного сеанса из репозитория автоматической загрузки S DBA AWR Active Session History Aktiv sessionshistorik från den automatiska arbetsbelastningsförvaret TR DBA AWR Active Session History Otomatik iş yükü havuzundan aktif oturum geçmişi US DBA AWR Active Session History Active session history from the automatic workload repository ZHS DBA AWR Active Session History 自动工作负载存储库中的活动会话记录 Diagnostic Pack Enginatics &blocking_cols2 &blocking_columns &dynamic_tables &sql_text 1=1 2=2 1 10 1=1 dhash.client_id=:user_name LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Nom de l'utilisateur US User Name 2 20 1=1 xxen_util.module_type(dhash.module,dhash.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(dhash.module) like '%'||lower(:module)||'%' Char F Le module contient US Module contains 4 40 &dynamic_tables left join ( select distinct dhash.instance_number, dhash.session_id, dhash.session_serial#, max(dhash.client_id) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) client_id, max(dhash.action) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) action, max(dhash.module) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) module, max(dhash.program) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) program, max(dhash.session_type) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) session_type, max(dhash.machine) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) machine, max(decode(dhash.p1text,'file#',dhash.p1)) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) file_id, max(decode(dhash.p2text,'block#',dhash.p2)) keep (dense_rank last order by dhash.sample_id) over (partition by dhash.instance_number,dhash.session_id,dhash.session_serial#) block_id from dba_hist_active_sess_history dhash ) dhash0 on dhash.blocking_inst_id=dhash0.instance_number and dhash.blocking_session=dhash0.session_id and dhash.blocking_session_serial#=dhash0.session_serial# LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual :$flex$.blocked_sessions_only F Afficher les informations sur la session de blocage US Show Blocking Session Info 5 &blocking_cols2 x.blocking_user_name, x.blocking_responsibility, x.blocking_module_type, x.blocking_module_name, x.blocking_session_type, x.blocking_machine, x.blocking_file_id, x.blocking_block_id, F Afficher les informations sur la session de blocage US Show Blocking Session Info 6 &blocking_columns xxen_util.user_name(dhash0.module,dhash0.action,dhash0.client_id) blocking_user_name, xxen_util.responsibility(dhash0.module,dhash0.action) blocking_responsibility, xxen_util.module_type(dhash0.module,dhash0.action) blocking_module_type, xxen_util.module_name(dhash0.module,dhash0.program) blocking_module_name, dhash0.session_type blocking_session_type, dhash0.machine blocking_machine, dhash0.file_id blocking_file_id, dhash0.block_id blocking_block_id, F Afficher les informations sur la session de blocage US Show Blocking Session Info 7 50 1=1 dhash.blocking_session is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Sessions bloquées uniquement US Blocked Sessions only 8 60 &dynamic_tables join (select fcr.actual_start_date, fcr.actual_completion_date, fu.user_name from fnd_concurrent_requests fcr, fnd_user fu where fcr.request_id=:request_id and fcr.requested_by=fu.user_id) fcr on dhash.sample_time between fcr.actual_start_date and nvl(fcr.actual_completion_date,dhash.sample_time) and dhash.client_id=fcr.user_name Number F Id de la demande US Request Id 9 70 1=1 dhash.sample_time>=:from_time DateTime 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.dbid=(select case when :$flex$.container_data in ('All','N/A') then vd.dbid else vd.con_dbid end dbid from v$database vd) and :$flex$.request_id is null and :$flex$.sid_serial is null ) dhs F Du temps US From Time 10 80 1=1 dhash.sample_time<:to_time+1/86400 DateTime select xxen_util.client_time(sysdate) from dual where :$flex$.request_id is null and :$flex$.sid_serial is null F Au temps US To Time 11 90 1=1 dhash.sql_id in (select gsa.sql_id from gv$sqlarea gsa where gsa.program_id in (select do.object_id from dba_objects do where upper(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 Code Name starts with 12 95 1=1 (dhash.plsql_entry_object_id, dhash.plsql_entry_subprogram_id) in (select dp.object_id, dp.subprogram_id from dba_procedures dp where upper(dp.object_name||case when dp.procedure_name is not null then '.'||dp.procedure_name end) like '%'||upper(:entry_procedure_contains)||'%') Char F La procédure d'entrée contient US Entry Procedure contains 13 100 1=1 dhash.event=:event_name LOV custom Y select x.event_name value, x.time_waited||' '||x.wait_class description from ( select distinct dhse.event_name, dhse.wait_class, round(sum(dhse.time_waited_micro_fg) over (partition by dhse.event_name, dhse.wait_class)/1000000) time_waited from dba_hist_snapshot dhs, dba_hist_system_event dhse where dhs.dbid=(select vd.dbid from v$database vd) and dhs.begin_interval_time>sysdate-7 and dhs.dbid=dhse.dbid and dhs.instance_number=dhse.instance_number and dhs.snap_id=dhse.snap_id and dhse.wait_class<>'Idle' ) x order by x.time_waited desc F Événement d'attente US Wait Event 14 110 1=1 nvl(dhash.event,'x')<>:exclude_event_name LOV custom Y select x.event value, x.time_waited||' '||x.wait_class description from ( select distinct gse.event, gse.wait_class, round(sum(gse.time_waited_micro_fg) over (partition by gse.event, gse.wait_class)/1000000) time_waited from gv$system_event gse where gse.wait_class<>'Idle' ) x order by x.time_waited desc virtual circuit wait US Exclude Wait Event 15 120 1=1 dhash.session_id=substr(:sid_serial,1,instr(:sid_serial,' - ')-1) and dhash.session_serial#=substr(:sid_serial,instr(:sid_serial,' - ')+3) Char US SID - Serial# 16 130 1=1 dhash.sql_id=:sql_id Char F Id. SQL US SQL Id 17 140 1=1 dhash.sql_plan_hash_value=:plan_hash_value Number F Valeur de hachage du plan US Plan Hash Value 18 150 &sql_text x.sql_text, LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher le texte SQL Pour faire pivoter des fichiers volumineux dans Excel, désactivez le texte SQL pour éviter les erreurs de mémoire US Show SQL Text For pivoting large files in Excel, switch off the SQL Text to avoid out of memory errors 19 160 1=1 (dhash.module like '%:frm:%' or dhash.module like 'frmweb@%' or dhash.module like '%:fwk:%') LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Sessions UI uniquement US UI Sessions only 20 170 1=1 dhash.machine=:machine Char US Machine 21 180 1=1 dhash.session_type=upper(:session_type) LOV DBA Session Type 8E2FF36EDEF079D2E0530100007F1FF2 Y select 'Foreground' value, 'User sessions only' description from dual union all select 'Background' value, 'DB internal processes only' description from dual Foreground US Session Type 22 190 2=2 du.username=: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 23 200 1=1 lower(dhash.action) like '%'||lower(:action)||'%' Char F L'action contient US Action contains 24 220 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 25 230 1=1 dhash.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 26 1=1 dhash.dbid=(select vd.con_dbid from v$database vd) Current PDB F Données sur les conteneurs US Container Data :$flex$.blocked_sessions_only Blocked Sessions only Show Blocking Session Info :$flex$.container_data Container Data From Time :$flex$.request_id Request Id From Time :$flex$.request_id Request Id To Time :$flex$.sid_serial SID - Serial# From Time :$flex$.sid_serial SID - Serial# To Time