Statistics related view

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10973950/viewspace-767433/