38.Oracle杂记——Oracle常用动态视图v$statname

38.Oracle杂记——Oracle常用动态视图v$statname

           视图v$statname显示了V$SESSTAT和V$SYSSTA表中的的统计名字。

描述如下：

sys@PDB1> desc v$statname;

 Name                                                                  Null?    Type

 ------------------------------------------------------------- ------------------------------------

 STATISTIC#                                                                     NUMBER

 NAME                                                                               VARCHAR2(64)

 CLASS                                                                                NUMBER

 STAT_ID                                                                NUMBER

 DISPLAY_NAME                                                                      VARCHAR2(64)

 CON_ID                                                                           NUMBER

各列解释如下：

STATISTIC#：静态统计编号

 NAME：静态统计名字

 CLASS：表示一个或多个静态统计类

 STAT_ID：静态统计ID

 DISPLAY_NAME：NAME列中更加具有描述意义和清除的名字

 CON_ID：容器ID