Database Tuning (MOSC)

MOSC Banner

Database Upgrade - SPM

edited Sep 17, 2013 5:57AM in Database Tuning (MOSC) 8 commentsAnswered
hi,

We are planning to upgrade our databases from 10.2.0.4 to 11.2.0.3. We are planning to use SQL plan management to retain the exisitng 10g plans and evalute and accept 11g plans at later stage if it looks better . We are planning to capture all the SQLs from appliction ( Say sql for one day) and load it to sql tunning set and import this tuning set to 11g SPM.My Question is, Is there any limiations on number of sqls that can be loaded to SPM.Do we have any performance issue if we load too many sqls from tuning set to SPM ?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center