ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8039F08ACE0530100007FEB91 select gsp.inst_id, gsp.sql_id, gsp.plan_hash_value, gsp.timestamp, lpad(' ',gsp.depth*2)||gsp.operation|| case when gsp.options is not null then ' '||gsp.options end|| case when gsp.object_name is not null then ' '||gsp.object_type||' '||gsp.object_owner||'.'||gsp.object_name end operation, gsp.qblock_name query_block, lpad(' ',gsp.depth)||gsp.depth depth, gsp.cardinality, gsp.bytes/1000000 mb, gsp.time, gsp.cost, gsp.cpu_cost, gsp.io_cost, gsp.id, gsp.parent_id, ds.object_size from gv$sql_plan gsp, ( select ds.owner, ds.segment_type, ds.segment_name, sum(ds.blocks)*(select vp.value from v$parameter vp where vp.name like 'db_block_size')/1000000 object_size from dba_segments ds where '&show_object_size'='Y' group by ds.owner, ds.segment_type, ds.segment_name ) ds where 1=1 and gsp.object_owner=ds.owner(+) and case when gsp.object_type like '% %' then substr(gsp.object_type,1,instr(gsp.object_type,' ')) else gsp.object_type end=ds.segment_type(+) and gsp.object_name=ds.segment_name(+) order by gsp.sql_id, gsp.timestamp desc, gsp.plan_hash_value, gsp.inst_id, gsp.id, gsp.position Y #,##0 :SQL_Id is not null or :Plan_Hash_Value is not null or :SQL_Text_contains is not null or :Module_contains is not null or :Using_Index is not null or :Object_Name is not null or :Options is not null or :Objects_larger_than_x_GB is not null AR DBA SGA SQL Execution Plan History سجل خطة التنفيذ لمعرف SQL معين من SGA D DBA SGA SQL Execution Plan History Ausführungsplan-Historie für eine bestimmte SQL-ID aus der SGA E DBA SGA SQL Execution Plan History Historial del plan de ejecución para un identificador de SQL concreto de la SGA F DBA SGA SQL Execution Plan History Historique du plan d'exécution pour un identifiant SQL particulier de la SGA I DBA SGA SQL Execution Plan History Storia del piano di esecuzione per un particolare id SQL dall'SGA JA DBA SGA SQL Execution Plan History SGA からの特定の SQL id の実行計画の履歴 KO DBA SGA SQL Execution Plan History SGA의 특정 SQL ID에 대한 실행 계획 기록 PTB DBA SGA SQL Execution Plan History Histórico do plano de execução de uma determinada id SQL da SGA RU DBA SGA SQL Execution Plan History История плана выполнения для конкретного SQL-идентификатора из SGA S DBA SGA SQL Execution Plan History Exekveringsplanhistorik för ett visst SQL-id från SGA TR DBA SGA SQL Execution Plan History SGA'dan belirli bir SQL kimliği için yürütme planı geçmişi US DBA SGA SQL Execution Plan History Execution plan history for a particular SQL id from the SGA ZHS DBA SGA SQL Execution Plan History 来自SGA的特定SQL id的执行计划历史。 Enginatics &show_object_size 1=1 1 10 1=1 gsp.sql_id=:sql_id Char F Id. SQL US SQL Id 2 20 1=1 gsp.plan_hash_value=:plan_hash_value Number F Valeur de hachage du plan US Plan Hash Value 3 30 1=1 gsp.sql_id=(select gsa.sql_id from gv$sqlarea gsa where lower(gsa.sql_fulltext) like lower('%'||:sql_text||'%') and (:module is null or lower(gsa.module) like '%'||lower(:module)||'%') order by gsa.last_active_time desc fetch first 1 rows only) Char US SQL Text contains 4 40 1=1 gsp.sql_id=(select gsa.sql_id from gv$sqlarea gsa where lower(gsa.module) like '%'||lower(:module)||'%' and (:sql_text is null or lower(gsa.sql_fulltext) like lower('%'||:sql_text||'%')) order by gsa.last_active_time desc fetch first 1 rows only) 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 ) gsa ) x order by last_active_time desc, description, x.module xxen_report_ebs.zoom_form_name US Module contains 5 50 1=1 (gsp.inst_id,gsp.sql_id,gsp.plan_hash_value) in (select gsp0.inst_id, gsp0.sql_id, gsp0.plan_hash_value from gv$sql_plan gsp0 where gsp0.object_name=:index_name and gsp0.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 6 60 1=1 gsp.object_name=:object_name LOV custom Y select distinct gsp.object_name value, gsp.object_owner description from gv$sql_plan gsp order by gsp.object_name, gsp.object_owner F Nom de l'objet US Object Name 7 70 1=1 gsp.options=:options LOV custom Y select x.options value, x.operation description from ( select count(*) count, gsp.options, gsp.operation from gv$sql_plan gsp where gsp.options is not null group by gsp.options, gsp.operation order by count desc ) x US Options 8 80 1=1 ds.object_size/1000>:min_object_size_gb Number F Objets d'une taille supérieure à x Go US Objects larger than x GB 9 &show_object_size Y US Objects larger than x GB 10 90 &show_object_size Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Object Size