peledc
asked on
Memory usage by 10g
Version Oracle 10.1.0.2
OS is Windows XP or 2K.
I'm trying to minimize the use of RAM but the minimum stated usage of
JAVA_POOL_SIZE =20M and
SHARED_POOL_SIZE=40M
I set DB_CACHE_SIZE=28M
total SGA size is around 100M and the process on windows shows it takes 145M.
Is there a safe way to reduce this memory usage
OS is Windows XP or 2K.
I'm trying to minimize the use of RAM but the minimum stated usage of
JAVA_POOL_SIZE =20M and
SHARED_POOL_SIZE=40M
I set DB_CACHE_SIZE=28M
total SGA size is around 100M and the process on windows shows it takes 145M.
Is there a safe way to reduce this memory usage
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
One easy way is to turn off the "OracleDBconsole<sid>"
This will free arounf 70M
Than, reduce the Java pool size to 4m and large pool size to 8m;
Thanks any way,
Peled