Q

Unacceptable performance in the test database

We have very large production databases, and small test databases. When our development team runs some queries in the small test database, it runs with a normal performance. But when we run the query in our production environment, the performance often very poor. Is there a solution to emulate the large database to do a test with a database that has less volume?
The DBMS_STATS package gives you the ability to export statistics from a database and import them into another database. You can therefore copy table and index statistics from your production database to your test database. The test database optimizer will then create execution plans based on your production database statistics, and you can evaluate the plans (and compare them with the plans produced with your actual test database statistics). Of course, you want to be sure that your production database statistics are up to date in any event!

You should also compare the initialization parameters of the two databases -- often, a single parameter can make the difference between unacceptable and acceptable performance.

This was last published in March 2005

Dig Deeper on Oracle database performance problems and tuning

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

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close