Re: 10.2 SQL Profile

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_at_dxc.com> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Hemant K Chitale <hemantkchitale_at_gmail.com>
> *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.'

--
http://www.freelists.org/webpage/oracle-l