Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to determine how many bytes are being written in oracle?

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

From: Andy Rivenes <arivenes_at_llnl.gov>
Date: Wed, 05 Jan 2005 14:10:22 -0800
Message-Id: <6.0.0.22.2.20050105140835.025fa7f8@mail.llnl.gov>


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-l
Received on Wed Jan 05 2005 - 16:12:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US