[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 724
  • Last Modified:

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
0
peledc
Asked:
peledc
1 Solution
 
schwertnerCommented:
You will loose the functionality of Oracle if you try to reduce the memory usage.
The only thing I see is to turn off some of the unused processes. But this is too complex.
0
 
peledcAuthor Commented:
Hi schwertner,

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
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now