Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Statistics in Oracle server performance

Re: Statistics in Oracle server performance

From: janet <janet_at_telesph.com>
Date: 1997/01/07
Message-ID: <32D262AE.3C20@telesph.com>#1/1

Leong San Io Francisco wrote:
> Recently, I posted a question regarding extremely bad Oracle performance on
> Netware, but no one replied... anyway, today, picking up the problem again,
> I deleted the statistics analyzed from the tables and the server returns
> back to the same level of performance before. Are statistics really BAD in
> Oracle 7.2.2?

Same thing happens here. Dunno why! But whenever we have a sudden performance problem we analyze table delete statistics... often works... (7.0)

janet Received on Tue Jan 07 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US