Home » RDBMS Server » Performance Tuning » Error while trying to compute Schema Statistics
Error while trying to compute Schema Statistics [message #233478] Thu, 26 April 2007 05:12 Go to next message
grahambo
Messages: 9
Registered: November 2006
Junior Member
Hi All,

I wonder if you could help me?

I am attempting to analyze a particular schema within my oracle 9i database.

however it keeps throwing up and error.

SQL> exec DBMS_UTILITY.ANALYZE_SCHEMA('TOPTEAMDB','COMPUTE');
BEGIN DBMS_UTILITY.ANALYZE_SCHEMA('TOPTEAMDB','COMPUTE'); END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25012], [5], [0], [], [], [], [],
[]
ORA-06512: at "SYS.DBMS_DDL", line 179
ORA-06512: at "SYS.DBMS_UTILITY", line 472
ORA-06512: at line 1


I'm fairly new to oracle and have no idea why this is happening.
if anyone knows why or how to fix it please let me know.

thanks

Graham
Re: Error while trying to compute Schema Statistics [message #233480 is a reply to message #233478] Thu, 26 April 2007 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600, ORA-07445, ORA-03113 means Oracle internal bug and call to support.

Regards
Michel
Re: Error while trying to compute Schema Statistics [message #233481 is a reply to message #233480] Thu, 26 April 2007 05:25 Go to previous messageGo to next message
grahambo
Messages: 9
Registered: November 2006
Junior Member
when you say call support you mean to call who ever created this database schema
Re: Error while trying to compute Schema Statistics [message #233486 is a reply to message #233481] Thu, 26 April 2007 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No, I mean Oracle support.
ora-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause:  This is the generic internal error number for Oracle program
           exceptions.  This indicates that a process has encountered an
           exceptional condition.
 *Action: Report as a bug - the first argument is the internal error number

You can also check on Metalink ORA-600 lookup.

Regards
Michel


Re: Error while trying to compute Schema Statistics [message #233527 is a reply to message #233478] Thu, 26 April 2007 08:10 Go to previous messageGo to next message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
Try using DBMS_STATS instead.

If ORA-600 still happens then try analyzing stats for each table instead for a whole schema.

HTH.
Michael
Re: Error while trying to compute Schema Statistics [message #233537 is a reply to message #233478] Thu, 26 April 2007 08:31 Go to previous messageGo to next message
grahambo
Messages: 9
Registered: November 2006
Junior Member
Hi Thanks your your reply

I tried this

SQL> exec DBMS_STATS.GATHER_SCHEMA_STAT('TOPTEAMDB',DBMS_STATS.AUTO_SAMPLE_SIZE);

BEGIN DBMS_STATS.GATHER_SCHEMA_STATS ('TOPTEAMDB',DBMS_STATS.AUTO_SAMPLE_SIZE);
END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


However as you can now see im getting a different error.

Any ideas?
Re: Error while trying to compute Schema Statistics [message #233571 is a reply to message #233537] Thu, 26 April 2007 11:40 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
ERROR at line 1:
ORA-03113: end-of-file on communication channel

It is also generic error you have to look in alert<sid>.log file for further information.

and post here last few lines from alert<sid>.log file.



regards
Taj

Previous Topic: Delete Select
Next Topic: refresh table mon_mods$
Goto Forum:
  


Current Time: Wed Dec 04 19:06:35 CST 2024