{"id":20,"date":"2015-11-08T15:33:54","date_gmt":"2015-11-08T17:33:54","guid":{"rendered":"http:\/\/dbtimewizard.com.br\/blog\/?p=20"},"modified":"2019-11-11T19:05:23","modified_gmt":"2019-11-11T22:05:23","slug":"dbms_xplan-voce-sabe-usar-esse-extraordinario-pacote","status":"publish","type":"post","link":"http:\/\/dbtimewizard.com.br\/blog\/dbms_xplan-voce-sabe-usar-esse-extraordinario-pacote\/","title":{"rendered":"DBMS_XPLAN: voc\u00ea sabe usar esse extraordin\u00e1rio pacote?"},"content":{"rendered":"

O pacote DBMS_XPLAN fornece uma maneira f\u00e1cil para exibir o plano de execu\u00e7\u00e3o em v\u00e1rios formatos pr\u00e9-definidos, essa flexibilidade e o n\u00edvel de detalhes estat\u00edsticos que o pacote oferece o torna uma ferramenta imprescind\u00edvel num processo de tuning de uma instru\u00e7\u00e3o SQL.<\/span><\/p>\n

Voc\u00ea pode usar o pacote para exibir uma estimativa de plano a partir do comando “Explain Plan”, ou para exibir um plano real que foi executado pelo otimizador e as informa\u00e7\u00f5es foram armazenadas em “SQL Cursors”, ou ainda para exibir um plano que foi executado a alguns dias e as informa\u00e7\u00f5es est\u00e3o armazenadas no Automatic Workload Repository (AWR).<\/span><\/p>\n

Vis\u00e3o geral <\/span><\/h2>\n

O pacote DBMS_XPLAN fornece cinco fun\u00e7\u00f5es de tabela:<\/span><\/p>\n

    \n
  1. DISPLAY – para formatar e exibir o conte\u00fado de uma “plan table”.<\/span><\/li>\n
  2. DISPLAY_AWR – para formatar e exibir o conte\u00fado do plano de execu\u00e7\u00e3o de uma instru\u00e7\u00e3o SQL armazenado no AWR.<\/span><\/li>\n
  3. DISPLAY_CURSOR – para formatar e exibir o conte\u00fado do plano de execu\u00e7\u00e3o de qualquer cursor na mem\u00f3ria da inst\u00e2ncia do banco.<\/span><\/li>\n
  4. DISPLAY_SQL_PLAN_BASELINE – para apresentar um ou mais planos de execu\u00e7\u00e3o para a instru\u00e7\u00e3o SQL identificado pelo “SQL handle”. <\/span><\/li>\n
  5. DISPLAY_SQLSET – para formatar e exibir o conte\u00fado do plano de execu\u00e7\u00e3o de instru\u00e7\u00f5es armazenadas em um “SQL tuning set”.<\/span><\/li>\n<\/ol>\n

    Neste post vamos explorar em mais detalhes a fun\u00e7\u00e3o DISPLAY_CURSOR, pois ela permite a visualiza\u00e7\u00e3o do plano de execu\u00e7\u00e3o de uma instru\u00e7\u00e3o SQL que realmente foi utilizada pelo otimizador. Algumas ferramentas utilizadas por profissionais de Tuning podem em algumas situa\u00e7\u00f5es exibir um plano diferente do plano de execu\u00e7\u00e3o utilizado pelo otimizador.<\/a><\/span><\/p>\n

    Fun\u00e7\u00e3o DISPLAY_CURSOR<\/span><\/h2>\n

    A DBMS_XPLAN.DISPLAY_CURSOR pode ser usada para obter mais informa\u00e7\u00f5es estat\u00edsticas sobre o consumo real de recursos a n\u00edvel de opera\u00e7\u00e3o do plano de execu\u00e7\u00e3o.<\/span><\/p>\n

    Para isso precisamos utilizar o “hint” GATHER_PLAN_STATISTICS na instru\u00e7\u00e3o SQL (a partir do 10g em diante), ou alterar o par\u00e2metro STATISTICS_LEVEL para ALL a n\u00edvel de sess\u00e3o (n\u00e3o \u00e9 recomendado utilizar esse par\u00e2metro a n\u00edvel de sistema pois ele pode causar uma sobrecarga na base).<\/span><\/p>\n

    Assim que uma instru\u00e7\u00e3o SQL \u00e9 executada (com \u00eaxito, cancelada ou com erro) o “Child Cursor” \u00e9 atualizado com os dados estat\u00edsticos para cada opera\u00e7\u00e3o do plano de execu\u00e7\u00e3o utilizado pelo otimizador e essas informa\u00e7\u00f5es podem ser acessadas via V$SQL_PLAN_STATISTICS e V$SQL_PLAN_STATISTICS_ALL.<\/span><\/p>\n

    Sintaxe<\/span><\/h2>\n
    1
    2
    3
    4
    <\/div><\/td>
    DBMS_XPLAN.<\/span>DISPLAY_CURSOR(<\/span>
    \n   sql_id            IN  VARCHAR2  DEFAULT<\/span>  NULL<\/span>,<\/span>
    \n   cursor_child_no   IN  NUMBER    DEFAULT<\/span>  0<\/span>,<\/span>
    \n   format            IN  VARCHAR2  DEFAULT<\/span>  'TYPICAL'<\/span>)<\/span>;<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    Par\u00e2metros<\/span><\/h2>\n

    SQL_ID:<\/span><\/h3>\n

    Especifique o SQL_ID da instru\u00e7\u00e3o SQL no “cursor cache”. Voc\u00ea pode recuperar esse c\u00f3digo consultando a coluna SQL_ID nas vis\u00f5es V$SQL ou V$SQLAREA. Caso este par\u00e2metro n\u00e3o seja informado (NULL) ser\u00e1 exibido o plano de execu\u00e7\u00e3o do ultimo cursor executado pela sess\u00e3o.<\/span><\/p>\n

    CURSOR_CHILD_NO:<\/span><\/h3>\n

    Especifique o “Child Number” do Cursor a ser exibido. Se esse par\u00e2metro n\u00e3o for fornecido, o plano de execu\u00e7\u00e3o de todos os cursores correspondentes ao par\u00e2metro sql_id informado ser\u00e3o exibidos. O CURSOR_CHILD_NO s\u00f3 pode ser especificado se o sql_id foi informado.<\/span><\/p>\n

    FORMAT:<\/span><\/h3>\n

    Este par\u00e2metro controla o n\u00edvel de detalhe do plano que ser\u00e1 exibido e na vers\u00e3o 11g podemos informar 5 valores:<\/span><\/p>\n

    \"dbms_xplan_format\"<\/a><\/p>\n

     <\/p>\n

    Basic<\/strong>: Exibe o minimo de informa\u00e7\u00f5es sobre o plano de execu\u00e7\u00e3o: O ID da opera\u00e7\u00e3o, o nome da opera\u00e7\u00e3o e o nome do objeto que ser\u00e1 tratado pela opera\u00e7\u00e3o. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Typical<\/strong>: Exibe as informa\u00e7\u00f5es mais relevantes do plano de execu\u00e7\u00e3o, se o par\u00e2metro “Format” for omitido (null) esse ser\u00e1 o valor considerado. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Serial<\/strong>: Exibe quase as mesmas informa\u00e7\u00f5es que o formato “Typical” com exce\u00e7\u00e3o das informa\u00e7\u00f5es das opera\u00e7\u00f5es de paralelismo que ser\u00e3o omitidas mesmo que o plano utilize o paralelismo na sua execu\u00e7\u00e3o. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Advanced<\/strong>: Exibe as mesmas informa\u00e7\u00f5es que o formato “Typical” e inclui algumas sess\u00f5es de informa\u00e7\u00f5es n\u00e3o estat\u00edsticas sobre o plano de execu\u00e7\u00e3o. Esse formato n\u00e3o esta documentado nos manuais da Oracle. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Aos formatos acima podemos adicionar mais informa\u00e7\u00f5es estat\u00edsticas, para tanto devemos adicionar uma das tr\u00eas palavras chaves abaixo:<\/span><\/p>\n

    \"dbms_xplan_format_ext\"<\/a><\/p>\n

     <\/p>\n

    MEMSTATS<\/strong>: Exibe estat\u00edstica referente a estimativa da quantidade de espa\u00e7o a ser utilizado na PGA para opera\u00e7\u00f5es de SORT, HASH JOIN, BITMAP MERGE ou BITMAP CREATE. Essas informa\u00e7\u00f5es s\u00f3 ser\u00e3o exibidas se as opera\u00e7\u00f5es listadas anteriormente forem utilizadas no plano de execu\u00e7\u00e3o. [veja exemplo…]<\/a><\/span> <\/span><\/p>\n

    IOSTATS<\/strong>: Exibe estat\u00edsticas referentes as opera\u00e7\u00f5es de “IO” executadas para um determinado plano de execu\u00e7\u00e3o. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    ALLSTATS<\/strong>: Exibe todas as informa\u00e7\u00f5es estat\u00edsticas fornecidas por MEMSTATS e IOSTATS. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

     <\/p>\n

    Alem dessas palavras chave que adicionam mais informa\u00e7\u00f5es estat\u00edsticas ao plano, podemos adicionar ao par\u00e2metro FORMAT mais duas palavras chaves:<\/span><\/p>\n

    LAST<\/strong>: Normalmente os valores estat\u00edsticos informados no plano de execu\u00e7\u00e3o s\u00e3o referentes a todos os cursores daquele plano (Lembrando que a exist\u00eancia de cada cursor na mem\u00f3ria tem um tempo limitado que depende da quantidade de transa\u00e7\u00f5es e do tamanho da \u00e1rea de mem\u00f3ria de cada base), se for informada a palavra chave LAST ser\u00e3o exibidos valores estat\u00edsticos somente da ultima execu\u00e7\u00e3o. [veja exemplo…]<\/a><\/span><\/span><\/p>\n

    ALL<\/strong>: Essa palavra chave permite que sejam exibidas sess\u00f5es adicionais (Query Block Name e Column Projection) de informa\u00e7\u00f5es n\u00e3o estat\u00edsticas que aparecem logo ap\u00f3s o plano de execu\u00e7\u00e3o.<\/span> [veja exemplo…]<\/a><\/span><\/p>\n

    Cada uma das palavras chave do par\u00e2metro FORMAT apresentam um determinado numero de sess\u00f5es adicionais listadas logo ap\u00f3s o plano de execu\u00e7\u00e3o, o quadro abaixo mostra quais s\u00e3o as sess\u00f5es listadas para cada uma das palavras chaves:<\/span><\/p>\n

    \"dbms_xplan_format_sessions\"<\/a><\/p>\n

     <\/p>\n

    Tamb\u00e9m podemos incluir ou eliminar as informa\u00e7\u00f5es que ser\u00e3o\u00a0exibidas no plano de execu\u00e7\u00e3o gerado pelo pacote DBMS_XPLAN, veja alguns exemplos abaixo:<\/p>\n

    As palavras chave “BASIC\u00a0MEMSTATS” n\u00e3o exibem a coluna “COST” no plano de execu\u00e7\u00e3o se quisermos adicionar esta informa\u00e7\u00e3o basta adicionar essa palavra chave “BASIC\u00a0MEMSTATS\u00a0COST”.\u00a0[veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Outra possibilidade seria eliminar informa\u00e7\u00f5es do plano de execu\u00e7\u00e3o, podemos por exemplo eliminar as colunas “E-ROWS”, “COST” e “BYTES” do plano de execu\u00e7\u00e3o informando o par\u00e2metro “FORMAT” da seguinte forma: “TYPICAL IOSTATS -ROWS -COST -BYTES”.\u00a0[veja exemplo…]<\/a><\/span><\/p>\n

    As sess\u00f5es de informa\u00e7\u00e3o n\u00e3o estat\u00edsticas tamb\u00e9m podem ser controladas e podemos adicionar \u00a0ou excluir sess\u00f5es, \u00a0por \u00a0exemplo \u00a0podemos \u00a0incluir \u00a0a \u00a0sess\u00e3o “Query Block Name” incluindo a palavra chave “ALIAS”.\u00a0\u00a0[veja exemplo…]<\/a><\/span><\/span><\/p>\n

    Ou ainda\u00a0podemos excluir sess\u00f5es de informa\u00e7\u00f5es n\u00e3o estat\u00edsticas como a sess\u00e3o “Projection” incluindo a palavra chave “-PROJECTION”.<\/span>\u00a0[veja exemplo…]<\/a><\/span><\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format Basic”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'BASIC'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nEXPLAINED SQL STATEMENT:<\/span>
    \n------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n-----------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span>
    \n-----------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>
    \n|<\/span>   3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>
    \n|<\/span>   6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>
    \n-----------------------------------------------<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format Typical”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Rows  |<\/span> Bytes |<\/span>TempSpc|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span>     Time<\/span><\/a>     |<\/span> Pstart|<\/span> Pstop |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>       |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>  7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>  7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>  7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>   119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span> 55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format Serial”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'SERIAL'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Rows  |<\/span> Bytes |<\/span>TempSpc|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span>     Time<\/span><\/a>     |<\/span> Pstart|<\/span> Pstop |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>       |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>  7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>  7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>  7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>   119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span> 55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format Advanced”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'ADVANCED'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Rows  |<\/span> Bytes |<\/span>TempSpc|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span>     Time<\/span><\/a>     |<\/span> Pstart|<\/span> Pstop |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>       |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>  7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>  7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>  7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>   119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span> 55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nQuery Block Name \/<\/span> Object Alias (<\/span>identified by operation id)<\/span>:<\/span>
    \n-------------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> SEL$1<\/span>
    \n   4<\/span> -<\/span> SEL$73523A42 \/<\/span> S@<\/span>SEL$1<\/span>
    \n   5<\/span> -<\/span> SEL$73523A42
    \n   8<\/span> -<\/span> SEL$73523A42 \/<\/span> A@<\/span>SEL$2<\/span>
    \n  10<\/span> -<\/span> SEL$73523A42 \/<\/span> B@<\/span>SEL$2<\/span>
    \n  11<\/span> -<\/span> SEL$1<\/span>        \/<\/span> C@<\/span>SEL$1<\/span>
    \n
    \nOutline Data
    \n-------------<\/span>
    \n
    \n  \/*+
    \n      BEGIN_OUTLINE_DATA
    \n      IGNORE_OPTIM_EMBEDDED_HINTS
    \n      OPTIMIZER_FEATURES_ENABLE('11.2.0.4')
    \n      DB_VERSION('11.2.0.4')
    \n      ALL_ROWS
    \n      OUTLINE_LEAF(@"SEL$73523A42")
    \n      ELIMINATE_OBY(@"SEL$2")
    \n      OUTLINE_LEAF(@"SEL$1")
    \n      OUTLINE(@"SEL$2")
    \n      NO_ACCESS(@"SEL$1" "S"@"SEL$1")
    \n      FULL(@"SEL$1" "C"@"SEL$1")
    \n      LEADING(@"SEL$1" "S"@"SEL$1" "C"@"SEL$1")
    \n      USE_HASH(@"SEL$1" "C"@"SEL$1")
    \n      USE_HASH_AGGREGATION(@"SEL$1")
    \n      FULL(@"SEL$73523A42" "A"@"SEL$2")
    \n      FULL(@"SEL$73523A42" "B"@"SEL$2")
    \n      LEADING(@"SEL$73523A42" "A"@"SEL$2" "B"@"SEL$2")
    \n      USE_HASH(@"SEL$73523A42" "B"@"SEL$2")
    \n      USE_HASH_AGGREGATION(@"SEL$73523A42")
    \n      END_OUTLINE_DATA
    \n  *\/<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \nColumn Projection Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n-----------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> (<\/span>#keys=1) SUM("TOT_SOLD_A")+SUM("TOT_SOLD_B")[22], "CUST_STATE_PROVINCE"[VARCHAR2,40]
    \n<\/span>   2<\/span> -<\/span> "CUST_STATE_PROVINCE"<\/span>[<\/span>VARCHAR2,<\/span>40<\/span>]<\/span>,<\/span> SUM(<\/span>"TOT_SOLD_B"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"TOT_SOLD_A"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>
    \n   3<\/span> -<\/span> (<\/span>#keys=1) "TOT_SOLD_B"[NUMBER,22], "TOT_SOLD_A"[NUMBER,22], "CUST_STATE_PROVINCE"[VARCHAR2,40]
    \n<\/span>
    \nPLAN_TABLE_OUTPUT
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n   4<\/span> -<\/span> "S"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "TOT_SOLD_A"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "TOT_SOLD_B"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   5<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>
    \n   6<\/span> -<\/span> (<\/span>#keys=1) "A"."CUST_ID"[NUMBER,22], "A"."AMOUNT_SOLD"[NUMBER,22], "B"."AMOUNT_SOLD"[NUMBER,22]
    \n<\/span>   7<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   8<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   9<\/span> -<\/span> "B"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n  10<\/span> -<\/span> "B"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n  11<\/span> -<\/span> "C"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "CUST_STATE_PROVINCE"<\/span>[<\/span>VARCHAR2,<\/span>40<\/span>]<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL MEMSTATS”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL MEMSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span>  OMem |<\/span>  1Mem |<\/span>  O\/<\/span>1<\/span>\/<\/span>M   |<\/span> Max-<\/span>Tmp |<\/span>
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span> 27648<\/span> |<\/span> 27648<\/span> |<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>  1487K|<\/span>  1190K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>  1539K|<\/span>  1539K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>  2772M|<\/span>    41M|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.16<\/span> |<\/span>    44M|<\/span>  9683K|<\/span>          |<\/span>   18432<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.09<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.11<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL IOSTATS”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.16<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.09<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.11<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL ALLSTATS”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL ALLSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>  OMem |<\/span>  1Mem |<\/span>  O\/<\/span>1<\/span>\/<\/span>M   |<\/span> Max-<\/span>Tmp |<\/span>
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span> 27648<\/span> |<\/span> 27648<\/span> |<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>  1487K|<\/span>  1190K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.26<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>  1539K|<\/span>  1539K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.23<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>  2772M|<\/span>    41M|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.16<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>    44M|<\/span>  9683K|<\/span>          |<\/span>   18432<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.09<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.11<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL IOSTATS LAST”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      2<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      2<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      2<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.80<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.75<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.75<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      2<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    345M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>58.32<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      2<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.40<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     56<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.20<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      2<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.45<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     56<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.24<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      2<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>    111K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.02<\/span> |<\/span>    2914<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \n
    \ncurso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS LAST'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan     hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.47<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.47<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.47<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.46<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.44<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>57.44<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>31.64<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.19<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.09<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.23<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.13<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL IOSTATS ALL”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS ALL'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      2<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      2<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      2<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    282<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.81<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.80<\/span> |<\/span>   20798<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.75<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      2<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>  14118<\/span> |<\/span>00<\/span>:<\/span>01<\/span>:<\/span>49.75<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      2<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    345M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>58.32<\/span> |<\/span>   17884<\/span> |<\/span>   4260<\/span> |<\/span>   4260<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      2<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.40<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     56<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.20<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      2<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.45<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     56<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>   1837K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.24<\/span> |<\/span>    8942<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      2<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>    111K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.02<\/span> |<\/span>    2914<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nQuery Block Name \/<\/span> Object Alias (<\/span>identified by operation id)<\/span>:<\/span>
    \n-------------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> SEL$1<\/span>
    \n   4<\/span> -<\/span> SEL$73523A42 \/<\/span> S@<\/span>SEL$1<\/span>
    \n   5<\/span> -<\/span> SEL$73523A42
    \n   8<\/span> -<\/span> SEL$73523A42 \/<\/span> A@<\/span>SEL$2<\/span>
    \n  10<\/span> -<\/span> SEL$73523A42 \/<\/span> B@<\/span>SEL$2<\/span>
    \n  11<\/span> -<\/span> SEL$1<\/span>        \/<\/span> C@<\/span>SEL$1<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \nColumn Projection Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n-----------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> (<\/span>#keys=1) SUM("TOT_SOLD_A")+SUM("TOT_SOLD_B")[22], "CUST_STATE_PROVINCE"[VARCHAR2,40]
    \n<\/span>   2<\/span> -<\/span> "CUST_STATE_PROVINCE"<\/span>[<\/span>VARCHAR2,<\/span>40<\/span>]<\/span>,<\/span> SUM(<\/span>"TOT_SOLD_B"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"TOT_SOLD_A"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>
    \n   3<\/span> -<\/span> (<\/span>#keys=1) "TOT_SOLD_B"[NUMBER,22], "TOT_SOLD_A"[NUMBER,22], "CUST_STATE_PROVINCE"[VARCHAR2,40]
    \n<\/span>   4<\/span> -<\/span> "S"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "TOT_SOLD_A"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "TOT_SOLD_B"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   5<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>,<\/span> SUM(<\/span>"A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>)<\/span>[<\/span>22<\/span>]<\/span>
    \n   6<\/span> -<\/span> (<\/span>#keys=1) "A"."CUST_ID"[NUMBER,22], "A"."AMOUNT_SOLD"[NUMBER,22], "B"."AMOUNT_SOLD"[NUMBER,22]
    \n<\/span>   7<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   8<\/span> -<\/span> "A"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "A"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n   9<\/span> -<\/span> "B"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n  10<\/span> -<\/span> "B"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "B"<\/span>.<\/span>"AMOUNT_SOLD"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>
    \n  11<\/span> -<\/span> "C"<\/span>.<\/span>"CUST_ID"<\/span>[<\/span>NUMBER,<\/span>22<\/span>]<\/span>,<\/span> "CUST_STATE_PROVINCE"<\/span>[<\/span>VARCHAR2,<\/span>40<\/span>]<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format BASIC\u00a0MEMSTATS\u00a0COST”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'BASIC MEMSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n---------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nEXPLAINED SQL STATEMENT:<\/span>
    \n------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n----------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>    Time<\/span><\/a>   |<\/span>  OMem |<\/span>  1Mem |<\/span>  O\/<\/span>1<\/span>\/<\/span>M   |<\/span> Max-<\/span>Tmp |<\/span>
    \n----------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span> 27648<\/span> |<\/span> 27648<\/span> |<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>  1487K|<\/span>  1190K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>  1539K|<\/span>  1539K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>  2772M|<\/span>    41M|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.41<\/span> |<\/span>    44M|<\/span>  9683K|<\/span>          |<\/span>   18432<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.08<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n----------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \n
    \n35<\/span> rows selected.<\/span>
    \n
    \nElapsed:<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span>
    \ncurso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'BASIC MEMSTATS COST'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n---------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nEXPLAINED SQL STATEMENT:<\/span>
    \n------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan     hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n-----------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> A-<\/span>Rows |<\/span>   A-<\/span>    Time<\/span><\/a>   |<\/span>  OMem |<\/span>  1Mem |<\/span>  O\/<\/span>1<\/span>\/<\/span>M   |<\/span> Max-<\/span>Tmp |<\/span>
    \n-----------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span> 27648<\/span> |<\/span> 27648<\/span> |<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>  1487K|<\/span>  1190K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>  1539K|<\/span>  1539K|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>  2772M|<\/span>    41M|<\/span>     1<\/span>\/<\/span>0<\/span>\/<\/span>0<\/span>|<\/span>         |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.41<\/span> |<\/span>    44M|<\/span>  9683K|<\/span>          |<\/span>   18432<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.08<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>       |<\/span>       |<\/span>          |<\/span>         |<\/span>
    \n-----------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL IOSTATS -ROWS -COST -BYTES”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.41<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.08<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \n
    \n35<\/span> rows selected.<\/span>
    \n
    \nElapsed:<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>00.06<\/span>
    \ncurso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS -ROWS -COST -BYTES'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n----------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan     hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n-------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n-------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.41<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.08<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n-------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL ALIAS”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n--------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Rows  |<\/span> Bytes |<\/span>TempSpc|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span>     Time<\/span><\/a>     |<\/span> Pstart|<\/span> Pstop |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>       |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>  7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>  7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>  7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>   119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span> 55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n
    \n
    \ncurso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL ALIAS'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n--------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan     hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Rows  |<\/span> Bytes |<\/span>TempSpc|<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span>     Time<\/span><\/a>     |<\/span> Pstart|<\/span> Pstop |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>       |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>   145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>  7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>  7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>  7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>   119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>   918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span> 55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>
    \n---------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nQuery Block Name \/<\/span> Object Alias (<\/span>identified by operation id)<\/span>:<\/span>
    \n-------------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> SEL$1<\/span>
    \n   4<\/span> -<\/span> SEL$73523A42 \/<\/span> S@<\/span>SEL$1<\/span>
    \n   5<\/span> -<\/span> SEL$73523A42
    \n   8<\/span> -<\/span> SEL$73523A42 \/<\/span> A@<\/span>SEL$2<\/span>
    \n  10<\/span> -<\/span> SEL$73523A42 \/<\/span> B@<\/span>SEL$2<\/span>
    \n  11<\/span> -<\/span> SEL$1<\/span>        \/<\/span> C@<\/span>SEL$1<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

    <\/a><\/p>\n

     <\/p>\n

    Exemplo “Format TYPICAL IOSTATS ALL -PROJECTION”:<\/span><\/p>\n

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    <\/div><\/td>
    curso01@<\/span>ODBSRV11 ><\/span> SELECT *<\/span> FROM TABLE (<\/span>DBMS_XPLAN.<\/span>display_cursor (<\/span>'2gmbuzy8dzvv2'<\/span>,<\/span> NULL<\/span>,<\/span> 'TYPICAL IOSTATS ALL -PROJECTION'<\/span>)<\/span>)<\/span>;<\/span>
    \n
    \nPLAN_TABLE_OUTPUT
    \n--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \nSQL_ID  2gmbuzy8dzvv2,<\/span> child number 0<\/span>
    \n-------------------------------------<\/span>
    \nSELECT \/* TESTE010 *\/<\/span> CUST_STATE_PROVINCE,<\/span>
    \nSUM(<\/span>TOT_SOLD_A)<\/span>+<\/span>SUM(<\/span>TOT_SOLD_B)<\/span> US   FROM SH.<\/span>CUSTOMERS C,<\/span>
    \n(<\/span>SELECT A.<\/span>CUST_ID,<\/span> SUM(<\/span>A.<\/span>AMOUNT_SOLD)<\/span> TOT_SOLD_A,<\/span> SUM(<\/span>B.<\/span>AMOUNT_SOLD)<\/span>
    \nTOT_SOLD_B           FROM SH.<\/span>SALES A,<\/span>                SH.<\/span>SALES B
    \n WHERE A.<\/span>CUST_ID =<\/span> B.<\/span>CUST_ID          GROUP BY A.<\/span>CUST_ID ORDER BY
    \n:<\/span>"SYS_B_0"<\/span>)<\/span> S  WHERE C.<\/span>CUST_ID =<\/span> S.<\/span>CUST_ID  GROUP BY
    \nCUST_STATE_PROVINCE  ORDER BY :<\/span>"SYS_B_1"<\/span> DESC
    \n
    \nPlan hash<\/span><\/a> value:<\/span> 1062552367<\/span>
    \n
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span> Id  |<\/span> Operation                 |<\/span> Name      |<\/span> Starts |<\/span> E-<\/span>Rows |<\/span>E-<\/span>Bytes|<\/span>E-<\/span>Temp |<\/span> Cost (<\/span>%<\/span>CPU)<\/span>|<\/span> E-<\/span>    Time<\/span><\/a>   |<\/span> Pstart|<\/span> Pstop |<\/span> A-<\/span>Rows |<\/span>   A-<\/span>Time<\/span><\/a>   |<\/span> Buffers |<\/span> Reads  |<\/span> Writes |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n|<\/span>   0<\/span> |<\/span> SELECT STATEMENT          |<\/span>           |<\/span>      1<\/span> |<\/span>        |<\/span>       |<\/span>       |<\/span>  7620<\/span> (<\/span>100<\/span>)<\/span>|<\/span>          |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   1<\/span> |<\/span>      SORT<\/span><\/a> ORDER BY            |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   2<\/span> |<\/span>       HASH<\/span><\/a> GROUP BY           |<\/span>           |<\/span>      1<\/span> |<\/span>    145<\/span> |<\/span>  6815<\/span> |<\/span>       |<\/span>  7620<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>    141<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  3<\/span> |<\/span>        HASH<\/span><\/a> JOIN<\/span><\/a>              |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   323K|<\/span>       |<\/span>  7618<\/span>  (<\/span>57<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>32<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.95<\/span> |<\/span>   10399<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   4<\/span> |<\/span>     VIEW                  |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   213K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   5<\/span> |<\/span>          HASH<\/span><\/a> GROUP BY        |<\/span>           |<\/span>      1<\/span> |<\/span>   7059<\/span> |<\/span>   137K|<\/span>       |<\/span>  7213<\/span>  (<\/span>60<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>01<\/span>:<\/span>27<\/span> |<\/span>       |<\/span>       |<\/span>   7059<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>50.93<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|*<\/span>  6<\/span> |<\/span>           HASH<\/span><\/a> JOIN<\/span><\/a>           |<\/span>           |<\/span>      1<\/span> |<\/span>    119M|<\/span>  2281M|<\/span>    19M|<\/span>  3292<\/span>  (<\/span>11<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>40<\/span> |<\/span>       |<\/span>       |<\/span>    172M|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>25.41<\/span> |<\/span>    8942<\/span> |<\/span>   2130<\/span> |<\/span>   2130<\/span> |<\/span>
    \n|<\/span>   7<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.18<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   8<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.08<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>   9<\/span> |<\/span>        PARTITION     RANGE<\/span><\/a> ALL|<\/span>           |<\/span>      1<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.21<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  10<\/span> |<\/span>         TABLE ACCESS FULL |<\/span> SALES     |<\/span>     28<\/span> |<\/span>    918K|<\/span>  8973K|<\/span>       |<\/span>   525<\/span>   (<\/span>2<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>07<\/span> |<\/span>     1<\/span> |<\/span>    28<\/span> |<\/span>    918K|<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.12<\/span> |<\/span>    4471<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n|<\/span>  11<\/span> |<\/span>     TABLE ACCESS FULL     |<\/span> CUSTOMERS |<\/span>      1<\/span> |<\/span>  55500<\/span> |<\/span>   867K|<\/span>       |<\/span>   405<\/span>   (<\/span>1<\/span>)<\/span>|<\/span> 00<\/span>:<\/span>00<\/span>:<\/span>05<\/span> |<\/span>       |<\/span>       |<\/span>  55500<\/span> |<\/span>00<\/span>:<\/span>00<\/span>:<\/span>00.01<\/span> |<\/span>    1457<\/span> |<\/span>      0<\/span> |<\/span>      0<\/span> |<\/span>
    \n---------------------------------------------------------------------------------------------------------------------------------------------------------------------------<\/span>
    \n
    \nQuery Block Name \/<\/span> Object Alias (<\/span>identified by operation id)<\/span>:<\/span>
    \n-------------------------------------------------------------<\/span>
    \n
    \n   1<\/span> -<\/span> SEL$1<\/span>
    \n   4<\/span> -<\/span> SEL$73523A42 \/<\/span> S@<\/span>SEL$1<\/span>
    \n   5<\/span> -<\/span> SEL$73523A42
    \n   8<\/span> -<\/span> SEL$73523A42 \/<\/span> A@<\/span>SEL$2<\/span>
    \n  10<\/span> -<\/span> SEL$73523A42 \/<\/span> B@<\/span>SEL$2<\/span>
    \n  11<\/span> -<\/span> SEL$1<\/span>        \/<\/span> C@<\/span>SEL$1<\/span>
    \n
    \nPredicate Information (<\/span>identified by operation id)<\/span>:<\/span>
    \n---------------------------------------------------<\/span>
    \n
    \n   3<\/span> -<\/span> access(<\/span>"C"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"S"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span>
    \n   6<\/span> -<\/span> access(<\/span>"A"<\/span>.<\/span>"CUST_ID"<\/span>=<\/span>"B"<\/span>.<\/span>"CUST_ID"<\/span>)<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

     <\/p>\n

    Conclus\u00e3o:<\/span><\/h2>\n

    O pacote “DBMS_XPLAN” como verificamos acima \u00e9 muito vers\u00e1til e gera informa\u00e7\u00f5es que s\u00e3o muito uteis no trabalho de ajuste de desempenho das instru\u00e7\u00f5es SQL utilizadas pelas aplica\u00e7\u00f5es, se voc\u00ea n\u00e3o utilizava esta ferramenta ou se utilizava de forma limitada, passe a utilizar todos os recursos que ela oferece para tornar o seu trabalho de tuning mais eficaz.<\/span><\/p>\n

     <\/p>\n

    Refer\u00eancia:<\/span><\/h2>\n

    http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_xplan.htm#ARPLS378<\/a><\/span><\/em><\/p>\n

    https:\/\/hoopercharles.wordpress.com\/2010\/03\/01\/dbms_xplan-format-parameters\/<\/a><\/span><\/em><\/p>\n

     
    \n 
    \n    \"Promo-D75L\"<\/a><\/p>\n

    \"video-02\"<\/a>
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n 
    \n <\/p>\n","protected":false},"excerpt":{"rendered":"

    O pacote DBMS_XPLAN fornece uma maneira f\u00e1cil para exibir o plano de execu\u00e7\u00e3o em v\u00e1rios formatos pr\u00e9-definidos, essa flexibilidade e o n\u00edvel de detalhes estat\u00edsticos que o pacote oferece o torna uma ferramenta imprescind\u00edvel num processo de tuning de uma instru\u00e7\u00e3o SQL. Voc\u00ea pode usar o pacote para exibir uma estimativa de plano a partir do comando “Explain Plan”, ou<\/p>\n","protected":false},"author":2,"featured_media":494,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[7,14,10,11,15],"class_list":["post-20","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tuning-tools","tag-dbms_xplan","tag-display_cursor","tag-otimizador","tag-plano-de-execucao","tag-tuning-tools"],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/20","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=20"}],"version-history":[{"count":37,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/20\/revisions"}],"predecessor-version":[{"id":2109,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/posts\/20\/revisions\/2109"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media\/494"}],"wp:attachment":[{"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/media?parent=20"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/categories?post=20"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dbtimewizard.com.br\/blog\/wp-json\/wp\/v2\/tags?post=20"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}