-
dba_free_space
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], [], [], [], [], [], []
-
What version of 10g?
Have you patched the database?
Do you have any INVALID objects listed in DBA_OBJECTS?
-
Thanks!
Version 10.2.0.1.0
Yes, there is lots of them.
It was fresh installation.
-
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.
-
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!
-
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.
-
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], [], [], [], [], [], []
-
Have you plugged your ora-600 error into Metalinks ORA-600 error lookup] to see what Oracle has to say about it? Hmmmm???
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
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,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|