Re: Multiple SQL Profiles for a given SQL Statement

force_matching_signature has a different purpose than to enforce that a sql_id has only one profile assigned. You CAN have multiple profiles for the same sql_id. However, they can not be for the same category. If you try you get an error

ORA-13830: SQL profile with category DEFAULT already exists for this SQL statement

> On Jul 14, 2016, at 7:50 AM, Chris Taylor <christopherdtaylor1994_at_gmail.com> wrote:
>
> 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