Summary of DBMS_LIBCACHE Subprograms

Table 22-1 DBMS_SESSION Subprograms

Subprogram	Description
COMPILE_CURSORS_FROM_REMOTE Procedure	Extracts SQL in batch from the source instance and compiles the SQL at the target instance.

COMPILE_CURSORS_FROM_REMOTE Procedure

This procedure extracts SQL in batch from the source instance and compiles the SQL at the target instance.

Syntax

DBMS_LIBCACHE.COMPILE_CURSORS_FROM_REMOTE('LIBC_LINK', {MY_USER}, 1, 
1024000);

Parameters

Table 22-2 COMPILE_CURSORS_FROM_REMOTE Procedure Parameters

Parameter	Description
Database Link Name	The database link pointing to the instance used for extracting the SQL statements.
Source username	Parsing username for the SQL statements extracted.
Execution threshold	Lower bound on the number of executions. Below this value cursors will not be selected for compiling.
Sharable memory threshold	The lower bound for the size of the shared memory consumed by the context area on the source instance. Below this value cursors will not be selected for compiling.

Usage Notes

Note the following:

• You must provide a Database link name and a Source user name as these are mandatory parameters. The syntax demonstrates the addition of the two optional parameters for preparsing all SQL larger than 1MB.
• Database link name - The connection may use either a password file or an LDAP authorization. A default database link, libc_link, is created when the catalog program, catlibc.sql, is executed. There is no actual default value as this parameter is mandatory for releases with dbms_libcache$def.ACCESS_METHOD = DB_LINK_METHOD.
• Source user name - This parameter allows the package to be executed in the matching local parsing user id. When using this parameter it is usual to be connected to the same username locally. If the username is supplied it must be a valid value. The name is not case sensitive.
• Execution threshold - The execution count on a cursor value is reset whenever the cursor is reloaded. This parameter allows the application to extract and compile statements with executions for example, greater than 3. The default value is 1. This means SQL statements that have never executed, including invalid SQL statements, will not be extracted.
• Sharable memory threshold - This parameter allows the application to extract and compile statements with shared memory for example, greater than 1024000 bytes. With the default value (1000), you can skip cursors that are invalid and so are never executed.