Hello all,
We have been receiving some various out of memory errors and database just crashes after a while.
Version 11.2.0.4 on Windows server 2012
ORA-04030: out of process memory when trying to allocate 4104 bytes (kksfr: qkesSet,frame segment)
ORA-04030: out of process memory when trying to allocate 824504 bytes (pga heap,kco buffer)
ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key)
ORA-04030: out of process memory when trying to allocate 123416 bytes (QERHJ hash-joi,kllcqas:kllsltba)
The server has 32GB and is physical and the database SGA is at 24GB so should be plenty but not quite sure if upping the memory would solve anything or is it something that is likely straining the DB.
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 10 08:38:16 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: sys / as sysdba
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
SQL> show sga
Total System Global Area 2.4052E+10 bytes
Fixed Size 2292168 bytes
Variable Size 2550138424 bytes
Database Buffers 2.1475E+10 bytes
Redo Buffers 24657920 bytes
SQL>
Is it really the PGA ?
Please let me know if you nee more info
Thanks all