Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: curious
"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
![]() |
![]() |