Oracle view V$SQLAREA Definition

Oracle GV$SQLAREA / V$SQLAREA view Definition,Just record for myself.



This is the definition from Oracle10g 10.2.0.3 :

SELECT inst_id, kglnaobj, kglfnobj, kglobt03,

      kglobhs0 + kglobhs1 + kglobhs2 + kglobhs3 + kglobhs4 + kglobhs5

      + kglobhs6,

      kglobt08 + kglobt11, kglobt10, kglobt01, kglobccc, kglobclc, kglhdlmd,

      kglhdlkc, kglobt04, kglobt05, kglobt48, kglobt35, kglobpc6, kglhdldc,

      SUBSTR (TO_CHAR (kglnatim, 'YYYY-MM-DD/HH24:MI:SS'), 1, 19), kglhdivc,

      kglobt12, kglobt13, kglobwdw, kglobt14, kglobwap, kglobwcc, kglobwcl,

      kglobwui, kglobt42, kglobt43, kglobt15, kglobt02,

      DECODE (kglobt32,

              0, 'NONE',

              1, 'ALL_ROWS',

              2, 'FIRST_ROWS',

              3, 'RULE',

              4, 'CHOOSE',

              'UNKNOWN'

              ),

      kglobtn0, kglobcce, kglobcceh, kglobt17, kglobt18, kglobts4, kglhdkmk,

      kglhdpar, kglnahsh, kglobt46, kglobt30, kglobts0, kglobt19, kglobts1,

      kglobt20, kglobt21, kglobts2, kglobt06, kglobt07,

      DECODE (kglobt28, 0, NULL, kglobt28), kglhdadr,

      DECODE (BITAND (kglobt00, 64), 64, 'Y', 'N'),

      DECODE (kglobsta,

              1, 'VALID',

              2, 'VALID_AUTH_ERROR',

              3, 'VALID_COMPILE_ERROR',

              4, 'VALID_UNAUTH',

              5, 'INVALID_UNAUTH',

              6, 'INVALID'

              ),

      kglobt31, kglobtt0, DECODE (kglobt33, 1, 'Y', 'N'), kglhdclt, kglobts3,

      kglobt44, kglobt45, kglobt47, kglobt49, kglobcla, kglobcbca

  FROM x$kglcursor_child_sqlid

WHERE kglobt02 != 0

The fllowing is the definition from Oracle9iR2 9.2.0.4:

SELECT  inst_id, kglnaobj,

        SUM (  kglobhs0

              + kglobhs1

              + kglobhs2

              + kglobhs3

              + kglobhs4

              + kglobhs5

              + kglobhs6

            ),

        SUM (kglobt08 + kglobt11), SUM (kglobt10), SUM (kglobt01),

        COUNT (*) - 1, SUM (DECODE (kglobhs6, 0, 0, 1)),

        DECODE (SUM (DECODE (kglhdlmd, 0, 0, 1)),

                0, 0,

                SUM (DECODE (kglhdlmd, 0, 0, 1)) - 1

                ),

        SUM (kglhdlkc) / 2, SUM (kglobt04), SUM (kglobt05), SUM (kglobpc6),

        SUM (kglhdldc) - 1,

        SUBSTR (TO_CHAR (kglnatim, 'YYYY-MM-DD/HH24:MI:SS'), 1, 19),

        SUM (kglhdivc), SUM (kglobt12), SUM (kglobt13), SUM (kglobt14),

        SUM (kglobt15), SUM (DECODE (kglobt09, 0, kglobt02, 0)),

        DECODE (COUNT (*) - 1,

                1, DECODE (SUM (DECODE (kglobt09, 0, kglobt32, 0)),

                            0, 'NONE',

                            1, 'ALL_ROWS',

                            2, 'FIRST_ROWS',

                            3, 'RULE',

                            4, 'CHOOSE',

                            'UNKNOWN'

                          ),

                'MULTIPLE CHILDREN PRESENT'

                ),

        SUM (DECODE (kglobt09, 0, kglobt17, 0)),

        SUM (DECODE (kglobt09, 0, kglobt18, 0)),

        DECODE (SUM (DECODE (kglhdkmk, 0, 0, 1)),

                0, 0,

                SUM (DECODE (kglhdkmk, 0, 0, 1)) - 1

                ),

        kglhdpar, kglnahsh, kglobts0, kglobt19, kglobts1, kglobt20,

        SUM (kglobt21), SUM (kglobt06), SUM (kglobt07),

        DECODE (kglobt33, 1, 'Y', 'N'), kglhdclt

    FROM x$kglcursor

GROUP BY inst_id,

        kglnaobj,

        kglhdpar,

        kglnahsh,

        kglnatim,

        kglobts0,

        kglobt19,

        kglobts1,

        kglobt20,

        DECODE (kglobt33, 1, 'Y', 'N'),

        kglhdclt

  HAVING SUM (DECODE (kglobt09, 0, kglobt02, 0)) != 0