| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: v$filestat
"LF" <frolio_at_videoshare.com> wrote in message
news:9864lj$2d1$1_at_bob.news.rcn.net...
> Can anyone unequivocally explain the difference between
> phyrds, phyblkrd, phywrts and phyblkwrt?
>
> Thank You, LF.
>
>
>
>
phyrds is the number of physical reads
phyblkrd is the number of physical blocks read during those physical reads.
If you see a high ratio full table scans are going on.
The difference between phywrts and phyblkwrt should hopefully be obvious
now.
Hth,
Sybrand Bakker, Oracle DBA Received on Wed Mar 07 2001 - 14:46:50 CST
 |
 |