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: Finding the size of Archived log files

Re: Finding the size of Archived log files

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 24 Apr 2003 16:09:06 GMT
Message-ID: <MPG.1911abfbd730a81c989754@news.la.sbcglobal.net>


member27732_at_dbforums.com said...
>
> I would like to know how much memory the archived redo log files are
> used in my physical disk folder .
>
> Thanks in advance
>
> --
> Posted via http://dbforums.com
>

You didn't specify your O/S, but...

Unix -

  1. Change to archive log directory (cd)
  2. Type the following cryptic command:

   ls -la *.arc | awk '{total += $5}; END {print total}'

 or to get it in MB:

   ls -la *.arc | awk '{total += $5}; END {print total/1024/1024 " MB"}'

WinNT/2000 -

  1. Open a DOS window
  2. Change to archive log folder (cd)
  3. Type DIR *.ARC -- /Karsten DBA > retired > DBA
Received on Thu Apr 24 2003 - 11:09:06 CDT

Original text of this message

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