ERROR: SGA memory leak detected

原创 2004年10月22日 11:23:00
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

Spark修炼之道(高级篇)——Spark源码阅读:第八节 Task执行

Task执行在上一节中,我们提到在Driver端CoarseGrainedSchedulerBackend中的launchTasks方法向Worker节点中的Executor发送启动任务命令,该命令的...
  • lovehuangjiaju
  • lovehuangjiaju
  • 2015年10月29日 12:00
  • 4722

初识内存泄露检测工具VisualLeakDetector

VLD为vc++下的内存泄露检测工具 1、首先下载安装vld,直接下载安装包,安装过程中会直接添加环境变量。 2、在安装目录下有vld.h, vldapi.h, vld.lib, vldmt.li...
  • dalong277
  • dalong277
  • 2016年10月03日 00:02
  • 625

Python之错误,调试和测试

1. 错误处理1.1 try …except…1.1.1 try …except…try: print ("try...") r = 10 / 0 print ("result:...
  • zengchen73
  • zengchen73
  • 2017年07月26日 10:20
  • 143

使用Visual Leak Detector检查内存泄露

使用Visual Leak Detector检查内存泄露
  • NJZhuJinhua
  • NJZhuJinhua
  • 2010年12月07日 22:36
  • 4013

kmemleak检测内存泄露

detected kernel memory leak This doc is from http://psankar.blogspot.com/2010/11/detecting-mem...
  • lishenglong666
  • lishenglong666
  • 2012年10月11日 16:44
  • 3219

使用Visual Leak Detect or 检测c/ c++ 程序内存泄漏

http://blog.sina.cn/dpool/blog/s/blog_a0f3ea9801010duw.html?vt=4 1.引言 通常的内存泄漏指堆内存泄漏[1]。堆内存指从堆中...
  • u011430225
  • u011430225
  • 2015年08月26日 09:56
  • 501

内存溢出 out of memory和内存泄露memory leak的区别和联系

Android 的虚拟机是基于寄存器的Dalvik,它的最大堆大小一般是16M,有的机器为24M。因此我们所能利用的内存空间是有限的。如果我们的内存占用超过了一定的水平就会出现OutOfMemory ...
  • qigemizi
  • qigemizi
  • 2017年02月19日 14:12
  • 574

Visual Leak Detector

ProjectDescription Visual Leak Detector is a free, robust, open-source memory leak detectionsyste...
  • pizi0475
  • pizi0475
  • 2013年12月26日 17:29
  • 2463

spark 2.1 LocalBackend Execute Task Process

LocalEndpoint call reviveOffers, when receive a ReviveOffers message. def reviveOffers() { val ...
  • houzhizhen
  • houzhizhen
  • 2017年05月24日 18:00
  • 174

内存溢出(Memory Overflow)和内存泄露(Memory Leak)的区别

内存泄漏指你用malloc或new申请了一块内存,但是没有通过free或delete将内存释放,导致这块内存一直处于占用状态 内存溢出指你申请了10个字节的空间,但是你在这个空间写入11或以上字节...
  • u013519020
  • u013519020
  • 2016年08月28日 19:09
  • 844
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ERROR: SGA memory leak detected
举报原因:
原因补充:

(最多只允许输入30个字)