|
逐渐整理记录Oracle数据字典表的创建、内容及含义。
是自己的一个过程，权当记录，给自己参考。
| View_Name |
Meanings |
Come from |
| GV $ENQUEUE_LOCK |
This view displays all locks owned by enqueue state objects. |
SELECT
/*+ ORDERED USE_NL(L), USE_NL(S),USE_NL(R) +*/
s.inst_id, l.addr, l.ksqlkadr,
s.ksusenum, r.ksqrsidt, r.ksqrsid1,
r.k sqrsid2, l.ksqlkmod, l.ksqlkreq,
l.ksqlkctim, l.ksqlklblk
FROM x $ksqeq l, x $ksuse s, x $ksqrs r
WHERE l.ksqlkses = s.addr
AND BITAND (l.kssobflg, 1) != 0
AND (l.ksqlkmod != 0 OR l.ksqlkreq != 0)
AND l.ksqlkres = r.addr
|
| GV $PARAMETER |
Displays information about the initialization parameters. |
SELECT x.inst_id, x.indx + 1, ksppinm,
ksppity, ksppstvl, ksppstdf,
DECODE (BITAND (ksppiflg / 256, 1), 1,
'TRUE', 'FALSE'),
DECODE (BITAND (ksppiflg / 65536, 3),
1, 'IMMEDIATE',
2, 'DEFERRED',
3, 'IMMEDIATE',
'FALSE'
),
DECODE (BITAND (ksppstvf, 7), 1,
'MODIFIED', 4, 'SYSTEM_MOD', 'FALSE'),
DECODE (BITAND (ksppstvf, 2), 2,
'TRUE', 'FALSE'), ksppdesc,
ksppstcmnt
FROM x $ksppi x, x $ksppcv y
WHERE (x.indx = y.indx)
AND ((TRANSLATE (ksppinm, '_', '#')
NOT LIKE '#%') OR (ksppstdf = 'FALSE')
)
|
| GV $RESOURCE_LIMIT |
Global resource use for some of the system resources |
SELECT inst_id, ksurlmnm, ksurlmcv, ksurlmmv,
LPAD (DECODE (BITAND (ksurlmfg, 1),
0, TO_CHAR (ksurlmia),
'UNLIMITED'
),
10
),
LPAD (DECODE (BITAND (ksurlmfg, 2),
0, TO_CHAR (ksurlmlv),
'UNLIMITED'
),
10
)
FROM x $ksurlmt
|
| GV $SEGSTAT |
Displays information about segment-level statistics |
select inst_id,
fts_tsn,
fts_objn,
fts_objd,
fts_statnam,
fts_statid,
fts_staval
from x $ksolsfts
where fts_inte = 0
| |
