Q
Manage Learn to apply best practices and optimize your operations.

ORA-600 error and slow server response after upgrade

We upgraded from 9i to 10g on a data warehouse database. Since then we are facing a lot of problems, such as the ORA-600 error and slow server response.

We upgraded from 9i to 10g -- it's a data warehouse database. Since then we are facing a lot of problems with it. First, it's the ORA-00600 error in the alert log file, which refers to trace files.

Besides that the major problem we are facing is the dead slow server response; actually there are many batch jobs that run on it on daily basis and they are our main concern. If you need any further details I can provide you with them.

Oracle support is also trying to help us out but so far no fruitful result has come out, so I need some desperate help.

Unfortunately, I'm not sure that I can be of much help to you. There are many, many reasons for the ORA-600 errors. Without the first parameter in the error message, I can't be of much help. Oracle Support should be able to help solve this problem.

There are many, many possible reasons for your performance problems. One thing I see that is not done after the upgrade is to ensure the optimizer statistics are up to date. Run the DBMS_STATS.GATHER_DATABASE_STATS procedure. And run the DBMS_STATS.GATHER_SYSTEM_STATS procedure. If you are still having problems, then sign on to the database as SYSTEM and run the ?/rdbms/admin/awrrpt.sql script. It will ask you for a beginning and ending time period. Pick any period that exhibits your poor response time. This script will generate a report. Feel free to email the report to me at and I will look over it and make some recommendations on how to improve performance.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close