Oracle OUTLN_EDIT_PKG
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Contains functional interface for procedures and functions associated with management of private outlines

Deprecation Notice: Outlines are deprecated as of 12cR1: Instead use baselines
This package is not available, even in script form, in 18c and will be dropped from the 19c Library.
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DBMS_OUTLN_LIB DBMS_STANDARD
DBMS_OUTLN_EDIT    
Documented No
First Available 9.0.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC and to the DBA and EXECUTE_CATALOG_ROLE roles
Source {ORACLE_HOME}/rdbms/admin/dbmsol.sql
Synonym DBMS_OUTLN_EDIT
Subprograms
 
CHANGE_JOIN_POS
Change the join position for the hint identified by outline name and hint number to the position specified by newpos outln_edit_pkg.change_join_pos(
name   IN VARCHAR2,
hintno IN NUMBER,
newpos IN NUMBER);
TBD
 
CREATE_EDIT_TABLES
Create outline editing tables in calling user's schema outln_edit_pkg.create_edit_tables;
exec outln_edit_pkg.create_edit_tables;
 
DROP_EDIT_TABLES
Drop outline editing tables in calling user's schema outln_edit_pkg.drop_edit_tables;
exec outln_edit_pkg.drop_edit_tables;
 
GENERATE_SIGNATURE
Generates a signature for the specified SQL text outln_edit_pkg.generate_signature(sqltxt IN VARCHAR2, signature OUT RAW);
set serveroutput on

DECLARE
 x RAW(32767);
BEGIN
  outln_edit_pkg.generate_signature('SELECT user FROM dual', x);
  dbms_output.put_line(x);
END;
/
 
REFRESH_PRIVATE_OUTLINE
Refresh the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints outln_edit_pkg.refresh_private_outline(name IN VARCHAR2);
exec outln_edit_pkg.refresh_private_outline('OL_DEMO');

Related Topics
Built-in Functions
Built-in Packages
DBMS_SPM
Outlines
OUTLN_PKG
Tuning
What's New In 12cR2
What's New In 18cR3

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved