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

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: ryan_gaffuri@xxxxxxxxxxx
  • Date: Wed, 5 Jan 2005 14:23:03 -0800

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@xxxxxxxxxxx
<ryan_gaffuri@xxxxxxxxxxx> 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.
> --
> //

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: