RE: SQL profile questions
- From: "Chandra Pabba" <Chandra_Pabba@xxxxxxxxxxx>
- To: <jheinrichdba@xxxxxxxxx>, "'Oracle List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2009 11:52:13 -0600
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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
Other related posts:
