| 本月文章推荐 |
Oracle数据字典说明发表日期：2008-2-9
|
|
逐渐整理记录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 |
| 上一篇：更改数据库SID
人气:869 下一篇：PL/SQL Packages and Types Reference 47 人气:634 |
| 浏览全部Oracle教程的内容
Dreamweaver插件下载 网页广告代码 祝你圣诞节快乐 2009年新年快乐 |
