Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Memory Notification: Library Cache Object loaded into SGA

#MVivekMay 1 2018 — edited May 2 2018

Hi Experts,

Getting the below message frequently in alert log,

Memory Notification: Library Cache Object loaded into SGA

Heap size 51201K exceeds notification threshold (51200K)

Details in trace file /orabin2/oracle/PROD/11.2.0/admin/PROD_eglprodfidb01/diag/rdbms/prod/PROD/trace/PROD_ora_14820.trc

KGL object name :BOLINF.XXMBB_TRXNS_LINES_N11

Wed May 02 05:14:24 2018

Memory Notification: Library Cache Object loaded into SGA

Heap size 51201K exceeds notification threshold (51200K)

Details in trace file /orabin2/oracle/PROD/11.2.0/admin/PROD_eglprodfidb01/diag/rdbms/prod/PROD/trace/PROD_ora_14806.trc

KGL object name :BOLINF.XXMBB_TRXNS_LINES_N05

Wed May 02 05:14:43 2018

Memory Notification: Library Cache Object loaded into SGA

Heap size 51202K exceeds notification threshold (51200K)

Details in trace file /orabin2/oracle/PROD/11.2.0/admin/PROD_eglprodfidb01/diag/rdbms/prod/PROD/trace/PROD_ora_14806.trc

KGL object name :BOLINF.XXMBB_TRXNS_LINES_N04

Wed May 02 05:15:00 2018

Thread 1 cannot allocate new log, sequence 55005

Private strand flush not complete

  Current log# 17 seq# 55004 mem# 0: +REDO_RAID1/prod/onlinelog/redo17a.log

  Current log# 17 seq# 55004 mem# 1: +REDO_RAID1/prod/onlinelog/redo17b.log

Wed May 02 05:15:01 2018

Memory Notification: Library Cache Object loaded into SGA

Heap size 51203K exceeds notification threshold (51200K)

Details in trace file /orabin2/oracle/PROD/11.2.0/admin/PROD_eglprodfidb01/diag/rdbms/prod/PROD/trace/PROD_ora_14820.trc

KGL object name :BOLINF.XXMBB_TRXNS_LINES_N02

Beginning log switch checkpoint up to RBA [0xd6dd.2.10], SCN: 6448340151485

Thread 1 advanced to log sequence 55005 (LGWR switch)

  Current log# 10 seq# 55005 mem# 0: +REDO_RAID1/prod/onlinelog/redo10a.log

  Current log# 10 seq# 55005 mem# 1: +REDO_RAID1/prod/onlinelog/redo10b.log

Wed May 02 05:15:20 2018

Memory Notification: Library Cache Object loaded into SGA

Heap size 51200K exceeds notification threshold (51200K)

Details in trace file /orabin2/oracle/PROD/11.2.0/admin/PROD_eglprodfidb01/diag/rdbms/prod/PROD/trace/PROD_ora_14820.trc

KGL object name :BOLINF.XXMBB_TRXNS_LINES_N01

Flashing SGA and buffer cache is the temporary solution as we are doing now, but need a permanent solution.

Please help !!

thanks

Vivek

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2018
Added on May 1 2018
12 comments
3,883 views