5 Replies Latest reply: Oct 3, 2012 8:43 AM by 933651 RSS

    oracle ram

    933651
      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
          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
            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
              it is the init, but this was used to create the spfile
              • 4. Re: oracle ram
                952768
                To be sure please provide the output of the spfile file.
                • 5. Re: oracle ram
                  933651
                  *.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