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: Urgent: performance problem

Re: Urgent: performance problem

From: <rspeaker_at_my-dejanews.com>
Date: Fri, 18 Dec 1998 16:47:11 GMT
Message-ID: <75e0ue$5l6$1@nnrp1.dejanews.com>


start by running the UTLBSTAT and UTLESTAT sql scripts during the time that the performance is bad. Analyze the report.txt file to see if there are any issues that jump out at you. This may not be the answer but it should give you a good starting point.

HTH In article <36793B30.6B3A486B_at_bart.inescn.pt>,   Marco Ribeiro <mar_at_bart.inescn.pt> wrote:
> Hi,
>
> We've got a database over which we execute several procedures. Each one
> of these procedures calculates a ratio an inserts the value in a table
> (pretty simple).
>
> At first these procedures ran very fast and overall performance was good
> but as time passed the performance degraded until it is now reduced to a
> crawl.
>
> The database has not grown in size.
>
> Thanks in advance,
>
> Marco Ribeiro
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Dec 18 1998 - 10:47:11 CST

Original text of this message

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