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

Data types and messages for dbms_libcache which compiles cursors in the local library cache

-- Table of SQL records extracted from the source instance
TYPE SQL_tab IS TABLE OF SQL_record INDEX BY BINARY_INTEGER;

-- Control record containing the meta data record for a bind variable
TYPE SQL_bind_record IS RECORD (
position INTEGER,
datatype INTEGER,
bind_name VARCHAR2(30),
max_length INTEGER,
array_length INTEGER);