calculate the amount of redo generated by a session
- From: genegurevich@xxxxxxxxxxxx
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 15 May 2008 11:30:27 -0500
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
Other related posts:
