Re: How to calculate the exact cost of a physical read

From: Ford <get4ked_at_yahoo.com>
Date: 9 Aug 2001 11:53:23 -0700
Message-ID: <b2b9197f.0108091053.54690f63@posting.google.com>

v$filestat also has info. on read times per file

garry_robinson_at_slc.co.uk (Garry Robinson) wrote in message news:<55fd501c.0108090422.2ffd69b2_at_posting.google.com>...
> Does anyone know how to calculate the average duration of a physical
> block read from disk?
> Can V$SYSTEM_EVENT.AVERAGE_WAIT_TIME for db_file_sequential_read event
> be relied on to represent the average time taken to transfer a random
> block from disk to the buffer cache?
Received on Thu Aug 09 2001 - 13:53:23 CDT