Hi,
I have issue that PGA for a session on 10.2.0.5 database on IBM 64 bits is unable to go beyond 2GB. Where should I look to allow extend it beyond 2GB, I would thought with 64bit it should be able to grow beyond 2GB.?
ulimit for oracle
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) 4096
threads(per process) unlimited
processes(per user) unlimited
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1175
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1084
ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghucall ,pmuccst: adt/record)
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
92% 1816 MB, 116539 chunks: "pmuccst: adt/record "
koh-kghu call ds=11046bc18 dsprt=110073230
6% 113 MB, 7284 chunks: "pl/sql vc2 "
koh-kghu call ds=11046bc18 dsprt=110073230
2% 43 MB, 2773 chunks: "pmucalm coll "
koh-kghu call ds=11046bc18 dsprt=110073230
0% 1418 KB, 23 chunks: "permanent memory "
pga heap ds=110073230 dsprt=0
0% 1008 KB, 4 chunks: "kllcqas:kllsltba " SQL
QERHJ hash-joi ds=110811a38 dsprt=11058bbd8
0% 242 KB, 60 chunks: "kxsFrame4kPage "
session heap ds=11047a818 dsprt=11019ee60
0% 214 KB, 20 chunks: "static frame of inst "
koh-kghu sessi ds=110837d88 dsprt=11047a818
0% 128 KB, 1 chunk : "HT buckets " SQL
QERHJ hash-joi ds=110811a38 dsprt=11058bbd8
0% 123 KB, 12 chunks: "recursive addr reg file "
koh-kghu sessi ds=11084d140 dsprt=11047a818
0% 119 KB, 6 chunks: "free memory "
top uga heap ds=11019ee60 dsprt=0
=======================================
PRIVATE MEMORY SUMMARY FOR THIS PROCESS
---------------------------------------
******************************************************
PRIVATE HEAP SUMMARY DUMP
1982 MB total:
1981 MB commented, 1451 KB permanent
168 KB free (0 KB in empty extents),
1977 MB, 1 heap: "koh-kghu call " 12 KB free held