Oracle数据字典说明
逐渐整理记录Oracle数据字典表的创建、内容及含义。
是自己学习的一个过程,权当记录,给自己参考。
View_Name | Meanings | Come from |
GV$ENQUEUE_LOCK | This view displays all locks owned by enqueue state objects. | SELECT |
GV$PARAMETER | Displays information about the initialization parameters. | SELECT x.inst_id, x.indx + 1, ksppinm, |
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 |
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。