Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

How can I compare two Oracle database servers which are on two different machines?

We need to ensure that the new server is setup correctly.

For example, one machine is running Oracle 10g on Windows, and the second machine is running Oracle 11g on Linux.

How can I ensure that we have correctly set up all the parameters on the new 11g machine?

Some of the items I need configured are:

  1. Temp Tablespace size
  2. SGA size
  3. any other particular fine tuning that has been applied on the Oracle 10g machine.
share|improve this question
    
before you think about changing parameters what are the problems you are trying to address? A default install of Oracle does a pretty good job for many uses. –  kevinsky Sep 25 '12 at 20:36

1 Answer 1

You don't want them to be running with the same parameters in the first place. Very likely that you want to enable the 11g features. Things that you might want to make sure to be at least equal size are the memory footprint, temp tablespaces and undo tablespaces.

In Oracle 11g you might be tempted to use Autmatic Memory Management. There are some issues with it so it might be smarter to configure your shared pool and database buffer according to the 10g database. In the run check if you are not over or undersized.

Best is to hire a dba to help you with the setup, next best is to dive into Oracle® Database 2 Day DBA 11g Release 2 (11.2) There is a lot to learn from.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.