RE: SYSSTAT statistics for buffer writes?
- From: "Tanel Poder" <tanel@xxxxxxxxxx>
- To: <Martin.Klier@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Feb 2009 12:29:42 +0200
Hi Martin,
Documentation is wrong. Conventional path inserts will be shown in "db block
changes". Direct path load blocks are not shown in there though.
Btw, you can use v$segment_statistics to get a segment level breakdown of
logical reads vs db block changes.
However I have to ask, what are you trying to achieve with this? Read vs
write ratio isn't too useful statistic for people and business, especially
if measured from such low level.
--
Regards,
Tanel Poder
http://blog.tanelpoder.com
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martin Klier
> Sent: 25 February 2009 11:44
> To: oracle-l@xxxxxxxxxxxxx
> Subject: SYSSTAT statistics for buffer writes?
>
>
> Dear list,
>
> I need to create a statistics overview for reads vs. writes
> on a 10gR2 database. Desire is, to compare "session logical
> reads" ('The sum of "db block gets" plus "consistent gets".
> This includes logical reads of database blocks from either
> the buffer cache or process private memory.' by 10g
> documentation) with its counterpart in writing. I don't want
> to gather information about phyiscal IO.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
