Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: interMedia 8.1.6 Performance Problem
One of our sites had a similar problem. I don't remember the specifics, but it involved Oracle performing full table scans of one of the internal Context queue tables (might have been dr$pending). Analyzing the table was a work around.
"archie" <jbg213_at_my-deja.com> wrote in message
news:8hmaac$guj$1_at_nnrp1.deja.com...
> 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 Sat Jun 24 2000 - 00:00:00 CDT