Issue Information
| Incident Number | 701328a |
| Issue | Memory management issues occur when using PSM and system-defined packages. Session-scope memory leaks and overruns exceeding the size of allocated strings have been identified. Issues occur in various situations, such as converting LONG columns to XML in XMLGEN, calling INSTR with a LOB pattern in DBMS_LOB, type mismatches when calling Column_value in DBMS_SQL, using nested tables in PSM, and errors occurring in specific packages. |
| Cause | In some cases, inconsistencies occurred during memory allocation and deallocation. There was a risk of overruns exceeding the memory size range. |
| Solutions | Protective logic is added to ensure that memory is properly deallocated within a session. |
| Occurrence Date | 26.08.27. |
| Required Patch Version | 7FS02PS |
Patch Information
| Patch Name | FS02PS_701328a |
| Major Version | 7 |
| Minor Version | FS02PS |
| Version Title | Fix for Memory Leak Occurring Within a Session When Using DBMS_LOB.INSTR and DBMS_XMLQUERY |
| Available for Deployment | 26.09.11. |
| Compatibility | • TAC rolling patch: Supported • TSC rolling patch: Supported • Backup data compatibility: Supported • Protocol compatibility: Supported • Data format compatibility: Supported |
| AP Impact | • Plan change: No • Result value change: No • SQL syntax change: No • System object change: No • Existing functionality change: No |
| Parameters | - |
| Workaround | Because this is a memory leak within a session, there is no impact in cases where a single statement is executed and the session is then terminated. In addition, although it is a memory leak, the amount is relatively small, so there is little to no impact unless a very large number of statements are executed. |