Re: usertrace error

yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0311240908.aed304_at_posting.google.com>...
> in my usertrace, i had a file which had the below entries
>
>
> *** SESSION ID:(25.1) 2003-11-21 06:18:59.119
> ******** ERROR: SGA memory leak detected 488 ********
> ******************************************************
> HEAP DUMP heap name="sga heap" desc=0xc0000000afa02040
> extent sz=0xfe0 alt=96 het=32767 rec=9 flg=2 opc=0
> parent=0 owner=0 nex=0 xsz=0x2b443680
> EXTENT 0
> Chunk c000000084001010 sz=362946168 perm "perm " alo=97401536
> Chunk c000000099a22e88 sz=320576864 free " "
> Chunk c0000000acbdcbe8 sz= 488 freeable "ksfv i/o slave "
> Chunk c0000000acbdcdd0 sz= 371264 free " "
> Chunk c0000000acc37810 sz= 40 R-freeable "reserved stoppe"
> Chunk c0000000acc37838 sz= 41943040 R-free " "
> Chunk c0000000af437838 sz= 40 R-freeable "reserved stoppe"
>
>
>
> i am not sure about what happened above. thanks
>
> my colleague reduced the number of processes and lock_sga. then the
> database started. he did correctly?
>
> thanks

Take a look at the alert log. I would expect that there is an associated entry that points to this trace file. If so you should be able to search metalink for the error and/or open an iTAR.

It would be nice to know what version of Oracle this is on and what if anything unusual was being done at the time of the trace.

HTH -- Mark D Powell -- Received on Mon Nov 24 2003 - 19:18:45 CST