Re: calculate the amount of redo generated by a session
- From: "Paul Drake" <bdbafh@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Thu, 15 May 2008 12:39:50 -0400
Gene,
A Google search for "oracle tom kyte runstats session" and "I'm feeling
lucky" returned this:
http://asktom.oracle.com/tkyte/runstats.html
Then again, its easier to find things when you know what you are looking
for.
Hth and enjoy.
Paul
On Thu, May 15, 2008 at 12:30 PM, <genegurevich@xxxxxxxxxxxx> wrote:
> Hello:
>
> If I wanted to calculate the amount of redo generated by a session in
> oracle 9 database, would that work?
>
> select value from v$mystat where statistic# = 115
>
> update
>
> insert
>
> delete
>
> update
>
> select value from v$mystat where statistic# = 115
>
> Subtract the first value from the second to arrive to the total size of
> redo generated.
> I am basing this on the following:
>
> 1* select * from v$statname where lower(name) like '%arc%' or lower(name)
> like '%redo%'
>
> 72 redo synch writes
> 8
> 73 redo synch time
> 8
> 114 redo entries
> 2
> 115 redo size
> 2
>
> Also, if this does look reasonable and assuming that no other sessions are
> running against this DB,
> should the total size of all the archived logs created during the session
> be close to the difference
> between my first and last values?
>
>
> thank you
>
> Gene Gurevich
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
Other related posts:
