I am trying to determine why an Oracle app is using a lot of storage (and growing and growing). I am not sure if it¹s application related or not. Initially I saw lots of OCIParamGet() calls with no corresponding OCIDescriptorFree() calls. However, after correcting this there was no respite from memory consumption.
Looking at the memory contents as the app runs to see what's in the new areas allocated I see lots of "Alloc statemen" eye-catchers. Statement handles are being created OCIHandleAlloc() and freed via OCIHandleFree() without error. This is Oracle 10g. Creating .sqlnet.ora with the following provides a lot of data but sheds no light: trace_level_client=16 trace_file_client=cli trace_directory_client=/tmp/oci trace_unique_client=true trace_timestamp_client=ON I'd really like to find out why Oracle believes the area cannot be freed. A similar app runs on Windows without a problem so I'd like some way of tracing all the OCI calls being made in both environments and compare them to see what magic incantation may be missing. Neale ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/
