Re: archivelog for DB with more than 10 millions insert/day

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Fri, 11 Feb 2000 19:21:59 GMT
Message-ID: <38a4610c.3942278@news.earthlink.net>

If your arch can keep up you should have no problem, you can also 'estimate' how much is archived/generated redo with the following query

select count(*) "# of Logs", count(*)*YOUR_LOG_SIZE||'M' "Total Generated Redo ", to_char(to_date(substr(a.first_time,0, 8), 'MM/DD/YY'), 'MM-DD-YYYY') "Date"
from v$loghist a
group by to_char(to_date(substr(a.first_time,0, 8), 'MM/DD/YY'), 'MM-DD-YYYY') On Fri, 11 Feb 2000 17:30:26 GMT, kerbiquet_at_hotmail.com wrote:

>Is someone managing a DB with more than 10 millions insert/update per
>day has figures on performance in noarchivelog vs. archivelog (well
>design with separed disks for redo and arch, redolog size, ckpt, etc.)?
>
>Thanks a lot.
>
>Pierre
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

---

In case I forgot to mention:
We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Fri Feb 11 2000 - 13:21:59 CST