My database is going slow after 1 week...!!!!! Urgent
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: My database is going slow after 1 week...!!!!! Urgent

  1. #1
    Join Date
    Jun 2001
    Posts
    17

    My database is going slow after 1 week...!!!!! Urgent

    Hi any body pl help me,

    i am working in 4 gb database in California, Financials dept,

    i have exported database schema from 8.1.5 db, & imported to 8.1.6 db & i have recompiled all Objects, & i have Analyzed with compute statistics, the database whenever shutdown & restarts it works for 1 week fine after 7 days it going slow down, whenever query parses it will hang.

    & i am getting in my alert log this error.
    SMON: Parallel transaction recovery slave got internal error
    SMON: Downgrading transaction recovery to serial
    Thu Nov 21 19:13:22 2002
    Errors in file E:\ORACLE\admin\NFA\bdump\nfaSMON.TRC:
    ORA-00600: internal error code, arguments: [4142], [4294967295], [], [], [], [], [], []

    ORACLE Instance nfa (pid = 6) - Error 600 encountered while recovering transaction (6, 13) on object 22071.
    Thu Nov 21 19:13:23 2002
    Errors in file E:\ORACLE\admin\NFA\bdump\nfaSMON.TRC:
    ORA-00600: internal error code, arguments: [4142], [4294967295], [], [], [], [], [], []


    Please help me.

    Radha . S
    radha

  2. #2
    Join Date
    Mar 2002
    Posts
    200
    Hmmm...

    I don't understand the errors.. I was thinking, for the time being, just as a temporary solution, write a batch program to run every six days to automatically shutdown and startup at midnight

  3. #3
    Join Date
    Nov 2002
    Location
    India
    Posts
    4

    Unhappy

    Hey...

    tried a bit to find a possible cause.

    Oracle 8.1.7.3 is a stable version with a lot of ORA-600 bugs fixed. Might be good to upgrade to that.

    In any event its always advisable to raise a tar for these ORA-0600 errors with oracle before making a decision to upgrade.

    P.S: It is a painless and simple process to upgrade from 8.1.6 to 8.1.7.3. Beleive me its very stable !!!
    -Thanks
    Ram

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and 8.1.7.4 is a LOT more stable than 8.1.7.3

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Are you truncating a table with CLOB column? If yes then is bug 1678963 that it is fixed in 8.1.7.2 and 9i.

    Regards

    Angel

  6. #6
    Join Date
    May 2002
    Posts
    193
    Originally posted by quester
    Hmmm...

    I don't understand the errors.. I was thinking, for the time being, just as a temporary solution, write a batch program to run every six days to automatically shutdown and startup at midnight


    What an intelligent answer.......

  7. #7
    Join Date
    Mar 2002
    Posts
    200
    Originally posted by diwakar
    What an intelligent answer.......
    Hey, didn't mean to mock; honeslty meant to help him atleast temporarily

  8. #8
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    If you are getting ORA-0600 errors in Alert Log, call Oracle Support !!!

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by quester
    Hmmm...

    I don't understand the errors.. I was thinking, for the time being, just as a temporary solution, write a batch program to run every six days to automatically shutdown and startup at midnight
    I love Unix...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  10. #10
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Does this happen when u run any particular SQL statement, if yes can please post the statements....


    regards
    anandkl
    anandkl

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