| 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
Don't forget physical reads or writes reported in Oracle are not always physical. OS caches pages too without Oracle's knowledge.
Yong Huang
yong321_at_yahoo.com
nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) wrote in article
<3aa7498d.1219024_at_news-server> :
>On Wed, 7 Mar 2001 15:11:30 -0500, "LF" <frolio_at_videoshare.com> wrote:
>
>>Can anyone unequivocally explain the difference between
>>phyrds, phyblkrd, phywrts and phyblkwrt?
>
>Think of it as phyrds is the number of read operations initiated,
>while phyblkrd is the actual number of blocks read from disk. That
>gives you a good indication if table scans are taking place, assuming
>you have db_file_multiblock_reads set.
>
>Same for writes, but things get slightly more complicated there: there
>is no such parameter as "db_file_multiblock_writes"... ;-)
>
>Cheers
>Nuno Souto
>nsouto_at_bigpond.net.au.nospam
>http://www.users.bigpond.net.au/the_Den/index.html
 |
 |