memory issue question and setup prob
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: memory issue question and setup prob

  1. #1
    Join Date
    Aug 2008
    Posts
    120

    memory issue question and setup prob

    Hello I am trying to navigate the problem i am having with memory issues and

    ORA-04031: unable to allocate 32 bytes of shared memory

    my memory set up this way by previous dba:

    Code:
    memory_target      = 0
    Mameroy_Max_target = 6442450944	
    large_pool_size	   = 0	
    sga_max_size	   = 6442450944	
    sga_target	   = 3170893824	
    shared_pool_size   = 0
    on oracle 11.2.03

    Please guide what should be and need done.

    Thanks
    Last edited by gandolf989; 02-01-2017 at 10:01 AM.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,133
    If this is Linux or Unix what do you get when you run "df -h /dev/shm" at the command line?
    this space intentionally left blank

  3. #3
    Join Date
    Aug 2008
    Posts
    120
    no it is on windows 2008 R2

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,133
    If you want to use AMM The you only need to set memory_max_target and memory_target.
    The total of your pga_aggregate_limit and sga_max_size can not exceed memory_max_target.
    You should be able to specify the parameters as I have them and the database will manage
    the memory for you.

    Code:
    alter system set memory_max_target       = 6G    scope=spfile;
    alter system set memory_target           = 6G    scope=spfile;
    
    alter system set pga_aggregate_limit     = 2G    scope=spfile;
    alter system set pga_aggregate_target    = 2G    scope=spfile;
    alter system set sga_max_size            = 4G    scope=spfile;
    alter system set sga_target              = 4G    scope=spfile;
    this space intentionally left blank

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width