Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Poor Performance on Oracle9i - 9.2.0.7
"eavanzi" <eavanzi_at_romi.com.br> wrote in message
news:1146968486.656701.14300_at_e56g2000cwe.googlegroups.com...
> Hi, Bob.
> I have flushed the shared pool but it is not resolving the problem.
> I have observed the performance is a little better from 07:00am until
> 11:30am. It is more poor from 14:00pm until 17:00pm.
> The system goes being slower, slower, slower, ..., then I shutdown the
> database and start the database again and the performance is better.
> Then the system goes being slower, slower, slower, ....
>
I did not say flush the shared pool. I said reduce the size of the shared pool. Have you tried that? Received on Sun May 07 2006 - 11:31:13 CDT