This discussion is archived
5 Replies Latest reply: Oct 3, 2012 6:43 AM by 933651 RSS

oracle ram

933651 Newbie
Currently Being Moderated
Hello everyone!
I don't know if I am in the right part of forum, but I have installed oracle 11g on red hat linux 5.5

I really can't understand why the total ram usage of my system is about 2gb when I have 64 GB.

So oracle is using maybe about 1gb.

mu spfile is like this:

# Cache and I/O
###########################################
db_block_size=8192
db_cache_size=1024M
db_files=128

###########################################
# Cursors and Library Cache
###########################################
open_cursors=1300

###########################################
# Diagnostics and Statistics
###########################################

timed_statistics=TRUE


###########################################
# Distributed, Replication and Snapshot
###########################################
remote_login_passwordfile=EXCLUSIVE

###########################################


###########################################
# MTS
###########################################
#dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.ser
ver.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

###########################################
# Miscellaneous
###########################################





###########################################
# Pools
###########################################
java_pool_size=536870912
large_pool_size=16777216
shared_pool_size=5G

###########################################
# Processes and Sessions
###########################################
processes=255
sessions=286
transactions=315

###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300

###########################################
# Resource Manager
###########################################
#resource_manager_plan=SYSTEM_PLAN

###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
hash_area_size=1048576
sort_area_size=1048576

###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_retention=10800

job_queue_processes=10

pga_aggregate_target = 1409286144
optimizer_features_enable='10.2.0.4'
  • 1. Re: oracle ram
    Balazs Papp Expert
    Currently Being Moderated
    I really can't understand why the total ram usage of my system is about 2gb when I have 64 GB.
    So oracle is using maybe about 1gb.
    post the output that confirms it

    also 5GB shared pool looks like a big overkill compared to others in this configuration (pga, buffer cache)
  • 2. Re: oracle ram
    952768 Journeyer
    Currently Being Moderated
    Is this the real output of your spfile?

    Maybe you have shown the output of an initDB.ora

    Can you provide the output with
    strings spfileDB.ora
  • 3. Re: oracle ram
    933651 Newbie
    Currently Being Moderated
    it is the init, but this was used to create the spfile
  • 4. Re: oracle ram
    952768 Journeyer
    Currently Being Moderated
    To be sure please provide the output of the spfile file.
  • 5. Re: oracle ram
    933651 Newbie
    Currently Being Moderated
    *.db_block_size=8192
    *.db_cache_size=1024M
    *.db_files=128


    *.fast_start_mttr_target=300
    *.hash_area_size=1048576

    *.java_pool_size=536870912
    *.job_queue_processes=10
    *.large_pool_size=16777216




    *.nls_length_semantics='CHAR'
    *.open_cursors=1300
    *.optimizer_features_enable='10.2.0.4'
    *.pga_aggregate_target=1409286144
    *.processes=255
    *.remote_login_passwordfile='EXCLUSIVE'

    *.sessions=286
    *.shared_pool_size=5G
    *.sort_area_size=1048576

    *.timed_statistics=TRUE
    *.transactions=315
    *.undo_management='AUTO'
    *.undo_retention=10800

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points