Re: SQL profile questions
From: (wrong string) 조동욱 <ukja.dion_at_gmail.com>
Date: Mon, 23 Feb 2009 10:27:53 +0900
Message-ID: <43c2e3d60902221727r13d3745dk7c36be163d70194f_at_mail.gmail.com>
Two ways
Dion Cho - Oracle Performance Storyteller
Date: Mon, 23 Feb 2009 10:27:53 +0900
Message-ID: <43c2e3d60902221727r13d3745dk7c36be163d70194f_at_mail.gmail.com>
Two ways
- v$sql.sql_profile
- select * from from(dbms_xplan.display_cursor('<sql_id>', <child_number>);
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
On Sat, Feb 21, 2009 at 2:30 AM, Jason Heinrich <jheinrichdba_at_gmail.com>wrote:
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 22 2009 - 19:27:53 CST