ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Statistics related view

Statistics related view

原创 Linux操作系统 作者:yuanqc 时间:2013-07-30 11:16:34 0 删除 编辑
v$segment_statistics
 
SQL> desc v$segment_statistics;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 OWNER                                              VARCHAR2(30)
 OBJECT_NAME                                        VARCHAR2(30)
 SUBOBJECT_NAME                                     VARCHAR2(30)
 TABLESPACE_NAME                                    VARCHAR2(30)
 TS#                                                NUMBER
 OBJ#                                               NUMBER
 DATAOBJ#                                           NUMBER
 OBJECT_TYPE                                        VARCHAR2(18)
 STATISTIC_NAME                                     VARCHAR2(64)
 STATISTIC#                                         NUMBER
 VALUE                                              NUMBER
 
 
 SQL> select distinct STATISTIC_NAME from v$segment_statistics;
STATISTIC_NAME
--------------------------------------------------------------------------------
gc buffer busy
db block changes
optimized physical reads
space used
segment scans
gc cr blocks received
gc current blocks received
row lock waits
buffer busy waits
physical reads
physical reads direct
physical writes
physical write requests
space allocated
logical reads
physical read requests
physical writes direct
ITL waits
18 rows selected.

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

下一篇: Oralce ASH report
请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    47
  • 访问量
    102376