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 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 49A8B1A803AA08ACE0530100007FEB91 select dhsp.sql_id, dhsp.plan_hash_value, xxen_util.client_time(dhsp.timestamp) timestamp, lpad(' ',dhsp.depth*2)||dhsp.operation|| case when dhsp.options is not null then ' '||dhsp.options end|| case when dhsp.object_name is not null then ' '||dhsp.object_type||' '||dhsp.object_owner||'.'||dhsp.object_name end operation, dhsp.qblock_name query_block, lpad(' ',dhsp.depth)||dhsp.depth depth, dhsp.cardinality, dhsp.bytes/1000000 mb, dhsp.time, dhsp.cost, dhsp.cpu_cost, dhsp.io_cost, dhsp.id, dhsp.parent_id, ds.object_size from dba_hist_sql_plan dhsp, ( 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 dhsp.object_owner=ds.owner(+) and case when dhsp.object_type like '% %' then substr(dhsp.object_type,1,instr(dhsp.object_type,' ')) else dhsp.object_type end=ds.segment_type(+) and dhsp.object_name=ds.segment_name(+) order by dhsp.sql_id, dhsp.sql_id, dhsp.timestamp desc, dhsp.plan_hash_value, dhsp.id, dhsp.position Y #,##0 :SQL_Id is not null or :Plan_Hash_Value 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 AWR SQL Execution Plan History محفوظات خطة التنفيذ لمعرف SQL معين من مخزن حمل العمل التلقائي D DBA AWR SQL Execution Plan History Ausführungsplanverlauf für eine bestimmte SQL-ID aus dem automatischen Workload-Repository E DBA AWR SQL Execution Plan History Historial del plan de ejecución para un id de SQL concreto desde el repositorio automático de cargas de trabajo F DBA AWR SQL Execution Plan History Historique du plan d'exécution pour un identifiant SQL particulier du référentiel automatique des charges de travail I DBA AWR SQL Execution Plan History Storia del piano di esecuzione per un particolare id SQL dal repository automatico del carico di lavoro JA DBA AWR SQL Execution Plan History 自動ワークロードリポジトリからの特定の SQL id の実行計画の履歴 KO DBA AWR SQL Execution Plan History 자동 워크로드 저장소에서 특정 SQL ID에 대한 실행 계획 기록 PTB DBA AWR SQL Execution Plan History Histórico do plano de execução de um determinado id SQL do repositório automático de carga de trabalho RU DBA AWR SQL Execution Plan History История плана выполнения для конкретного SQL-идентификатора из репозитория автоматической загрузки S DBA AWR SQL Execution Plan History Exekveringsplanhistorik för ett visst SQL-id från det automatiska arbetsbelastningsförvaret TR DBA AWR SQL Execution Plan History Otomatik iş yükü havuzundan belirli bir SQL kimliği için yürütme planı geçmişi US DBA AWR SQL Execution Plan History Execution plan history for a particular SQL id from the automatic workload repository ZHS DBA AWR SQL Execution Plan History 自动工作负载库中特定SQL id的执行计划历史记录。 Diagnostic Pack Enginatics &show_object_size 1=1 1 10 1=1 dhsp.sql_id=:sql_id Char F Id. SQL US SQL Id 2 20 1=1 dhsp.plan_hash_value=:plan_hash_value LOV custom Y select distinct dhsp.plan_hash_value value, dhsp.timestamp description from dba_hist_sql_plan dhsp where dhsp.sql_id=:$flex$.sql_id and dhsp.dbid=(select vd.dbid from v$database vd) order by dhsp.timestamp desc F Valeur de hachage du plan US Plan Hash Value 3 30 1=1 (dhsp.sql_id,dhsp.plan_hash_value) in (select dhsp0.sql_id, dhsp0.plan_hash_value from dba_hist_sql_plan dhsp0 where dhsp0.object_name=:index_name and dhsp0.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 4 40 1=1 dhsp.object_name=:object_name LOV custom Y select distinct dhsp.object_name value, dhsp.object_owner description from dba_hist_sql_plan dhsp where dhsp.dbid=(select vd.dbid from v$database vd) order by dhsp.object_name, dhsp.object_owner F Nom de l'objet US Object Name 5 50 1=1 dhsp.options like :options||'%' LOV custom Y select x.options value, x.operation description from ( select count(*) count, dhsp.options, dhsp.operation from dba_hist_sql_plan dhsp where dhsp.options is not null and dhsp.dbid=(select vd.dbid from v$database vd) group by dhsp.options, dhsp.operation order by count desc ) x US Options 6 60 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 7 &show_object_size Y US Objects larger than x GB 8 70 &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 9 200 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 10 210 1=1 dhsp.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 11 1=1 dhsp.dbid=(select vd.con_dbid from v$database vd) Current PDB F Données sur les conteneurs US Container Data :$flex$.sql_id SQL Id Plan Hash Value