Re: Flooding Log Files

From: Rawender Singh Guron <Rawender_Guron_at_rta.nsw.gov.au>
Date: Tue, 16 Feb 1999 12:52:56 -0800
Message-ID: <36C9DAA8.3C50@rta.nsw.gov.au>

Van Messner wrote:
>
> 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

The rebuild will need resources from SYSTEM tablespace if the user's temporary table has not been specified. It will use SYSTEM tablespace as its default temporary tablespace.

Rawender Received on Tue Feb 16 1999 - 14:52:56 CST