December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_LIBCACHE.COMPILE_CURSORS_FROM_REMOTE
(dblink IN VARCHAR2,
username IN VARCHAR2,
execution_threshold IN NUMBER,
shared_mem_threshold IN NUMBER);
Retrieves SQL in batch from dblink and parses it with username user. Only SQL-parsed execution_threshold times and above shared_mem_threshold will be retrieved.