ITPub博客

首页 > 数据库 > Oracle > v$statname,v$sysstat,v$sesstat,v$mystat

v$statname,v$sysstat,v$sesstat,v$mystat

原创 Oracle 作者:General_715 时间:2014-12-26 15:11:45 0 删除 编辑
v$statname
This view displays decoded statistic names for the statistics shown in the V$SESSTAT and V$SYSSTAT tables.
 STATISTIC#                 
 NAME
 CLASS 
 STAT_ID

v$sysstat
This view lists system statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
STATISTIC#
NAME
CLASS
VALUE
STAT_ID

v$sesstat
This view lists user session statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
SID
STATISTIC#
VALUE

v$mystat
This view contains statistics on the current session.

SID
STATISTIC#
VALUE

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/24989466/viewspace-1381040/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-12-08

  • 博文量
    41
  • 访问量
    132420