Running out of memory
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Running out of memory

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    Running out of memory

    Hi Friends,

    I always get an ORA-4031 error (out of memory).
    What V$ performance view will I get the info of current
    running programs that eat a lot of memory (the most)?


    Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is the OS & Oracle ?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Shared Pool Fragementation.
    Search Metalink. There are few good documents on this. Also there are some associated bugs.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    There are many reasons why you get 4031 error.
    1 Shared Pool Size is small
    2 Fragmentation in SP

    You can flush the recreateable objects in the SP by issuing
    "ALTER SYSTEM FLUSH SHARED_POOL" statement. However, there is a drawback here. The cached sequences are gone. In order to avoid the gaps in the sequences, you have to pin the Sequences after the db startup. Also, you must pin large pkgs after the db startup.

  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Hi Thanks all,

    Sorry to repond late,

    OS AIX 4.3.2
    DB 8.1.7


    I already increased shared_pool from 60Mb to 120Mb. We
    have 1Gb memory.
    I also flush shared_pool every 12mn. Is bouncing the DB back
    better?
    But the error still persist.
    I'm still trying to download the mentioned patch (8.1.7.4)

  6. #6
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    8
    This problem occured to me
    ENV: oracle 8.1.6.2 on HP-UX 64
    condition: loading xml files into temp tables by using DBMS_XMLSAVE
    package.

    solution: metalink document says:

    1. create special functions with system or sys as owner(don't remember)

    2. execute these functions for the session which is having this memory problem.

    3. These functions increase session memory for the duration of the session.

    4. I was told these bugs will be fixed in 8.1.7 version.

    Good luck !!
    Brahmaiah Koniki

  7. #7
    Join Date
    Aug 2003
    Location
    China
    Posts
    4
    You may reference the Note:146599.1 in metalink.
    Oracle Is My all.

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