Page History
Wiki Markup
\\ It provides information including the SQL statement name, if the outline is enabled or not, and the Name, Category, and Hints associated with the outline. Additionally, the Drop parameter specifies if it is dropped or not at execution time. \\ !worddav6724506d7ad6b1c60cc452622ddda5bf.png|height=116,width=573! \\ \\ In order to view outlines, thetime.
In order to view outlines, the session needs to have session needs to have USE_STORED_OUTLINES=true set prior to execution. Outlines in tuning are created for the DEFAULT category, by default. Use the following commands to enable outlines with the default settings:
\\
alter
...
system
...
set
...
USE_STORED_OUTILNES=true;
...
alter
...
system
...
set
...
USE_STORED_OUTLINES=
...
‘DEFAULT’;
...
alter
...
session
...
set
...
USE_STORED_OUTLINES=true;
\\
\\
Additionally, in order for a session to USE_STORED_OUTLINES, the user requires the create any outline role. Use the following command to set up the proper permissions:
\\
grant
...
create
...
any
...
outline
...
to
...
[user
...
];
...