Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_LIBCACHE , 2 of 2
Subprogram | Description |
---|---|
Extracts SQL in batch from the source instance and compiles the SQL at the target instance. |
This procedure extracts SQL in batch from the source instance and compiles the SQL at the target instance.
DBMS_LIBCACHE.COMPILE_CURSORS_FROM_REMOTE('LIBC_LINK', {MY_USER}, 1, 1024000);
Note the following:
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.
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|