RE: SQL profile questions
From: Chandra Pabba <Chandra_Pabba_at_verizon.net>
Date: Fri, 20 Feb 2009 11:52:13 -0600
Message-id: <011f01c99383$f624de60$e26e9b20$_at_net>
Jason,
Date: Fri, 20 Feb 2009 11:52:13 -0600
Message-id: <011f01c99383$f624de60$e26e9b20$_at_net>
Jason,
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.
Thanks
Chandra
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.
--
Jason Heinrich
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 20 2009 - 11:52:13 CST