Re: Very slow response to ALL queries
From: Steve Long <slong3_at_mediaone.net>
Date: Mon, 18 Jun 2001 13:28:38 GMT
Message-ID: <amnX6.10874$ID2.3161325_at_typhoon.jacksonville.mediaone.net>
Date: Mon, 18 Jun 2001 13:28:38 GMT
Message-ID: <amnX6.10874$ID2.3161325_at_typhoon.jacksonville.mediaone.net>
how is it you have concluded the problem is with an init.ora parameter ?
"kmiller" <keith_d_miller_at_yahoo.com> wrote in message
news:8a6b1853.0106041239.34088177_at_posting.google.com...
> Oracle8i 8.1.5
> Sun e5500 Solaris 2.8
>
> We have increasingly frequent periods of time where all queries
> against the database including queries such as
> "select 9843292 from dual"
> respond very slowly.
>
> We have been recycling the database to eliviate this problem. It
> consistantly returns after approximately 3/4 of a day uptime.
>
> What kind of init.ora settings could be modified to fix this.
>
> K Miller
Received on Mon Jun 18 2001 - 15:28:38 CEST