RE: SQL profile questions
Date: Fri, 20 Feb 2009 11:52:13 -0600
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Jason Heinrich
Sent: Friday, February 20, 2009 11:30 AM To: Oracle List
Subject: SQL profile questions
- 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.
- 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.
http://www.freelists.org/webpage/oracle-l Received on Fri Feb 20 2009 - 11:52:13 CST