Re: Tuning Problem, ANALYZE ..

From: Kyle Hailey <oraperf_at_yahoo.com>
Date: Fri, 16 Nov 2001 23:55:14 GMT
Message-ID: <3bf5a4f7.23945531@newsfeeds-goliath.1usenet.net>

I don't recall this particular one myself but here are some possibilities from Metalink:

PURPOSE:
  This article discusses the internal error "ORA-600 [25012]", what   it means and possible actions. The information here is only applicable
  to the versions listed and is provided only for guidance.  

ERROR:
  ORA-600 [25012][a][b][c][d][e]  

VERSIONS:
  versions 8.0.X to 9.0.X  

DESCRIPTION:   We are trying to generate the absolute file number given a tablespace
  number and relative file number and cannot find a matching file number
  or the file number is zero.  

ARGUMENTS:
  Arg [a] Tablespace Number
  Arg [b] Relative file number  

FUNCTIONALITY:
  KERNEL FILE MANAGEMENT TABLESPACE COMPONENT   IMPACT:
  POSSIBLE PHYSICAL CORRUPTION   SUGGESTIONS:   The possibility of physical corruption exists.

  Obtain the trace files and alert.log for this error and log an iTAR   with Oracle Support Services for diagnosis.

  Known Issues:

  Bug 1678963 ORA-600[25012]/ORA-600[4142] possible on TRUNCATE of a   table with a CLOB column.
  fixed in releases 8.1.7.2 and 9i

  Bug 1788648 ORA-600 [25012] [2147483647] possible selecting from   certain V$ views.
  Fixed in releases 9.0.1.1
Best Wishes
Kyle Hailey

http://oraperf.sourceforge.net

---

Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net Received on Fri Nov 16 2001 - 17:55:14 CST