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

Home -> Community -> Usenet -> c.d.o.server -> Re: curious

Re: curious

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 30 Apr 2005 07:23:54 +0200
Message-ID: <42731630$0$20858$626a14ce@news.free.fr>

"Tom76" <rbhuma_at_ford.com> a écrit dans le message de news:1114806775.056186.110850_at_g14g2000cwa.googlegroups.com...
| my redo logs are 100m in size. how do i find the current size of redo
| log.
| in other words:
| > if i do a 'alter system switch logfile' and get a 40 m archived log'
| how can i know the size (here 40m) before hand.
| > or how to find the amount of 100m redo log that is used up, before
| the redo fills to 100m.
|
| i hope i was able to word my question
|

You'll find a script on Steve Adam site: http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage

Regards
Michel Cadot Received on Sat Apr 30 2005 - 00:23:54 CDT

Original text of this message

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