shared memory error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: shared memory error

  1. #1
    Join Date
    Feb 2006
    Posts
    34

    shared memory error

    Hi,

    How to solve below error msg. Just restarted that particular database. users can able to access now.

    DISTRIB TRAN MIMS.WORLD.d0c46b42.5.16.9664
    is local tran 5.16.9664 (hex=05.10.25c0)
    insert pending collecting tran, scn=621062569 (hex=0.2504a9a9)
    *** 2006-08-06 07:47:05.923
    SMON: following errors trapped and ignored:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
    n object","sga heap","multiblock rea")
    *** 2006-08-06 09:50:00.500
    SMON: following errors trapped and ignored:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-04031: unable to allocate 4128 bytes of shared memory ("shared pool","unknow
    n object","sga heap","multiblock rea")

    Regards.
    Last edited by vijill; 08-07-2006 at 12:25 AM.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    either your shared pool isnt being enough, or you arent using bind variables

  3. #3
    Join Date
    Feb 2006
    Posts
    34
    What is the formula to increase shared pool. Please let me know.

    regards.

  4. #4
    Join Date
    Feb 2006
    Posts
    34
    There was 6 instances are running on same server.rest of the instances shared memory is lower than this . Do not know why this database instance is having shared memory error very frequent. Please advice me on this.

    db_name = "RIS"
    db_domain = WORLD

    instance_name = RIS

    service_names = RIS.WORLD


    control_files = ("/ris1/RIS/control01.ctl", "/ris1/RIS/control02.ctl", "/ris1/RI
    S/control03.ctl")

    open_cursors = 300
    max_enabled_roles = 30

    db_block_buffers = 8000
    db_file_multiblock_read_count=8

    shared_pool_size = 52428800

    large_pool_size = 10485760
    java_pool_size = 0

    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 3600

    processes = 80

    log_buffer = 163840

    # audit_trail = false # if you want auditing
    timed_statistics = true # if you want timed statistics
    max_dump_file_size = 10000 # limit trace file size to 5M each

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    6 instances on one server? deary me

    original statement still holds, either you arent using bind variables or your shared pool isnt big enough

  6. #6
    Join Date
    Feb 2006
    Posts
    34
    How do we increase shared pool size. what is the formula for this. please advise me on this.

    regards.

  7. #7
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Quote Originally Posted by davey23uk
    6 instances on one server? deary me
    The biggest server I have ever seen is with 70 instances in an old Fujitsu-Siemens RM-600 Server. We never got a chance to re-boot the because of the various appliations for 248 days and finally hit the bug: 1084273 ( Note: 118228.1).
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    how much memory do you have on that server

  9. #9
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    lol... Sorry Devey, I don't remember the specs of the server as this is something 5 years back!
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the question was aimed at the OP :-)

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