Re: Uneducated Guess

To get an idea of how much space you'll need for archived redo logs, you'll need to know a few things. 1) How big are your redo logs? Use: select group#,bytes from v$log; Your archived logs will be the same size as your current redo logs. 2) How many redo logs are you generating? Query the v$loghist view to determine. For instance, to determine how many redo logs switches occured in the last 24 hours; select count(*) from v$loghist where first_time between sysdate-1 and sysdate; Now multiply the size by the number of log switches and that's the amount of space you'll need for archived redo logs in a 24 hour period.

HTH,
Brian

Greg Akins wrote:
>
> Stupid question.
>
> My company is buying a new NT server. We're running Oracle 8.0.5
> and have about 14gigs of data.
>
> We're not in archivelog mode now. But will be after getting the
> new server. Any idea how much extra diskspace we'll need for
> the archive logs (Sorry if this is a really stupid question, my
> DBA is too busy evaluating Access 2000...).
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================