ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 44BB3D5CCD98EA34E0630100007FD853 DBA Command Type Y select 'create table' value, null description from dual union all select 'insert' value, null description from dual union all select 'select' value, null description from dual union all select 'update' value, null description from dual union all select 'delete' value, null description from dual union all select 'create index' value, null description from dual union all select 'alter index' value, null description from dual union all select 'lock table' value, null description from dual union all select 'alter session' value, null description from dual union all select 'commit' value, null description from dual union all select 'rollback' value, null description from dual union all select 'savepoint' value, null description from dual union all select 'pl/sql block' value, null description from dual union all select 'set transaction' value, null description from dual union all select 'explain' value, null description from dual union all select 'analyze table' value, null description from dual union all select 'set constraints' value, null description from dual union all select 'call' value, null description from dual union all select 'merge' value, null description from dual union all select 'other' value, null description from dual US 8E2FF36EDE9479D2E0530100007F1FF2 DBA Index Y Y select di.index_name value, di.owner||'.'||di.table_name||': '||di.index_type description from dba_indexes di order by di.index_name 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 49A8B1A803A708ACE0530100007FEB91 select gsa.inst_id, decode(gsbc.row_number,null, &order_by/xxen_util.zero_to_null(sum(decode(gsbc.row_number,null,&order_by)) over (partition by gsa.inst_id))*100 ) percentage, xxen_util.responsibility(gsa.module,gsa.action) responsibility, xxen_util.module_type(gsa.module,gsa.action) module_type, xxen_util.module_name(gsa.module) module_name, gsa.module, gsa.code, case when gsa.program_line#>0 then gsa.program_line# end code_line#, &literals_columns gsa.sql_id, gsa.plan_hash_value, gsa.sql_fulltext sql_text, &bind_columns decode(gsbc.row_number,null,gsa.executions*gsa.time_factor) executions, xxen_util.time(gsa.elapsed_time*gsa.time_factor/1000000) time, decode(gsbc.row_number,null,gsa.elapsed_time*gsa.time_factor/1000000) elapsed_time, decode(gsbc.row_number,null,gsa.user_io_wait_time*gsa.time_factor/1000000) user_io_wait_time, decode(gsbc.row_number,null,gsa.cpu_time*gsa.time_factor/1000000) cpu_time, decode(gsbc.row_number,null,(gsa.user_io_wait_time+gsa.cpu_time)/xxen_util.zero_to_null(gsa.cpu_time)) io_factor, decode(gsbc.row_number,null,gsa.plsql_exec_time*gsa.time_factor/1000000) plsql_exec_time, decode(gsbc.row_number,null,gsa.concurrency_wait_time*gsa.time_factor/1000000) concurrency_wait_time, decode(gsbc.row_number,null,gsa.application_wait_time*gsa.time_factor/1000000) application_wait_time, gsa.time_exec*gsa.time_factor time_exec, decode(gsbc.row_number,null,gsa.buffer_io*gsa.time_factor) buffer_io, decode(gsbc.row_number,null,gsa.disk_io*gsa.time_factor) disk_io, gsa.io_exec, gsa.blocks_exec, gsa.rows_processed*gsa.time_factor rows_processed, gsa.rows_processed/gsa.executions_ rows_exec, gsa.buffer_io/gsa.rows_processed_ io_row, gsa.buffer_gets/gsa.rows_processed_ blocks_row, 1000000*gsa.buffer_io/xxen_util.zero_to_null(gsa.elapsed_time) io_sec, case when gsa.executions>100 then gsa.buffer_io/gsa.seconds end io_sec_avg, 1000000*(gsa.buffer_io-gsa.disk_io)/xxen_util.zero_to_null(gsa.cpu_time) buffer_rate, 1000000*gsa.disk_io/xxen_util.zero_to_null(gsa.user_io_wait_time) disk_rate, 100*gsa.disk_io/xxen_util.zero_to_null(gsa.buffer_io) disk_percentage, case when gsa.executions>100 then gsa.executions/gsa.seconds*3600 end execs_per_hour, case when gsa.executions>100 then 100*gsa.elapsed_time/1000000/gsa.seconds end time_percentage, gsa.is_bind_sensitive, gsa.is_bind_aware, gsa.parsing_schema_name schema, gsa.parse_calls, gsa.sorts, xxen_util.client_time(gsa.first_load_time_) first_load_time, xxen_util.client_time(gsa.last_active_time) last_active_time, decode(gsa.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') command_type, gsa.action from ( select gsa.elapsed_time/1000000/xxen_util.zero_to_null(gsa.executions) time_exec, vp.value*gsa.buffer_gets/1000000/xxen_util.zero_to_null(gsa.executions) io_exec, gsa.buffer_gets/xxen_util.zero_to_null(gsa.executions) blocks_exec, xxen_util.zero_to_null(gsa.executions) executions_, xxen_util.zero_to_null(gsa.rows_processed) rows_processed_, vp.value*gsa.buffer_gets/1000000 buffer_io, vp.value*gsa.disk_reads/1000000 disk_io, xxen_util.zero_to_null(sysdate-gsa.first_load_time_)*86400 seconds, nvl2(:time_basis_days,:time_basis_days/xxen_util.zero_to_null(sysdate-gsa.first_load_time_),1) time_factor, gsa.*, (select so.name from sys.obj$ so where gsa.program_id=so.obj#) code, count(distinct decode(gsa.force_matching_signature,0,null,gsa.sql_id)) over (partition by gsa.force_matching_signature) literals_dupl_count, row_number() over (partition by gsa.force_matching_signature order by gsa.inst_id,gsa.sql_id,gsa.plan_hash_value) literals_row_number from (select vp.value from v$parameter vp where vp.name like 'db_block_size') vp, (select to_date(gsa.first_load_time,'YYYY-MM-DD/HH24:MI:SS') first_load_time_, gsa.* from gv$sqlarea gsa) gsa where 1=1 ) gsa, ( select decode(row_number() over (partition by gsbc.inst_id, gsbc.sql_id order by gsbc.child_number desc, gsbc.position),1,null,2) row_number, gsbc.* from ( select distinct gsbc.inst_id, gsbc.sql_id, gsbc.child_number, gsbc.name, case when gsbc.datatype_string like 'TIMESTAMP%' then to_char(anydata.accesstimestamp(gsbc.value_anydata)) when gsbc.datatype_string='DATE' then to_char(anydata.accessdate(gsbc.value_anydata)) else gsbc.value_string end value_string, gsbc.last_captured, min(gsbc.position) over (partition by gsbc.inst_id, gsbc.sql_id, gsbc.child_number, gsbc.name, gsbc.value_string, gsbc.last_captured) position from gv$sql_bind_capture gsbc where '&show_binds'='Y' and gsbc.was_captured='YES' ) gsbc ) gsbc where 2=2 and gsa.inst_id=gsbc.inst_id(+) and gsa.sql_id=gsbc.sql_id(+) order by &literals_order_by &order_by_last_active_time &order_by desc nulls last, gsa.sql_id &bind_order Y #,##0.00 AR DBA SGA SQL Performance Summary ملخص أداء قاعدة بيانات SQL من SGA لإعطاء نظرة عامة على أهم مشكلات تحميل وأداء SQL. الغرض من هذا التقرير ، مقارنة بـ "ملخص أداء DBA AWR SQL" هو استرداد SQLs غير الموجودة في تقارير العرب والغرب ، إما لأنها تم تشغيلها بعد أحدث لقطة أو لأن تأثير أدائها صغير جدًا بحيث لا يمكن كتابته في تقارير تقارير العرب والغرب ( انظر topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). هذا مفيد على سبيل المثال: -تحديد SQLs التي يتم تنفيذها بواسطة برنامج معين أو وظيفة واجهة المستخدم دون تشغيل أي أثر. انتقل إلى وظيفة واجهة المستخدم أولاً ، ثم بعد ذلك مباشرة ، قم بتنفيذ هذا التقرير وتقييد اسم الوحدة المعنية. فرز حسب العمود "وقت آخر نشاط" -تحديد SQLs ومثال ربط المتغيرات لإعادة إنتاج تنفيذ SQL في أداة الوصول إلى قاعدة البيانات. تبديل المعلمة "إظهار قيم الربط" إلى "نعم" -تحديد SQLs بشكل غير صحيح باستخدام القيم الحرفية بدلاً من الروابط. عيّن المعلمة "Literals Duplication Count" إلى قيمة أكبر من الصفر لإظهار جميع SQLs التي تم تكرارها على الأقل هذا العدد من المرات. D DBA SGA SQL Performance Summary Datenbank-SQL-Leistungszusammenfassung aus der SGA, um einen Überblick über die wichtigsten SQL-Last- und Leistungsprobleme zu geben. Der Zweck dieses Berichts im Vergleich zu "DBA AWR SQL Performance Summary" ist es, SQLs abzurufen, die nicht im AWR sind, entweder weil sie nach dem letzten Snapshot ausgeführt wurden oder weil ihre Leistungsauswirkungen zu gering sind, um in das AWR geschrieben zu werden (siehe topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Dies ist zum Beispiel nützlich, um: -Identifizieren von SQLs, die von einem bestimmten Programm oder einer UI-Funktion ausgeführt wurden, ohne einen Trace auszuführen. Navigieren Sie zuerst zu der UI-Funktionalität, führen Sie direkt danach diesen Bericht aus und beschränken Sie ihn auf den betreffenden Modulnamen. Sortieren nach Spalte 'Letzte aktive Zeit' -Identifizieren Sie SQLs und Beispiel-Bind-Variablen, um eine SQL-Ausführung in einem DB-Access-Tool zu reproduzieren. Schalten Sie den Parameter 'Bindungswerte anzeigen' auf 'Ja' um. -Identifizieren Sie SQLs, die fälschlicherweise Literale anstelle von Bindungen verwenden. Setzen Sie den Parameter 'Literals Duplication Count' auf einen Wert größer als Null, um alle SQLs anzuzeigen, die mindestens so oft dupliziert werden. E DBA SGA SQL Performance Summary Resumen de rendimiento de SQL de la base de datos desde el SGA para ofrecer una visión general de los principales problemas de carga y rendimiento de SQL. El propósito de este informe, comparado con el 'Resumen de rendimiento SQL del DBA AWR', es recuperar los SQLs que no están en el AWR, ya sea porque se ejecutaron después de la instantánea más reciente o porque su impacto en el rendimiento es demasiado pequeño para ser escrito en el AWR (ver topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Esto es útil, por ejemplo, para: -Identificar los SQLs ejecutados por un programa o función de la UI en particular sin ejecutar una traza. Navegar primero a la función de la UI, luego directamente ejecutar este informe y restringir al nombre del módulo en cuestión. Ordenar por la columna "Último tiempo activo". -Identificar SQLs y variables bind de ejemplo para reproducir una ejecución SQL en una herramienta de acceso a la BD. Cambie el parámetro 'Show Bind Values' a 'Yes' -Identificar los SQLs que utilizan incorrectamente literales en lugar de binds. Establecer el parámetro 'Literals Duplication Count' a un valor mayor que cero para mostrar todos los SQLs que están al menos duplicados este número de veces. F DBA SGA SQL Performance Summary Résumé des performances de la base de données SQL de la SGA pour donner un aperçu des principaux problèmes de charge et de performances du SQL. L'objectif de ce rapport, comparé au "DBA AWR SQL Performance Summary", est de récupérer les SQL qui ne sont pas dans l'AWR, soit parce qu'ils ont été exécutés après l'instantané le plus récent, soit parce que leur impact sur les performances est trop faible pour être écrit dans l'AWR (voir topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Ceci est utile par exemple pour : -Identifier les SQL exécutés par un programme ou une fonction d'interface utilisateur particulière sans qu'il y ait de trace. Naviguer d'abord vers la fonction UI, puis directement après, exécuter ce rapport et se limiter au nom du module en question. Trier par colonne "Dernière heure active". -Identifier les SQL et les variables de liaison d'exemple pour reproduire une exécution SQL dans un outil d'accès à une base de données. Passez le paramètre "Show Bind Values" à "Yes". -Identifier les SQL de manière incorrecte en utilisant des littéraux au lieu de liens. Réglez le paramètre "Literals Duplication Count" sur une valeur supérieure à zéro pour afficher tous les SQL qui sont au moins dupliqués ce nombre de fois. I DBA SGA SQL Performance Summary Riassunto delle prestazioni SQL del database dall'SGA per dare una visione d'insieme dei principali problemi di carico SQL e di prestazioni. Lo scopo di questo report, rispetto al 'DBA AWR SQL Performance Summary' è quello di recuperare gli SQL che non sono nell'AWR, o perché sono stati eseguiti dopo lo snapshot più recente o perché il loro impatto sulle prestazioni è troppo piccolo per essere scritto nell'AWR (vedi topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Questo è utile per esempio per: -Identificare gli SQL eseguiti da un particolare programma o funzione UI senza eseguire una traccia. Navigare alla funzionalità UI prima, poi direttamente dopo, eseguire questo rapporto e limitare al nome del modulo in questione. Ordina per colonna "Ultimo tempo attivo". -Identifica gli SQL e le variabili bind di esempio per riprodurre un'esecuzione SQL in uno strumento di accesso al DB. Passa il parametro 'Mostra valori di binding' a 'Sì'. -Identifica gli SQL che usano scorrettamente i letterali invece dei bind. Imposta il parametro 'Literals Duplication Count' ad un valore maggiore di zero per mostrare tutti gli SQL che sono duplicati almeno questo numero di volte. JA DBA SGA SQL Performance Summary SGAからのデータベースSQLパフォーマンスサマリーは、トップSQLの負荷とパフォーマンスの問題の概要を提供します。 DBA AWR SQL Performance Summary'と比較して、このレポートの目的は、最新のスナップショットの後に実行されたか、パフォーマンスへの影響が小さすぎてAWRに書き込まれていないSQLを取得することです(topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140 を参照)。 これは例えば以下のような場合に便利です。 -トレースを実行せずに、特定のプログラムやUI関数で実行されたSQLを特定する。最初にUI機能にアクセスし、その後直接このレポートを実行し、問題のモジュール名に制限します。列 '最後にアクティブになった時間' で並べ替え -DBアクセスツールでのSQL実行を再現するために、SQLとバインド変数の例を特定します。パラメータ「Show Bind Values」を「Yes」に切り替えます。 -バインドの代わりにリテラルを誤って使用している SQL を識別します。パラメータ 'Literals Duplication Count' をゼロよりも大きな値に設定して、少なくともこの数だけ重複しているすべての SQL を表示します。 KO DBA SGA SQL Performance Summary SGA의 데이터베이스 SQL 성능 요약을 통해 주요 SQL로드 및 성능 문제에 대한 개요를 제공합니다. 이 보고서의 목적은 'DBA AWR SQL 성능 요약'과 비교하여 가장 최근 스냅 샷 이후에 실행되었거나 성능 영향이 너무 작아 AWR에 기록 할 수 없기 때문에 AWR에없는 SQL을 검색하는 것입니다 ( topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140 참조). 예를 들어 다음과 같은 경우에 유용합니다. -추적을 실행하지 않고 특정 프로그램 또는 UI 기능에 의해 실행 된 SQL을 식별합니다. 먼저 UI 기능으로 이동 한 다음 바로 뒤에이 보고서를 실행하고 해당 모듈 이름으로 제한합니다. '마지막 활성 시간'열을 기준으로 정렬 -DB 액세스 도구에서 SQL 실행을 재현하기 위해 SQL 및 예제 바인드 변수를 식별합니다. 매개 변수 '바인드 값 표시'를 '예'로 전환 -바인드 대신 리터럴을 사용하여 SQL을 잘못 식별합니다. 이 횟수 이상 중복 된 모든 SQL을 표시하려면 'Literals Duplication Count'매개 변수를 0보다 큰 값으로 설정하십시오. PTB DBA SGA SQL Performance Summary Resumo de desempenho SQL do banco de dados da SGA para dar uma visão geral das principais questões de carga e desempenho SQL. O objetivo deste relatório, comparado ao 'DBA AWR SQL Performance Summary' é recuperar SQLs que não estão no AWR, seja porque correram após o mais recente snapshot ou porque seu impacto de desempenho é muito pequeno para ser escrito no AWR (veja topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Isto é útil, por exemplo, para: -Identificar SQLs executados por um determinado programa ou função UI sem executar um traço. Navegar primeiro até a funcionalidade UI, depois diretamente após, executar este relatório e restringir ao nome do módulo em questão. Ordenar por coluna 'Última hora ativa'. -Identificar SQLs e variáveis de exemplo bind para reproduzir uma execução SQL em uma ferramenta de acesso DB. Alternar o parâmetro 'Show Bind Values' para 'Yes'. -Identificar os SQLs incorretamente usando literalmente em vez de ligas. Definir o parâmetro 'Literals Duplication Count' para um valor maior que zero para mostrar todos os SQLs que estão pelo menos duplicados este número de vezes. RU DBA SGA SQL Performance Summary Сводка о производительности SQL базы данных от SGA, чтобы дать обзор о верхней загрузке SQL и проблемы производительности. Целью данного отчета, по сравнению с 'DBA AWR SQL Performance Summary', является получение SQL, которые не находятся в AWR, либо потому, что они запущены после последнего снимка, либо потому, что их влияние на производительность слишком мало, чтобы быть написанным в AWR (см. topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Это полезно, например, для: -Идентифицировать SQL-файлы, выполняемые определенной программой или функцией пользовательского интерфейса без запуска трассировки. Сначала перейдите к функциям пользовательского интерфейса, а затем сразу после этого выполните этот отчет и ограничьтесь именем модуля, о котором идет речь. Сортировать по столбцу "Последнее активное время". -Идентифицировать SQL и пример привязки переменных для воспроизведения выполнения SQL в инструменте доступа к БД. Переключить параметр 'Показывать значения привязки' в 'Да'. -Ошибочно идентифицировать SQL, используя литералы вместо связок. Установите параметр 'Literals Duplication Count' в значение больше нуля, чтобы показать все SQL, которые хотя бы дублируют это число раз. S DBA SGA SQL Performance Summary Databas SQL-prestandasammanfattning från SGA för att ge en översikt över de bästa SQL-belastnings- och prestandafrågorna. Syftet med denna rapport, jämfört med 'DBA AWR SQL Performance Summary', är att hämta SQL-filer som inte finns i AWR, antingen eftersom de sprang efter den senaste ögonblicksbilden eller eftersom deras prestandapåverkan är för liten för att kunna skrivas till AWR se topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Detta är till exempel användbart för: -Identifiera SQL-filer som körs av ett visst program eller UI-funktion utan att köra ett spår. Navigera till gränssnittsfunktionaliteten först, sedan direkt efter, kör rapporten och begränsa till modulnamnet i fråga. Sortera efter kolumn 'Senaste aktiv tid' -Identifiera SQL-filer och exempelbindningsvariabler för att reproducera en SQL-körning i ett DB-åtkomstverktyg. Byt parameter 'Visa bindningsvärden' till 'Ja' -Identifiera SQL-filer felaktigt med hjälp av bokstäver istället för bindningar. Ställ in parametern "Antal kopior av bokstäver" till ett värde större än noll för att visa alla SQL-filer som åtminstone dupliceras detta antal gånger. TR DBA SGA SQL Performance Summary En önemli SQL yükü ve performans sorunlarına genel bir bakış sağlamak için SGA'dan veritabanı SQL performans özeti. Bu raporun 'DBA AWR SQL Performans Özeti' ile karşılaştırıldığında amacı, ya en son anlık görüntüden sonra çalıştıkları ya da performans etkileri AWR'ye yazılamayacak kadar küçük olduğu için AWR'de olmayan SQL'leri almaktır ( bkz. topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). Bu, örneğin şunlar için kullanışlıdır: -Belirli bir program veya UI işlevi tarafından yürütülen SQL'leri izleme çalıştırmadan tanımlayın. Önce UI işlevine gidin, ardından doğrudan bu raporu çalıştırın ve söz konusu modül adıyla sınırlayın. 'Son Aktif Zaman' sütununa göre sırala -Bir DB erişim aracında bir SQL yürütmesini yeniden oluşturmak için SQL'leri tanımlayın ve değişkenleri bağlama örneği. "Bağlantı Değerlerini Göster" parametresini "Evet" olarak değiştirin -Bağlantılar yerine değişmez değerleri kullanarak SQL'leri yanlış tanımlayın En azından bu sayıda çoğaltılmış tüm SQL'leri göstermek için 'Literals Duplication Count' parametresini sıfırdan büyük bir değere ayarlayın. US DBA SGA SQL Performance Summary Database SQL performance summary from the SGA to give an overview of top SQL load and performance issues. The purpose of this report, compared to 'DBA AWR SQL Performance Summary' is to retrieve SQLs which are not in the AWR, either becasue they ran after the most recent snapshot or because their performance impact is too small to be written to the AWR (see topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140). This is useful for example to: -Identify SQLs executed by a particular program or UI function without running a trace. Navigate to the UI functionality first, then directly after, execute this report and restrict to the module name in question. Sort by column 'Last Active Time' -Identify SQLs and example bind variables to reproduce a SQL execution in a DB access tool. Switch parameter 'Show Bind Values' to 'Yes' -Identify SQLs incorrectly using literals instead of binds. Set parameter 'Literals Duplication Count' to a value bigger than zero to show all SQLs which are at least duplicated this numer of times. ZHS DBA SGA SQL Performance Summary 数据库SQL性能摘要从SGA给出了一个顶级SQL负载和性能问题的概述。 与 "DBA AWR SQL性能摘要 "相比，这个报告的目的是检索那些不在AWR中的SQL，因为它们是在最近的快照之后运行的，或者因为它们对性能的影响太小而无法写入AWR（参见topnsql https://docs.oracle.com/database/121/ARPLS/d_workload_repos.htm#ARPLS69140）。 例如，这对以下情况很有用 -识别特定程序或UI功能执行的SQL，而无需运行跟踪。先导航到UI功能，然后直接执行这个报告，并限制在相关模块名称上。按 "最后活动时间 "列排序 -识别SQL和绑定变量的例子，以便在DB访问工具中重现SQL的执行。将参数 "显示绑定值 "切换为 "是"。 -识别不正确地使用字元而非绑定的SQL。将参数'Literals Duplication Count'设置为大于0的值，以显示所有至少重复了这个数字的SQL。 Enginatics &bind_columns &bind_order &literals_columns &literals_order_by &order_by &order_by_last_active_time &show_binds 1=1 2=2 :time_basis_days 1 -20 1=1 :program_short_name=:program_short_name Char US Program Short Name 2 -10 1=1 :request_id=:request_id Char US Request Id 3 10 1=1 lower(gsa.sql_fulltext) like lower('%'||:sql_text||'%') Char F Le texte SQL contient US SQL Text contains 4 20 1=1 xxen_util.module_type(gsa.module,gsa.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 decode(:$flex$.program_short_name,null,nvl2(xxen_report_ebs.zoom_form_name,'Form',null),'XXEN_REPORT','Blitz Report','Concurrent Request') F Type de module US Module Type 5 1=1 gsa.module like 'XXEN_REPORT - %' Blitz Report F Type de module US Module Type 6 1=1 regexp_like(gsa.module,'^e:\w*:bes:.+$') Business Event F Type de module US Module Type 7 1=1 regexp_like(gsa.module,'^e:\w*:(cp|gsm|GSM):\w+$') Concurrent Manager F Type de module US Module Type 8 1=1 (gsa.module like 'Disco%' or gsa.module like 'dis%adm%' or gsa.module like 'dis%usr%' or gsa.module like 'dis%ws%') Discoverer F Type de module US Module Type 9 1=1 regexp_like(gsa.module,'^e:\w+:frm:\w+$') Form F Type de module US Module Type 10 1=1 regexp_like(gsa.module,'^e:\w+:fwk:') Oracle Application Framework F Type de module US Module Type 11 1=1 regexp_like(gsa.module,'^e:\w+:wf:\w+$') Workflow F Type de module US Module Type 12 30 1=1 lower(gsa.module) like '%'||lower(:module)||'%' LOV custom select distinct x.module value, max(x.last_active_time) over (partition by x.module,x.description)||' - '||x.description description, max(x.last_active_time) over (partition by x.module,x.description) last_active_time from ( select /*+ no_merge(gsa)*/ distinct gsa.module, xxen_util.module_name(gsa.module)||nvl2(xxen_util.module_type(gsa.module,gsa.action),' ('||xxen_util.module_type(gsa.module,gsa.action)||')',null) description, last_active_time from ( select distinct max(gsa.last_active_time) over (partition by gsa.module,gsa.action) last_active_time, gsa.module, gsa.action from gv$sqlarea gsa where trim(gsa.module) is not null and (:$flex$.module_type is null or xxen_util.module_type(gsa.module,gsa.action)=:$flex$.module_type) ) gsa ) x order by last_active_time desc, description, x.module decode(:$flex$.program_short_name,null,xxen_report_ebs.zoom_form_name,'XXEN_REPORT',(select substr('XXEN_REPORT - '||xxen_report.space_to_underscore(fcr.argument1),1,48) from fnd_concurrent_requests fcr where fcr.request_id=:$flex$.request_id),:$flex$.program_short_name) F Le module contient US Module contains 13 40 1=1 gsa.sql_id=:sql_id Char F Id. SQL US SQL Id 14 50 1=1 gsa.plan_hash_value=:plan_hash_value Number F Valeur de hachage du plan US Plan Hash Value 15 60 &show_binds Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher les valeurs de liaison US Show Bind Values 16 &bind_columns gsbc.child_number, gsbc.name bind, gsbc.value_string bind_value, gsbc.last_captured capture_date, F Afficher les valeurs de liaison US Show Bind Values 17 &bind_order ,gsbc.child_number desc, gsbc.position F Afficher les valeurs de liaison US Show Bind Values 18 70 1=1 gsa.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 19 80 1=1 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 20 90 1=1 gsa.first_load_time_>=:first_load_time_from DateTime US First Load Time From 21 100 1=1 gsa.last_active_time>=:last_active_from DateTime F Dernier actif du US Last Active from 22 110 1=1 gsa.last_active_time<=:last_active_to DateTime F Dernier actif à US Last Active to 23 120 :time_basis_days Number F Base de temps Jours US Time Basis Days 24 130 1=1 (gsa.last_active_time-to_date(gsa.first_load_time,'YYYY-MM-DD/HH24:MI:SS'))>=:min_days_active Number F Nombre minimum de jours actifs en SGA US Minimum Days Active in SGA 25 140 1=1 gsa.executions>=:min_executions Number F Exécutions minimales dans la SGA US Minimum Executions in SGA 26 150 2=2 gsa.literals_dupl_count>=:literals_dupl_count Number F Littéraux Compte de duplication US Literals Duplication Count 27 &literals_columns gsa.literals_dupl_count, to_char(gsa.force_matching_signature) force_matching_signature, F Littéraux Compte de duplication US Literals Duplication Count 28 &literals_order_by gsa.literals_dupl_count desc, gsa.force_matching_signature, gsa.literals_row_number, F Littéraux Compte de duplication US Literals Duplication Count 29 160 2=2 gsa.literals_row_number<=:literals_dupl_examples LOV custom Y select level value, null description from dual where :$flex$.literals_duplication_count is not null connect by level<=100 1 F Exemples par duplicata US Examples per Duplicate 30 170 1=1 decode(gsa.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')=:command_type LOV DBA Command Type 44BB3D5CCD98EA34E0630100007FD853 Y select 'create table' value, null description from dual union all select 'insert' value, null description from dual union all select 'select' value, null description from dual union all select 'update' value, null description from dual union all select 'delete' value, null description from dual union all select 'create index' value, null description from dual union all select 'alter index' value, null description from dual union all select 'lock table' value, null description from dual union all select 'alter session' value, null description from dual union all select 'commit' value, null description from dual union all select 'rollback' value, null description from dual union all select 'savepoint' value, null description from dual union all select 'pl/sql block' value, null description from dual union all select 'set transaction' value, null description from dual union all select 'explain' value, null description from dual union all select 'analyze table' value, null description from dual union all select 'set constraints' value, null description from dual union all select 'call' value, null description from dual union all select 'merge' value, null description from dual union all select 'other' value, null description from dual F Type de commande US Command Type 31 180 1=1 decode(gsa.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')<>:exclude_command_type LOV DBA Command Type 44BB3D5CCD98EA34E0630100007FD853 Y select 'create table' value, null description from dual union all select 'insert' value, null description from dual union all select 'select' value, null description from dual union all select 'update' value, null description from dual union all select 'delete' value, null description from dual union all select 'create index' value, null description from dual union all select 'alter index' value, null description from dual union all select 'lock table' value, null description from dual union all select 'alter session' value, null description from dual union all select 'commit' value, null description from dual union all select 'rollback' value, null description from dual union all select 'savepoint' value, null description from dual union all select 'pl/sql block' value, null description from dual union all select 'set transaction' value, null description from dual union all select 'explain' value, null description from dual union all select 'analyze table' value, null description from dual union all select 'set constraints' value, null description from dual union all select 'call' value, null description from dual union all select 'merge' value, null description from dual union all select 'other' value, null description from dual US Exclude Command Type 32 190 1=1 (gsa.inst_id,gsa.sql_id,gsa.plan_hash_value) in (select /*+ cardinality(gsp 1) */ gsp.inst_id, gsp.sql_id, gsp.plan_hash_value from gv$sql_plan gsp where gsp.object_name=:index_name and gsp.operation='INDEX') LOV DBA Index 8E2FF36EDE9479D2E0530100007F1FF2 Y Y select di.index_name value, di.owner||'.'||di.table_name||': '||di.index_type description from dba_indexes di order by di.index_name F Utilisation de l'index US Using Index 33 200 &order_by select nvl((select 'gsa.'||lower(translate(:oder_by_column,' ','_')) from dual where :oder_by_column<>'Last Active Time'),'buffer_io') 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 nvl((select 'Last Active Time' from dual where xxen_report_ebs.zoom_form_name is not null),'CPU Time') Y F Commander par US Order By 34 &order_by_last_active_time last_active_time desc, Last Active Time US Order By 35 210 1=1 gsa.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 36 220 1=1 gsa.parsing_user_id<>0 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 l'utilisateur SYS US Exclude SYS User :$flex$.literals_duplication_count Literals Duplication Count Examples per Duplicate :$flex$.module_type Module Type Module contains :$flex$.program_short_name Program Short Name Module Type :$flex$.program_short_name Program Short Name Module contains :$flex$.request_id Request Id Module contains :$flex$.sql_id SQL Id Exclude PLSQL Code :$flex$.sql_id SQL Id Exclude SYS User B1A9F67C88E4BF55FF038F39634B5D03 Missing GL summary templates for FSG ANDY.HAACK 45 ACTION 20 APPLICATION_WAIT_TIME 25 BLOCKS_EXEC 29 BLOCKS_ROW 22 BUFFER_IO 32 BUFFER_RATE 7 CODE 8 CODE_LINE# 44 COMMAND_TYPE 19 CONCURRENCY_WAIT_TIME 16 CPU_TIME 23 DISK_IO 34 DISK_PERCENTAGE 33 DISK_RATE 14 ELAPSED_TIME 35 EXECS_PER_HOUR 12 EXECUTIONS 42 FIRST_LOAD_TIME 1 INST_ID 24 IO_EXEC 17 IO_FACTOR 28 IO_ROW 30 IO_SEC 31 IO_SEC_AVG 38 IS_BIND_AWARE 37 IS_BIND_SENSITIVE 43 LAST_ACTIVE_TIME 6 MODULE 5 MODULE_NAME 4 MODULE_TYPE 40 PARSE_CALLS 2 PERCENTAGE 10 PLAN_HASH_VALUE 18 PLSQL_EXEC_TIME 3 RESPONSIBILITY 27 ROWS_EXEC 26 ROWS_PROCESSED 39 SCHEMA 41 SORTS 9 SQL_ID 11 SQL_TEXT 13 TIME 21 TIME_EXEC 36 TIME_PERCENTAGE 15 USER_IO_WAIT_TIME SQL Text contains select /*+ leading(gcc) index(gb gl_balances_n1) use_nl(gcc)*/%gl_balances gb%gcc.summary_flag='N' S Site ANDY.HAACK B1A9F67C88E4BF55FF038F39634B5D03