Re: performance problems

yes but this happens at random times. Its accounting server for modem access and authorization
and last time it "died" was 8 am when there is almost no access. I noticed shared pool is getting filled up and it goes from 70 % initial to 90 % full
during operating hours.
What do you want me to post.. all queries on database? Best i can do is get statspack output... I tried to optimize tables, get few indexes more in places where i noticed full table scan,
partitioned accounting table by year,put it on separate tablespace and lots of other things
but nothing helped so far.
it kills me because it worked ok for 6 months and this kind of bahaveour is noticable last few days
BTW im using static queries to fill info in accounting.

Thanks for trying to help,
Damir

In article <MRvr9.22094$zX3.60054_at_news.indigo.ie>, Telemachus wrote:
> Yes.
>
>
> pls post query, plan,tkprof output and statspack output. Restarting instance
> is a bad idea.
> Does load profile change during day ?
> "Damir Jurica" <sircco_at_online.hr> wrote in message
> news:slrnaqr4m6.37k.djurica_at_damir.globalnet.hr...

>> since im new i dont know what does this mean but problem is database works

>> 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
>>
>> TIA,
>> Damir Jurica