Re: Oracle SQL Plan Baseline

As mentioned on twitter check 1540948.1

Rgds,
Sachin

On Wed, Mar 13, 2019 at 7:44 AM Neil Chandler <neil_chandler_at_hotmail.com> wrote:

> Tracing enabled - thanks Timur! At least I know why now...
>
> declare
> cnt number;
> begin
> *dbms_spm.configure('spm_tracing',1); *
> cnt :=
> dbms_spm.load_plans_from_sqlset(sqlset_name=>'NEIL',SQLSET_OWNER=>'NEIL_DBA');
> dbms_output.put_line('Plans Loaded : '||to_char(cnt));
> *dbms_spm.configure('spm_tracing',0); *
> end;
> /
>
> From the trace:
>
> load sts: sql_id=4jcxvz3adqbs2 phv=1905606778
> load sts: plan has empty outline, skipping it
>
>
> Neil.
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Neil Chandler <neil_chandler_at_hotmail.com>
> *Sent:* 13 March 2019 11:16
> *To:* oracle-l-freelists
> *Subject:* Oracle SQL Plan Baseline
>
> Does anyone know how to determine why an Oracle SQL Plan Baseline will not
> create from a SQL Tuning set? 11.2.0.3
>
> select ... from dba_sqlset_statements where sqlset_name = 'NEIL
>
> SQLSET_NAME SQLSET_OWNER SQLSET_ID SQL_ID PLAN_HASH_VALUE
> FORCE_MATCHING_SIGNATURE PARSING_SCHEMA_NAME
> NEIL NEIL_DBA 35 4jcxvz3adqbs2 1905606778
> 6134983393191283611 APP
>
>
> declare
> cnt number;
> begin
> cnt :=
> dbms_spm.load_plans_from_sqlset(sqlset_name=>'NEIL',SQLSET_OWNER=>'NEIL_DBA');
> dbms_output.put_line('Plans Loaded : '||to_char(cnt));
> end;
> /
>
> Plans Loaded : 0
>

-- 
Rgds,
Sachin Pawar
https://twitter.com/sach_pwr

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