RE: SQL profile questions

From: Chandra Pabba <>
Date: Fri, 20 Feb 2009 11:52:13 -0600
Message-id: <011f01c99383$f624de60$e26e9b20$_at_net>


Not sure, if you have already looked at the Execution Plan . If you check the Execution Plan, it will indicate whether or not a SQL Profile is used.

I don't think restarting the database should disable the usage of SQL Profiles.  



From: [] On Behalf Of Jason Heinrich
Sent: Friday, February 20, 2009 11:30 AM To: Oracle List
Subject: SQL profile questions  

  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

-- Received on Fri Feb 20 2009 - 11:52:13 CST

Original text of this message