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:
- Temp Tablespace size
- SGA size
- any other particular fine tuning that has been applied on the Oracle 10g machine.