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 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 7FF38AE61DF30706E0530100007FE675 with y as ( select /*+ materialize*/ distinct count(*) over (partition by x.instance_number, x.sid_serial#, x.code, x.code_line#, x.sql_id, x.plan_hash_value, x.session_type, x.session_state, x.event, x.wait_class, x.time_model, x.sql_plan_operation, x.sql_plan_options, x.object, x.file_id, x.block_id, x.blocking_inst_id, x.blocking_sid_serial#, x.blocking_client_id, x.blocking_action, x.blocking_module, x.blocking_program, x.blocking_session_type, x.blocking_machine, x.blocking_file_id, x.blocking_block_id, x.machine, x.command_type, x.schema, x.client_id, x.action, x.module, x.program ) seconds, x.instance_number, x.sid_serial#, x.code, x.code_line#, x.sql_id, x.plan_hash_value, x.session_type, x.session_state, x.event, x.wait_class, x.time_model, x.sql_plan_operation, x.sql_plan_options, x.object, x.file_id, x.block_id, x.blocking_inst_id, x.blocking_sid_serial#, x.blocking_client_id, x.blocking_action, x.blocking_module, x.blocking_program, x.blocking_session_type, x.blocking_machine, x.blocking_file_id, x.blocking_block_id, x.machine, x.command_type, x.schema, x.client_id, x.action, x.module, x.program from ( select dhash.sample_time_ sample_time, dhash.instance_number, 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, 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, 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.p1text,'file#',dhash.p1) file_id, decode(dhash.p2text,'block#',dhash.p2) block_id, dhash.blocking_inst_id blocking_inst_id, nvl2(dhash.blocking_session,dhash.blocking_session||' - '||dhash.blocking_session_serial#,null) blocking_sid_serial#, dhash0.client_id blocking_client_id, dhash0.action blocking_action, dhash0.module blocking_module, dhash0.program blocking_program, dhash0.session_type blocking_session_type, dhash0.machine blocking_machine, dhash0.file_id blocking_file_id, dhash0.block_id blocking_block_id, dhash.machine, lower(dhash.sql_opname) command_type, du.username schema, dhash.action, dhash.module, dhash.program 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_snapshot dhs, dba_hist_active_sess_history dhash where 1=1 and dhash.blocking_session is not null and dhs.dbid=dhash.dbid and dhs.snap_id=dhash.snap_id and dhs.instance_number=dhash.instance_number ) dhash, ( 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, dba_users du where 2=2 and dhash.user_id=du.user_id(+) and dhash.blocking_inst_id=dhash0.instance_number(+) and dhash.blocking_session=dhash0.session_id(+) and dhash.blocking_session_serial#=dhash0.session_serial#(+) ) x ) select y.seconds, y.instance_number, y.sid_serial#, xxen_util.user_name(y.module,y.action,y.client_id) user_name, xxen_util.responsibility(y.module,y.action) responsibility, xxen_util.module_type(y.module,y.action) module_type, xxen_util.module_name(y.module,y.program) module_name, y.code, y.code_line#, y.sql_id, y.plan_hash_value, y.session_type, y.session_state, y.event, y.wait_class, y.time_model, y.sql_plan_operation, y.sql_plan_options, y.object, y.file_id, y.block_id, y.blocking_inst_id, y.blocking_sid_serial#, xxen_util.user_name(y.blocking_module,y.blocking_action,y.blocking_client_id) blocking_user_name, xxen_util.responsibility(y.blocking_module,y.blocking_action) blocking_responsibility, xxen_util.module_type(y.blocking_module,y.blocking_action) blocking_module_type, xxen_util.module_name(y.blocking_module,y.blocking_program) blocking_module_name, y.blocking_session_type, y.blocking_machine, y.blocking_file_id, y.blocking_block_id, y.machine, y.command_type, y.schema, y.client_id, y.action, y.module, y.program, y.blocking_client_id, y.blocking_action, y.blocking_module, y.blocking_program from y order by y.seconds desc Y AR DBA AWR Blocking Session Summary ملخص الجلسات المحظورة والمنعشة بناءً على سجل الجلسة النشطة من تقارير العرب والغرب. الارتباط إلى جلسات الحظر غير فريد بشكل متعمد دون الاتصال بـ sample_id لزيادة فرصة جلب المعلومات الإضافية لجلسة الحظر مثل الوحدة النمطية والإجراء و client_id. في بعض الحالات ، مثل سيناريوهات قفل الصف ، تكون جلسة الحظر خاملة ولا تظهر في ASH. نوصي بإجراء مزيد من التحليل باستخدام محور في Excel بدلاً من SQL ، لأن السحب والإفلات في Excel أسرع بكثير من كتابة الأوامر يدويًا. D DBA AWR Blocking Session Summary Zusammenfassung der blockierten und blockierenden Sitzungen basierend auf dem aktiven Sitzungsverlauf aus dem AWR. Die Verknüpfung mit blockierten Sitzungen ist absichtlich nicht eindeutig, ohne Verknüpfung mit sample_id, um die Chance zu erhöhen, die zusätzlichen Informationen der blockierten Sitzung wie Modul, Aktion und client_id abzurufen. In einigen Fällen, z. B. bei Zeilensperrszenarien, ist die blockierende Sitzung inaktiv und wird nicht in der ASH angezeigt. Wir empfehlen, die weitere Analyse mit einem Pivot in Excel statt mit SQL durchzuführen, da das Ziehen und Ablegen in Excel viel schneller ist als die manuelle Eingabe von Befehlen. E DBA AWR Blocking Session Summary Resumen de las sesiones bloqueadas y en bloqueo basado en el historial de sesiones activas del AWR. El enlace a las sesiones bloqueadas es deliberadamente no único sin unión a sample_id para aumentar la posibilidad de obtener la información adicional de la sesión bloqueada, como el módulo, la acción y el client_id. En algunos casos, como los escenarios de bloqueo de filas, la sesión de bloqueo está inactiva y no aparece en el ASH. Recomendamos hacer un análisis más profundo con un pivote en Excel en lugar de hacerlo con SQL, ya que la función de arrastrar y soltar de Excel es mucho más rápida que escribir los comandos manualmente. F DBA AWR Blocking Session Summary Résumé des sessions bloquées et en cours de blocage basé sur l'historique des sessions actives de l'AWR. Le lien vers les sessions bloquées est délibérément non univoque, sans jointure avec sample_id, afin d'augmenter les chances de récupérer les informations supplémentaires de la session bloquée, telles que le module, l'action et le client_id. Dans certains cas, tels que les scénarios de verrouillage des lignes, la session de blocage est inactive et n'apparaît pas dans l'ASH. Nous recommandons de faire une analyse plus poussée avec un pivot dans Excel plutôt que par SQL, car le glisser-déposer d'Excel est beaucoup plus rapide que la saisie manuelle de commandes. I DBA AWR Blocking Session Summary Riepilogo delle sessioni bloccate e bloccanti basato sulla cronologia delle sessioni attive dall'AWR. Il collegamento alle sessioni bloccanti è deliberatamente non univoco senza l'unione a sample_id per aumentare la possibilità di recuperare le informazioni aggiuntive della sessione bloccante come modulo, azione e client_id. In alcuni casi, come gli scenari di blocco delle righe, la sessione bloccante è inattiva e non appare nell'ASH. Raccomandiamo di fare ulteriori analisi con un pivot in Excel piuttosto che con SQL, dato che il drag and drop di Excel è molto più veloce che digitare manualmente i comandi. JA DBA AWR Blocking Session Summary AWRからのアクティブなセッション履歴に基づいて、ブロックされたセッションとブロッキングされたセッションの概要を表示しています。 ブロッキングセッションへのリンクは、モジュール、アクション、client_idなどのブロッキングセッションの追加情報を取得する機会を増やすために、sample_idとジョイントせずに、意図的に一意ではないものにしています。 行ロックのシナリオのように、ブロッキングセッションがアイドル状態でASHに表示されない場合もあります。 Excelのドラッグ＆ドロップはコマンドを手入力するよりもはるかに速いので、SQLではなくExcelのピボットでさらに分析を行うことをお勧めします。 KO DBA AWR Blocking Session Summary AWR의 활성 세션 기록을 기반으로 차단 및 차단 세션 요약. 차단 세션에 대한 링크는 module, action 및 client_id와 같은 차단 세션의 추가 정보를 가져올 가능성을 높이기 위해 sample_id에 결합하지 않고 의도적으로 고유하지 않습니다. 행 잠금 시나리오와 같은 일부 경우 차단 세션이 유휴 상태이며 ASH에 표시되지 않습니다. Excel의 끌어서 놓기가 수동으로 명령을 입력하는 것보다 훨씬 빠르기 때문에 SQL보다는 Excel에서 피벗을 사용하여 추가 분석을 수행하는 것이 좋습니다. PTB DBA AWR Blocking Session Summary Resumo das sessões bloqueadas e bloqueadas com base no histórico ativo das sessões do AWR. O link para as sessões de bloqueio é deliberadamente não único sem se juntar a amostra_id para aumentar a chance de buscar as informações adicionais da sessão de bloqueio, tais como módulo, ação e client_id. Em alguns casos, tais como cenários de bloqueio de linha, a sessão de bloqueio é ociosa e não aparece no ASH. Recomendamos fazer mais análises com um pivô no Excel em vez de por SQL, pois o arrastar e soltar do Excel é muito mais rápido do que digitar comandos manualmente. RU DBA AWR Blocking Session Summary Сводка заблокированных и блокированных сеансов на основе истории активных сеансов из AWR. Ссылка на блокировку сеансов намеренно неуничтожена без объединения с sample_id, чтобы увеличить шанс получить дополнительную информацию о блокировке сеанса, такую как модуль, действие и Client_id. В некоторых случаях, таких как сценарии блокировки строк, блокирующий сеанс простаивает и не отображается в ASH. Мы рекомендуем проводить дальнейший анализ с поворотным пунктом в Excel, а не с помощью SQL, так как перетаскивание Excel намного быстрее, чем ввод команд вручную. S DBA AWR Blocking Session Summary Sammanfattning av blockerade och blockerande sessioner baserat på den aktiva sessionshistoriken från AWR. Länken till blockeringssessioner är medvetet unikt utan att kopplas till sample_id för att öka chansen att hämta blockeringssessionens ytterligare information som modul, åtgärd och client_id. I vissa fall, till exempel radlås-scenarier, är blockeringssessionen inaktiv och visas inte i ASH. Vi rekommenderar att du gör ytterligare analyser med en pivot i Excel snarare än med SQL, eftersom Excels drag-and-drop är mycket snabbare än att skriva kommandon manuellt. TR DBA AWR Blocking Session Summary AWR'den gelen etkin oturum geçmişine dayalı olarak engellenen ve engelleyen oturumların özeti. Engelleme oturumlarına olan bağlantı, modül, eylem ve client_id gibi engelleme oturumunun ek bilgilerini alma şansını artırmak için sample_id ile birleştirilmeden kasıtlı olarak benzersiz değildir. Satır kilitleme senaryoları gibi bazı durumlarda, engelleme oturumu boştur ve ASH'de görünmez. Excel'in sürükle ve bırak özelliği, komutları elle yazmaktan çok daha hızlı olduğu için, SQL yerine Excel'de bir özet ile daha fazla analiz yapmanızı öneririz. US DBA AWR Blocking Session Summary Summary of blocked and blocking sessions based on the active session history from the AWR. The link to blocking sessions is deliberately nonunique without jointing to sample_id to increase the chance to fetch the blocking session's additional information such as module, action and client_id. In some cases, such as row lock scenarios, the blocking session is idle and does not show up in the ASH. We recommend doing further analysis with a pivot in Excel rather than by SQL, as Excel's drag- and drop is a lot faster than typing commands manually. ZHS DBA AWR Blocking Session Summary 根据AWR的活动会话历史记录，总结被阻断和阻断的会话。 封锁会话的链接故意是非唯一的，不与sample_id联合，以增加获取封锁会话的额外信息的机会，如模块、action和client_id。 在某些情况下，比如行锁定的情况下，阻塞会话是空闲的，不会在ASH中显示出来。 我们建议用Excel中的数据透视来做进一步的分析，而不是用SQL来做，因为Excel的拖放比手动输入命令要快很多。 Diagnostic Pack Enginatics 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 1=1 dhs.end_interval_time>=:from_time and 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) ) dhs F Du temps US From Time 5 50 1=1 dhs.begin_interval_time<=:to_time and dhash.sample_time<=:to_time DateTime xxen_util.client_time(sysdate) F Au temps US To Time 6 60 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 v$database vd, dba_hist_snapshot dhs, dba_hist_system_event dhse where dhs.begin_interval_time>sysdate-7 and vd.dbid=dhs.dbid 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 7 70 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# 8 80 1=1 dhash.sql_id=:sql_id Char F Id. SQL US SQL Id 9 90 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 10 100 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 F Type de session US Session Type 11 110 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 12 120 1=1 lower(dhash.action) like '%'||lower(:action)||'%' Char F L'action contient US Action contains 13 130 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 14 140 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 15 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 From Time