Each row represents a package that has been created by binding an application program.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PKGSCHEMA | VARCHAR (128) | Schema name of the package. | |
PKGNAME | VARCHAR (128) | Unqualified name of the package. | |
BOUNDBY | VARCHAR (128) | Authorization ID of the binder and owner of the package. | |
BOUNDBYTYPE | CHAR (1) |
|
|
OWNER | VARCHAR (128) | Authorization ID of the binder and owner of the package. | |
OWNERTYPE | CHAR (1) |
|
|
DEFAULT_SCHEMA | VARCHAR (128) | Default schema name used for unqualified names in static SQL statements. | |
VALID1 | CHAR (1) |
|
|
UNIQUE_ID | CHAR (8) FOR BIT DATA | Identifier for a specific package when multiple packages having the same name exist. | |
TOTAL_SECT | SMALLINT | Number of sections in the package. | |
FORMAT | CHAR (1) | Date and time format associated with the package.
|
|
ISOLATION | CHAR (2) | Y | Isolation level.
|
CONCURRENTACCESSRESOLUTION | CHAR (1) | Y | The value of the CONCURRENTACCESSRESOLUTION bind option:
|
BLOCKING | CHAR (1) | Y | Cursor blocking option.
|
INSERT_BUF | CHAR (1) | Setting of the INSERT bind option (applies to partitioned
database systems).
|
|
LANG_LEVEL | CHAR (1) | Y | Setting of the LANGLEVEL bind option.
|
FUNC_PATH | CLOB (2K) | SQL path in effect when the package was bound. | |
QUERYOPT | INTEGER | Optimization class under which this package was bound. Used for rebind operations. | |
EXPLAIN_LEVEL | CHAR (1) | Indicates whether Explain was requested using the EXPLAIN
or EXPLSNAP bind option.
|
|
EXPLAIN_MODE | CHAR (1) | Value of the EXPLAIN bind option.
|
|
EXPLAIN_SNAPSHOT | CHAR (1) | Value of the EXPLSNAP bind option.
|
|
SQLWARN | CHAR (1) | Indicates whether or not positive SQLCODEs resulting from
dynamic SQL statements are returned to the application.
|
|
SQLMATHWARN | CHAR (1) | Value of the dft_sqlmathwarn database configuration
parameter at bind time. Indicates whether arithmetic and retrieval
conversion errors return warnings and null values (indicator -2),
allowing query processing to continue whenever possible.
|
|
CREATE_TIME | TIMESTAMP | Time at which the package was first bound. | |
EXPLICIT_BIND_TIME | TIMESTAMP | Time at which this package was last changed by:
|
|
LAST_BIND_TIME | TIMESTAMP | Time at which the package was last changed by:
|
|
ALTER_TIME | TIMESTAMP | Time at which this package was last changed by:
|
|
CODEPAGE | SMALLINT | Application code page at bind time; -1 if not known. | |
COLLATIONSCHEMA | VARCHAR (128) | Schema name of the collation for the package. | |
COLLATIONNAME | VARCHAR (128) | Unqualified name of the collation for the package. | |
COLLATIONSCHEMA_ORDERBY | VARCHAR (128) | Schema name of the collation for ORDER BY clauses in the package. | |
COLLATIONNAME_ORDERBY | VARCHAR (128) | Unqualified name of the collation for ORDER BY clauses in the package. | |
DEGREE | CHAR (5) | Degree of intra-partition parallelism that was specified when
the package was bound.
|
|
MULTINODE_PLANS | CHAR (1) |
|
|
INTRA_PARALLEL | CHAR (1) | Use of intra-partition parallelism by static SQL statements
within the package.
|
|
VALIDATE | CHAR (1) | Indicates whether validity checking can be deferred until run
time.
|
|
DYNAMICRULES | CHAR (1) |
|
|
SQLERROR | CHAR (1) | SQLERROR option on the most recent subcommand that bound or
rebound the package.
|
|
REFRESHAGE | DECIMAL (20,6) | Timestamp duration indicating the maximum length of time between execution of a REFRESH TABLE statement for a materialized query table (MQT) and when that MQT is used in place of a base table. | |
FEDERATED | CHAR (1) |
|
|
TRANSFORMGROUP | VARCHAR (1024) | Y | Value of the TRANSFORM GROUP bind option; the null value if a transform group is not specified. |
REOPTVAR | CHAR (1) | Indicates whether the access path is determined again at execution
time using input variable values.
|
|
OS_PTR_SIZE | INTEGER | Word size for the platform on which the package was created.
|
|
PKGVERSION | VARCHAR (64) | Version identifier for the package. | |
STATICREADONLY | CHAR (1) | Indicates whether or not static cursors will be treated as
READ ONLY. Possible values are:
|
|
FEDERATED_ASYNCHRONY | INTEGER | Indicates the limit on asynchrony (the number of ATQs in the
plan) as a bind option when the package was bound.
|
|
ANONBLOCK | CHAR (1) |
|
|
OPTPROFILESCHEMA | VARCHAR (128) | Y | Value of the optimization profile schema specified as part of the OPTPROFILE bind option. |
OPTPROFILENAME | VARCHAR (128) | Y | Value of the optimization profile name specified as part of the OPTPROFILE bind option. |
PKGID | BIGINT | Identifier for the package. | |
DBPARTITIONNUM | SMALLINT | Number of the database partition where the package was bound. | |
DEFINER2 | VARCHAR (128) | Authorization ID of the binder and owner of the package. | |
PKG_CREATE_TIME3 | TIMESTAMP | Time at which the package was first bound. | |
APREUSE | CHAR (1) |
|
|
EXTENDEDINDICATOR | CHAR (1) |
|
|
LASTUSED | DATE | Date when any statement in the package was last executed. This column is not updated for a package associated with an anonymous block. This column is not updated when a statement in the package is executed on an HADR standby database. The default value is '0001-01-01'. This value is updated asynchronously not more than once within a 24 hour period and might not reflect usage within the last 15 minutes. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|