Database 10.2.0.1.0 response is too late on sparc t5120 as compared to V240
Hi,
My previous server was v240, on which db version is 10.2.0.1.0, took a dump and restore it on sparc T5120. But few reports on sparc T5120 are taking almost double time as compared to old V240. also put the same dump on windows, core 2 duo machines they are responding 100 times better than v240 as well.
Steps performed so far:
update the db version to 10.2.0.4
index rebuild
recompile invalid objects
first install the db with default parameters, then increase the memory structure upto 4 times.
then make the same parameters as it was on v240
but after performing all these tasks and so many others the response time is still the same. even not it increase or decrease.