DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Hi All,

    I am running an .plb file at SQL*Plus that contains over 70 wrapped procedures. I get the following error for a particular procedure.

    ERROR at line 1:
    ORA-04030: out of process memory when trying to allocate 391296 bytes (PLS non-lib hp,PAR.C:parchk:ptb)

    The error does not occur if only the single procedure is created.

    Database info: version 8.1.6 on Windows NT
    db_block_size = 8192
    sort_area_size = 65536
    sort_area_retained_size = 65536

    db_block_buffers = 2048

    shared_pool_size = 15728640

    large_pool_size = 614400
    java_pool_size = 20971520

    Please help..


  2. #2
    Join Date
    Jul 2002
    From metalink:

    This is happening because your process memory is getting exhausted. The possible solutions would be

    - Increase the ulimit ( virtual memory ) to unlimited.
    % ulimit -a would give you the current settings.

    - Decrease the SGA size, if it is set to a very large value. This is required if you are hitting the address space limits.

    - You may also try decreasing the parameters like sort_area_size , bitmap_merge_area_size , create_bitmap_area_size .

    - You can also free up the unused PGA memory by running the procedure dbms_session.free_unused_user_memory..

    If your application uses lots of PL/SQL tables, it might be a good idea to initialize them to NULL when not used. This will force
    the garbage collection and there by freeing up the process memory.

  3. #3
    Are you using Java on Oracle? If no then why do you require such a big Java_pool_size? Set it to 0 and increase the shared_pool_size/large_pool_size.

    Shyami.S.Seelan, OCP 8i, 9i DBA
    Dublin, Ireland.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.