Re: How much archived redo is there to write during a log switch?
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Aug 2004 18:39:04 -0600
Leng,
I saw a couple replies on this, but they either referenced things out on the
internet or what-not, and I'm answering this while disconnected (stuck in an
airplane on ground-hold for weather, dammit!)...
The wording of your question implies that you want the information prior to
archiving, but if that is not the case, summing the two columns BLOCKS times
BLOCK_SIZE in V$ARCHIVE_LOG should be pretty good.
Hope this helps...
-Tim
on 8/18/04 12:12 AM, Kaing, Leng at Leng.Kaing@xxxxxxxxxxxxxxxx wrote:
> Hi all,
>
> I've got a very simple question: how can I tell how much archived redo =
> log is there to write when a log switch happens? ie. how full is the =
> redo log? how big the archived redo is when I switch?
>
> Looking at Oracle 8.1.7.4 for instance.
>
> TIA,
>
> Leng
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
