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

  • From: Andy Rivenes <arivenes@xxxxxxxx>
  • To: ryan_gaffuri@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 05 Jan 2005 14:10:22 -0800

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@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.

Andy Rivenes
Email: arivenes@xxxxxxxx


Other related posts: