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 !!!!