Hi,

I am running SAP R/3 on Oracle 816 EE / WinNT 4.0 EE.

RAM = 2 GB
Processors 4 x 733 XEON


My SGA is as below :

SHARED_POOL_SIZE = 381 MB
BUFFER CACHE = 703 MB (90000 x 8192)
JAVA POOL = 19 MB

All this comes out to 1103 MB.

These days when I see the Task Manager I have observed following :


CPU Utilization Above 40% and sometimes it reaches 70% also.
Memory allocated to Oracle.exe 1.35 GB.

My peformance is also getting very slow. Some is due to expensive queries, but how to attack this thins.

Help me !!!!