{"id":646,"date":"2016-04-24T22:40:59","date_gmt":"2016-04-25T01:40:59","guid":{"rendered":"http:\/\/dbtimewizard.com.br\/blog\/?p=646"},"modified":"2022-10-27T20:58:31","modified_gmt":"2022-10-27T23:58:31","slug":"como-modificar-um-plano-de-execucao-sem-alterar-a-instrucao-sql","status":"publish","type":"post","link":"http:\/\/dbtimewizard.com.br\/blog\/como-modificar-um-plano-de-execucao-sem-alterar-a-instrucao-sql\/","title":{"rendered":"Como modificar um plano de execu\u00e7\u00e3o sem alterar a instru\u00e7\u00e3o SQL?"},"content":{"rendered":"<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Quando estamos realizando um trabalho de tuning SQL muitas vezes nos deparamos com situa\u00e7\u00f5es em que n\u00e3o podemos alterar o c\u00f3digo da aplica\u00e7\u00e3o pois esta pertence a terceiros. Essa limita\u00e7\u00e3o\u00a0pode ser superada facilmente utilizando o recurso SQL PROFILE do banco Oracle, dispon\u00edvel a partir da vers\u00e3o 10g. Neste artigo vamos fazer uma demonstra\u00e7\u00e3o de uma situa\u00e7\u00e3o hipot\u00e9tica onde vamos utilizar SQL PROFILE para alterar o plano de execu\u00e7\u00e3o de uma instru\u00e7\u00e3o SQL sem alterar o c\u00f3digo da instru\u00e7\u00e3o.<\/span><\/p>\n<h2 style=\"text-align: justify;\"><span style=\"font-size: 14pt;\">Descri\u00e7\u00e3o da situa\u00e7\u00e3o hipot\u00e9tica<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"font-size: 12pt;\">Cen\u00e1rio:<\/span><\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">O fornecedor da Aplica\u00e7\u00e3o pede um prazo de seis meses para fazer qualquer altera\u00e7\u00e3o na aplica\u00e7\u00e3o.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">A aplica\u00e7\u00e3o \u00e9 antiga e quando foi escrita o fornecedor inseriu HINTs nas instru\u00e7\u00f5es SQL.<\/span><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong><span style=\"font-size: 12pt;\">Problema:<\/span><\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Existe uma consulta com um HINT FULL SCAN em uma tabela que impede o Otimizador de gerar um plano de execu\u00e7\u00e3o melhor.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"font-size: 12pt;\">Solu\u00e7\u00e3o:<\/span><\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Vamos utilizar o recurso de SQL PROFILE para permitir que Otimizador utilize um plano de execu\u00e7\u00e3o melhor.<\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 14pt;\">Simula\u00e7\u00e3o da situa\u00e7\u00e3o hipot\u00e9tica<\/span><\/h2>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">A seguir vamos simular uma instru\u00e7\u00e3o SQL que esta sendo executada num banco de dados Oracle com um HINT FULL SCAN, na sequ\u00eancia vamos criar uma SQL PROFILE dessa instru\u00e7\u00e3o, alterar a SQL PROFILE dessa instru\u00e7\u00e3o e comparar a efici\u00eancia dos dois planos de execu\u00e7\u00e3o.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Cria\u00e7\u00e3o das tabelas<\/span><\/h3>\n<p><span style=\"font-size: 12pt;\">Primeiro vamos criar 3 tabelas que ser\u00e3o utilizadas na consulta da nossa simula\u00e7\u00e3o:<\/span><br \/>\n&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/>47<br \/>48<br \/>49<br \/>50<br \/>51<br \/>52<br \/>53<br \/>54<br \/>55<br \/>56<br \/>57<br \/>58<br \/>59<br \/>60<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span> SELECT <span class=\"sy0\">*<\/span> FROM V<span class=\"re0\">$VERSION<\/span> where rownum <span class=\"sy0\">&lt;<\/span> <span class=\"nu0\">2<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nBANNER<br \/>\n<span class=\"sy0\">--------------------------------------------------------------------------------<\/span><br \/>\nOracle Database 11g Enterprise Edition Release 11<span class=\"sy0\">.<\/span>2<span class=\"sy0\">.<\/span>0<span class=\"sy0\">.<\/span>4<span class=\"sy0\">.<\/span>0 <span class=\"sy0\">-<\/span> Production<br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create table dbtw_segments <span class=\"kw1\">as<\/span> select <span class=\"sy0\">*<\/span> from dba_segments<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTable created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create index dbtw_seg_name on dbtw_segments<span class=\"br0\">&#40;<\/span>segment_name<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nIndex created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> <a href=\"http:\/\/www.php.net\/exec\"><span class=\"kw3\">exec<\/span><\/a> dbms_stats<span class=\"sy0\">.<\/span>gather_table_stats<span class=\"br0\">&#40;<\/span>ownname<span class=\"sy0\">=&gt;<\/span> USER<span class=\"sy0\">,<\/span> tabname<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'DBTW_SEGMENTS'<\/span><span class=\"sy0\">,<\/span> cascade<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">true<\/span><span class=\"sy0\">,<\/span> estimate_percent<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">null<\/span><span class=\"sy0\">,<\/span> method_opt<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'FOR ALL COLUMNS SIZE 254'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nPL<span class=\"sy0\">\/<\/span>SQL procedure successfully completed<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create table dbtw_objects <span class=\"kw1\">as<\/span> select <span class=\"sy0\">*<\/span> from dba_objects<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTable created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create index dbtw_obj_name on dbtw_objects<span class=\"br0\">&#40;<\/span>object_name<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nIndex created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create index dbtw_obj_owner on dbtw_objects<span class=\"br0\">&#40;<\/span>owner<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nIndex created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> <a href=\"http:\/\/www.php.net\/exec\"><span class=\"kw3\">exec<\/span><\/a> dbms_stats<span class=\"sy0\">.<\/span>gather_table_stats<span class=\"br0\">&#40;<\/span>ownname<span class=\"sy0\">=&gt;<\/span> USER<span class=\"sy0\">,<\/span> tabname<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'DBTW_OBJECTS'<\/span><span class=\"sy0\">,<\/span> cascade<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">true<\/span><span class=\"sy0\">,<\/span> estimate_percent<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">null<\/span><span class=\"sy0\">,<\/span> method_opt<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'FOR ALL COLUMNS SIZE 254'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nPL<span class=\"sy0\">\/<\/span>SQL procedure successfully completed<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create table dbtw_tables <span class=\"kw1\">as<\/span> select <span class=\"sy0\">*<\/span> from dba_tables<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTable created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> create index dbtw_tab_name on dbtw_tables<span class=\"br0\">&#40;<\/span>table_name<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nIndex created<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> <a href=\"http:\/\/www.php.net\/exec\"><span class=\"kw3\">exec<\/span><\/a> dbms_stats<span class=\"sy0\">.<\/span>gather_table_stats<span class=\"br0\">&#40;<\/span>ownname<span class=\"sy0\">=&gt;<\/span> USER<span class=\"sy0\">,<\/span> tabname<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'DBTW_TABLES'<\/span><span class=\"sy0\">,<\/span> cascade<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">true<\/span><span class=\"sy0\">,<\/span> estimate_percent<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">null<\/span><span class=\"sy0\">,<\/span> method_opt<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'FOR ALL COLUMNS SIZE 254'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nPL<span class=\"sy0\">\/<\/span>SQL procedure successfully completed<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Execu\u00e7\u00e3o da consulta<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Agora vamos executar a consulta com o HINT FULL SCAN e verificar o plano de execu\u00e7\u00e3o gerado pelo Otimizador.<\/span><\/p>\n<p>&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/>47<br \/>48<br \/>49<br \/>50<br \/>51<br \/>52<br \/>53<br \/>54<br \/>55<br \/>56<br \/>57<br \/>58<br \/>59<br \/>60<br \/>61<br \/>62<br \/>63<br \/>64<br \/>65<br \/>66<br \/>67<br \/>68<br \/>69<br \/>70<br \/>71<br \/>72<br \/>73<br \/>74<br \/>75<br \/>76<br \/>77<br \/>78<br \/>79<br \/>80<br \/>81<br \/>82<br \/>83<br \/>84<br \/>85<br \/>86<br \/>87<br \/>88<br \/>89<br \/>90<br \/>91<br \/>92<br \/>93<br \/>94<br \/>95<br \/>96<br \/>97<br \/>98<br \/>99<br \/>100<br \/>101<br \/>102<br \/>103<br \/>104<br \/>105<br \/>106<br \/>107<br \/>108<br \/>109<br \/>110<br \/>111<br \/>112<br \/>113<br \/>114<br \/>115<br \/>116<br \/>117<br \/>118<br \/>119<br \/>120<br \/>121<br \/>122<br \/>123<br \/>124<br \/>125<br \/>126<br \/>127<br \/>128<br \/>129<br \/>130<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span> ALTER SESSION SET statistics_level<span class=\"sy0\">=<\/span>ALL<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSession altered<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> select <span class=\"coMULTI\">\/*+ FULL(O) *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span> <a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;from dbtw_objects O<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_segments S<br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp; where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name<br \/>\n&nbsp; <span class=\"nu0\">6<\/span> &nbsp; &nbsp; and t<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name<br \/>\n&nbsp; <span class=\"nu0\">7<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\n&nbsp; <span class=\"nu0\">8<\/span> &nbsp; &nbsp; and o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span><br \/>\n&nbsp; <span class=\"nu0\">9<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTABLE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TABLESPACE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CREATED &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KB<br \/>\n<span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">---------<\/span> <span class=\"sy0\">----------<\/span><br \/>\nDEPT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nSALGRADE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\n<br \/>\n<span class=\"nu0\">6<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> column sql_id new_value m_sql_id<br \/>\nSQL<span class=\"sy0\">&gt;<\/span> column child_number new_value m_child_no<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> SELECT sql_id<span class=\"sy0\">,<\/span> child_number<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM v<span class=\"re0\">$sql<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; WHERE sql_text LIKE <span class=\"st_h\">'%FULL%'<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; AND sql_text LIKE <span class=\"st_h\">'%dbtw_objects%'<\/span><br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp; &nbsp; AND sql_text NOT LIKE <span class=\"st_h\">'%v$sql%'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSQL_ID &nbsp; &nbsp; &nbsp; &nbsp;CHILD_NUMBER<br \/>\n<span class=\"sy0\">-------------<\/span> <span class=\"sy0\">------------<\/span><br \/>\n4phc2ztdt60y6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span> SELECT <span class=\"sy0\">*<\/span><br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nold &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<span class=\"kw2\">new<\/span> &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'4phc2ztdt60y6'<\/span><span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">0<\/span><span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nPLAN_TABLE_OUTPUT<br \/>\n<span class=\"sy0\">------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nSQL_ID &nbsp;4phc2ztdt60y6<span class=\"sy0\">,<\/span> child number <span class=\"nu0\">0<\/span><br \/>\n<span class=\"sy0\">-------------------------------------<\/span><br \/>\nselect <span class=\"coMULTI\">\/*+ FULL(O) *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB &nbsp; from dbtw_objects O<span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp;dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp;dbtw_segments S &nbsp;where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name &nbsp; &nbsp;and<br \/>\nt<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\nand o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span> &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><br \/>\n<br \/>\nPlan <a href=\"http:\/\/www.php.net\/hash\"><span class=\"kw3\">hash<\/span><\/a> value<span class=\"sy0\">:<\/span> <span class=\"nu0\">2684391254<\/span><br \/>\n<br \/>\n<span class=\"sy0\">---------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> Id &nbsp;<span class=\"sy0\">|<\/span> Operation &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> Starts <span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span>E<span class=\"sy0\">-<\/span>Bytes<span class=\"sy0\">|<\/span> Cost <span class=\"br0\">&#40;<\/span><span class=\"sy0\">%<\/span>CPU<span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> A<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span> &nbsp; A<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> Buffers <span class=\"sy0\">|<\/span> Reads &nbsp;<span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">---------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span> SELECT STATEMENT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">355<\/span> <span class=\"br0\">&#40;<\/span><span class=\"nu0\">100<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">1269<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1239<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">355<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">1<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">05<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">1269<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1239<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">2<\/span> <span class=\"sy0\">|<\/span> &nbsp; NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">355<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">1<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">05<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">1263<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1239<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">3<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">74<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">353<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">1<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">05<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">1256<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1239<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS FULL &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_OBJECTS &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">234<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">346<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">1<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">05<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">1242<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1239<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS BY INDEX ROWID<span class=\"sy0\">|<\/span> DBTW_SEGMENTS <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">35<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">14<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_SEG_NAME <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">10<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_TAB_NAME <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">8<\/span> <span class=\"sy0\">|<\/span> &nbsp; TABLE ACCESS BY INDEX ROWID &nbsp;<span class=\"sy0\">|<\/span> DBTW_TABLES &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">27<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">---------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nQuery Block Name <span class=\"sy0\">\/<\/span> Object Alias <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-------------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> O<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n<br \/>\nOutline Data<br \/>\n<span class=\"sy0\">-------------<\/span><br \/>\n<br \/>\n&nbsp; <span class=\"coMULTI\">\/*+<br \/>\n&nbsp; &nbsp; &nbsp; BEGIN_OUTLINE_DATA<br \/>\n&nbsp; &nbsp; &nbsp; IGNORE_OPTIM_EMBEDDED_HINTS<br \/>\n&nbsp; &nbsp; &nbsp; OPTIMIZER_FEATURES_ENABLE('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; DB_VERSION('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; ALL_ROWS<br \/>\n&nbsp; &nbsp; &nbsp; OUTLINE_LEAF(@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; FULL(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; (&quot;DBTW_SEGMENTS&quot;.&quot;SEGMENT_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; INDEX(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot; (&quot;DBTW_TABLES&quot;.&quot;TABLE_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; LEADING(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; NLJ_BATCHING(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; END_OUTLINE_DATA<br \/>\n&nbsp; *\/<\/span><br \/>\n<br \/>\nPredicate Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">---------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OWNER&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'SCOTT'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_TYPE&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'TABLE'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nColumn Projection Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-----------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">2<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">3<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n<br \/>\n<br \/>\n<span class=\"nu0\">75<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Podemos observar que o plano de execu\u00e7\u00e3o gerado pelo Otimizador utiliza 3 opera\u00e7\u00f5es NESTED LOOPS e faz um FULL TABLE SCAN na tabela DBTW_OBJECTS, \u00e9 nesse momento que o plano de execu\u00e7\u00e3o fica oneroso pois esta opera\u00e7\u00e3o realiza 1242 leituras de Buffers de um total de 1269 Buffers lidos por todo o plano de execu\u00e7\u00e3o.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Cria\u00e7\u00e3o da SQL PROFILE manualmente<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Vamos utilizar o script &#8220;<strong>coe_xfr_sql_profile.sql<\/strong>&#8221; para gerar um script no diret\u00f3rio &#8220;c:\\temp&#8221;, ao executar esse script ser\u00e1 criada uma SQL PROFILE para a consulta acima:<\/span><\/p>\n<p>&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/>47<br \/>48<br \/>49<br \/>50<br \/>51<br \/>52<br \/>53<br \/>54<br \/>55<br \/>56<br \/>57<br \/>58<br \/>59<br \/>60<br \/>61<br \/>62<br \/>63<br \/>64<br \/>65<br \/>66<br \/>67<br \/>68<br \/>69<br \/>70<br \/>71<br \/>72<br \/>73<br \/>74<br \/>75<br \/>76<br \/>77<br \/>78<br \/>79<br \/>80<br \/>81<br \/>82<br \/>83<br \/>84<br \/>85<br \/>86<br \/>87<br \/>88<br \/>89<br \/>90<br \/>91<br \/>92<br \/>93<br \/>94<br \/>95<br \/>96<br \/>97<br \/>98<br \/>99<br \/>100<br \/>101<br \/>102<br \/>103<br \/>104<br \/>105<br \/>106<br \/>107<br \/>108<br \/>109<br \/>110<br \/>111<br \/>112<br \/>113<br \/>114<br \/>115<br \/>116<br \/>117<br \/>118<br \/>119<br \/>120<br \/>121<br \/>122<br \/>123<br \/>124<br \/>125<br \/>126<br \/>127<br \/>128<br \/>129<br \/>130<br \/>131<br \/>132<br \/>133<br \/>134<br \/>135<br \/>136<br \/>137<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span> <span class=\"sy0\">@<\/span>coe_xfr_sql_profile 4phc2ztdt60y6 <span class=\"nu0\">2684391254<\/span><br \/>\n<br \/>\nParameter <span class=\"nu0\">1<\/span><span class=\"sy0\">:<\/span><br \/>\nSQL_ID <span class=\"br0\">&#40;<\/span>required<span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\n<br \/>\n<br \/>\nPLAN_HASH_VALUE AVG_ET_SECS<br \/>\n<span class=\"sy0\">---------------<\/span> <span class=\"sy0\">-----------<\/span><br \/>\n&nbsp; &nbsp; &nbsp;<span class=\"nu0\">2684391254<\/span> &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu19\">.028<\/span><br \/>\n<br \/>\nParameter <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span><br \/>\nPLAN_HASH_VALUE <span class=\"br0\">&#40;<\/span>required<span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\n<br \/>\nValues passed<span class=\"sy0\">:<\/span><br \/>\n~~~~~~~~~~~~~<br \/>\nSQL_ID &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">:<\/span> <span class=\"st0\">&quot;4phc2ztdt60y6&quot;<\/span><br \/>\nPLAN_HASH_VALUE<span class=\"sy0\">:<\/span> <span class=\"st0\">&quot;2684391254&quot;<\/span><br \/>\n<br \/>\n<br \/>\nExecute coe_xfr_sql_profile_4phc2ztdt60y6_2684391254<span class=\"sy0\">.<\/span>sql<br \/>\non TARGET <a href=\"http:\/\/www.php.net\/system\"><span class=\"kw3\">system<\/span><\/a> in order to create a custom SQL Profile<br \/>\nwith plan <span class=\"nu0\">2684391254<\/span> linked to adjusted sql_text<span class=\"sy0\">.<\/span><br \/>\n<br \/>\n<br \/>\nCOE_XFR_SQL_PROFILE completed<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;@<\/span>c<span class=\"sy0\">:<\/span>\\temp\\coe_xfr_sql_profile_4phc2ztdt60y6_2684391254<span class=\"sy0\">.<\/span>sql<span class=\"sy0\">;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM <span class=\"re0\">$Header<\/span><span class=\"sy0\">:<\/span> <span class=\"nu19\">215187.1<\/span> coe_xfr_sql_profile_4phc2ztdt60y6_2684391254<span class=\"sy0\">.<\/span>sql 11<span class=\"sy0\">.<\/span>4<span class=\"sy0\">.<\/span>1<span class=\"sy0\">.<\/span>4 <span class=\"nu0\">2016<\/span><span class=\"sy0\">\/<\/span><span class=\"nu8\">04<\/span><span class=\"sy0\">\/<\/span><span class=\"nu0\">24<\/span> csierra $<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM Copyright <span class=\"br0\">&#40;<\/span>c<span class=\"br0\">&#41;<\/span> <span class=\"nu0\">2000<\/span><span class=\"sy0\">-<\/span><span class=\"nu0\">2010<\/span><span class=\"sy0\">,<\/span> Oracle Corporation<span class=\"sy0\">.<\/span> All rights reserved<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM AUTHOR<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; carlos<span class=\"sy0\">.<\/span>sierra<span class=\"sy0\">@<\/span>oracle<span class=\"sy0\">.<\/span>com<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM SCRIPT<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; coe_xfr_sql_profile_4phc2ztdt60y6_2684391254<span class=\"sy0\">.<\/span>sql<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM DESCRIPTION<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; This script is generated by coe_xfr_sql_profile<span class=\"sy0\">.<\/span>sql<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; It contains the SQL<span class=\"sy0\">*<\/span>Plus commands to create a custom<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; SQL Profile <span class=\"kw1\">for<\/span> SQL_ID 4phc2ztdt60y6 based on plan <a href=\"http:\/\/www.php.net\/hash\"><span class=\"kw3\">hash<\/span><\/a><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; value <span class=\"nu0\">2684391254<\/span><span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; The custom SQL Profile to be created by this script<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; will affect plans <span class=\"kw1\">for<\/span> SQL commands with signature<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; matching the one <span class=\"kw1\">for<\/span> SQL Text below<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; Review SQL Text and adjust accordingly<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM PARAMETERS<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; None<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM EXAMPLE<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; SQL<span class=\"sy0\">&gt;<\/span> START coe_xfr_sql_profile_4phc2ztdt60y6_2684391254<span class=\"sy0\">.<\/span>sql<span class=\"sy0\">;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM NOTES<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; <span class=\"nu0\">1<\/span><span class=\"sy0\">.<\/span> Should be run <span class=\"kw1\">as<\/span> <a href=\"http:\/\/www.php.net\/system\"><span class=\"kw3\">SYSTEM<\/span><\/a> or SYSDBA<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">.<\/span> User must have CREATE ANY SQL PROFILE privilege<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; <span class=\"nu0\">3<\/span><span class=\"sy0\">.<\/span> SOURCE and TARGET systems can be the same or similar<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; <span class=\"nu0\">4<\/span><span class=\"sy0\">.<\/span> To drop this custom SQL Profile after it has been created<span class=\"sy0\">:<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; &nbsp; &nbsp;<a href=\"http:\/\/www.php.net\/exec\"><span class=\"kw3\">EXEC<\/span><\/a> DBMS_SQLTUNE<span class=\"sy0\">.<\/span>DROP_SQL_PROFILE<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; <span class=\"nu0\">5<\/span><span class=\"sy0\">.<\/span> Be aware that using DBMS_SQLTUNE requires a license<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM &nbsp; &nbsp; &nbsp;<span class=\"kw1\">for<\/span> the Oracle Tuning <a href=\"http:\/\/www.php.net\/pack\"><span class=\"kw3\">Pack<\/span><\/a><span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>WHENEVER SQLERROR <a href=\"http:\/\/www.php.net\/exit\"><span class=\"kw3\">EXIT<\/span><\/a> SQL<span class=\"sy0\">.<\/span>SQLCODE<span class=\"sy0\">;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><span class=\"kw2\">VAR<\/span> signature NUMBER<span class=\"sy0\">;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>REM<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><span class=\"kw2\">DECLARE<\/span><br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp;sql_txt CLOB<span class=\"sy0\">;<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp;h &nbsp; &nbsp; &nbsp; SYS<span class=\"sy0\">.<\/span>SQLPROF_ATTR<span class=\"sy0\">;<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp;BEGIN<br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp;sql_txt <span class=\"sy0\">:=<\/span> q<span class=\"st_h\">'[<br \/>\n&nbsp; 6 &nbsp;select \/*+ FULL(O) *\/ t.table_name, t.TABLESPACE_NAME, O.CREATED, round(S.bytes\/1024) KB<br \/>\n&nbsp; 7 &nbsp;from dbtw_objects O,<br \/>\n&nbsp; 8 &nbsp;dbtw_tables T,<br \/>\n&nbsp; 9 &nbsp;dbtw_segments S<br \/>\n&nbsp;10 &nbsp;where o.object_name = t.table_name<br \/>\n&nbsp;11 &nbsp;and t.table_name = s.segment_name<br \/>\n&nbsp;12 &nbsp;and s.segment_name = o.object_name<br \/>\n&nbsp;13 &nbsp;and o.owner = '<\/span>SCOTT<span class=\"st_h\">'<br \/>\n&nbsp;14 &nbsp;and s.segment_type = '<\/span>TABLE<span class=\"st_h\">'<br \/>\n&nbsp;15 &nbsp;]'<\/span><span class=\"sy0\">;<\/span><br \/>\n&nbsp;<span class=\"nu0\">16<\/span> &nbsp;h <span class=\"sy0\">:=<\/span> SYS<span class=\"sy0\">.<\/span>SQLPROF_ATTR<span class=\"br0\">&#40;<\/span><br \/>\n&nbsp;<span class=\"nu0\">17<\/span> &nbsp;q<span class=\"st_h\">'[BEGIN_OUTLINE_DATA]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">18<\/span> &nbsp;q<span class=\"st_h\">'[IGNORE_OPTIM_EMBEDDED_HINTS]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">19<\/span> &nbsp;q<span class=\"st_h\">'[OPTIMIZER_FEATURES_ENABLE('<\/span>11<span class=\"sy0\">.<\/span>2<span class=\"sy0\">.<\/span>0<span class=\"sy0\">.<\/span>4<span class=\"st_h\">')]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">20<\/span> &nbsp;q<span class=\"st_h\">'[DB_VERSION('<\/span>11<span class=\"sy0\">.<\/span>2<span class=\"sy0\">.<\/span>0<span class=\"sy0\">.<\/span>4<span class=\"st_h\">')]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">21<\/span> &nbsp;q<span class=\"st_h\">'[ALL_ROWS]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">22<\/span> &nbsp;q<span class=\"st_h\">'[OUTLINE_LEAF(@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">23<\/span> &nbsp;q<span class=\"st_h\">'[FULL(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">24<\/span> &nbsp;q<span class=\"st_h\">'[INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; (&quot;DBTW_SEGMENTS&quot;.&quot;SEGMENT_NAME&quot;))]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">25<\/span> &nbsp;q<span class=\"st_h\">'[INDEX(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot; (&quot;DBTW_TABLES&quot;.&quot;TABLE_NAME&quot;))]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">26<\/span> &nbsp;q<span class=\"st_h\">'[LEADING(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">27<\/span> &nbsp;q<span class=\"st_h\">'[USE_NL(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">28<\/span> &nbsp;q<span class=\"st_h\">'[USE_NL(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">29<\/span> &nbsp;q<span class=\"st_h\">'[NLJ_BATCHING(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)]'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">30<\/span> &nbsp;q<span class=\"st_h\">'[END_OUTLINE_DATA]'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n&nbsp;<span class=\"nu0\">31<\/span> &nbsp;<span class=\"sy0\">:<\/span>signature <span class=\"sy0\">:=<\/span> DBMS_SQLTUNE<span class=\"sy0\">.<\/span>SQLTEXT_TO_SIGNATURE<span class=\"br0\">&#40;<\/span>sql_txt<span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n&nbsp;<span class=\"nu0\">32<\/span> &nbsp;DBMS_SQLTUNE<span class=\"sy0\">.<\/span>IMPORT_SQL_PROFILE <span class=\"br0\">&#40;<\/span><br \/>\n&nbsp;<span class=\"nu0\">33<\/span> &nbsp;sql_text &nbsp; &nbsp;<span class=\"sy0\">=&gt;<\/span> sql_txt<span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">34<\/span> &nbsp;profile &nbsp; &nbsp; <span class=\"sy0\">=&gt;<\/span> h<span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">35<\/span> &nbsp;name &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">36<\/span> &nbsp;description <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'coe 4phc2ztdt60y6 2684391254 '<\/span><span class=\"sy0\">||:<\/span>signature<span class=\"sy0\">||<\/span><span class=\"st_h\">''<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">37<\/span> &nbsp;category &nbsp; &nbsp;<span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'DEFAULT'<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">38<\/span> &nbsp;validate &nbsp; &nbsp;<span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">TRUE<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">39<\/span> &nbsp;replace &nbsp; &nbsp; <span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">TRUE<\/span><span class=\"sy0\">,<\/span><br \/>\n&nbsp;<span class=\"nu0\">40<\/span> &nbsp;force_match <span class=\"sy0\">=&gt;<\/span> <span class=\"kw4\">FALSE<\/span> <span class=\"coMULTI\">\/* TRUE:FORCE (match even when different literals in SQL). FALSE:EXACT (similar to CURSOR_SHARING) *\/<\/span> <span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\n&nbsp;<span class=\"nu0\">41<\/span> &nbsp;<a href=\"http:\/\/www.php.net\/end\"><span class=\"kw3\">END<\/span><\/a><span class=\"sy0\">;<\/span><br \/>\n&nbsp;<span class=\"nu0\">42<\/span> &nbsp;<span class=\"sy0\">\/<\/span><br \/>\n<br \/>\nPL<span class=\"sy0\">\/<\/span>SQL procedure successfully completed<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>WHENEVER SQLERROR <span class=\"kw1\">CONTINUE<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>SET <span class=\"kw1\">ECHO<\/span> OFF<span class=\"sy0\">;<\/span><br \/>\n<br \/>\n&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SIGNATURE<br \/>\n<span class=\"sy0\">---------------------<\/span><br \/>\n&nbsp; <span class=\"nu0\">9130450230344665996<\/span><br \/>\n<br \/>\n<br \/>\n<span class=\"sy0\">...<\/span> manual custom SQL Profile has been created<br \/>\n<br \/>\n<br \/>\nCOE_XFR_SQL_PROFILE_4phc2ztdt60y6_2684391254 completed<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>set lines <span class=\"nu0\">200<\/span> pages <span class=\"nu0\">100<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>select name<span class=\"sy0\">,<\/span> created<span class=\"sy0\">,<\/span> type<span class=\"sy0\">,<\/span> status from DBA_SQL_PROFILES<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nNAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CREATED &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TYPE &nbsp; &nbsp;STATUS<br \/>\n<span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">---------------------------------------------------------------------------<\/span> <span class=\"sy0\">-------<\/span> <span class=\"sy0\">--------<\/span><br \/>\ncoe_4phc2ztdt60y6_2684391254 &nbsp; <span class=\"nu0\">24<\/span><span class=\"sy0\">-<\/span>APR<span class=\"sy0\">-<\/span><span class=\"nu0\">16<\/span> 04<span class=\"sy0\">.<\/span>25<span class=\"sy0\">.<\/span>42<span class=\"sy0\">.<\/span>000000 PM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MANUAL &nbsp;ENABLED<br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Execu\u00e7\u00e3o da consulta sem HINT FULL SCAN<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Vamos executar a mesma consulta retirando o HINT FULL SCAN e verificar a qualidade do plano de execu\u00e7\u00e3o gerado:<\/span><\/p>\n<p>&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/>47<br \/>48<br \/>49<br \/>50<br \/>51<br \/>52<br \/>53<br \/>54<br \/>55<br \/>56<br \/>57<br \/>58<br \/>59<br \/>60<br \/>61<br \/>62<br \/>63<br \/>64<br \/>65<br \/>66<br \/>67<br \/>68<br \/>69<br \/>70<br \/>71<br \/>72<br \/>73<br \/>74<br \/>75<br \/>76<br \/>77<br \/>78<br \/>79<br \/>80<br \/>81<br \/>82<br \/>83<br \/>84<br \/>85<br \/>86<br \/>87<br \/>88<br \/>89<br \/>90<br \/>91<br \/>92<br \/>93<br \/>94<br \/>95<br \/>96<br \/>97<br \/>98<br \/>99<br \/>100<br \/>101<br \/>102<br \/>103<br \/>104<br \/>105<br \/>106<br \/>107<br \/>108<br \/>109<br \/>110<br \/>111<br \/>112<br \/>113<br \/>114<br \/>115<br \/>116<br \/>117<br \/>118<br \/>119<br \/>120<br \/>121<br \/>122<br \/>123<br \/>124<br \/>125<br \/>126<br \/>127<br \/>128<br \/>129<br \/>130<br \/>131<br \/>132<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span>ALTER SESSION SET statistics_level<span class=\"sy0\">=<\/span>ALL<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSession altered<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>select <span class=\"coMULTI\">\/* dbtw101 *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span> <a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;from dbtw_objects O<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_segments S<br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp; where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name<br \/>\n&nbsp; <span class=\"nu0\">6<\/span> &nbsp; &nbsp; and t<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name<br \/>\n&nbsp; <span class=\"nu0\">7<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\n&nbsp; <span class=\"nu0\">8<\/span> &nbsp; &nbsp; and o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span><br \/>\n&nbsp; <span class=\"nu0\">9<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTABLE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TABLESPACE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CREATED &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KB<br \/>\n<span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">---------<\/span> <span class=\"sy0\">----------<\/span><br \/>\nDEPT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nSALGRADE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\n<br \/>\n<span class=\"nu0\">6<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>column sql_id new_value m_sql_id<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>column child_number new_value m_child_no<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>SELECT sql_id<span class=\"sy0\">,<\/span> child_number<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM v<span class=\"re0\">$sql<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; WHERE sql_text LIKE <span class=\"st_h\">'%dbtw101%'<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; AND sql_text NOT LIKE <span class=\"st_h\">'%v$sql%'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSQL_ID &nbsp; &nbsp; &nbsp; &nbsp;CHILD_NUMBER<br \/>\n<span class=\"sy0\">-------------<\/span> <span class=\"sy0\">------------<\/span><br \/>\n491h6ndhvqucm &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>SELECT <span class=\"sy0\">*<\/span><br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nold &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<span class=\"kw2\">new<\/span> &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'491h6ndhvqucm'<\/span><span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">0<\/span><span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nPLAN_TABLE_OUTPUT<br \/>\n<span class=\"sy0\">-----------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nSQL_ID &nbsp;491h6ndhvqucm<span class=\"sy0\">,<\/span> child number <span class=\"nu0\">0<\/span><br \/>\n<span class=\"sy0\">-------------------------------------<\/span><br \/>\nselect <span class=\"coMULTI\">\/* dbtw101 *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB &nbsp; from dbtw_objects O<span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp;dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp;dbtw_segments S &nbsp;where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name &nbsp; &nbsp;and<br \/>\nt<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\nand o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span> &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><br \/>\n<br \/>\nPlan <a href=\"http:\/\/www.php.net\/hash\"><span class=\"kw3\">hash<\/span><\/a> value<span class=\"sy0\">:<\/span> <span class=\"nu0\">1886115670<\/span><br \/>\n<br \/>\n<span class=\"sy0\">----------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> Id &nbsp;<span class=\"sy0\">|<\/span> Operation &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> Starts <span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span>E<span class=\"sy0\">-<\/span>Bytes<span class=\"sy0\">|<\/span> Cost <span class=\"br0\">&#40;<\/span><span class=\"sy0\">%<\/span>CPU<span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> A<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span> &nbsp; A<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> Buffers <span class=\"sy0\">|<\/span> Reads &nbsp;<span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">----------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span> SELECT STATEMENT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> <span class=\"br0\">&#40;<\/span><span class=\"nu0\">100<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">32<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">32<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">2<\/span> <span class=\"sy0\">|<\/span> &nbsp; NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">26<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">3<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">74<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">9<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">19<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS BY INDEX ROWID<span class=\"sy0\">|<\/span> DBTW_OBJECTS &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">234<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">5<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_OBJ_OWNER <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">3<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS BY INDEX ROWID<span class=\"sy0\">|<\/span> DBTW_SEGMENTS &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">35<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">14<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_SEG_NAME &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">10<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_TAB_NAME &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">9<\/span> <span class=\"sy0\">|<\/span> &nbsp; TABLE ACCESS BY INDEX ROWID &nbsp;<span class=\"sy0\">|<\/span> DBTW_TABLES &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">27<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">----------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nQuery Block Name <span class=\"sy0\">\/<\/span> Object Alias <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-------------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> O<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> O<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">9<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n<br \/>\nOutline Data<br \/>\n<span class=\"sy0\">-------------<\/span><br \/>\n<br \/>\n&nbsp; <span class=\"coMULTI\">\/*+<br \/>\n&nbsp; &nbsp; &nbsp; BEGIN_OUTLINE_DATA<br \/>\n&nbsp; &nbsp; &nbsp; IGNORE_OPTIM_EMBEDDED_HINTS<br \/>\n&nbsp; &nbsp; &nbsp; OPTIMIZER_FEATURES_ENABLE('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; DB_VERSION('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; ALL_ROWS<br \/>\n&nbsp; &nbsp; &nbsp; OUTLINE_LEAF(@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; (&quot;DBTW_OBJECTS&quot;.&quot;OWNER&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; (&quot;DBTW_SEGMENTS&quot;.&quot;SEGMENT_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; INDEX(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot; (&quot;DBTW_TABLES&quot;.&quot;TABLE_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; LEADING(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; NLJ_BATCHING(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; END_OUTLINE_DATA<br \/>\n&nbsp; *\/<\/span><br \/>\n<br \/>\nPredicate Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">---------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OWNER&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'SCOTT'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_TYPE&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'TABLE'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nColumn Projection Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-----------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">2<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">3<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">9<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n<br \/>\n<br \/>\n<span class=\"nu0\">78<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">No plano de execu\u00e7\u00e3o acima podemos observar que o Otimizador passou a utilizar o \u00edndice DBTW_OBJ_OWNER para acessar a tabela DBTW_OBJECTS, essa altera\u00e7\u00e3o tornou o plano de execu\u00e7\u00e3o mais eficiente, na primeira execu\u00e7\u00e3o da consulta o plano de execu\u00e7\u00e3o leu 1269 Buffers, agora o plano de execu\u00e7\u00e3o leu somente 32 Buffers.<\/span><\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Altera\u00e7\u00e3o da SQL PROFILE<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Conseguimos identificar um plano de execu\u00e7\u00e3o mais eficiente para a nossa consulta, o grande desafio agora \u00e9 alterar a SQL PROFILE que criamos para que ela reproduza o plano de execu\u00e7\u00e3o acima.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Para garantir que o Otimizador despreze o HINT da instru\u00e7\u00e3o SQL precisamos alterar a SQL PROFILE criada ou seja vamos substituir a OUTLINE:<\/span><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"font-size: 12pt;\"> FULL(@&#8221;SEL$1&#8243; &#8220;O&#8221;@&#8221;SEL$1&#8221;) <\/span><\/strong><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">por <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\"><strong>INDEX_RS_ASC(@&#8221;SEL$1&#8243; &#8220;O&#8221;@&#8221;SEL$1&#8221; (&#8220;DBTW_OBJECTS&#8221;.&#8221;OWNER&#8221;))<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Para isso vamos utilizar o script &#8220;fix_sql_profile_hint.sql&#8221;.<\/span><\/p>\n<p>&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span>conn sys<span class=\"sy0\">\/<\/span>oracle<span class=\"sy0\">@<\/span>lab11 <span class=\"kw1\">as<\/span> sysdba<span class=\"sy0\">;<\/span><br \/>\nConectado<span class=\"sy0\">.<\/span><br \/>\nSQL<span class=\"sy0\">&gt;@<\/span>fix_sql_profile_hint<br \/>\nEnter value <span class=\"kw1\">for<\/span> profile_name<span class=\"sy0\">:<\/span> coe_4phc2ztdt60y6_2684391254<br \/>\nEnter value <span class=\"kw1\">for<\/span> bad_hint<span class=\"sy0\">:<\/span> FULL<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nEnter value <span class=\"kw1\">for<\/span> good_hint<span class=\"sy0\">:<\/span> INDEX_RS_ASC<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;DBTW_OBJECTS&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OWNER&quot;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">15<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'select replace(attr_val,'<\/span><span class=\"st_h\">'&amp;&amp;bad_hint'<\/span><span class=\"st_h\">','<\/span><span class=\"st_h\">'&amp;&amp;good_hint'<\/span><span class=\"st_h\">') as outline_hints '<\/span><span class=\"sy0\">||<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">15<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'select replace(attr_val,'<\/span><span class=\"st_h\">'FULL(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot;)'<\/span><span class=\"st_h\">','<\/span><span class=\"st_h\">'INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; (&quot;DBTW_OBJECTS&quot;.&quot;OWNER&quot;))'<\/span><span class=\"st_h\">') as outline_hints '<\/span><span class=\"sy0\">||<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">18<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'and name like ('<\/span><span class=\"st_h\">'&amp;&amp;profile_name'<\/span><span class=\"st_h\">') '<\/span><span class=\"sy0\">||<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">18<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'and name like ('<\/span><span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"st_h\">') '<\/span><span class=\"sy0\">||<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">27<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'select replace(hint,'<\/span><span class=\"st_h\">'&amp;&amp;bad_hint'<\/span><span class=\"st_h\">','<\/span><span class=\"st_h\">'&amp;&amp;good_hint'<\/span><span class=\"st_h\">') as outline_hints '<\/span><span class=\"sy0\">||<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">27<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'select replace(hint,'<\/span><span class=\"st_h\">'FULL(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot;)'<\/span><span class=\"st_h\">','<\/span><span class=\"st_h\">'INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; (&quot;DBTW_OBJECTS&quot;.&quot;OWNER&quot;))'<\/span><span class=\"st_h\">') as outline_hints '<\/span><span class=\"sy0\">||<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">36<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'and p.name like ('<\/span><span class=\"st_h\">'&amp;&amp;profile_name'<\/span><span class=\"st_h\">')) '<\/span><span class=\"sy0\">||<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">36<\/span><span class=\"sy0\">:<\/span> &nbsp; &nbsp;<span class=\"st_h\">'and p.name like ('<\/span><span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"st_h\">')) '<\/span><span class=\"sy0\">||<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">49<\/span><span class=\"sy0\">:<\/span> where name like <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;&amp;profile_name'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">49<\/span><span class=\"sy0\">:<\/span> where name like <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nantigo &nbsp;<span class=\"nu0\">60<\/span><span class=\"sy0\">:<\/span> <span class=\"sy0\">,<\/span> name <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'&amp;&amp;profile_name'<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">60<\/span><span class=\"sy0\">:<\/span> <span class=\"sy0\">,<\/span> name <span class=\"sy0\">=&gt;<\/span> <span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><br \/>\n<br \/>\nProcedimento PL<span class=\"sy0\">\/<\/span>SQL conclu\u00ed<span class=\"kw1\">do<\/span> com sucesso<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;@<\/span>sql_profile_hints11<br \/>\nInforme o valor para name<span class=\"sy0\">:<\/span> coe_4phc2ztdt60y6_2684391254<br \/>\nantigo &nbsp;<span class=\"nu0\">11<\/span><span class=\"sy0\">:<\/span> and p<span class=\"sy0\">.<\/span>name like nvl<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;name'<\/span><span class=\"sy0\">,<\/span>name<span class=\"br0\">&#41;<\/span><br \/>\nnovo &nbsp;<span class=\"nu0\">11<\/span><span class=\"sy0\">:<\/span> and p<span class=\"sy0\">.<\/span>name like nvl<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'coe_4phc2ztdt60y6_2684391254'<\/span><span class=\"sy0\">,<\/span>name<span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nHINT<br \/>\n<span class=\"sy0\">------------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\nBEGIN_OUTLINE_DATA<br \/>\nIGNORE_OPTIM_EMBEDDED_HINTS<br \/>\nOPTIMIZER_FEATURES_ENABLE<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'11.2.0.4'<\/span><span class=\"br0\">&#41;<\/span><br \/>\nDB_VERSION<span class=\"br0\">&#40;<\/span><span class=\"st_h\">'11.2.0.4'<\/span><span class=\"br0\">&#41;<\/span><br \/>\nALL_ROWS<br \/>\nOUTLINE_LEAF<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nINDEX_RS_ASC<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;DBTW_OBJECTS&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OWNER&quot;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nINDEX_RS_ASC<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;DBTW_SEGMENTS&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nINDEX<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;DBTW_TABLES&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nLEADING<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nUSE_NL<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nUSE_NL<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nNLJ_BATCHING<span class=\"br0\">&#40;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">@<\/span><span class=\"st0\">&quot;SEL<span class=\"es4\">$1<\/span>&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\nEND_OUTLINE_DATA<br \/>\n<br \/>\n<span class=\"nu0\">14<\/span> linhas selecionadas<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<h3 style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Execu\u00e7\u00e3o da consulta novamente<\/span><\/h3>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Criamos manualmente a SQL Profile da consulta com o HINT FULL SCAN, alteramos a SQL Profile para que ela despreze o HINT e utilize um \u00edndice para acessar a tabela, agora vamos executar a consulta novamente e verificar se a SQL Profile vai ser utilizada.<\/span><\/p>\n<p>&nbsp;<\/p>\n<div class=\"codecolorer-container php default codecolorer-noborder\" style=\"overflow:auto;white-space:nowrap;width:800px;height:520px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/>2<br \/>3<br \/>4<br \/>5<br \/>6<br \/>7<br \/>8<br \/>9<br \/>10<br \/>11<br \/>12<br \/>13<br \/>14<br \/>15<br \/>16<br \/>17<br \/>18<br \/>19<br \/>20<br \/>21<br \/>22<br \/>23<br \/>24<br \/>25<br \/>26<br \/>27<br \/>28<br \/>29<br \/>30<br \/>31<br \/>32<br \/>33<br \/>34<br \/>35<br \/>36<br \/>37<br \/>38<br \/>39<br \/>40<br \/>41<br \/>42<br \/>43<br \/>44<br \/>45<br \/>46<br \/>47<br \/>48<br \/>49<br \/>50<br \/>51<br \/>52<br \/>53<br \/>54<br \/>55<br \/>56<br \/>57<br \/>58<br \/>59<br \/>60<br \/>61<br \/>62<br \/>63<br \/>64<br \/>65<br \/>66<br \/>67<br \/>68<br \/>69<br \/>70<br \/>71<br \/>72<br \/>73<br \/>74<br \/>75<br \/>76<br \/>77<br \/>78<br \/>79<br \/>80<br \/>81<br \/>82<br \/>83<br \/>84<br \/>85<br \/>86<br \/>87<br \/>88<br \/>89<br \/>90<br \/>91<br \/>92<br \/>93<br \/>94<br \/>95<br \/>96<br \/>97<br \/>98<br \/>99<br \/>100<br \/>101<br \/>102<br \/>103<br \/>104<br \/>105<br \/>106<br \/>107<br \/>108<br \/>109<br \/>110<br \/>111<br \/>112<br \/>113<br \/>114<br \/>115<br \/>116<br \/>117<br \/>118<br \/>119<br \/>120<br \/>121<br \/>122<br \/>123<br \/>124<br \/>125<br \/>126<br \/>127<br \/>128<br \/>129<br \/>130<br \/>131<br \/>132<br \/>133<br \/>134<br \/>135<br \/>136<br \/>137<br \/>138<br \/>139<br \/>140<br \/>141<br \/>142<br \/><\/div><\/td><td><div class=\"php codecolorer\">SQL<span class=\"sy0\">&gt;<\/span>ALTER <a href=\"http:\/\/www.php.net\/system\"><span class=\"kw3\">SYSTEM<\/span><\/a> <a href=\"http:\/\/www.php.net\/flush\"><span class=\"kw3\">FLUSH<\/span><\/a> SHARED_POOL<span class=\"sy0\">;<\/span><br \/>\n<br \/>\n<a href=\"http:\/\/www.php.net\/system\"><span class=\"kw3\">System<\/span><\/a> altered<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>ALTER SESSION SET statistics_level<span class=\"sy0\">=<\/span>ALL<span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSession altered<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>select <span class=\"coMULTI\">\/*+ FULL(O) *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span> <a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;from dbtw_objects O<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; &nbsp; &nbsp; dbtw_segments S<br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp; where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name<br \/>\n&nbsp; <span class=\"nu0\">6<\/span> &nbsp; &nbsp; and t<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name<br \/>\n&nbsp; <span class=\"nu0\">7<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\n&nbsp; <span class=\"nu0\">8<\/span> &nbsp; &nbsp; and o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span><br \/>\n&nbsp; <span class=\"nu0\">9<\/span> &nbsp; &nbsp; and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nTABLE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TABLESPACE_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CREATED &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; KB<br \/>\n<span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">------------------------------<\/span> <span class=\"sy0\">---------<\/span> <span class=\"sy0\">----------<\/span><br \/>\nDEPT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nEMP &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\nSALGRADE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">25<\/span><span class=\"sy0\">-<\/span>AUG<span class=\"sy0\">-<\/span><span class=\"nu0\">13<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">64<\/span><br \/>\n<br \/>\n<span class=\"nu0\">6<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>column sql_id new_value m_sql_id<br \/>\nSQL<span class=\"sy0\">&gt;<\/span>column child_number new_value m_child_no<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>SELECT sql_id<span class=\"sy0\">,<\/span> child_number<br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM v<span class=\"re0\">$sql<\/span><br \/>\n&nbsp; <span class=\"nu0\">3<\/span> &nbsp; WHERE sql_text LIKE <span class=\"st_h\">'%FULL%'<\/span><br \/>\n&nbsp; <span class=\"nu0\">4<\/span> &nbsp; &nbsp; AND sql_text LIKE <span class=\"st_h\">'%dbtw_objects%'<\/span><br \/>\n&nbsp; <span class=\"nu0\">5<\/span> &nbsp; &nbsp; AND sql_text NOT LIKE <span class=\"st_h\">'%v$sql%'<\/span><span class=\"sy0\">;<\/span><br \/>\n<br \/>\nSQL_ID &nbsp; &nbsp; &nbsp; &nbsp;CHILD_NUMBER<br \/>\n<span class=\"sy0\">-------------<\/span> <span class=\"sy0\">------------<\/span><br \/>\n4phc2ztdt60y6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"nu0\">0<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span><br \/>\nSQL<span class=\"sy0\">&gt;<\/span>SELECT <span class=\"sy0\">*<\/span><br \/>\n&nbsp; <span class=\"nu0\">2<\/span> &nbsp; &nbsp;FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">;<\/span><br \/>\nold &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'&amp;m_sql_id'<\/span><span class=\"sy0\">,&amp;<\/span>m_child_no<span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<span class=\"kw2\">new<\/span> &nbsp; <span class=\"nu0\">2<\/span><span class=\"sy0\">:<\/span> &nbsp; FROM TABLE <span class=\"br0\">&#40;<\/span>dbms_xplan<span class=\"sy0\">.<\/span>display_cursor <span class=\"br0\">&#40;<\/span><span class=\"st_h\">'4phc2ztdt60y6'<\/span><span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"nu0\">0<\/span><span class=\"sy0\">,<\/span><span class=\"st_h\">'advanced iostats last'<\/span><span class=\"br0\">&#41;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nPLAN_TABLE_OUTPUT<br \/>\n<span class=\"sy0\">--------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nSQL_ID &nbsp;4phc2ztdt60y6<span class=\"sy0\">,<\/span> child number <span class=\"nu0\">0<\/span><br \/>\n<span class=\"sy0\">-------------------------------------<\/span><br \/>\nselect <span class=\"coMULTI\">\/*+ FULL(O) *\/<\/span> t<span class=\"sy0\">.<\/span>table_name<span class=\"sy0\">,<\/span> t<span class=\"sy0\">.<\/span>TABLESPACE_NAME<span class=\"sy0\">,<\/span> O<span class=\"sy0\">.<\/span>CREATED<span class=\"sy0\">,<\/span><br \/>\n<a href=\"http:\/\/www.php.net\/round\"><span class=\"kw3\">round<\/span><\/a><span class=\"br0\">&#40;<\/span>S<span class=\"sy0\">.<\/span>bytes<span class=\"sy0\">\/<\/span><span class=\"nu0\">1024<\/span><span class=\"br0\">&#41;<\/span> KB &nbsp; from dbtw_objects O<span class=\"sy0\">,<\/span> &nbsp; &nbsp; &nbsp; &nbsp;dbtw_tables T<span class=\"sy0\">,<\/span><br \/>\n&nbsp; &nbsp;dbtw_segments S &nbsp;where o<span class=\"sy0\">.<\/span>object_name <span class=\"sy0\">=<\/span> t<span class=\"sy0\">.<\/span>table_name &nbsp; &nbsp;and<br \/>\nt<span class=\"sy0\">.<\/span>table_name <span class=\"sy0\">=<\/span> s<span class=\"sy0\">.<\/span>segment_name &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_name <span class=\"sy0\">=<\/span> o<span class=\"sy0\">.<\/span>object_name<br \/>\nand o<span class=\"sy0\">.<\/span>owner <span class=\"sy0\">=<\/span> <span class=\"st_h\">'SCOTT'<\/span> &nbsp; &nbsp;and s<span class=\"sy0\">.<\/span>segment_type <span class=\"sy0\">=<\/span> <span class=\"st_h\">'TABLE'<\/span><br \/>\n<br \/>\nPlan <a href=\"http:\/\/www.php.net\/hash\"><span class=\"kw3\">hash<\/span><\/a> value<span class=\"sy0\">:<\/span> <span class=\"nu0\">1886115670<\/span><br \/>\n<br \/>\n<span class=\"sy0\">-------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> Id &nbsp;<span class=\"sy0\">|<\/span> Operation &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> Starts <span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span>E<span class=\"sy0\">-<\/span>Bytes<span class=\"sy0\">|<\/span> Cost <span class=\"br0\">&#40;<\/span><span class=\"sy0\">%<\/span>CPU<span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> E<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> A<span class=\"sy0\">-<\/span>Rows <span class=\"sy0\">|<\/span> &nbsp; A<span class=\"sy0\">-<\/span><a href=\"http:\/\/www.php.net\/time\"><span class=\"kw3\">Time<\/span><\/a> &nbsp; <span class=\"sy0\">|<\/span> Buffers <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">-------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">0<\/span> <span class=\"sy0\">|<\/span> SELECT STATEMENT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> <span class=\"br0\">&#40;<\/span><span class=\"nu0\">100<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">32<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">32<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">2<\/span> <span class=\"sy0\">|<\/span> &nbsp; NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">101<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">11<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">26<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">3<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;NESTED LOOPS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">74<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">9<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">19<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS BY INDEX ROWID<span class=\"sy0\">|<\/span> DBTW_OBJECTS &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">234<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">5<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_OBJ_OWNER <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">3<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; TABLE ACCESS BY INDEX ROWID<span class=\"sy0\">|<\/span> DBTW_SEGMENTS &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">35<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">14<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_SEG_NAME &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">10<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|*<\/span> &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;INDEX <a href=\"http:\/\/www.php.net\/range\"><span class=\"kw3\">RANGE<\/span><\/a> SCAN &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span class=\"sy0\">|<\/span> DBTW_TAB_NAME &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">1<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">7<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">|<\/span> &nbsp; <span class=\"nu0\">9<\/span> <span class=\"sy0\">|<\/span> &nbsp; TABLE ACCESS BY INDEX ROWID &nbsp;<span class=\"sy0\">|<\/span> DBTW_TABLES &nbsp; &nbsp;<span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp;<span class=\"nu0\">27<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; <span class=\"nu0\">2<\/span> &nbsp; <span class=\"br0\">&#40;<\/span><span class=\"nu0\">0<\/span><span class=\"br0\">&#41;<\/span><span class=\"sy0\">|<\/span> <span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu8\">00<\/span><span class=\"sy0\">:<\/span><span class=\"nu19\">00.01<\/span> <span class=\"sy0\">|<\/span> &nbsp; &nbsp; &nbsp; <span class=\"nu0\">6<\/span> <span class=\"sy0\">|<\/span><br \/>\n<span class=\"sy0\">-------------------------------------------------------------------------------------------------------------------------------------------<\/span><br \/>\n<br \/>\nQuery Block Name <span class=\"sy0\">\/<\/span> Object Alias <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-------------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> O<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> O<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> S<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">9<\/span> <span class=\"sy0\">-<\/span> SEL$<span class=\"nu19\">1<\/span> <span class=\"sy0\">\/<\/span> T<span class=\"sy0\">@<\/span>SEL$<span class=\"nu19\">1<\/span><br \/>\n<br \/>\nOutline Data<br \/>\n<span class=\"sy0\">-------------<\/span><br \/>\n<br \/>\n&nbsp; <span class=\"coMULTI\">\/*+<br \/>\n&nbsp; &nbsp; &nbsp; BEGIN_OUTLINE_DATA<br \/>\n&nbsp; &nbsp; &nbsp; IGNORE_OPTIM_EMBEDDED_HINTS<br \/>\n&nbsp; &nbsp; &nbsp; OPTIMIZER_FEATURES_ENABLE('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; DB_VERSION('11.2.0.4')<br \/>\n&nbsp; &nbsp; &nbsp; ALL_ROWS<br \/>\n&nbsp; &nbsp; &nbsp; OUTLINE_LEAF(@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; (&quot;DBTW_OBJECTS&quot;.&quot;OWNER&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; INDEX_RS_ASC(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; (&quot;DBTW_SEGMENTS&quot;.&quot;SEGMENT_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; INDEX(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot; (&quot;DBTW_TABLES&quot;.&quot;TABLE_NAME&quot;))<br \/>\n&nbsp; &nbsp; &nbsp; LEADING(@&quot;SEL$1&quot; &quot;O&quot;@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;S&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; USE_NL(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; NLJ_BATCHING(@&quot;SEL$1&quot; &quot;T&quot;@&quot;SEL$1&quot;)<br \/>\n&nbsp; &nbsp; &nbsp; END_OUTLINE_DATA<br \/>\n&nbsp; *\/<\/span><br \/>\n<br \/>\nPredicate Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">---------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OWNER&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'SCOTT'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_TYPE&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st_h\">'TABLE'<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> access<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n&nbsp; &nbsp; &nbsp; &nbsp;filter<span class=\"br0\">&#40;<\/span><span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"sy0\">=<\/span><span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#41;<\/span><br \/>\n<br \/>\nColumn Projection Information <span class=\"br0\">&#40;<\/span>identified by operation id<span class=\"br0\">&#41;<\/span><span class=\"sy0\">:<\/span><br \/>\n<span class=\"sy0\">-----------------------------------------------------------<\/span><br \/>\n<br \/>\n&nbsp; &nbsp;<span class=\"nu0\">1<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">2<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">3<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">4<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;OBJECT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">128<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;CREATED&quot;<\/span><span class=\"br0\">&#91;<\/span><a href=\"http:\/\/www.php.net\/date\"><span class=\"kw3\">DATE<\/span><\/a><span class=\"sy0\">,<\/span><span class=\"nu0\">7<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">5<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;O&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">6<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;BYTES&quot;<\/span><span class=\"br0\">&#91;<\/span>NUMBER<span class=\"sy0\">,<\/span><span class=\"nu0\">22<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">7<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;S&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;SEGMENT_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">81<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">8<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span>ROWID<span class=\"br0\">&#91;<\/span>ROWID<span class=\"sy0\">,<\/span><span class=\"nu0\">10<\/span><span class=\"br0\">&#93;<\/span><span class=\"sy0\">,<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n&nbsp; &nbsp;<span class=\"nu0\">9<\/span> <span class=\"sy0\">-<\/span> <span class=\"st0\">&quot;T&quot;<\/span><span class=\"sy0\">.<\/span><span class=\"st0\">&quot;TABLESPACE_NAME&quot;<\/span><span class=\"br0\">&#91;<\/span>VARCHAR2<span class=\"sy0\">,<\/span><span class=\"nu0\">30<\/span><span class=\"br0\">&#93;<\/span><br \/>\n<br \/>\nNote<br \/>\n<span class=\"sy0\">-----<\/span><br \/>\n&nbsp; &nbsp;<span class=\"sy0\">-<\/span> SQL profile coe_4phc2ztdt60y6_2684391254 used <span class=\"kw1\">for<\/span> this statement<br \/>\n<br \/>\n<br \/>\n<span class=\"nu0\">82<\/span> rows selected<span class=\"sy0\">.<\/span><br \/>\n<br \/>\nSQL<span class=\"sy0\">&gt;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<p>&nbsp;<\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Podemos verificar que a consulta utilizou a SQL PROFILE, na linha 137 da log acima na se\u00e7\u00e3o NOTE temos um coment\u00e1rio que indica isso e o Otimizador ignorou o HINT de FULL SCAN na tabela DBTW_OBJECTS, pois ele utilizou as OUTLINE DATA da SQL PROFILE para montar o plano de execu\u00e7\u00e3o que utilizou o \u00edndice para acessar as linhas da tabela.<\/span><\/p>\n<h2><span style=\"font-size: 14pt;\">Conclus\u00e3o<\/span><\/h2>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">A utiliza\u00e7\u00e3o do recurso SQL Profile no processo de Tuning abre um leque de possibilidades, esse recurso agiliza o processo de Tuning pois n\u00e3o necessita de altera\u00e7\u00e3o no c\u00f3digo da aplica\u00e7\u00e3o para ajudar o Otimizador a montar planos de execu\u00e7\u00e3o mais eficientes. <\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-size: 12pt;\">Recomendamos que esse processo de Tuning seja aplicado primeiro num ambiente de Homologa\u00e7\u00e3o antes de aplicar em Produ\u00e7\u00e3o.<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 14pt;\">Scripts<\/span><\/h2>\n<p><strong><span style=\"font-size: 12pt;\"><a href=\"http:\/\/dbtimewizard.com.br\/blog\/scripts\/coe_xfr_sql_profile.pdf\" target=\"_blank\" rel=\"noopener\">coe_xfr_sql_profile<\/a><\/span><\/strong><\/p>\n<p><strong><span style=\"font-size: 12pt;\"><a href=\"http:\/\/dbtimewizard.com.br\/blog\/scripts\/fix_sql_profile_hint.pdf\" target=\"_blank\" rel=\"noopener\">fix_sql_profile_hint<\/a><\/span><\/strong><\/p>\n<p><strong><span style=\"font-size: 12pt;\"><a href=\"http:\/\/dbtimewizard.com.br\/blog\/scripts\/sql_profile_hints11.pdf\" target=\"_blank\" rel=\"noopener\">sql_profile_hints11<\/a><\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span style=\"font-size: 14pt;\">Refer\u00eancias<\/span><\/h2>\n<p><strong><span style=\"font-size: 12pt;\"><a href=\"http:\/\/kerryosborne.oracle-guy.com\/2009\/07\/why-isnt-oracle-using-my-outline-profile-baseline\/\" target=\"_blank\" rel=\"noopener\">http:\/\/kerryosborne.oracle-guy.com\/2009\/07\/why-isnt-oracle-using-my-outline-profile-baseline\/<\/a><\/span><\/strong><\/p>\n<p><strong><span style=\"font-size: 12pt;\"><a href=\"https:\/\/carlos-sierra.net\/2012\/04\/09\/custom-sql-profile-and-plan-stability-on-10g\/\" target=\"_blank\" rel=\"noopener\">https:\/\/carlos-sierra.net\/2012\/04\/09\/custom-sql-profile-and-plan-stability-on-10g\/<\/a><\/span><\/strong><\/p>\n<p>&nbsp;<br \/>\n&nbsp;<br \/>\n<a href=\"http:\/\/dbtimewizard.com.br\/treinamento\/\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1255\" src=\"http:\/\/dbtimewizard.com.br\/blog\/wp-content\/uploads\/2018\/10\/promo_cur02.jpg\" alt=\"Promo-D75L\" width=\"330\" height=\"242\" \/><\/a><\/p>\n<p><a href=\"https:\/\/youtu.be\/l6OphhTle9I\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright size-full wp-image-1215\" src=\"http:\/\/dbtimewizard.com.br\/wp-content\/uploads\/2018\/01\/video-02-300x168.jpg\" alt=\"video-02\" width=\"330\" height=\"242\" \/><\/a><br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<br \/>\n&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quando estamos realizando um trabalho de tuning SQL muitas vezes nos deparamos com situa\u00e7\u00f5es em que n\u00e3o podemos alterar o c\u00f3digo da aplica\u00e7\u00e3o pois esta pertence a terceiros. Essa limita\u00e7\u00e3o\u00a0pode ser superada facilmente utilizando o recurso SQL PROFILE do banco Oracle, dispon\u00edvel a partir da vers\u00e3o 10g. Neste artigo vamos fazer uma demonstra\u00e7\u00e3o de uma situa\u00e7\u00e3o hipot\u00e9tica onde vamos utilizar<\/p>\n","protected":false},"author":2,"featured_media":647,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[115],"tags":[6,42,10,118],"class_list":["post-646","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-profile","tag-cbo","tag-cost-base-optimizer","tag-otimizador","tag-sql-profile"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/comments?post=646"}],"version-history":[{"count":23,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/646\/revisions"}],"predecessor-version":[{"id":2375,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/646\/revisions\/2375"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media\/647"}],"wp:attachment":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media?parent=646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/categories?post=646"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/tags?post=646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}