Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent: performance problem
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