RE: Cancelling ANALYZE causes ORA-600

From: Trassens, Christian <CTrassens_at_uni2.es>
Date: Wed, 10 Jan 2001 17:43:32 +0100
Message-Id: <10737.126283@fatcity.com>

Did you look at the PMON dump ?. Which latch it didn't acquire.

Are you using MTS ?. Test to set the event 10246 before the analyze and CTRL+C:=20
alter session set events '10246 trace name context forever, level 10';

For a more detailed trace.

Regards.

> -----Mensaje original-----
> De: DEMANCHE Luc (Cetelem) [SMTP:luc.demanche_at_cetelem.fr]
> Enviado el: mi=E9rcoles 10 de enero de 2001 16:30
> Para: Multiple recipients of list ORACLE-L
> Asunto: Cancelling ANALYZE causes ORA-600

>=20

> Hi gurus,=20

>=20

> Oracle 8.1.6.2=20
> Solaris 2.6=20

>=20

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

>=20

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

>=20

> Does this ring a bell for anyone ?=20

>=20

> TIA=20

>=20
>=20


> -----------------=20

> Luc Demanche=20
> CETELEM=20
> T=E9l.: 01-46-39-14-49=20
Received on Wed Jan 10 2001 - 10:43:32 CST