Re: Flooding Log Files

From: Van Messner <vmessner_at_netaxis.com>
Date: Tue, 16 Feb 1999 20:37:17 -0500
Message-ID: <08py2.190$rj3.2001@news14.ispnews.com>

Thank you all for the information. I have not had problems with flooding the logs outside of index rebuilds - at least not yet. The database is reasonably good-sized but there are not many concurrent users and it's been in operation for three years. I will do the rebuilds using unrecoverable and increase the log sizes if any problems devlop in the future.

Van

Van Messner wrote in message <3e0y2.81$wP2.694_at_news6.ispnews.com>...
>Anyone
>
> One of our databases has 4 log groups of size 6M each (2 members per
>group). The other day I used an alter index..rebuild to rebuld a 300MB
>index that had thrown 100 extents. ARCH had trouble keeping up and I could
>see from the alert log that log groups filled faster than they could be
>archived. The rebuild took about fifteen minutes and not much else was
>putting a load on the database at the time.
> Is index rebuilding generally this demanding of ARCH? And if the index
>is in an "INDEX" tablespace should the rebuild need resources from the
>SYSTEM tablespace?
> Running a Novell server, Oracle 7.3, DB size of maybe 50G and around
>1500 objects.
>
>Thanks for your knowledge
>
>Van
>
>
Received on Tue Feb 16 1999 - 19:37:17 CST