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

  • From: "Ghassan Salem" <salem.ghassan@xxxxxxxxx>
  • To: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • Date: Tue, 2 Jan 2007 10:20:35 +0100

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
> giving the version of oracle would help
>
> On 12/26/06, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2007