1

Topic: Creation outline under sys

Colleagues, good afternoon.
I train in creation outline and came across a foolish problem. Searched on a metalink - did not find.
SYS cannot create outline?
12.2.0.1 ENTERPRISE EDITIONS

SQL> show user
USER is "SYS"
SQL> grant CREATE ANY OUTLINE to sys;
Grant succeeded.
SQL> create or replace public outline p_outline_src_1_pub from private p_outline_src_1 for category prod;
create or replace public outline p_outline_src_1_pub from private p_outline_src_1 for category prod
*
ERROR at line 1:
ORA-18005: CREATE ANY OUTLINE privilege is required for this operation

2

Re: Creation outline under sys

Here a radish.
All the same was successfully fulfilled on 11th.
And where about it it is written?

3

Re: Creation outline under sys

https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6005.htm#SQLRF01305 wrote:

Stored outlines will be desupported in a future release in favor of SQL plan management. In Oracle Database 11g Release 1 (11.1), stored outlines continue to function as in past releases. However, Oracle strongly recommends that you use SQL plan management for new applications. SQL plan management creates SQL plan baselines, which offer superior SQL performance and stability compared with stored outlines.
If you have existing stored outlines, please consider migrating them to SQL plan baselines by using the LOAD_PLANS_FROM_CURSOR_CACHE or LOAD_PLANS_FROM_SQLSET procedure of the DBMS_SPM package. When the migration is complete, you should disable or remove the stored outlines.

4

Re: Creation outline under sys

Thanks smile
There is a question - if in 12th  cancelled outlines, and baseline is accessible only in Enterprise than to use in 12 SE for adjustment of plans?

5

Re: Creation outline under sys

dcdba;
Is not documented sqlpatch, it like in any way , is not documented yet. Whether but  it is possible to start up it in , but the fear and risk

6

Re: Creation outline under sys

kinky cat wrote:

dcdba;
Is not documented sqlpatch, it like in any way , is not documented yet. Whether but  it is possible to start up it in , but the fear and risk

Well not such it and not documented - dock
In a blog of a command of the optimizer write :

wrote:

Do we need additional licenses or the SQL diag pack to use this?
- No. No additional licenses are needed to use SQL Repair Advisor or SQL patches. SQL Repair Advisor is available as part of Oracle Database Enterprise Edition 11g.

7

Re: Creation outline under sys

Melkomyagkii_newbi wrote:

well not such it and not documented - dock

Function i_create_patch/create_sql_patch in dock is not mentioned wink
Now mastered technology, in passing clarifying that in 12th syntax exchanged - i_create_patch there does not work, instead of it here so:

patch_name: = sys.dbms_sqldiag.create_sql_patch (sql_id => l_sql_id_trg, hint_text => l_hints);