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

[radha]

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

[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

[neolithicdba]

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 !!!

[davey23uk]

and 8.1.7.4 is a LOT more stable than 8.1.7.3

[aarroyob]

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

[diwakar]

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.......

[quester]

Originally posted by diwakar
What an intelligent answer.......

Hey, didn't mean to mock; honeslty meant to help him atleast temporarily

[Raminder]

If you are getting ORA-0600 errors in Alert Log, call Oracle Support !!!

[marist89]

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...

[anandkl]

Does this happen when u run any particular SQL statement, if yes can please post the statements....


regards
anandkl