The DBMS_OUTLN_EDIT package is an invoker's rights package.
See Also:
For more information about using theDBMS_OUTLN_EDIT package, see "Using Plan Stability" in Oracle Database Performance Tuning Guide.This chapter contains the following topic:
Table 67-1 DBMS_OUTLN_EDIT Package Subprograms
| Subprogram | Description |
|---|---|
|
Changes the join position for the hint identified by outline name and hint number to the position specified by |
|
|
Creates outline editing tables in calling a user's schema |
|
|
Drops outline editing tables in calling the user's schema |
|
|
Generates a signature for the specified SQL text |
|
|
Refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints |
This function changes the join position for the hint identified by outline name and hint number to the position specified by newpos.
DBMS_OUTLN_EDIT.CHANGE_JOIN_POS ( name VARCHAR2 hintno NUMBER newpos NUMBER);
Table 67-2 CHANGE_JOIN_POS Procedure Parameters
| Parameter | Description |
|---|---|
|
|
Name of the private outline to be modified. |
|
|
Hint number to be modified. |
|
|
New join position for the target hint. |
This procedure creates outline editing tables in calling a user's schema.
DBMS_OUTLN_EDIT.CREATE_EDIT_TABLES;
Beginning with Oracle Database 10g Release 1 (10.1) you will not need to use this statement because the outline editing tables will already exist as temporary tables in the SYSTEM schema.
This procedure drops outline editing tables in calling the user's schema.
DBMS_OUTLN_EDIT.DROP_EDIT_TABLES;
This procedure generates a signature for the specified SQL text.
DBMS_OUTLN.GENERATE_SIGNATURE ( sqltxt IN VARCHAR2, signature OUT RAW);
Table 67-3 GENERATE_SIGNATURE Procedure Parameters
| Parameter | Description |
|---|---|
|
|
The specified SQL. |
|
|
The signature to be generated. |
This procedure refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints.
DBMS_OUTLN_EDIT.REFRESH_PRIVATE_OUTLINE ( name IN VARCHAR2);