Oracle DBMS_IAS_TEMPLATE
Version 18.3.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 Oracle Internet Application Server configuration utility. This package is not installed by default and must be manually installed from the Source file by SYS when connected to CDB$ROOT.
AUTHID DEFINER
Dependencies Only STANDARD
Documented No
First Available Not Known
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsiast.sql

Unfortunately Oracle did not include the .PLB file with the package bodies so this package is now broken.
Opening an SR with Oracle so that they can either provide the body or drop the package definition.
Subprograms
 
CREATE_IAS_OBJECT
Add an object to an IAS template

Overload 1
dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN VARCHAR2,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
Overload 2 dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN NUMBER,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
Overload 3 dbms_ias_template.create_ias_object(
ias_template_name  IN VARCHAR2,
object_name        IN VARCHAR2,
object_type        IN NUMBER,
schema_name        IN VARCHAR2,
derived_from_sname IN VARCHAR2,
derived_from_oname IN VARCHAR2,
ddl_text           IN CLOB)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
 
CREATE_IAS_TEMPLATE
Create a new IAS template dbms_ias_template.create_ias_template(
owner              IN VARCHAR2,
refresh_group_name IN VARCHAR2,
ias_template_name  IN VARCHAR2,
template_comments  IN VARCHAR2)
RETURN NUMBER;
Broken by Oracle see SOURCE above.
 
DROP_IAS_OBJECT
Drop an object from an IAS template

Overload 1
dbms_ias_template.drop_ias_object(
ias_template_name IN VARCHAR2,
object_name       IN VARCHAR2,
object_type       IN NUMBER,
schema_name       IN VARCHAR2);
Broken by Oracle see SOURCE above.
Overload 2 dbms_ias_template.drop_ias_object(
ias_template_name IN VARCHAR2,
object_name       IN VARCHAR2,
object_type       IN VARCHAR2,
schema_name       IN VARCHAR2);
Broken by Oracle see SOURCE above.
 
DROP_IAS_TEMPLATE
Drop an IAS template dbms_ias_template.drop_ias_template(ias_template_name IN VARCHAR2);
Broken by Oracle see SOURCE above.

Related Topics
Built-in Functions
Built-in Packages
DBMS_IAS_CONFIGURE
DBMS_IAS_QUERY
DBMS_IAS_SESSION
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