Re: performance problems

Damir.

to help you here, get a bstat/estat report when the problem happens and upload that report. Otherwise this is like reading tea leaves

Hope this helps
Stefan

Damir Jurica <sircco_at_online.hr> wrote in message news:<slrnar10lg.cb6.djurica_at_damir.globalnet.hr>...
> In article <3DAE97FB.6030304_at_web.de>, Michael Gast wrote:
> > Hi Damir,
> >
> > Damir Jurica schrieb:
> >> since im new i dont know what does this mean but problem is database works ok
> >> for like a day and then queries start to get slooow so i have to
> >> restart instance.
> >> Any ideas what could generate problems?
> >>
> >> Oracle 8.1.7
> >> linux
> >
> > Just an idea came into my mind: Could it be, that transactions are not
> > finished?
> >
> also ... i found out that during the time load avg goes from .01 to 40 %.
> Also from standard 4 concurent queries i have like 40 in v$open_cursor.
> Ideas?
> Someone suggested toput profile on users that kills those sessions after
> predefined time. Good/ bad idea?
>
> TIA
> Damir
Received on Sun Oct 20 2002 - 23:27:38 CDT