Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: interMedia 8.1.6 Performance Problem
This might not be the correct answer but I would try the following:
1). Restart database in NOARCHIVELOG mode (if possible). 2). Increase the size of the redo log files (anticipate a large load) 3). Create large rollback segments specifically for this transaction.
In article <20000607125630.19962.00001895_at_ng-cn1.aol.com>,
timkarnold_at_aol.com (TimKArnold) wrote:
> Hi,
>
> I'm running 8.1.6 on NT. My table has 400,000 rows.
> When trying to create the context index, it starts off
> fast - 100 records/2secs. But once it gets to around 25,000,
> that becomes 100 records/ 4-5 minutes.
> Any clues?
>
> TIA,
> Tim
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Jun 07 2000 - 00:00:00 CDT