Database Tuning (MOSC)

MOSC Banner

SQL Plan Management & the migration of SQL Tuning Sets from a 10g database

edited Nov 4, 2011 6:18AM in Database Tuning (MOSC) 2 commentsAnswered
Hi

I'm are just starting to rolling out SQL Plan Management to our test database's and a few questions have arisen which which I can't find answers for.

1.      We are using hash joins in our 10g database and we intend to capture those SQL statements using hash joins into a SQL Tuning Set and then migrate the tuning set to the 11g database which will have SPM enabled. So those STS’s will then seed SPM. But we will have disabled the ability to use hash joins on the 11g database. So my question is how will SPM management handle this situation? Will it use the seeded explain plans(Baselines) with the hash joining functionality or will it disregard those Baselines due to the functionality not being available?

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