Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle.exe consumed 80% Physical Memory on Windows OS

535871Jan 30 2010 — edited Jan 30 2010
Oracle.exe consumed 80% of memory and still on consumption. Below parameters are defined under which db is running,

Oracle 10g Enterprise Edition R2:

ORADB.__db_cache_size=4412407808
ORADB.__java_pool_size=16777216
ORADB.__large_pool_size=16777216
ORADB.__shared_pool_size=905969664
ORADB.__streams_pool_size=0
*.open_cursors=700
*.pga_aggregate_target=1073741824
*.processes=700
*.sessions=775
*.sga_target=5368709120
*.sga_max_size=5368709120

OS:

Windows 2003 Enterprise Edition 64 bit
Service Pack 2

Server Physical Memory:

16 GB

Server Virtual Memory:

32 GB defined on E Drive


Please suggest if anything wrong in parameters so that we can further fine tune them



Thanks,

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 27 2010
Added on Jan 30 2010
#general-database-discussions
1 comment
622 views