Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    46

    Unanswered: ora-04031 - sga heap memory

    Hello,

    I have again faced the shared memory error.
    I am attaching the trace file when the error occured.

    Pl. advice me to resolve this issue for ever and explain me what the trace file says.

    Thanks
    Attached Files Attached Files

  2. #2
    Join Date
    Oct 2005
    Posts
    61
    Can you post the code running which you get this error?
    Seems to me bind variables are not being used.

    Srinivas

  3. #3
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    You might need to increase your shared pool size and or sga_max_size.

    Alan

Posting Permissions

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