SQL profile questions

  • From: Jason Heinrich <jheinrichdba@xxxxxxxxx>
  • To: Oracle List <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 20 Feb 2009 11:30:02 -0600

1. Is there a way to determine if an SQL profile (part of the tuning pack)
is actually being used?  The dba_sql_profiles view shows that the profile in
question is 'ENABLED', but we had a performance issue with the query this
morning that shouldn't have happened if the profile was working.
2. The database was restarted last night.  Does the profile continue to be
applied after a restart?

Answers or links to documentation with the answers are greatly appreciated.

Jason Heinrich

Other related posts: