Database Administration (MOSC)

MOSC Banner

v$segstat and v$filestat

edited Mar 23, 2012 7:57AM in Database Administration (MOSC) 7 comments
Hello everyone,
Could anybody please explain the relation between these 2 views in terms of physical reads and writes. if we checked the descriptions of both views:

SQL> desc v$filestat
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE#                                              NUMBER
 PHYRDS                                             NUMBER
 PHYWRTS                                            NUMBER
 PHYBLKRD                                           NUMBER
 PHYBLKWRT                                          NUMBER
 SINGLEBLKRDS                                       NUMBER
 READTIM                                            NUMBER
 WRITETIM                                           NUMBER
 SINGLEBLKRDTIM                                     NUMBER
 AVGIOTIM                                           NUMBER
 LSTIOTIM                                           NUMBER
 MINIOTIM                                           NUMBER
 MAXIORTM                                           NUMBER
 MAXIOWTM    

SQL> desc v$segstat
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TS#                                                NUMBER
 OBJ#                                               NUMBER
 DATAOBJ#                                           NUMBER
 STATISTIC_NAME                                     VARCHAR2(64)
 STATISTIC#                                         NUMBER
 VALUE


I think that it's supposed that if we got the some of the segments that reside in 1 tablespace from statistic physical_reads from v$segstat, that should be equal to phrds of files that belong to the same tablespace in v$filestat, correct?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center