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: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Tue, 2 Jan 2007 10:20:35 +0100
Message-ID: <411d50f60701020120h8fa02e8k68e062b0e2274592@mail.gmail.com>


Then, upgrade to 10.2.0.2 and apply fix for bug 4969005. (it does not seem to be in 10.2.0.3).

rgds

On 1/2/07, Ujang Jaenudin <ujang.jaenudin_at_gmail.com> wrote:
>
> 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 - 03:20:35 CST

Original text of this message

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