Re: v$filestat

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 08 Mar 2001 09:12:46 GMT
Message-ID: <3aa7498d.1219024@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 Received on Thu Mar 08 2001 - 03:12:46 CST