MEMORY I/O CONTENTION ON ORACLE 9I

[ashley75]

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

[marist89]

What does show sga say?

[ashley75]

Total System Global Area 114364796 bytes
Fixed Size 450940 bytes
Variable Size 88080384 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.

I noticed that the variable size is huge, could you please tell me why ??? and what else I need to do to fix this problem???

thanks as always JEFF

[marist89]

Your SGA size is only 114M. The Variable Size is mainly made up from your large pool, java pool, and shared pool. You think you are allocating about 68M, but you must remember that oracle will allocate in granules. Also, there are other parameters that contribute to the SGA size. I think this looks about right for what you have specified.

If Oracle really is taking 630M at startup, I would look at your kernal parameters. You may have the minimum shared memory segment at 640M or something.

[ashley75]

If Oracle really is taking 630M at startup, I would look at your kernal parameters. You may have the minimum shared memory segment at 640M or something.
[/B][/QUOTE]

Thanks for your reply, this is the first time I install Oracle on Linux environement so I don't know much about the Unix side. per your advise, I might have the minimum shared memory segment at 640M or something, how to I check that??? What do I need to do ???

Please help me b/c I want to learn more about Unix.

Thanks so much Jeff

[marist89]

I don't know about linux, but on solaris the kernal parameters are in the /etc/system file.

See http://metalink.oracle.com/metalink/...&p_id=144638.1 for kernal paramter definitions.

[pando]

Originally posted by ashley75
Oracle consume memory more than what I have specified

Hw do you determine it's using more than you specified? With what command?

[ashley75]

by looking at the paramter I specified above, plus my SGA.

Do you have any solutions or advises????

Thanks

[marist89]

The parameters you have specified above say your SGA is only 114 MB. How do you get 630 MB?

[pando]

Originally posted by marist89
The parameters you have specified above say your SGA is only 114 MB. How do you get 630 MB?

That's why I wonder