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