Re: Multiple SQL Profiles for a given SQL Statement

Yes you can NOT have > 1 sql profile ENABLED for a given SQL statement ID - it's enforced through the use of the FORCE_MATCHING_SIGNATURE of the SQL statement.

I do NOT "think" you can have multiple SQL profiles in DBA_SQL_PROFILES for the same sql_id even if the status is DISABLED but I haven't confirmed.

Chris

On Thu, Jul 14, 2016 at 8:29 AM, Beckstrom Jeffrey <JBECKSTROM_at_gcrta.org> wrote:

> What happens if you create multiple profiles for a given SQL Statement.
> Will Oracle prevent me from doing this accidently?
>
> Jeffrey Beckstrom
> Lead Database Administrator
> Information Technology Department
> Greater Cleveland Regional Transit Authority
> 1240 W. 6th Street
> Cleveland, Ohio 44113
>
>
>
> .
>
>

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