-
Hi all,
I have Oracle 9i running on Linux 7.3. The total ram on the box is 640M. I have the parameter copied as below and with these value for some reason, Oracle consume memory more than what I have specified on the parameter and I try to understand why. Every time , when I start Oracle, it take away 630M of ram and I have nothing running on this box, I only have oe database. please see below
db_block_size=8192
db_cache_size=25165824
db_file_multiblock_read_count=16
open_cursors=300
db_domain=""
db_name=TEST
background_dump_dest=/home/oracle/admin/TEST/bdump
core_dump_dest=/home/oracle/admin/TEST/cdump
timed_statistics=TRUE
user_dump_dest=/home/oracle/admin/TEST/udump
control_files=("/u01/oradata/TEST/control01.ctl", "/u02/oradata/TEST/control02.ctl", "/u01/oradata/TEST/control03.ctl")
instance_name=TEST
compatible=9.2.0.0.0
hash_join_enabled=TRUE
query_rewrite_enabled=TRUE
QUERY_REWRITE_INTEGRITY=TRUSTED
star_transformation_enabled=FALSE
max_enabled_roles=100
java_pool_size=33554432
large_pool_size=4194304
shared_pool_size=33554432
processes=150
fast_start_mttr_target=300
remote_login_passwordfile=EXCLUSIVE
pga_aggregate_target=25165824
sort_area_size=524288
=undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
Could someone please tell me how to fix this problem???
Thanks so much
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|