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

Home -> Community -> Mailing Lists -> Oracle-L -> Cancelling ANALYZE causes ORA-600

Cancelling ANALYZE causes ORA-600

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Wed, 10 Jan 2001 16:30:27 +0100
Message-Id: <10737.126267@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C07B1A.6EA95572
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi gurus,

Oracle 8.1.6.2
Solaris 2.6

Did anyone ever get ORA-600 [1113] when he cancelling a ANALYZE ? =20

This is in my log file :
ORA-00600: internal error code, arguments: [1113], [], [], [], [], [], = [],
[]
ORA-00604: error occurred at recursive SQL level 1 ORA-01013: user requested cancel of current operation Wed Jan 10 14:57:56 2001

PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump

Does this ring a bell for anyone ?

TIA



Luc Demanche
CETELEM
T=E9l.: 01-46-39-14-49
Fax : 01-46-39-59-88

------_=_NextPart_001_01C07B1A.6EA95572
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Cancelling ANALYZE causes ORA-600</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi gurus,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Oracle 8.1.6.2</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Solaris 2.6</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Did anyone ever get ORA-600 [1113] =
when he cancelling a ANALYZE ?&nbsp; </FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">This is in my log file :</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">ORA-00600: internal error code, =
arguments: [1113], [], [], [], [], [], [], []</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">ORA-00604: error occurred at =
recursive SQL level 1</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">ORA-01013: user requested cancel of =
current operation</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Wed Jan 10 14:57:56 2001</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">PMON failed to acquire latch, see =
PMON dump</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">PMON failed to acquire latch, see =
PMON dump</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">PMON failed to acquire latch, see =
PMON dump</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Does this ring a bell for anyone =
?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">TIA</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">-----------------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Luc Demanche</FONT>
<BR><B><I><FONT FACE=3D"Arial">CETELEM</FONT></I></B>
<BR><FONT SIZE=3D2 FACE=3D"Arial">T=E9l.: 01-46-39-14-49</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Fax : 01-46-39-59-88</FONT>
Received on Wed Jan 10 2001 - 09:30:27 CST

Original text of this message

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