Memory allocation of 872 bytes of type 'tab' failed at location BrTabListGet-23

[farkathulla_cikkanther]

Hello Friends,

  When we run the update statistics and Check DB in DB 13, It is getting failure and throws below error in log.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

BR0280I BRCONNECT time stamp: 2015-05-07 00.00.26

BR0813I Schema owner found in database QA1: SAPSR3*

BR0254E Memory allocation of 872 bytes of type 'tab' failed at location BrTabListGet-23

BR0280I BRCONNECT time stamp: 2015-05-07 00.00.29

BR0301W SQL error -1456 at location brc_dblog_close-1, SQL statement:

'FETCH curs_52'

'UPDATE SAP_SDBAH SET RC = '0003', ENDE = '20150507000029', LINE = '7.20 (41) stats ALL JID=STATS20120110000000' WHERE BEG = '20150507000024' AND FUNCT = 'sta' AND SYSID = 'QA1''

ORA-01456: may not perform insert/delete/update operation inside a READ ONLY transaction

BR0326W Update of database log header failed

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Alert Log:

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Wed May 06 17:44:33 2015                                                                                                   |

|Errors in file F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\trace\qa1_ora_6316.trc  (incident=17129):                         |

|ORA-04030: out of process memory when trying to allocate 4194328 bytes (QERHJ hash-joi,HT buckets)                         |

|Incident details in: F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\incident\incdir_17129\qa1_ora_6316_i17129.trc               |

|Use ADRCI or Support Workbench to package the incident.                                                                    |

|See Note 411.1 at My Oracle Support for error and packaging details.                                                       |

|Errors in file F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\trace\qa1_ora_6316.trc  (incident=17130):                         |

|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 4194328 bytes (QERHJ hash-joi,HT buckets)                         |

|Incident details in: F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\incident\incdir_17130\qa1_ora_6316_i17130.trc               |

|Use ADRCI or Support Workbench to package the incident.                                                                    |

|See Note 411.1 at My Oracle Support for error and packaging details.                                                       |

|Errors in file F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\incident\incdir_17129\qa1_ora_6316_i17129.trc:                    |

|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 4194328 bytes (QERHJ hash-joi,HT buckets)                         |

|Errors in file F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\trace\qa1_ora_6316.trc  (incident=17131):                         |

|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 4194328 bytes (QERHJ hash-joi,HT buckets)                         |

|Incident details in: F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\incident\incdir_17131\qa1_ora_6316_i17131.trc               |

|Use ADRCI or Support Workbench to package the incident.                                                                    |

|See Note 411.1 at My Oracle Support for error and packaging details.                                                       |

|Wed May 06 17:44:37 2015                                                                                                   |

|Dumping diagnostic data in directory=[cdmp_20150506174437], requested by (instance=1, osid=6316), summary=[incident=17130].|

|Errors in file F:\ORACLE\QA1\SAPTRACE\diag\rdbms\qa1\qa1\incident\incdir_17129\qa1_ora_6316_i17129.trc:                    |

|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 4194328 bytes (QERHJ hash-joi,HT buckets)                         |

|Wed May 06 17:44:39 2015                                                                                                   |

|Sweep [inc][17131]: completed                                                                                              |

|Sweep [inc][17130]: completed                                                                                              |

|Sweep [inc][17129]: completed                                                                                              |

|Sweep [inc2][17131]: completed                                                                                             |

|Sweep [inc2][17130]: completed                                                                                             |

|Sweep [inc2][17129]: completed                                                     

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

What could be the reason for this error.

Which memory is need to be extend to run this process.

Please find the alert log file and update statics log file.

Regards,

Farkath C

Alert log.txt.zip

DBstaterror.txt.zip

[AtulKumarJain]

Hi,

Please check

Check Note 789011 - FAQ: Oracle memory areas

Please check below thread as well.

ORA-04030: out of process memory when trying to allocate 8192 bytes - Toolbox for IT Groups

BR

AKJ