Database Tuning (MOSC)

MOSC Banner

manually creating sql profiles

edited Nov 2, 2009 3:57AM in Database Tuning (MOSC) 4 commentsAnswered
 I have some  poor performing queries (vendor code) that I would like to supply hints to without having the ability to change the code.

The queries do contain literals, and I cannot turn cursor sharing on.  This eliminates stored outlines.

I think I can use sql profiles, but have no experience creating them.  I have some questions and was wondering if someone out there could help.

Thanks Ken

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