Database Tuning (MOSC)

MOSC Banner

Performance issues with 10.2.0.4 database

edited Jul 22, 2009 10:59PM in Database Tuning (MOSC) 9 commentsAnswered
 We recently upgraded one of the production(OLTP) database from 9.2.0.7 to 10.2.0.4. One of the important job from application end is running very slow in 10.2.0.4, it is taking twice time of actual(9.2.0.7).When traced the session in both 9.2.0.7 and 10.2.0.4, I can see execution plans are quite same. The difference I found in between both traces is in wait events, Db file sequential reads and Log buffer space events have dramatically increased. SGA size and logbuffer space size are almost twice bigger than 9.2.0.7, but still facing performance issues. Can any body help me.

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