SQL profile questions

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Fri, 20 Feb 2009 11:30:02 -0600
Message-ID: <b32e774d0902200930w265c34b4m6f62b8d3a487ec66_at_mail.gmail.com>

  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


http://www.freelists.org/webpage/oracle-l Received on Fri Feb 20 2009 - 11:30:02 CST

Original text of this message