dba_free_space

[dba_dada]

Oracle 10g
SOlaris - 10
----------

Any idea why?

SQL> select * from dba_free_space;
select * from dba_free_space
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qksfroFXTStatsLoc() - unknown KQ],
[1694498816], [], [], [], [], [], []

[ebrian]

What version of 10g?

Have you patched the database?

Do you have any INVALID objects listed in DBA_OBJECTS?

[dba_dada]

Thanks!

Version 10.2.0.1.0

Yes, there is lots of them.

It was fresh installation.

[ebrian]

Are you saying you have lots of INVALID objects in DBA_OBJECTS? Are they SYS/SYSTEM objects? Do you have any messages in your alert log?

I would try to recompile the PL/SQL packages by running @?/rdbms/admin/utlrp.sql and then re-check for INVALID objects. However, it appears that you may have to try and rebuild your data dictionary all together.

[dba_dada]

Thanks Ebrian. @?/rdbms/admin/utlrp.sql wouldn't validate all objects. I tried to run it few times but number stays the same. You maybe right I might have to rebuild your data dictionary all together.

Thanks!

[ebrian]

Did you see any error messages in your alert log?

If this is just a test system, you may want to consider just rebuilding the whole database. In the long run, it could save you A LOT of time.

[dba_dada]

Sadly it is a production system. Yes, I'm getting error massages in alert logs.

ERROR at line 1:
ORA-00600: internal error code, arguments: [qksfroFXTStatsLoc() - unknown KQ],
[1694498816], [], [], [], [], [], []

[OracleDoc]

Have you plugged your ora-600 error into Metalinks ORA-600 error lookup] to see what Oracle has to say about it? Hmmmm???

[dba_dada]

I Did the reserch on METALINK, but didn't open a TAR yet. I want to make sure I validate all objects first. Before I open one. You know what would they say..run the RDA tool and stuff. I will try to find a downtime rebuild data dictionary and validate all objects then see what happend.

Thanks,