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 Fri Oct 18 2002 - 16:52:00 CDT
