v$segstat and v$filestat
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?
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?
0