Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory

Threaded View

  1. #1
    Join Date
    Apr 2001
    Location
    Ludhiana (Punjab) India
    Posts
    36

    Question Ora-04031 Unable To Allocate 316 Bytes Of Shared Memory

    HELLO ORACLE GURU'S

    I AM FACING A STRANGE PROBLEM I MY DATABASE I HAVE 2 VIEWS :
    PENDING_ANX_IV_POST_VIEW & PENDING_ANX_V_POST_VIEW.
    WHEN EVER I USE TO RUN THESE VIEWS THEY BOTH GIVE SAM ERROR :

    ORA-04031: unable to allocate 316 bytes of shared memory
    ("large pool","unknown object","cursor work he","kdiixs1 : kdipc")

    HOWEVER WHEN I VIEW SHARED POOL AND LARGE POOL THE STATISTICS IS :


    SGA CACHE STATISTICS
    ********************
    SQL Cache Hit rate = 99.73
    Dict Cache Hit rate = 92.03
    Buffer Cache Hit rate = 99.93
    Redo Log space requests = 1
    Total SGA = 292.69

    INIT.ORA SETTING
    ****************
    Shared Pool Size = 149380352 Bytes
    DB Block Buffer = 47202 Blocks
    Log Buffer = 32768 Bytes



    Main SGA Areas NAME SUM(BYTES)
    -------------------- -------------------- ----------------
    DB Buffer Cache db_block_buffers 386,678,784
    Shared Pool shared pool 158,447,628
    Large Pool large pool 40,405,560
    Redo Log Buffer log_buffer 65,536
    Fixed SGA fixed_sga 65,484
    ----------------
    585,662,992


    Shared Pool Areas NAME SUM(BYTES)
    -------------------- -------------------- ----------------
    Shared Pool free memory 133,477,124
    Shared Pool miscellaneous 14,100,744
    Shared Pool sql area 5,939,240
    Shared Pool library cache 4,290,964
    Shared Pool dictionary cache 639,556
    ----------------
    sum 158,447,628




    I AM ATTACHING SOURCE CODE OF BOTH VIEWS. WHEN I USE TO RUN THESE VIEWS BY MAKING PART OF IT. THEY RUN SUCCESFULLY. I AM NOT GETTING WHAT IS THE PROBLEM.

    PLEASE HELP WHAT IS THE REASON.

    REGARDS

    GURPREET SINGH SETHI
    Attached Files Attached Files

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