RE: Redo logs size
- From: "Shamsudeen, Riyaj" <RS2273@xxxxxxx>
- To: <rjamya@xxxxxxxxx>, "Oracle Discussion List" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 11 Jun 2007 13:56:30 -0500
I think, v$archived_log should give you that.
select name, blocks*block_size from V$ARCHIVED_LOG
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of rjamya
Sent: Monday, June 11, 2007 1:51 PM
To: Oracle Discussion List
Subject: Redo logs size
It is possible to find out using dictionary/v$ views how much the online
redo log file contained when it was switched? i.e. it is possible to
estimate/calculate mb of archive log generated per hour without doing
calculations at os level?
version 9i and above. i have looked in the manuals and metalink, but
didn't find any references. Perhaps i missed.
Best regards
RJamya
Other related posts:
