Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to determine how many bytes are being written in oracle?
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-lReceived on Wed Jan 05 2005 - 16:25:52 CST
![]() |
![]() |