Oracle database server becomes slow after sone time

[kllick123]

Hi,

I am using Oracle 8i(8.1.17) on sun solaris.
After running the database for say 2-3 hours, it becomes slow. My queries takes long time to fetch the results.

If I shutdown the datbase and re-start it, then performance becomes OK.

SGA STATUS AT 30-Dec-2005 02:57:20 PM
=====================================
Object memory : 35721340 bytes (34.07MB)
Shared sql memory : 23490369 bytes (22.4MB)
Cursors memory : 368500 bytes (.35MB)
Shared pool utilization (total) : 71496251 bytes (68.18MB)
Free memory : 95885068 bytes (91.44MB)
Shared pool allocation (actual) : 131072000 bytes (125MB)
Percentage Utilized : 55%
----------------------------------------------------
redo buffer allocation retries : 20
redo log space wait time : 0
----------------------------------------------------
Event Total_wait Total Timeout
buffer busy waits : 7839 1582
db file sequential read : 5138 0


I am able to see that free memory is there.

What could be the reason for slowing down.


It would be appreciable to get a resonse.

Arun

 

[sem]

We had the same issue with memory leak on OPS 8.1.7 (also Solaris). Try to look for a patch at Metalink, unfortunately I don't remember its number, but it was not public one (I found its number in forum but had to order it via local representative). Another (probably even less helpful) advice is to upgrade to 9i

Regards, Dima

http://seminihin.narod.ru