Hi Hemant,
Could you show what returns the following query for your profile name:
select
p.name as profile_name
,p.sql_text
,p.signature
,s.sql_id
,h.attr# as n
,attr_val as outline_hints
from
dba_sql_profiles p
,sys.sqlprof$attr h
,v$sqlarea s
where
p.name like '&_profile_name'
and p.category = h.category
and p.signature = h.signature
and h.p.signature = s.force_matching_signature(+)
;
On Wed, Jan 24, 2018 at 11:45 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
wrote:
Did you turn on the force matching option? Is it using bind variables?
On Wed, Jan 24, 2018 at 2:36 PM, Powell, Mark <mark.powell2@xxxxxxx>
wrote:
Since I am pretty sure SQL Profiles are an 11g+ feature did you mean
11.2.0.4 instead of 10.2.0.4?
Do you have the actual commands that used to create the profile so you
post them?
Take a look at DBA_SQL_PROFILES and show us the appropriate column values
for your profile.
Maybe one of the experts can then offer decent advice.
Mark Powell
Database Administration
(313) 592-5148
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Hemant K Chitale <hemantkchitale@xxxxxxxxx>
*Sent:* Wednesday, January 24, 2018 5:28:03 AM
*To:* ORACLE-L
*Subject:* 10.2 SQL Profile
10.2.0.4 SQL Profile created and accepted.
Profile was used in Test DB.
I used DBMS_SQLTUNE to create the Profile afresh in PROD. (Table stats
different).
Yet Profile not used in PROD.
Any debugging suggestions ?
sent from my mobile phone
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'