Skip Headers

Oracle9i Supplied PL/SQL Packages and Types Reference
Release 2 (9.2)

Part Number A96612-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_LIBCACHE , 2 of 2


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:


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 2000, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback