|Purpose||This package provides a mechanism for applications to view and compile cursors in the local library cache using cursors selected from the library cache on a remote instance. This package is intended for use with RAC and is not part of the default installation.|
|Note||-- In 18.104.22.168 we wrote
the following: Attempting to compile this package using dbmslibc.sql produces the following errors:
98/20 PLS-00201: identifier 'DBMS_LIBCACHE$DEF.DB_LINK' must be declared
160/3 PL/SQL: Declaration ignored
161/19 PLS-00201: identifier 'DBMS_LIBCACHE$DEF.DB_LINK' must be declared
-- you must run catlibc.sql before attempting to install this package.
The database link parameter is mandatory and points to the instance that will be used for extracting the SQL statements. The user must have the role SELECT_ON_CATALOG at the source instance. For improved security, the connection may use a password file or LDAP authentication. The database link is mandatory only for releases with dbms_libcache$def.ACCESS_METHOD = DB_LINK_METHOD.
-- as of 22.214.171.124 things get worse and as this is package has not been maintained since 2001 it will stay in the Library
-- but be sure to test it thoroughly before depending upon any of its functionality
|Security Model||Owned by SYS with EXECUTE granted to PUBLIC.
According to the docs the session executing the code must have the SELECT_CATALOG_ROLE role as well as the ability to ALTER the target schema and a valid database link to the same user in the source schema. So why is execute granted to PUBLIC? I have no idea. I suspect no one at Oracle does either.
|Call when the library cache on the source instance is stable, and whenever the target library cache is restarted||
|-- prepares the database's library cache
-- prepares the library cache for a named schema's entries
-- prepares the library cache for a named schema's statements with greater than 10 executions
-- as above but additionally specifying a minimum cursor size of 4K
|Called as a standalone job allows for parallel execution of the compilation task||
|What's New In 18cR3|
|What's New In 19cR2|
|This site is maintained by Dan Morgan. Last Updated:||This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved|