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?
For data/temp files, v$filestat and v$tempstat, for redo v$sysstat. As I
recall, v$sysstat has totals for data files as well.
At 12:54 PM 1/5/2005, 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
Andy Rivenes
Email: arivenes_at_llnl.gov
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 05 2005 - 16:12:19 CST
![]() |
![]() |