ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDF1279D2E0530100007F1FF2 DBA Instance Id Y select gi.inst_id value, gi.instance_name||' '||gi.host_name||' '||gi.startup_time description from gv$instance gi 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 8E2FF36EDF1779D2E0530100007F1FF2 DBA SGA Module (gash) Y select x.value, sum(x.count)||' '||x.description description from ( select /*+ no_merge(gash)*/ gash.count, gash.module value, xxen_util.module_name(gash.module,gash.program)||nvl2(xxen_util.module_type(gash.module,gash.action),' ('||xxen_util.module_type(gash.module,gash.action)||')',null) description from ( select count(*) count, gash.module, gash.program, gash.action from gv$active_session_history gash where nvl(gash.event,'x')<>coalesce(:$flex$.exclude_wait_event,'z') and trim(gash.module) is not null and (:$flex$.from_time is null or gash.sample_time>=:$flex$.from_time) and (:$flex$.to_time is null or gash.sample_time<=:$flex$.to_time) and (:$flex$.module_type is null or xxen_util.module_type(gash.module,gash.action)=:$flex$.module_type) group by gash.module, gash.program, gash.action ) gash ) x group by x.value, x.description order by sum(x.count) desc, x.value US E86C31428B563088E0530100007F53D7 DBA SGA User Name (gash) Y Y select gash.client_id value, gash.count||' '||xxen_util.user_name(gash.client_id) description from ( select distinct count(*) over (partition by gash.client_id) count, gash.client_id from gv$active_session_history gash where :$flex$.request_id is null and (:$flex$.from_time is null or gash.sample_time>=:$flex$.from_time) and (:$flex$.to_time is null or gash.sample_time<=:$flex$.to_time) and gash.session_type='FOREGROUND' and gash.client_id is not null ) gash where gash.client_id in (select fu.user_name from fnd_user fu) order by gash.count desc, gash.client_id US All FND user names, which are stored in the client_ids of the active session history 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 7FE6BEFE22534B72E0530100007FF27C with y as ( select /*+ materialize*/ distinct count(*) over (partition by x.inst_id, x.sid_serial#, x.ui_type, 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.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.machine, x.command_type, x.schema, x.client_id, x.action, x.module, x.program ) seconds, x.inst_id, x.sid_serial#, x.ui_type, 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.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.machine, x.command_type, x.schema, x.client_id, x.action, x.module, x.program from ( select gash.sample_time_, gash.inst_id, gash.session_id||' - '||gash.session_serial# sid_serial#, case when lower(gash.module) like '%frm%' then 'Forms' when lower(gash.module) like '%fwk%' then 'OAF' end ui_type, xxen_util.instring(gash.code_and_line,'|',1) code, xxen_util.instring(gash.code_and_line,'|',2) code_line#, gash.sql_id, gash.sql_plan_hash_value plan_hash_value, gash.session_type, gash.session_state, nvl(gash.event,gash.session_state)|| case when gash.event like 'enq%' and gash.session_state='WAITING' then ' (mode='||bitand(gash.p1,power(2,14)-1)||')' when gash.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 gash.p3=vw.row_num), (select decode(mod(bitand(gash.p3,to_number('FFFF','XXXX'))-17,2),0,'undo header',1,'undo data','error') from dual) )||')' end event, gash.wait_class, rtrim( case when bitand(gash.time_model,power(2,01))=power(2,01) then 'DBTIME ' end|| case when bitand(gash.time_model,power(2,02))=power(2,02) then 'BACKGROUND ' end|| case when bitand(gash.time_model,power(2,03))=power(2,03) then 'CONNECTION_MGMT ' end|| case when bitand(gash.time_model,power(2,04))=power(2,04) then 'PARSE ' end|| case when bitand(gash.time_model,power(2,05))=power(2,05) then 'FAILED_PARSE ' end|| case when bitand(gash.time_model,power(2,06))=power(2,06) then 'NOMEM_PARSE ' end|| case when bitand(gash.time_model,power(2,07))=power(2,07) then 'HARD_PARSE ' end|| case when bitand(gash.time_model,power(2,08))=power(2,08) then 'NO_SHARERS_PARSE ' end|| case when bitand(gash.time_model,power(2,09))=power(2,09) then 'BIND_MISMATCH_PARSE ' end|| case when bitand(gash.time_model,power(2,10))=power(2,10) then 'SQL_EXECUTION ' end|| case when bitand(gash.time_model,power(2,11))=power(2,11) then 'PLSQL_EXECUTION ' end|| case when bitand(gash.time_model,power(2,12))=power(2,12) then 'PLSQL_RPC ' end|| case when bitand(gash.time_model,power(2,13))=power(2,13) then 'PLSQL_COMPILATION ' end|| case when bitand(gash.time_model,power(2,14))=power(2,14) then 'JAVA_EXECUTION ' end|| case when bitand(gash.time_model,power(2,15))=power(2,15) then 'BIND ' end|| case when bitand(gash.time_model,power(2,16))=power(2,16) then 'CURSOR_CLOSE ' end|| case when bitand(gash.time_model,power(2,17))=power(2,17) then 'SEQUENCE_LOAD ' end|| case when bitand(gash.time_model,power(2,18))=power(2,18) then 'INMEMORY_QUERY ' end|| case when bitand(gash.time_model,power(2,19))=power(2,19) then 'INMEMORY_POPULATE ' end|| case when bitand(gash.time_model,power(2,20))=power(2,20) then 'INMEMORY_PREPOPULATE ' end|| case when bitand(gash.time_model,power(2,21))=power(2,21) then 'INMEMORY_REPOPULATE ' end|| case when bitand(gash.time_model,power(2,22))=power(2,22) then 'INMEMORY_TREPOPULATE ' end|| case when bitand(gash.time_model,power(2,23))=power(2,23) then 'TABLESPACE_ENCRYPTION ' end ) time_model, gash.sql_plan_operation, gash.sql_plan_options, (select do.owner||'.'||do.object_name||' ('||do.object_type||')' from dba_objects do where gash.current_obj#=do.object_id) object, gash.blocking_inst_id, nvl2(gash.blocking_session,gash.blocking_session||' - '||gash.blocking_session_serial#,null) blocking_sid_serial#, gash0.client_id blocking_client_id, gash0.action blocking_action, gash0.module blocking_module, gash0.program blocking_program, gash0.session_type blocking_session_type, gash0.machine blocking_machine, gash.machine, lower(gash.sql_opname) command_type, du.username schema, gash.client_id, gash.action, gash.module, gash.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 gash.sql_id=gsa.sql_id and gsa.program_id=so.obj#(+) and rownum=1) code_and_line, cast(gash.sample_time as date) sample_time_, gash.* from gv$active_session_history gash where 1=1 ) gash, ( select distinct gash.inst_id, gash.session_id, gash.session_serial#, max(gash.client_id) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) client_id, max(gash.action) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) action, max(gash.module) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) module, max(gash.program) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) program, max(gash.session_type) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) session_type, max(gash.machine) keep (dense_rank last order by gash.sample_id) over (partition by gash.inst_id,gash.session_id,gash.session_serial#) machine from gv$active_session_history gash ) gash0, dba_users du where 2=2 and gash.blocking_session is not null and gash.user_id=du.user_id(+) and gash.blocking_inst_id=gash0.inst_id(+) and gash.blocking_session=gash0.session_id(+) and gash.blocking_session_serial#=gash0.session_serial#(+) ) x ) select y.seconds, y.inst_id, 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.ui_type, 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.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.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 SGA Blocking Session Summary ملخص الجلسات المحظورة والمنعشة بناءً على سجل الجلسة النشطة من SGA. الارتباط إلى جلسات الحظر غير فريد بشكل متعمد دون الاتصال بـ sample_id لزيادة فرصة جلب المعلومات الإضافية لجلسة الحظر مثل الوحدة النمطية والإجراء و client_id. في بعض الحالات ، مثل سيناريوهات قفل الصف ، تكون جلسة الحظر خاملة ولا تظهر في ASH. نوصي بإجراء مزيد من التحليل باستخدام محور في Excel بدلاً من SQL ، لأن السحب والإفلات في Excel أسرع بكثير من كتابة الأوامر يدويًا. D DBA SGA Blocking Session Summary Zusammenfassung der blockierten und blockierenden Sitzungen basierend auf dem aktiven Sitzungsverlauf aus der SGA. Die Verknüpfung zu 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 im Leerlauf 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 SGA Blocking Session Summary Resumen de las sesiones bloqueadas y en bloqueo basado en el historial de sesiones activas del SGA. 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 SGA Blocking Session Summary Résumé des sessions bloquées et bloquantes basé sur l'historique des sessions actives de la SGA. 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 SGA Blocking Session Summary Riepilogo delle sessioni bloccate e bloccanti basato sulla cronologia delle sessioni attive dall'SGA. 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, poiché il drag and drop di Excel è molto più veloce che digitare manualmente i comandi. JA DBA SGA Blocking Session Summary SGAからのアクティブなセッション履歴に基づいて、ブロックされたセッションとブロッキングされたセッションのまとめです。 ブロッキングセッションへのリンクは、モジュール、アクション、client_idなどのブロッキングセッションの追加情報を取得する機会を増やすために、sample_idとジョイントせずに意図的に一意ではないものにしています。 行ロックのシナリオのように、ブロッキングセッションがアイドル状態でASHに表示されない場合もあります。 Excelのドラッグ＆ドロップはコマンドを手入力するよりもはるかに速いので、SQLではなくExcelのピボットでさらに分析を行うことをお勧めします。 KO DBA SGA Blocking Session Summary SGA의 활성 세션 기록을 기반으로 차단 및 차단 세션 요약. 차단 세션에 대한 링크는 module, action 및 client_id와 같은 차단 세션의 추가 정보를 가져올 가능성을 높이기 위해 sample_id에 결합하지 않고 의도적으로 고유하지 않습니다. 행 잠금 시나리오와 같은 일부 경우 차단 세션이 유휴 상태이며 ASH에 표시되지 않습니다. Excel의 끌어서 놓기가 수동으로 명령을 입력하는 것보다 훨씬 빠르기 때문에 SQL보다는 Excel에서 피벗을 사용하여 추가 분석을 수행하는 것이 좋습니다. PTB DBA SGA Blocking Session Summary Resumo das sessões bloqueadas e bloqueadas com base no histórico ativo das sessões da SGA. 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 SGA Blocking Session Summary Сводка заблокированных и блокированных сеансов на основе истории активных сеансов от SGA. Ссылка на блокировку сеансов намеренно неуничтожена без объединения с sample_id, чтобы увеличить шанс получить дополнительную информацию о блокирующей сессии, такую как модуль, действие и Client_id. В некоторых случаях, таких как сценарии блокировки строк, блокирующий сеанс простаивает и не отображается в ASH. Мы рекомендуем проводить дальнейший анализ с поворотным пунктом в Excel, а не с помощью SQL, так как перетаскивание Excel намного быстрее, чем ввод команд вручную. S DBA SGA Blocking Session Summary Sammanfattning av blockerade och blockerande sessioner baserat på den aktiva sessionshistoriken från SGA. 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 SGA Blocking Session Summary SGA'dan gelen aktif 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 SGA Blocking Session Summary Summary of blocked and blocking sessions based on the active session history from the SGA. 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 SGA Blocking Session Summary 根据SGA的活动会话历史记录，总结被阻塞和阻塞的会话。 封锁会话的链接故意是非唯一的，没有与sample_id联合，以增加获取封锁会话额外信息的机会，如模块、action和client_id。 在某些情况下，比如行锁定的情况下，阻塞会话是空闲的，不会在ASH中显示出来。 我们建议用Excel中的数据透视来做进一步的分析，而不是用SQL来做，因为Excel的拖放比手动输入命令要快很多。 Diagnostic Pack Enginatics 1=1 2=2 1 10 1=1 gash.client_id like upper(:user_name) LOV DBA SGA User Name (gash) E86C31428B563088E0530100007F53D7 Y Y select gash.client_id value, gash.count||' '||xxen_util.user_name(gash.client_id) description from ( select distinct count(*) over (partition by gash.client_id) count, gash.client_id from gv$active_session_history gash where :$flex$.request_id is null and (:$flex$.from_time is null or gash.sample_time>=:$flex$.from_time) and (:$flex$.to_time is null or gash.sample_time<=:$flex$.to_time) and gash.session_type='FOREGROUND' and gash.client_id is not null ) gash where gash.client_id in (select fu.user_name from fnd_user fu) order by gash.count desc, gash.client_id F Nom de l'utilisateur US User Name 2 20 1=1 xxen_util.module_type(gash.module,gash.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(gash.module) like '%'||lower(:module)||'%' LOV DBA SGA Module (gash) 8E2FF36EDF1779D2E0530100007F1FF2 Y select x.value, sum(x.count)||' '||x.description description from ( select /*+ no_merge(gash)*/ gash.count, gash.module value, xxen_util.module_name(gash.module,gash.program)||nvl2(xxen_util.module_type(gash.module,gash.action),' ('||xxen_util.module_type(gash.module,gash.action)||')',null) description from ( select count(*) count, gash.module, gash.program, gash.action from gv$active_session_history gash where nvl(gash.event,'x')<>coalesce(:$flex$.exclude_wait_event,'z') and trim(gash.module) is not null and (:$flex$.from_time is null or gash.sample_time>=:$flex$.from_time) and (:$flex$.to_time is null or gash.sample_time<=:$flex$.to_time) and (:$flex$.module_type is null or xxen_util.module_type(gash.module,gash.action)=:$flex$.module_type) group by gash.module, gash.program, gash.action ) gash ) x group by x.value, x.description order by sum(x.count) desc, x.value F Le module contient US Module contains 4 40 1=1 gash.sample_time>=:from_time DateTime select xxen_util.client_time(gash.sample_time) from ( select min(gash.sample_time) sample_time from gv$active_session_history gash where gash.session_type='FOREGROUND' ) gash F Du temps US From Time 5 50 1=1 gash.sample_time<:to_time+1/86400 DateTime xxen_util.client_time(sysdate) F Au temps US To Time 6 60 1=1 gash.event=: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 F Événement d'attente US Wait Event 7 70 1=1 gash.session_id=substr(:sid_serial,1,instr(:sid_serial,' - ')-1) and gash.session_serial#=substr(:sid_serial,instr(:sid_serial,' - ')+3) LOV custom select x.session_id||' - '||x.session_serial# value, x.count||': '|| case when x.client_id is not null then x.client_id||': ' end||x.module||': '|| x.min_sample_time||' - '|| x.max_sample_time description from ( select distinct gash.session_id, gash.session_serial#, count(*) over (partition by gash.session_id, gash.session_serial#) count, gash.client_id, max(gash.module) over (partition by gash.session_id, gash.session_serial#) module, min(cast(gash.sample_time as date)) over (partition by gash.session_id, gash.session_serial#) min_sample_time, max(cast(gash.sample_time as date)) over (partition by gash.session_id, gash.session_serial#) max_sample_time from gv$active_session_history gash where gash.session_type='FOREGROUND' ) x order by x.count desc US SID - Serial# 8 80 1=1 gash.sql_id=:sql_id Char F Id. SQL US SQL Id 9 90 1=1 (gash.module like '%:frm:%' or gash.module like 'frmweb@%' or gash.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 gash.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 1=1 gash.inst_id=:inst_id LOV DBA Instance Id 8E2FF36EDF1279D2E0530100007F1FF2 Y select gi.inst_id value, gi.instance_name||' '||gi.host_name||' '||gi.startup_time description from gv$instance gi F Id de l'instance US Instance Id 12 120 1=1 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 13 130 1=1 lower(gash.action) like '%'||lower(:action)||'%' Char F L'action contient US Action contains 14 140 1=1 gash.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 do.object_name like '%'||upper(:package_name)||'%')) Char F Le programme contient US Program contains 15 150 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 :$flex$.from_time From Time Y Module contains :$flex$.from_time From Time Y User Name :$flex$.module_type Module Type Module contains :$flex$.to_time To Time Y Module contains :$flex$.to_time To Time Y User Name Pivot blocked and blocking modules with wait event ENGINATICS 33 ACTION 37 BLOCKING_ACTION 36 BLOCKING_CLIENT_ID 21 BLOCKING_INST_ID 28 BLOCKING_MACHINE 38 BLOCKING_MODULE 26 BLOCKING_MODULE_NAME 25 BLOCKING_MODULE_TYPE 39 BLOCKING_PROGRAM 24 BLOCKING_RESPONSIBILITY 27 BLOCKING_SESSION_TYPE 22 BLOCKING_SID_SERIAL# 23 BLOCKING_USER_NAME 32 CLIENT_ID 9 CODE 10 CODE_LINE# 30 COMMAND_TYPE 15 EVENT 2 INST_ID 29 MACHINE 34 MODULE 7 MODULE_NAME 6 MODULE_TYPE 20 OBJECT 12 PLAN_HASH_VALUE 35 PROGRAM 5 RESPONSIBILITY 31 SCHEMA 1 SECONDS 14 SESSION_STATE 13 SESSION_TYPE 3 SID_SERIAL# 11 SQL_ID 18 SQL_PLAN_OPERATION 19 SQL_PLAN_OPTIONS 17 TIME_MODEL 8 UI_TYPE 4 USER_NAME 16 WAIT_CLASS DBA SGA Blocking Session Summary - Pivot blocked and blocking modules with wait event.xlsx US UEsDBBQAAAAIAJZ5qFyQ7xzWmgEAAG0HAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbM2V30/CMBDH3038H5a+mq2AiTGGwQPqoxLFP6CsB2vY2qZXEP57bx34g0yQgNGXtVt79/20d7vr9pdlES3AoTI6Ze2kxSLQmZFKT1P2MrqPr1mEXmgpCqMhZStA1u+dn3VHKwsYkbXGlOXe2xvOMcuhFJgYC5pWJsaVwtOrm3IrspmYAu+0Wlc8M9qD9rGvfLBe9xYmYl746G5Jn2sSBwWyaFBvrLRSJqwtVCY8rfOFllsq8VohIcuwB3Nl8YIwGG9UqFa+F1jbPdLVOCUhGgrnH0RJGHxZ8FfjZmNjZsluJw2UZjJRGUiTzUs6WILWgZCYA/iySMKYlELpDfcO/bAZeRjaJwapzhccH8jR+Sccl3/EYdXC+IGg34B/TCm7lVZVSp46TE0aeyLWSPgEmXESfw9vLbCHzVP1AB6ex6MEN3sE0a8KwBPnSu10n3IuHMhn76jOnhzgs++fpMNIjIm4ztgwP/72v9a1D8+7cKgoDp2xSO3BweFB2dT/yjq25AicV7sD8a5IreVwwa1SDlXzkiAbtHlolr03UEsDBBQAAAAIAJZ5qFy1VTAj7gAAAEwCAAALAAAAX3JlbHMvLnJlbHONks9OwzAMxu9IvEPk++puSAihpbtMSLshVB7AJO4ftY2jJED39oQDgkpj29H2588/W97u5mlUHxxiL07DuihBsTNie9dqeK2fVg+gYiJnaRTHGo4cYVfd3mxfeKSUm2LX+6iyi4saupT8I2I0HU8UC/HscqWRMFHKYWjRkxmoZdyU5T2Gvx5QLTzVwWoIB3sHqj76PPmytzRNb3gv5n1il06MQJ4TO8t25UNmC6nP26iaQstJgxXznNMRyfsiYwOeJtpcT/T/tjhxIkuJ0Ejg8zzfinNA6+uBLp9oqfi9zjzip4ThTWT4YcHFD1RfUEsDBBQAAAAIAJZ5qFzeUZAyrwEAAH8DAAAQAAAAZG9jUHJvcHMvYXBwLnhtbJ2TO2/bMBCA9wL5D4T2mErcFoVBMXDitBla1ICUdGaok0WYIgXyLNj99T3JsCwnmbrdm989KO72jWUdhGi8y5KbWZowcNqXxm2y5Ln4fv0tYRGVK5X1DrLkADG5k1efxDr4FgIaiIxKuJglNWK74DzqGhoVZ+R25Kl8aBSSGjbcV5XRsPJ614BDfpumXznsEVwJ5XU7FkyOFRcd/m/R0uueL74Uh5aApSg8KluYBmQq+FkRy7a1Riuk7uUvo4OPvkL2uNdgBZ86BVHnoHfB4KGvMVVFrpWFB3pQVspGEPxsEE+g+mGulQlRig4XHWj0gUXzl8Z5m7BXFaHHzJJOBaMcEm4fdlQG2bYRg/zjwzbWABgFH42DOI2dyuaznA8BJFwGDlkDCDkuEQuDFuLvaq0CfkA8nxIPYEfeI+PqfsnyH0t2b73eUtssh9ifFst3TaPCFHzMGWKhZHRk7PWU1/hyRxgfJhCZagDpaN8N4tTSmyZ+GreNz23hVwrhtKRLo8hrFaCkvY5LHA3iifYTbF/koVZuA+Up5r2jP6mX43+SN19m6Tyla5nYBD//HPkPUEsDBBQAAAAIAJZ5qFyPibi7NAEAAFECAAARAAAAZG9jUHJvcHMvY29yZS54bWyNkl9LwzAUxd8Fv0PJe5um001C24HKnhwIThTfQnK3BZs/JNFu39603boN9uDjvefcX869pJzvVJP8gvPS6AqRLEcJaG6E1JsKva8W6QNKfGBasMZoqNAePJrXtzclt5QbB6/OWHBBgk8iSXvKbYW2IViKsedbUMxn0aGjuDZOsRBLt8GW8W+2AVzk+RQrCEywwHAHTO1IRAek4CPS/rimBwiOoQEFOnhMMoJP3gBO+asDvXLmVDLsbdzpEPecLfggju6dl6OxbdusnfQxYn6CP5cvb/2qqdTdrTiguhSccgcsGFeXMe2piIdrmA/LeOO1BPG4j/qVnuB93GEORBID0CHuUfmYPD2vFqgu8oKkhKTFbEXu6d2EktlX9+TFfBdoaKjDw/8nTinJz4hHwJD78hPUf1BLAwQUAAAACACWeahcTUHW0hoBAAB7BAAAGgAAAHhsL19yZWxzL3dvcmtib29rLnhtbC5yZWxzvZTBSsQwEIbvgu8Q5m7TdnUV2XQPLsJedX2A0E7bsG0SMnG1b2+s0FpY6h6Kl8DMJP//Mcxks/1sG3ZCR8poAUkUA0Odm0LpSsDb4fnmARh5qQvZGI0COiTYZtdXmxdspA+PqFaWWFDRJKD23j5yTnmNraTIWNShUhrXSh9CV3Er86OskKdxvObutwZkE022LwS4fbECduhscP5b25SlynFn8vcWtT9jwT+MO1KN6IOodBV6AUOKeF9ZRYEY+HmY+yVhqJYOi1fvQq9pBJqk52DSJWEu6Ew6B5P8M0wyB7NeEoZ814ShHwbmJ56zv1vS3odVwtG9D3l/zrbgdkkGq07GP8mw1TsslVbfez8ijVV+7uKAySdfRvYFUEsDBBQAAAAIAJZ5qFziK397uwAAADMBAAAyAAAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHOFj8FqwzAQRO+F/oPYey07h1CK5RwSArkG5wMWaW2L2FqhVUL899ExoYUeh2HezLS7xzKrOyXxHAw0VQ2KgmXnw2jg0h+/vkFJxuBw5kAGVhLYdZ8f7ZlmzCUkk4+iCiWIgSnn+KO12IkWlIojheIMnBbMRaZRR7RXHElv6nqr0ysDujemOjkD6eQaUP0aS/P/bB4Gb+nA9rZQyH9U6OjvnPdY5p3JcnJS4JhGygZ+WU1VpoPuWv12tXsCUEsDBBQAAAAIAJZ5qFwr5NbvaAQAAKsTAAAnAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1s1VjbciI3EH1PVf5BNXlJHsxlGMBQwBYXe0PK2K7Fu9lXMaMBxbrMShqvSWr/fVszIIgvzGwZKpUXG6Sm1WqdPn2k3rtHztADUZpK0ffqlZqHiAhlRMWy7328uzw795A2WESYSUH63ppo793g5596CX2QZozDFZmQmApqwAECZ0L3vZUxSbda1TDJsa7IhAiYiaXi2MBXtazqRBEc6RUhhrOqX6u1qhxT4eUeuqqMDxnHNCQTGaacCJM7UYRhG4le0UR7SHVp1PfUNKrDZxIrAitGo3XfG6ZmJZUbvBFXEoPlvtkEG9hvEDT9dqXVadda/nnQ9usdD4UQuyHRp23WmnvO9wc5FR/yRfGCETfTsOahVNFYpsL0Pb/pDXqhzeRcpiokyKwTWPmrVPdZgmDWfd5YwF5gD/XucOa34HysVd+bjIZo/n6IRkyG93B+aE60PVY0TznHyqsOetW9ZTZrXlLCIo3CPJZGZxtLNo4E5hDKHMIVEeRTpPySmylkqgF2sC9Foqkh3P5eGDhAPSeczugjie5gEwAFwJObMipD1d7QdcoXBA4b8r61mgpDlpsxSOAnzFKIAAw4ftx8aTZ2e8nC3N/KJuSp0AZNo/2Qa/9hyPXiiOc0ghNTFLNfDkTtDvG1jX/URKFrOLYyWx8xLO5tdgvdfiA6gbKiC8qoWR/X90xGKSPIIuYkjouzkWG/ZfGBHvreH5PRGN2tqEBjRoFabHayCYtNJTBDMywwgNRNjKWIGQ0NgjRJlmZc+NTmZjhDwyQBs5yh0ATr1UJiFaGxZIyEdtR5lAqHjFRwkuhKLKIKlEeYKgXRVBT5khJtYIgnjAARuR/dpCZJDbqVgP1bJUOofyA5e7Z7pbplgVcBREufxLUUOUservLyKBvL6MgQsB7RFRXkUFEdoigXvDMqTVq+JecdbdmvhXU2/8JK0lb5rN5ClaPfAW0oI9AyNXYiGgec7PLRaPntoNloNf0Sadm0sgKOKE7vtiUawO1baPbiwRLDXkN83l3yhrolFSaXKKZAc3otQlexoFbCVRc6uO2kKJGSualFGsdA5YtUr9FXTI1Gv0bYYLSw7f23H63qP8ED0BnW/+riT4IuTN8d5QQBXRNWBkTlEWpRn6H0JiEqo8eT+c+4t4z3o5PbzeIvIPkyS5dPnNN6/z+9s5OpxxE+zt+JFJDzf0op5BY5mSZ6ukKxOMqF/X4fdMzGt8ro8+eLa7h4UPM3SKBEqp1meklM/YgceXabOb5M3KUELmEgFY5borNCp4W0O5ZwgRNRaV1Wnj/m2RX9LY0wl8hH1yzDXA4fbLBPgFmYxrym3rJZENVLhflbXDiwnShxzv8pMviEPI57PM55cZadFn8V6flLR/64MeiRR3OlTfYfpYr2vX/afnN44Q8vzjpBp34WnC/I2cgfBWfBxajTDi7Hjdp58G37HPVYD549SHEaKqllnN3Dqvlb1PNnrU61kz9sDXrgpPvSo5mFLcSV/82irL5kNvgOUEsDBBQAAAAIAJZ5qFxs0P5ERAUAADwqAAAkAAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlUmVjb3JkczEueG1s7Vpbd6pGFH7vWv0Ps3hp+hBBQIyumFMCJMtWgQLmJE8sgpPIKhfDoD35990MCd44RpPTlsQ8qMMMDsM3e/bl2/v0y7coRHOckiCJe0yzwTEIx34yDuL7HjNyLo5PGEQyLx57YRLjHvOICfPl7OefTqfBPMkUz59gC/tJOiYIZopJj5lk2bTLsgRGIo80kimOYeQuSSMvg8v0niXTFHtjMsE4i0KW5ziJjbwgZooZuukucyR3d4GP1cSfRTjOiklSHHoZvAeZBFPCID+ZxVmP4VvM2Wl6dhqjeY9pCQz71GzmLZJ3igKHjlGr0zlp5X3R0udbPs6t9+Z30OnoCJ3jwrC0S8sY6WrZ9VXuO339Mr9eTENvVpIoCrLvzrpYWQvWxYtih/ZsXxedGADPcNoIE98LxwkF9emPdFg2TXt5Jtr5u3quIGcSxEgJA8CyXH/VwPIa8jYLwJbYUjQoLkvY8hK8g8hLn9C+AVqxSmyFXDrabYmOfQptcQ73FdpKZCUuF9pmS2x/Qvt6fSCcVOgDicultiU2O5/Qvh5avtKMNYVc1QptCi09DfaNLavDvo6OTC9Ddpb4f/26YhGUJPZnaQpqHw292LvHaWmuNmzOe7d6K4iUELFlC3e7/rQrLGx6Xxn+tmlR0ZGj2+iqeXwllFgua99lk9jkK46A0KTKhRPEH7JP9BHrdvk9eycv79OFruZbBT+KNSxBhPYbt4v6KGsOTD1sAcWkrw0b8HFV05UVxXFtR3ZGNsijfD7QqCyurf1duY9VKq0e1uIAwK/SUzUJiw4V/VoETuvgD4zLD6NwKm1zHWKqT4n/HwPaQwW/HhzYOvqmZSiabX8wV4eGVut+ptDJo7emVFCUW8O3YvARuL4IyeMoiAOSpV6W0ODtiWEs4zoLP8wwobEmpSE36KKPGdc9h74sNBxwmmkc3LcdS3YMaynme74vDyju4jELQYUhDxVj8GoetHJ3a0F7HO7pEgXKjbSb7QU1rRi6MrIsTXfQUNblS82CUGoSEORNp2Hg01QCmhGcotiLMEoxpC0IMCUEZRMM2YXyhEUFc4IgS4Lg7wQOIoZWjDCkR9BsOvYyuM682xCTX9BAth13ZKqyo6nu+Q1MFM6iuIFyDr7i2ROPoDiBp5MpZDaC2yAMsgCTBo33XlYE5zMSxJgQpM2fuH2qBCj18HbSYAnMZzj8x8XC/hy42rWmjJy+oW/kHSAZMYDD14AD5+raV3cIeh42YZt7KTX5fBdFgV+QNJp+2ddlp6/QzAYFBJis2Z3nZ7MUsljLvFaRqYFM1CrJ9b0ETnU2ZZ9ES6GLN+RsQ8HvrKRuMekmqeeHuAFSShqgsRoLSWykha6HrmgaYpC6xZMcWVdlS92BIaGLroLVVlg4KKMLWXFGFmS2XHtkapY7suFLthVzSasObaV7l0bd62tNdy3NNCxnsT8w8De+3WElK1RabcnkjxwjVduy3bIjz7jkfNXQ0Ptgd3OhMa+ccit5XiqFhus8PN4++Cnh5h7VIdRBEiS+LbYEqUWjtV1TrYubS4J7m16i0xYqeYUd35twe4ky2foSe6sbuuzCvJTg/LgU7/7J4ZeOK8+JoL4loV3Q4u/exX3OqVMzBk4jmDDnSh64uqFqrmn1h7J14/6h3aCjvq5q1/8hQ1tNodfLJYaagBpUBhyyS1yLqpdDs561qNo4NNAlanlaHLdSdVBoSZzOoZLsKUzIi8nK4GCjZOm9MyX5+re8dOFdQVLVNMyFM79vRU2VyyiKNOctNKEY7yNY/lIQ/vVSvbpYcnaj3vPsH1BLAwQUAAAACACWeahcCkEM6r0AAABHAQAAKQAAAHhsL3Bpdm90VGFibGVzL19yZWxzL3Bpdm90VGFibGUxLnhtbC5yZWxzhY/BCsIwDIbvgu9QcrfdPIjIOg+K4FX0AUKXbcUtLW0VfXvrbQPBY8if789X7V/jIJ4UonWsoZQFCGLjGsudhtv1tNqCiAm5wcExaXhThH29XFQXGjDlo9hbH0WmcNTQp+R3SkXT04hROk+cN60LI6Y8hk55NHfsSK2LYqPClAH1jCnOjYZwbkoQ17fPzf/Zrm2toaMzj5E4/ahQ3j5dOmB+70itZfsVyHwMHSUNUk4CP7OlzDqg6krN9OsPUEsDBBQAAAAIAJZ5qFzR/rF7tgMAAOANAAAeAAAAeGwvcGl2b3RUYWJsZXMvcGl2b3RUYWJsZTEueG1s7Vfdb9s2EH8fsP9B4LsjW5bTKrBcOHGFBmi3oM66Z0Y62QQoUiCpxEbR/31HUlZk2QXarmiLYS+y70jdx+9O9zF/tat48AhKMylSMrkYkwBELgsmNin56z4bvSSBNlQUlEsBKdmDJq8Wv/82r9mjNPf0gcMKSiaYQQEBChM6JVtj6qsw1PkWKqovZA0CT0qpKmqQVJtQ1wpoobcApuJhNB5fhhVlggSCVqjlrhM+JUFOUc5tgdZNSEDrmu//aKoHUJmXlxK02bGvpSrOsDMpzMndO2oMKHHCX3K2ERWceeNvVpjtG2Cb7bM0NKight7Q2rqfkg+UNwhQ0NTIhuLDAdcZCSom3kOpQG8tZt0J+tdoWDZGelOMAx7lMgPVnWLC3DPDAb1EXo6gDcQyUaCxDgPZGM5sjPBm+3+Fxjm6arhhNYeMAS8yxtF3B9xizmVOXewUlClZTq6uo4gEJVPavMEQgXovn5wIx7ICTxg3ktsb4cInhdOhg1w21rBpgkqe+Q4vd8MJFU2VVcYGF4HQW/m05ChrfCzr5x7QHUOo7BMdPzIy0FKZ+32NkBegcxD2q0Fvbeg6/1+0jGCXksj6ZU8t4QA7EM7jAzHtE3GfmHUEIltASTGslhU6lYs5xTxao1HrHL+5FvYlJo1D/U/B98eJgklT2lDcSe2+X58RmAigsAhA58Okz/WvpCSOkji5fIFPTEwfawyoBg455qgXtQse22iGnVS09lkDEi43rJH4f2C/P3PZcpRDv2aifNaqf5lB8Vdm0P+p8cvVkB+RsJ/PskFF+j759B/5Nn9EZL5QRw9RLOVKPg0aKZYBV3pt87i0Vb+jJq5JdGTk2kTYSXDCbvtNKbIVnbX12XWlECkWKFvDz7Kj82x3u/+6u3dgtJJcp/sGBQPRX25Zq9f10W/Ta/uWR/HrcWm1u5icvn4MRgdrj431e6Nw4u4haWPpAriY55IfhdJF0mo6HCzm3Yh11MA7bjtjr5sqkGWwhlyKAmfW0jZ1nAgeqPZjYkdZfYc2/iy77chuBVibPYdbUcr+/O6Y76BgTZX4uQkHKD9T+nHWsnB2HLLw1tooVtuhF+1pbw1Zb6k2+HJT2bXFQg0781Yb9xs0iqXkY3IZvc5mq8lodrOMRnGeTEcvX2fxaHWdzW7Gs3iarKJPxC8tV7tJfLK4VCxXUsvSXOSyCmVZshxOV5ckTPzygoGfxFdnF6MtK8AvB4fpudWKwA62pbNKYZdDf0+yAUdH/dO57avHYCFb/ANQSwMEFAAAAAgAlnmoXNsVeV1gAwAAUAoAAA0AAAB4bC9zdHlsZXMueG1sxVZbj6M2FH6v1P9g8c4ASUiTCFhNLkgrbVeVZirtw7wYMMRaX5Ax07BV/3uPbZIwu9PuzG4vL2Af29/5ztVO3pw4Q49EdVSK1ItuQg8RUcqKiib1fr3P/ZWHOo1FhZkUJPUG0nlvsh9/SDo9MHJ3JEQjgBBd6h21bjdB0JVHwnF3I1siYKWWimMNU9UEXasIrjpziLNgFobLgGMqPIew4eVLQDhWH/vWLyVvsaYFZVQPFstDvNy8bYRUuGBA9RQtcHnGtpMv4DktlexkrW8ALpB1TUvyJct1sA4AKUtEz3OuO1TKXmjw1kWE3MrbCoTL2EPO6J2sgEb14HPOH/xheEDH44bzTdd5QZYEI1qW1FJcQWfA2HDdfBTyN5GbJafJ7MqS7hN6xAwkocEoJZMKaXA4KIqMRGBO3I4dZrRQ1AhrzCkbnHhmBDZG4z5OwWOWkNPgvoXZ9a/rsio70EkZu7h1bowFQZZAgDVRIocJGsf3QwumCshFR9nu+8ruRuEhmsUvP9BJRivDotlZB6umSL08P9we8tzCFOMCFRU5EYj6cmHRJ4Qv5CxHsLGQqoI6myaPE2UJI7WG44o2R/PXsjU6pNaQlFlSUdxIgZlRcD4xDgC2JIzdmVr8UD/BPtWTpISqNp42+WmGQGgcOjw3MfhTNIc9hQ3BJ6/HRaf6ouCvTkdXVlAAU1aX0wi3LRtMQZhUH2dgyZj4T5DHIvyaxZ9hv+95QVRua/c51PlLvPhKzBdF5pt88Erklj5Kve0h58w9YJLhOyLtonPLaCM4ObdK6Eduio5S0U8QSNOPTO7b1DvV/6lKZGrXUfs/tdt2/M/Y/kz62nqGCp60iSdN4lLuyNwbqffe5D6DG2isWFT0lGkqnmkQgFmdri3Htg9tLl7bjC5aIAsrUuOe6fvLYupdxz+TivYcan7c9YtJQwuRetex27U2OshJv+vggoI/6hVNvd8P25/W+0M+81fhduUv5iT21/F278eL3Xa/z9fhLNz9MXkHfMcrwL5WIE2jxaZj8FZQo7Ej+burLPUmk3emsbs8A9pT7uvZMryNo9DP52HkL5Z45a+W89jP42i2Xy62hziPJ9zjb+MehUEUuaeWIR9vNOWEUXGO1TlCUykECaZ/Y4QxxUYiuD4Fsz8BUEsDBBQAAAAIAJZ5qFyDr+rjXwYAAOMbAAATAAAAeGwvdGhlbWUvdGhlbWUxLnhtbO1ZT2/bNhS/D9h3IHRvYyd2Ggd1itix261NGyRuhx5pmZbYUKJA0kl9G9rjgAHDumGXAbvtMGwr0AK7dJ8mW4etA/oV9khKMhnLTdKm2L+mQC1SP77/7/GRunzlfsLQARGS8rQd1C/WAkTSkI9oGrWD24P+hbUASYXTEWY8Je1gSmRwZeP99y7jdRWThCBYn8p13A5ipbL1pSUZwjSWF3lGUng35iLBCoYiWhoJfAh0E7a0XKutLiWYpgFKcQJkb43HNCRooEkGGwXxHoNhqqSeCJnY06SJt8JgR/t1/SOnsssEOsCsHQCfET8ckPsqQAxLBS/aQc38BUsbl5fKRUwtWOus65u/fF2+YLS/bHiKaFgyrfcbrUtbJX0DYGoe1+v1ur16Sc8AcBiCplYWl2ajv1bvFDQdkH2cp92tNWsNH+/QX5mj3+p0Os1WLoslakD2sTGHX6utNjaXPbwBWXxzXv7OZre76uENyOJX5/D9S63Vho83oJjRdH8Orf1ZeqaEjDm7VglfA/haEQAzFERDGV2axZinalGsJfgeF30AGOdiRVOkphkZ4xCiuIuToaA4QBlOuYSJ2nKtX1uB//W/hnlqaFvgdYKddXYqlHNTWhIkQ0Ez1Q4+BKqBA3n57PuXz56gl88eHz14evTgp6OHD48e/GhpeQuv4TRyF7749rM/v/4Y/fHkmxePvqjGSxf/6w+f/PLz59VAyK+Z/s+/fPzb08fPv/r09+8eVcA3BR668AFNiEQ3ySHa5QnoViE5GYqzrRjEmHorcAy0K0j3VOwBb04xq8J1iG+8OwJKSxXw6uSeJ+teLCaKVnC+HicecJtz1uGi0gDXNS/HwoNJGlUzFxMXt4vxQRXvLk491/YmGdRUCNl523dj4om5w3CqcERSopB+x/cJqVh2l1LPrts0FFzysUJ3KepgWmmSAR16gTRbdI0m4JdplYDgas8223dQh7MqrbfIgY+EhMCsQvgBYZ4Zr+KJwkkVyQFOmGvwG1jFVULuTUXo4npSgacjwjjqjYiUVWtuCdDXcfp1DNWs0u3bbJr4SKHofhXNG5hzF7nF97sxTrJKmWkau9gP5D6EKEY7XFXBt7mfIXoMfsDpQnffocRz98mF4DaNPJFmAaLfTESFL68S7ufjlI0xMVUGCr5XxxOavqqoMwpV/VhRb74r6nZXOl7UN2EDrEqta8dK+SLcv7CAb+FJukMgZ+aL6Lv6/a5+B//5+r0ol8+/as8KNdTwWZ9uWt5kYdM+poztqSkjN6Tp2yVsT6M+TJqBOVWWh7gshsd8k/BwkcBmDRJcfURVvBfjDFr8ujmCRjInHUmUcQmdv5mupG2OtxQae3NSbRZnUkBjtc1HdnrFPauWZMzWFZnzcMFoRRM4LbOVS/kB+DWZ1a1Up1StbkQzRdFTrVQZlJlXzWiYWxP6HgTdElh5Fa4MNDU4DWFGRtrudiMv3GJscp4ukjEekdxHWu95RerGSUWsFGFU4SN97jzBag63lib7BtxO4ySXXWMBu8J7b+KlwjozL+m8PZaOLHWTk6XosB20msvNAIU4awdjOGbDY5KB16VuNTGL4K4qVMIG4onJbFAzb7aqw7IONycLvOmxyIRUW1jGNjTMq+IqJzWXAkb+5SaY9bwUsJH+GlKsrEEw/G1SgMy+a8l4TELlOtuZMbciBpAnP58oIvbi0SEasonYxeB+Haqgz4hK6DxNRdADuNrT1jYjvzjnSedeqBmcnccsi3FebnWKFpls4cbmpQxm5IhXjow2M9mPDU+rikn5c1LFDeP/mSp6P4ELipWRuU+Dm2WBkc7XdsCFijlUoSymYV/AtZqJAIgWuB6G12B8uN82v4Ic6F+bc5aGSWs4Z6pdGiFBYT9SsSBkB8qSib4TiNXzvcuSLAjZnJ6JKzMr9pAcEDbQNWRV7+0BiotqkpcBgzsef/44D7thpBuWf2rnY5P5rO3BrPOx60/ZizScou9sBa03E+GMW62tWHMaLzdPvdVmcM0Et8sKYiKkImT2Y4neUAd8F0onKjtKBFF9wTYeSBdI+zSExslO2mDSpN5uGzXrdEu+b7H5dLb5sjnz2Xm5+Oru82zGzi3s2drtdCtMDQ44nqK6PSoOMsYx5iub+yGMD++Bo7fgk8OEKWk/JtyHS0XYsuxHC0h+61yzdOMvUEsDBBQAAAAIAJZ5qFz33wIPKwIAAEgEAAAPAAAAeGwvd29ya2Jvb2sueG1sjZTJbtswEIbvBfoOLGEgp1hL3MAwLAd23bQ+tDBgNzkGNDm2CHMRSMrL23dEV7XSHJqTxGW+mf+fkcYPJ63IAZyX1hQ066eUgOFWSLMr6K/14+2QEh+YEUxZAwU9g6cPk48fxkfr9htr9wQBxhe0DKEaJYnnJWjm+7YCgydb6zQLuHS7xFcOmPAlQNAqydP0PtFMGnohjNx7GHa7lRzmltcaTLhAHCgWsHxfysq3NM3fg9PM7evqlltdIWIjlQznCKVE89FiZ6xjG4WyT9nnloyvb9Bacme93YY+opJLkW/0ZmmSZRfJk/FWKni62E5YVf1kusmiKFHMh69CBhAFxTKUPcJ1Y0CJq6tZLRWeZoNBntJk8rcVS0cQG8AtnTwwfsYrlAjYslqFNbalTYj7+SDP75vYpoVPEo7+immW5PQsjbDHguYDHIlzu8pS9OEYj56lCGVTxfC69x3krgwFHaYZRjEe5AHWbNMUgrmSTrI4Bpg0PomJ8uezKVl9m5KZsnyPA0hW4KNBq1pjp3AQm8uLRjr6MJL44hYioruYGA6C4NCSTYvSVtQKZ/fKuOsw8n8ZS+awJLSyG5F3Iu6ioFYFmiwNiKaLqKmz+qPs5aSM7r88xu7MWWAb5qFpLmdq1YpCx0opBDTfIZ3c/MeNm0+9aS8b9aY/etk46aTEsl6Xgzk4jkbziN7leZ5F0yp5sOELwy8Wi74u8CZuxatdnwdR8auYpP0JTH4DUEsDBBQAAAAIAJZ5qFzIobj6uAAAADQBAAAjAAAAeGwvd29ya3NoZWV0cy9fcmVscy9zaGVldDIueG1sLnJlbHOFj8EKwjAQRO+C/xD2btJ6EJGmvYjgVeoHrOm2DbZJyEbRvzfHCoK32R32zU7VvOZJPCmy9U5DKQsQ5IzvrBs0XNvTZg+CE7oOJ+9Iw5sYmnq9qi40YcpHPNrAIlMcaxhTCgel2Iw0I0sfyGWn93HGlMc4qIDmjgOpbVHsVFwyoP5iinOnIZ67EkT7Djn5P9v3vTV09OYxk0s/IlSwT59avE2UqRgHShqkXKx5oUuZfwdVV+qra/0BUEsDBBQAAAAIAJZ5qFzXH3LFSQMAAEYNAAAYAAAAeGwvd29ya3NoZWV0cy9zaGVldDIueG1slVddb5swFH2ftP+A/N4Qk6RtopCqXVVtD5OmfT47xgSrgJntJO2/37VNCJBB4KWFcjjH99yb05v1w1uWegcmFRd5iPBkijyWUxHxfBeiXz9fbu6RpzTJI5KKnIXonSn0sPn4YX0U8lUljGkPGHIVokTrYuX7iiYsI2oiCpbDk1jIjGi4lTtfFZKRyL6UpX4wnd76GeE5cgwrOYRDxDGn7FnQfcZy7UgkS4mG86uEF+rEltEhdBmRr/vihoqsAIotT7l+t6TIy+jqyy4XkmxTqPsNzwk9cdubC/qMUymUiPUE6Hx30Mual/7SB6bNOuJQgbHdkywO0SNePQUB8jdra9Bvzo6qdu1psv3BUkY1i6BPyDP+b4V4NcAv8KcpUCoLMJQEfh3YJ5amwDyDFv51IjMj4FcK9euT2ovt2DfpRSwm+1R/F8fPjO8SDbLB5G4BJpjyV9H7M1MUmgDaE3twKlIggZ9exs0wgYfkzR2WRzoJ0Ryma8uUfuGGDHl0r7TI/riHuKRwLwfly/C7fBnPJsH9Ai9uAzhCP4vvTmLLfCaabNZSHD2YL9BUBTHTilfA/N9CoAIDfTTYEIEWnFWBuYfNdO0fwDFaIp4AUT3D1TMftCpBEBksaLAhgsmrSIOWoEMs7WGCRYek6fbQGg02RHc1yVlL0iFOkmcHGlXOR0gabIggVaoq5y1Jh7giCX0ZXKXBNqtctCQdwkl22Ap9GSxosM0a2510iF5B6MpgQYNtjs5tq0KHKE09N7nRRhP1QyfHYPsnxyH6FZcjFA22f3Acol8RQwQNLtKCm77etTPAQcpOntvcMBaPyh0XPH0fSst3VXRM9mAXLX0fyxJypdIx6YNduNQT775tbz1/OsYWj4kfC77ibj2AujTH5A928dJrbj2BujTHRBB2CVP3dtn2dkAI4TEpZMFXvK3nUEfS4jE5ZMFXvK0nUZfmmCTCLmjq3uKL3aAeRl3LwZgsClzQ1GMBn3ntyvJUYnr/rQRjssiCm+7ii6WkEUYda9CYLIIt+MLe9lpSYsqsX7YNdhuuW/0KsmNfidzxXHkpi+26Ci5Kt9Laay0Ke2UWS6FhJT3dJfB9hYGz0wnkUCyEPt2YLbr6BrT5B1BLAQIUABQAAAAIAJZ5qFyQ7xzWmgEAAG0HAAATAAAAAAAAAAAAIAC2gQAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAhQAFAAAAAgAlnmoXLVVMCPuAAAATAIAAAsAAAAAAAAAAAAgALaBywEAAF9yZWxzLy5yZWxzUEsBAhQAFAAAAAgAlnmoXN5RkDKvAQAAfwMAABAAAAAAAAAAAAAgALaB4gIAAGRvY1Byb3BzL2FwcC54bWxQSwECFAAUAAAACACWeahcj4m4uzQBAABRAgAAEQAAAAAAAAAAACAAtoG/BAAAZG9jUHJvcHMvY29yZS54bWxQSwECFAAUAAAACACWeahcTUHW0hoBAAB7BAAAGgAAAAAAAAAAACAAtoEiBgAAeGwvX3JlbHMvd29ya2Jvb2sueG1sLnJlbHNQSwECFAAUAAAACACWeahc4it/e7sAAAAzAQAAMgAAAAAAAAAAACAAtoF0BwAAeGwvcGl2b3RDYWNoZS9fcmVscy9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sLnJlbHNQSwECFAAUAAAACACWeahcK+TW72gEAACrEwAAJwAAAAAAAAAAACAAtoF/CAAAeGwvcGl2b3RDYWNoZS9waXZvdENhY2hlRGVmaW5pdGlvbjEueG1sUEsBAhQAFAAAAAgAlnmoXGzQ/kREBQAAPCoAACQAAAAAAAAAAAAgALaBLA0AAHhsL3Bpdm90Q2FjaGUvcGl2b3RDYWNoZVJlY29yZHMxLnhtbFBLAQIUABQAAAAIAJZ5qFwKQQzqvQAAAEcBAAApAAAAAAAAAAAAIAC2gbISAAB4bC9waXZvdFRhYmxlcy9fcmVscy9waXZvdFRhYmxlMS54bWwucmVsc1BLAQIUABQAAAAIAJZ5qFzR/rF7tgMAAOANAAAeAAAAAAAAAAAAIAC2gbYTAAB4bC9waXZvdFRhYmxlcy9waXZvdFRhYmxlMS54bWxQSwECFAAUAAAACACWeahc2xV5XWADAABQCgAADQAAAAAAAAAAACAAtoGoFwAAeGwvc3R5bGVzLnhtbFBLAQIUABQAAAAIAJZ5qFyDr+rjXwYAAOMbAAATAAAAAAAAAAAAIAC2gTMbAAB4bC90aGVtZS90aGVtZTEueG1sUEsBAhQAFAAAAAgAlnmoXPffAg8rAgAASAQAAA8AAAAAAAAAAAAgALaBwyEAAHhsL3dvcmtib29rLnhtbFBLAQIUABQAAAAIAJZ5qFzIobj6uAAAADQBAAAjAAAAAAAAAAAAIAC2gRskAAB4bC93b3Jrc2hlZXRzL19yZWxzL3NoZWV0Mi54bWwucmVsc1BLAQIUABQAAAAIAJZ5qFzXH3LFSQMAAEYNAAAYAAAAAAAAAAAAIAC2gRQlAAB4bC93b3Jrc2hlZXRzL3NoZWV0Mi54bWxQSwUGAAAAAA8ADwA5BAAAkygAAAAA xl/worksheets/sheet3.xml 0 Row Labels 1 Sum of Seconds 2 JDBC Thin Client 3 log file sync 4 (blank) 5 buffer busy waits (data block) 6 Internal Manager 7 Conflict Resolution Manager 8 OAM Applications Dashboard Collection 9 Output Post Processor 10 oracle.apps.fnd.concurrent.request.completed 11 latch: shared pool 12 XXEN Blitz Report 13 Grand Total data A 3 data A1 1 data AA1 1 data AB1 1 data AC1 1 data AD1 1 data AE1 1 data AF1 1 data AG1 1 data AH1 1 data AI1 1 data AJ1 1 data AK1 1 data AL1 1 data AM1 1 data B1 1 data C1 1 data D1 1 data E1 1 data F1 1 data G1 1 data H1 1 data I1 1 data J1 1 data K1 1 data L1 1 data M1 1 data N1 1 data O1 1 data P1 1 data Q1 1 data R1 1 data S1 1 data T1 1 data U1 1 data V1 1 data W1 1 data X1 1 data Y1 1 data Z1 1 parameter A1 1 parameter A10 1 parameter A11 1 parameter A12 1 parameter A2 1 parameter A3 1 parameter A4 1 parameter A5 1 parameter A6 1 parameter A7 1 parameter A9 1 parameter B1 4 parameter B10 4 parameter B11 4 parameter B12 4 parameter B2 4 parameter B3 2 parameter B4 4 parameter B5 4 parameter B6 4 parameter B7 4 parameter B9 4 S Site Pivot blocked and blocking modules with wait event