dba_free_space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: dba_free_space

  1. #1
    Join Date
    Jul 2000
    Posts
    147

    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], [], [], [], [], [], []

  2. #2
    Join Date
    Apr 2006
    Posts
    377
    What version of 10g?

    Have you patched the database?

    Do you have any INVALID objects listed in DBA_OBJECTS?

  3. #3
    Join Date
    Jul 2000
    Posts
    147
    Thanks!

    Version 10.2.0.1.0

    Yes, there is lots of them.

    It was fresh installation.

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    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.

  5. #5
    Join Date
    Jul 2000
    Posts
    147
    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!

  6. #6
    Join Date
    Apr 2006
    Posts
    377
    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.

  7. #7
    Join Date
    Jul 2000
    Posts
    147
    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], [], [], [], [], [], []

  8. #8
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    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

  9. #9
    Join Date
    Jul 2000
    Posts
    147
    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
  •  



Click Here to Expand Forum to Full Width