Re: database is slow after 3 days

Does the load on the machine go up? Does the number of processes go up? DO the connections to the DB close?

On Sun, 12 Sep 1999 18:54:34 -0700, "wozi" <wozi_at_dhc.net> wrote:

>When our oracle database first comes up, everything runs smoothly.
>After about 3 days, it really starts to slow down. I am having to shutdown
>the instance every 3 days to improve performance.
>
>This is Oracle 7.3 on Sco Unix 5.5
>
>We have over 300M of RAM, and have 2 instances: test and prod.
>
>Any help will be appreciated.
>
>Please, reply as well to tyc77_at_hotmail.com
>
>
>

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