OraFAQ Forum: Performance Tuning » Error while trying to compute Schema Statistics

Home » RDBMS Server » Performance Tuning » Error while trying to compute Schema Statistics

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while trying to compute Schema Statistics [message #233478]

Thu, 26 April 2007 05:12

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

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233480 is a reply to message #233478]

Thu, 26 April 2007 05:23

Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-00600, ORA-07445, ORA-03113 means Oracle internal bug and call to support.

Regards
Michel

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233481 is a reply to message #233480]

Thu, 26 April 2007 05:25

grahambo
Messages: 9
Registered: November 2006

Junior Member

when you say call support you mean to call who ever created this database schema

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233486 is a reply to message #233481]

Thu, 26 April 2007 06:05

Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233527 is a reply to message #233478]

Thu, 26 April 2007 08:10

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

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233537 is a reply to message #233478]

Thu, 26 April 2007 08:31

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?

Report message to a moderator

Re: Error while trying to compute Schema Statistics [message #233571 is a reply to message #233537]

Thu, 26 April 2007 11:40

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 04 15:24:48 CST 2024