Severe Perfromance Degradation When Querying LOB Data (Doc ID 2178763.1)

Last updated on NOVEMBER 23, 2016

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.
IE performance degrades while fetching LOBS from database

Symptoms

 ORA-04030: out of process memory when trying to allocate 55600 bytes
(qmcxdDecodeIni,qmemNextBuf:Large Alloc)
.
*** 2016-06-13 14:49:21.377
.
TOP 10 MEMORY USES FOR THIS PROCESS
.
37% 7982 MB, 611319 chunks: "permanent memory "
kolarsCreateCt ds=0x2b5530644f78 dsprt=0x2b4fd5557000
26% 5673 MB, 436637 chunks: "permanent memory "
qmcxdDecodeIni ds=0x2b5530640c28 dsprt=0x2b5530644f78
20% 4380 MB, 88934 chunks: "free memory "
top uga heap ds=0xc176280 dsprt=(nil)
7% 1636 MB, 175378 chunks: "free memory "
session heap ds=0x2b4fd4fc61a0 dsprt=0xc176280
5% 1016 MB, 87328 chunks: "qmcxdDecode:ctx "
kolarsCreateCt ds=0x2b5530644f78 dsprt=0x2b4fd5557000
3% 662 MB, 349325 chunks: "permanent memory "
qmxpInitPrintW ds=0x2b5530642d68 dsprt=0x2b5530644f78
1% 305 MB, 87328 chunks: "free memory "
qmcxdDecodeIni ds=0x2b5530640c28 dsprt=0x2b5530644f78
0% 77 MB, 4934 chunks: "kollalos2 "
koh-kghu sessi ds=0x2b4fd4fef660 dsprt=0x2b4fd4fc61a0
0% 17 MB, 87328 chunks: "qmcxdDecodeInit "
kolarsCreateCt ds=0x2b5530644f78 dsprt=0x2b4fd5557000
0% 16 MB, 87331 chunks: "kolars: kolarsCreateCtx "
koh dur heap d ds=0x2b4fd5557000 dsprt=0x2b4fd4fc61a0
.
PRIVATE HEAP SUMMARY DUMP
17 GB commented, 616 KB permanent
4380 MB free (0 KB in empty extents),
21 GB, 1 heap: "session heap " 4380 MB free held
.
Top 10 processes:
-------------------------
(percentage is of 23 GB total allocated memory)
93% pid 116: 17 GB used of 21 GB allocated <= CURRENT PROC
1% pid 96: 155 MB used of 230 MB allocated (49 MB freeable)
1% pid 109: 129 MB used of 166 MB allocated (18 MB freeable)
.
Begin session detail for pid 116
sid: 2739 ser: 1145 audsid: 36639071 user: 725/GGSADMIN2
pid: 116 O/S info: user: oracle, term: UNKNOWN, ospid: 32280
client details:
O/S info: user: oracle, term: , ospid: 32271
machine: campshlqdb01.gbcaydc.emea.bankofamerica.com program:
extract@campsh
lqdb01.gbcaydc.emea.bankofamerica.
application name: OGG-E01GPPME-GLOPEN_DATA_SOURCE, hash value=742385963
.
----- Current SQL Statement for this session (sql_id=8s1uts9qqk3p8) -----
SELECT x."P_MID",XMLSERIALIZE(CONTENT x."XML_ORIG_MSG"),XMLSERIALIZE(CONTENT
x."
XML_MSG"),x."P_OFFICE",x."P_DEPARTMENT",x."P_MSG_TYPE",x."P_MSG_SUB_TYPE",x."P
_C
DT_MOP",x."P_PREFERRED_CDT_MOP",x."P_NON_ACC",x."P_MSG_STS",x."P_DBT_CUST_CD",
x.
...
FROM "PMTS_HUB_OWNER"."MINF" x WHERE ROWID = :rid

Changes

Integrated Extract using FETCHCOLS for LOBs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms