DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Out of Process memory

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Let me give a brief idea about our Server setup.

    OS : Windows NT 4.0
    Oracle Version : 8.1.5.0.0
    RAM : 3.8Gb.
    Virtual Mem : 6 Gb.
    No. of instances : 3.

    Out of the 3 databases, one is OLTP database(this is the db. in which 500 concurrent users will connect at peak time).
    Through database link we take a few information from the 2nd instance running on the same server. The other database will be used by warehouse.

    500 Concurrent users will establish connection with the OLTP database(a few of them using application and a few of them through the web).

    We use Oracle 9iAS as our application server(which is installed in a remote system).

    Problem:

    When any long running query is issued(which might use an index) or any batch programs are started, they are failing
    by giving the following error:

    ORA-04030: out of process memory when trying to allocate xxxxx bytes.

    Diagnose:

    1. More than 45% of memory was free(from the OS).
    2. The amount of Process memory allocated for all users did not go beyond 2Gb(for 200 users).

    It will be great if you can help us in resolving the problem.

    Thanks.
    Vijay.
    Say No To Plastics

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Have a look at Doc ID: 122887.1
    Also there are several bug associated with this error some of them fixed in 8.1.7. Check on Metalink.

    Sanjay

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    I have already looked at that document.

    In my case the SGA size is not 2gb. I have configured the
    SGA size only to 450mb.

    Thanks.
    Vijay.
    Say No To Plastics

  4. #4
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Guys I would appreciate your help in this regard.

    Thanks.
    Vijay.
    Say No To Plastics

  5. #5
    Join Date
    Sep 2002
    Posts
    15
    do you use MTS if not check the amount of memory the Oracle process is using windows nt.

    I had a similar issue on 7.3.4. with nt hitting a process limit at 1.8 gb (approx) - even though there was extra memory on the Server.

    I have upgraded to new servers using 8.1.7 and windows 2000. I have 4.5 gb - buffer cache of 1.8, shared_pool = 400 and 600 dedicated sessions.

    The Oracle process hit 900 megs (doesn't seem to show buffer cache included) and I start to get ora-12500 . Dropped session memory sort area size etc = oracle process using 700 + megs so more problems. I did get 2 instances of ora-4031 even though the shared pool had 120 megs free. Didn't pin much code, flush it once a week and removed an auto job that used 200 megs of shared pool to execute (didn't use this much on 7i).

    if you are getting a cannot allocate problem - could be fragmentation or memory leak.

    If you are getting problems logging = limit in process size.

    Hope this helps a little.

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    What's the optimizer mode set to?
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Sep 2002
    Posts
    15
    mine is always choose

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Which is very smart in the long run,Sean..

    Using something like cost can exhaust the optimiser and then he throw's up the exception.
    Well for the same reason you must also check if all those long running queries/batch jobs are taking advantages of bind variables..
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  9. #9
    Join Date
    Sep 2002
    Posts
    15
    am I right that oravijay's error is not ebing able to allocate x amount of continous space in the share_pool = which is basically fragmentation...

  10. #10
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    That might be the case here!
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

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