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

Home -> Community -> Usenet -> c.d.o.server -> Re: O8 getting slower and slower

Re: O8 getting slower and slower

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 17 Nov 1999 15:28:47 GMT
Message-ID: <3832c98c.72532242@news.earthlink.net>


analyze for chained rows, they might have degraded your performance, especially if you did a lot of updates to your tables.

On Wed, 10 Nov 1999 11:21:28 +0100, "Bernd Maierhofer" <BerndM_at_dato.at> wrote:

>Maybe you can help me with this one. And thank you for reading.
>
>Our O8 server seems to degrade in performance. We havenīt added data, but
>restructured tables and indices quite a lot. The indices get used, so this
>is not the problem. Maybe there is kind of defragmentation? How can I
>"reorganize" the database and will this help?
>
>Any info is appreciated.
>
>--
>dato Denkwerkzeuge - Bernd Maierhofer
>Corneliusgasse 4/5
>A-1060 Wien , Austria
>support_at_dato.at
>
>


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Wed Nov 17 1999 - 09:28:47 CST

Original text of this message

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