Get Data Moving 1
Results 1 to 2 of 2

Thread: ORA-04030: out of process memory when trying to allocate 138540 bytes

  1. #1
    i5mail is offline Junior Member
    Join Date
    May 2012
    Posts
    8
    Rep Power
    0

    Exclamation ORA-04030: out of process memory when trying to allocate 138540 bytes

    Hi,

    We are extracting data from VSAM datasets on z/OS.We use Oracle HSODBC. (ATT Server on z/OS)

    When we are extracting data from VSAM datasets, we watched memory usage of oracle*32.exe process from the task manager.

    We are getting "ORA-04030: out of process memory when trying to allocate 138540 bytes" error when we want to extract data from VSAM datasets via HSODBC. We have two kind of VSAM datasets, One of them were created by us.They are originally stored in z/OS as QSAM.Before extract process, We are converting these QSAM datasets to VSAM.

    The second VSAM datasets; We didnt make any change on them.When we are extracting these datasets, everything is fine.Memory usage of oracle*32.exe is normal.

    But When we are extracting other VSAM (Created from QSAM) datasets.Memory usage of oracle*32.exe is increasing very very fast.If it reaches approximately 2.5 GB, we are getting this oracle error. (ORA-04030: out of process memory when trying to allocate 138540 bytes)

    We have checked the VSAM definitions but we couldn't find any major differences.

    Does Anyone have any suggestion about this issue ?

    Regards,

    i5mail

  2. #2
    Join Date
    Sep 2006
    Posts
    233
    Rep Power
    10
    You will have to get this handled via the official support channel who would look into your environment in more details to help you isolate the issue and get it resolved.

    In more general terms, the code that runs on the Windows side is not aware of the differences between VSAM and QSAM. On the other hand, the kind of data (specifically, the data structures and data types involved) can affect the Windows side behavior -- in particular, the way groups (array) and variants (unions) are accessed is significant. Groups can be accessed as nested result-sets and if not closed, memory utilization will grow indefinitely. Also take notice if disconnecting your session results in the memory being released - that is an important piece of information support will need.
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

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