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.

This was last published in February 2007

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close