Re: New Sql profiles

Thank you Lok. Actually that is what I was trying to find out and confirm. Is there any way I can get the exact auto job name/schedule which has created these profiles and also made them enabled?

On Mon, Sep 13, 2021 at 11:13 AM Lok P <loknath.73_at_gmail.com> wrote:

> As you mentioned nobody has created it manually and its having TYPE as
> AUTO so it must have been created by some auto task.
>
> On Mon, 13 Sep 2021, 2:05 am Pap, <oracle.developer35_at_gmail.com> wrote:
>
>> Hello Listers, We are seeing a few sqls running longer post 19c migration
>> and when looking into the details , we found the new plan which it opting
>> are having some sql profiles created/attached(having name SYS_SQLPROF****)
>> and forcing the plan to go for a suboptimal ones. Want To understand how
>> those are created for so many(around ~10) sqls. In DBa_sql_profiles they
>> are having TYPE as 'AUTO' and STATUs as ENABLED having a specific
>> TASK_EXEC_NAME. So wanted to understand if any automatic job caused this
>> which should have been turned off during this migration or somebody must
>> have created those by manually running some task , which seems unlikely?
>>
>> Regards
>> Pap
>>
>

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