Database Tuning (MOSC)

MOSC Banner

SQL Profiles and different users running the same SQL

edited Sep 27, 2011 12:42AM in Database Tuning (MOSC) 5 commentsAnswered
If Enterprise Manager suggests a SQL Profile that will improve performance for a specific SQL ID and I accept it, will other users automatically use the same profile even if it is not in the parsing schema? For instance, If user A runs a query that is exactly the same (same SQL ID) as user B and user A is the parsing schema when the profile was recommended, will user B automatically use that execution plan as well or is it on a user-by-user basis?

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