« Infostealer.Gampass病毒的清除方法 | Blog首页 | 转载新闻一则--一只小野鸭的超能量 »
Oracle view V$SQLAREA Definition
作者：eygle |【转载时请务必以超链接形式标明文章原始出处和作者信息及本声明】链接：http://www.eygle.com/archives/2007/09/oracle_sqlarea_view_definition.html
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
By eygle on 2007-09-01 14:00 | Comments (2) | Posted to FAQ | Edit |Pageviews:
| 相关文章 | 随机文章 |
|
|
Oracle11g开始倒计时 ntoskrnl.exe文件丢失或损坏的问题解决 eygle的菜谱：金钩玉条 如何使用ordered提示改变SQL执行计划 参加微软的"迎接新纪元"产品发布会 |
网上相关主题:
留言 (2)
呵呵，10g的没有了group by，不知道会不会效率会高很多。
之前在书上看因为v$sqlarea中有group by，效率没有v$sql那么高。
Posted by: 小荷 at September 4, 2007 6:01 PM
终于有人看到深层的原因了，当然10g这块的改进还不止于此。
可以说非常的大。
Posted by: eygle at September 4, 2007 10:05 PM
