18c Containers Are Taking Up So Much PGA When Doing RMAN Backups
(Doc ID 2701635.1)
Last updated on JANUARY 14, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 18.6.0.0.0 to 20.0.0.0.0 Beta [Release 18 to 20.0]Information in this document applies to any platform.
Symptoms
RMAN backup fails with the following errors on 18C
RMAN-03009: failure of backup command on CH6 channel at 11/12/2019 20:37:04
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
The trace files shows most of the memory is allocated by 'KSFQ BUFFERS':
a. The PL/SQL code for SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE is being executed:
*** 2020-06-12T16:36:41.366281-05:00 (WPSDEV(7))
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
at 0x7ffda68e7a98 placed dbkda.c@295
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
at 0x7ffda68ebd28 placed krbb.c@5626
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x16118ade0 1707 package body SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=3, mask=0x0)
----- Error Stack Dump -----
at 0x7ffda68e7a98 placed dbkda.c@295
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
at 0x7ffda68ebd28 placed krbb.c@5626
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x16118ade0 1707 package body SYS.DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
b. Part of the call stack is:
ksesecl0()+189 call kgeselv() 7F64FA6F4980 ? 7F64F597DA60 ?
ksucin()+202 call ksesecl0() 7F64FA6F4980 ? 7F64F597DA60 ?
krbbpcint()+10605 call ksucin() 7F64FA6F4980 ? 7F64F597DA60 ?
krbbpc()+847 call krbbpcint() 7FFDA68EC6E1 7FFDA68ECFA0
krbibpc()+1911 call krbbpc() 7FFDA68EC6E1 7FFDA68ECFA0
pevm_icd_call_commo call krbibpc() 7F64F3F81280 00000001A
pfrinstr_ICAL()+162 call pevm_icd_call_commo 7FFDA68EEF30 ? 000000000
pfrrun_no_tool()+60 call pfrinstr_ICAL() 7F64F3F81280 ? 18289033E
pfrrun()+922 call pfrrun_no_tool() 7F64F3F81280 ? 18289033E ?
plsql_run()+755 call pfrrun() 7F64F3F81280 18289033E ?
ksucin()+202 call ksesecl0() 7F64FA6F4980 ? 7F64F597DA60 ?
krbbpcint()+10605 call ksucin() 7F64FA6F4980 ? 7F64F597DA60 ?
krbbpc()+847 call krbbpcint() 7FFDA68EC6E1 7FFDA68ECFA0
krbibpc()+1911 call krbbpc() 7FFDA68EC6E1 7FFDA68ECFA0
pevm_icd_call_commo call krbibpc() 7F64F3F81280 00000001A
pfrinstr_ICAL()+162 call pevm_icd_call_commo 7FFDA68EEF30 ? 000000000
pfrrun_no_tool()+60 call pfrinstr_ICAL() 7F64F3F81280 ? 18289033E
pfrrun()+922 call pfrrun_no_tool() 7F64F3F81280 ? 18289033E ?
plsql_run()+755 call pfrrun() 7F64F3F81280 18289033E ?
4. Actually all the processes that produced the error are using "KSFQ Buffers" in most of the PGA allocation memory:
TOP 10 MEMORY USES FOR THIS PROCESS
----------------------------------------
94% 108 MB, 30 chunks: "KSFQ Buffers " KSFQ heap ds=0x7f64f5b30c00 dsprt=0x7f64fa6f9280
2% 2502 KB, 89 chunks: "free memory " pga heap ds=0x7f64fa6f9280 dsprt=(nil)
1% 693 KB, 65 chunks: "kgnfs cmsg fragment " pga heap ds=0x7f64fa6f9280 dsprt=(nil)
0% 576 KB, 1 chunk : "dbgraim: pdb stage handle " diag pga ds=0x7f64fa6b47c0 dsprt=0x7f64fa6f9280
0% 360 KB, 28 chunks: "permanent memory "
----------------------------------------
94% 108 MB, 30 chunks: "KSFQ Buffers " KSFQ heap ds=0x7f64f5b30c00 dsprt=0x7f64fa6f9280
2% 2502 KB, 89 chunks: "free memory " pga heap ds=0x7f64fa6f9280 dsprt=(nil)
1% 693 KB, 65 chunks: "kgnfs cmsg fragment " pga heap ds=0x7f64fa6f9280 dsprt=(nil)
0% 576 KB, 1 chunk : "dbgraim: pdb stage handle " diag pga ds=0x7f64fa6b47c0 dsprt=0x7f64fa6f9280
0% 360 KB, 28 chunks: "permanent memory "
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |