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>
Date: Fri, 20 Feb 2009 11:30:02 -0600
Message-ID: <b32e774d0902200930w265c34b4m6f62b8d3a487ec66_at_mail.gmail.com>
- 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:30:02 CST