We have a data warehouse environment and are in the process of upgrading our oracle database from 10g to 12c supercluster environment;
During testing we experienced oracle performance with inserting data into 12c database is slower than 10g.
It really surprises me that database on 10g has better performance than one on latest and greatest hardware on 12c;
Both databases are identical in structure, same table names, same tablespace names, identical database files etc.
Hardware on 10g database as below:
Microsoft Windows Server 2003 Service Pack 2
Intel Xeon 2.40 GHz; 4GB RAM
Hardware on 12c supercluster database as below:
Solaris – Dual core 12 GB memory in RAC configurations
One core, 6GB memory on each node
While comparing Oracle parameters on 10g and 12c there are a few parameters (especially some Boolean values) are different.
Can anyone provide your expertise if parameter values mismatching has any significance on database performance?@
Can we enforce matching database parameters values from 10g to 12c to improve performance?
Any suggestions/guidance are greatly welcome.
Jay