SQL Performance (MOSC)

MOSC Banner

Database 10.2.0.1.0 response is too late on sparc t5120 as compared to V240

edited Aug 25, 2016 8:57PM in SQL Performance (MOSC) 9 commentsAnswered ✓

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center