Re: how to determine how many bytes are being written in oracle?

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 5 Jan 2005 14:23:03 -0800
Message-ID: <bf4638050105142345af5c7e@mail.gmail.com>

How about:
v$filestat.PHYBLKRD * blocksize
v$filestat.PHYBLKWRT * blocksize

v$log_history entries * size of logs.

On Wed, 05 Jan 2005 20:54:04 +0000, ryan_gaffuri_at_comcast.net <ryan_gaffuri_at_comcast.net> wrote:
> If I look at the physical reads in v$sess_io I can see how many writes. Is there anyway to estimate how many bytes are being written to disk? This includes undo. We want to use this for capacity planning purposes. We cannot look at increases in volume since this needs to encompass updates and deletes.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 05 2005 - 16:25:52 CST