Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-00600: [kghstack_alloc], [sql txt in kkslod],

Re: ORA-00600: [kghstack_alloc], [sql txt in kkslod],

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 2 Jan 2007 13:38:59 +0700
Message-ID: <3edcb66e0701012238j76c943e0o384df2da5d5cb386@mail.gmail.com>


oracle 10.2.0.1 64bit
on linux redhat enterprise 4 64bit

sorry for the late reply.

thanks
Ujang

On 12/27/06, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
> giving the version of oracle would help
>
> On 12/26/06, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
> >
> > does anyone know, why this happen?, on the normal operation is OK, but
> > when spooling to htm file, this trace file occur.
> >
> > ksedmp: internal or fatal error
> > ORA-00600: internal error code, arguments: [kghstack_alloc], [sql txt in
> > kkslod], [], [], [], [], [], []
> > Current SQL statement for this session:
> > select '<TR>
> > <TD ALIGN="CENTER"><FONT FACE="Arial"
> > SIZE="2">'||s.username||'</FONT></TD>
> > <TD ALIGN="CENTER"><FONT FACE="Arial" SIZE="2">'||nvl( s.osuser
> > ,'&nbsp;')||'</FONT></TD>
> > <TD ALIGN="CENTER"><FONT FACE="Arial" SIZE="2">'||s.sid||'</FONT></TD>
> > <TD ALIGN="CENTER"><FONT FACE="Arial"
> > SIZE="2">'||a.owner||'</FONT></TD>
> > <TD ALIGN="CENTER"><FONT FACE="Arial"
> > SIZE="2">'||a.object||'</FONT></TD>
> > <TD ALIGN="CENTER"><FONT FACE="Arial"
> > SIZE="2">'||a.type||'</FONT></TD>
> > </TR>'
> > from sys.v_$session s, sys.v_$access a
> > where s.sid = a.sid
> > and s.username not in ('SYS','SYSTEM')
> > and a.owner not in ('SYS','SYSTEM')
> > order by a.object , a.type, s.username
> >
> > regards
> > ujang
>
>

-- 


regards
ujang
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 02 2007 - 00:38:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US