Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    21

    Unanswered: can't connect a db after getting several ORA-04031 errors

    Hello:
    Several files were due to upload to an oracle database can't certainly know what went wrong but i got the ORA-04031 a thousand times with this legend: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGER$","sga heap","state objects")
    funny, it ain't over I wanted to connect the db and now Im unable to
    any idea?

  2. #2
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    quewstions

    What Oracle version?
    What OS are you running on? (win2000, XP, Solaris, etc..)
    Michellea Southern-David

  3. #3
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    metalink answer

    Michellea Southern-David

  4. #4
    Join Date
    Oct 2003
    Posts
    21

    Re: quewstions

    Originally posted by msouthern
    What Oracle version?
    What OS are you running on? (win2000, XP, Solaris, etc..)
    Oracle version:8.1.7
    OS:AIX 5.2

  5. #5
    Join Date
    Oct 2003
    Posts
    21

    Re: metalink answer

    Originally posted by msouthern
    http://metalink.oracle.com/metalink/...l2_gui.startup

    Check out this metalink article.
    I am afraid i can't i don't have any valid user logon.

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You are going to have to "bump" the database. The SGA has become fragmented with objects being loaded and flushed from the shared pool. As Oracle needs to load into the pool, it must have enough contiguous space to load the object. When there is not enough contiguous space, you get the error you are looking at ...

    Try Pinning objects in memory that have large number of reloads ...
    Also look at pinning larger objects in the SGA so they don't get flushed out. I do this with a database startup trigger ...

    Attached is a script to look at objects that have been reloaded
    and objects that are subjects for pinning based on size and loads and
    executions ...

    HTH
    Gregg
    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
  •