ERROR: SGA memory leak detected 288
SGA Memory Leak Detected in trace file
Hello,
I have discovered a trace file (see below) alerting me to an SGA Memory Leak - no Oracle error code was listed in the message. I need some advice as to how serious this is and whether I should be contacting my local Oracle support for help. What is strange is this file is not referenced at all in the alert log for the instance. However, looking at the timestamp, it appears to have been generated when the database was being shutdown (this occurs nightly).
Can anyone shed some light on this for me please?
Dump file /ora_home/app/oracle/admin/MIS/udump/ora_19825_mis.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
ORACLE_HOME = /ora_home/app/oracle/product/8.1.7
System name: HP-UX
Node name: warehse1
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: MIS
Redo thread mounted by this instance: 0 <none>
Oracle process number: 9
Unix process pid: 19825, image: oracle@warehse1
*** SESSION ID:(8.1) 2003-01-09 02:00:40.396
******** ERROR: SGA memory leak detected 288 ********
******************************************************
HEAP DUMP heap name="sga heap" desc=0xc00000000a22a040
extent sz=0xfe0 alt=96 het=32767 rec=9 flg=2 opc=0
parent=0 owner=0 nex=0 xsz=0x212cad8
EXTENT 0
Chunk c000000008001010 sz= 17395392 perm "perm " alo=569478
4
Chunk c000000009097ed0 sz= 13464288 free " "
Chunk c000000009d6f1b0 sz= 288 freeable "active checkpo "
Chunk c000000009d6f2d0 sz= 871896 free " "
Chunk c000000009e440a8 sz= 40 R-freeable "reserved stoppe"
Chunk c000000009e440d0 sz= 3000000 R-free " "
Chunk c00000000a120790 sz= 40 R-freeable "reserved stoppe"
Chunk c00000000a1207b8 sz= 54048 free " "
Total heap size = 34785992
FREE LISTS:
Bucket 0 size=32
Bucket 1 size=40
Bucket 2 size=48
Bucket 3 size=56
Bucket 4 size=64
etc etc etc
Bucket 252 size=16408
Bucket 253 size=32792
Chunk c00000000a1207b8 sz= 54048 free " "
Bucket 254 size=65560
Chunk c000000009d6f2d0 sz= 871896 free " "
Chunk c000000009097ed0 sz= 13464288 free " "
Total free space = 14390232
RESERVED FREE LIST:
Chunk c000000009e440d0 sz= 3000000 R-free " "
Total reserved free space = 3000000
UNPINNED RECREATABLE CHUNKS (lru first):
SEPARATOR
Unpinned space = 0 rcr=0 trn=0
PERMANENT CHUNKS:
Chunk c000000008001010 sz= 17395392 perm "perm " alo=569478
4
Permanent space = 17395392
******************************************************
Thanks for your time.
Gail
From: Oracle, Rajiv Bhawar 17-Jan-03 14:46
Subject: Re : ERROR: SGA memory leak detected 288
From: Gail Creighton 17-Jan-03 14:49
Subject: Re : ERROR: SGA memory leak detected 288
From: Oracle, Rajiv Bhawar 20-Jan-03 14:02
Subject: Re : ERROR: SGA memory leak detected 288
SGA Memory Leak Detected in trace file
Hello,
I have discovered a trace file (see below) alerting me to an SGA Memory Leak - no Oracle error code was listed in the message. I need some advice as to how serious this is and whether I should be contacting my local Oracle support for help. What is strange is this file is not referenced at all in the alert log for the instance. However, looking at the timestamp, it appears to have been generated when the database was being shutdown (this occurs nightly).
Can anyone shed some light on this for me please?
Dump file /ora_home/app/oracle/admin/MIS/udump/ora_19825_mis.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production
ORACLE_HOME = /ora_home/app/oracle/product/8.1.7
System name: HP-UX
Node name: warehse1
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: MIS
Redo thread mounted by this instance: 0 <none>
Oracle process number: 9
Unix process pid: 19825, image: oracle@warehse1
*** SESSION ID:(8.1) 2003-01-09 02:00:40.396
******** ERROR: SGA memory leak detected 288 ********
******************************************************
HEAP DUMP heap name="sga heap" desc=0xc00000000a22a040
extent sz=0xfe0 alt=96 het=32767 rec=9 flg=2 opc=0
parent=0 owner=0 nex=0 xsz=0x212cad8
EXTENT 0
Chunk c000000008001010 sz= 17395392 perm "perm " alo=569478
4
Chunk c000000009097ed0 sz= 13464288 free " "
Chunk c000000009d6f1b0 sz= 288 freeable "active checkpo "
Chunk c000000009d6f2d0 sz= 871896 free " "
Chunk c000000009e440a8 sz= 40 R-freeable "reserved stoppe"
Chunk c000000009e440d0 sz= 3000000 R-free " "
Chunk c00000000a120790 sz= 40 R-freeable "reserved stoppe"
Chunk c00000000a1207b8 sz= 54048 free " "
Total heap size = 34785992
FREE LISTS:
Bucket 0 size=32
Bucket 1 size=40
Bucket 2 size=48
Bucket 3 size=56
Bucket 4 size=64
etc etc etc
Bucket 252 size=16408
Bucket 253 size=32792
Chunk c00000000a1207b8 sz= 54048 free " "
Bucket 254 size=65560
Chunk c000000009d6f2d0 sz= 871896 free " "
Chunk c000000009097ed0 sz= 13464288 free " "
Total free space = 14390232
RESERVED FREE LIST:
Chunk c000000009e440d0 sz= 3000000 R-free " "
Total reserved free space = 3000000
UNPINNED RECREATABLE CHUNKS (lru first):
SEPARATOR
Unpinned space = 0 rcr=0 trn=0
PERMANENT CHUNKS:
Chunk c000000008001010 sz= 17395392 perm "perm " alo=569478
4
Permanent space = 17395392
******************************************************
Thanks for your time.
Gail
From: Oracle, Rajiv Bhawar 17-Jan-03 14:46
Subject: Re : ERROR: SGA memory leak detected 288
Hi,
Please check for any ora-00600 space leak errors in the alert.log file.
Let me know your feedback.
Rajiv
From: Gail Creighton 17-Jan-03 14:49
Subject: Re : ERROR: SGA memory leak detected 288
Hi
Thanks for your reply. There's absolutely nothing reported in the alert log, no ORA messages at all.
Thanks
Gail
From: Oracle, Rajiv Bhawar 20-Jan-03 14:02
Subject: Re : ERROR: SGA memory leak detected 288
Hi,
Then you can ignore such messeges.
This could be part of routine housekeeping operation.
Incase of any space leakage of higher memory size oracle will report ora-00600 in the alert.log.
Rajiv