Re: What does "koh-kghu call " mean?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 24 Mar 2006 08:32:49 +0000 (UTC)
Message-ID: <e00arh$rtv$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

"oracle_doc" <nilendu_at_nilendu.com> wrote in message news:1143168438.924779.209050_at_v46g2000cwv.googlegroups.com...
>I am getting a lot of ORA-4030 errors while UGA touches 1.8GB and
> freezes.
>
> The heapdump contains information like -
>
> ksedmp: internal or fatal error
> ORA-04030: out of process memory when trying to allocate 16396 bytes
> (koh-kghu call ,pmuccst: adt/record)
>
> i.e., it also has "kon-kghu call".
>
> Thus it looks like the most memory is allocated for koh-kghu call and
> it fails on the same call as well. Does anyone know what is this
> "kon-kghu call"?
>

One possibility is a program that has a runaway (or leaking) pl/sql loop populating pl/sql tables. For example:

declare

     type t1_type is table of varchar2(32767) index by binary_integer;
     t1 t1_type;
begin
     for i in 1..100 loop
         t1(i) := rpad('x',4000);
     end loop;
     execute immediate 'alter session set events ''immediate trace name 
heapdump level 1''';
     dbms_lock.sleep(4);

end;
/

The sleep is probably unnecessary, but I put it there in case the heapdump operated asynchronously.

I've used 4000 byte strings to see if the space allocation would follow that size, or start allocating your 16K chunks.

This is what I got in the pga heap dump:

EXTENT 1 addr=057D0034
Chunk 57d003c sz= 16416 freeable "koh-kghu call " ds=031DE974 EXTENT 2 addr=055C80AC
Chunk 55c80b4 sz= 16416 freeable "koh-kghu call " ds=031DE974

    similar for chunks 3 to 33

EXTENT 34 addr=033B2184
Chunk 33b218c sz= 16416 freeable "koh-kghu call " ds=031DE974 EXTENT 35 addr=033B0034
Chunk 33b003c sz= 276 free " "
Chunk 33b0150 sz= 8224 freeable "koh-kghu call " ds=031DE974

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

Received on Fri Mar 24 2006 - 02:32:49 CST