Results for DBMS_SHARED_POOL


1 to 20 of 453 results. Prev  Next
Results per page:  20 |  40  | 60


Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.6 UNKEEP ProcedureThis procedure unkeeps the named object. Syntax DBMS_SHARED_POOL.UNKEEP ( name VARCHAR2, flag CHAR DEFAULT 'P'); DBMS_SHARED_POOL.UNKEEP ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.UNKEEP ( hash VARCHAR2, namespace NUMBER); WARNING: This procedure may not be supported in the future if automatic mechanisms are implemented to make this

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.7 UNMARKHOT ProcedureThis procedure unmarks a library cache object as a hot object. Syntax DBMS_SHARED_POOL.UNMARKHOT ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.UNMARKHOT ( hash VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE); Parameters Table 152-8 UNMARKHOT Procedure Parameters Parameter Description

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.2 DBMS_SHARED_POOL Operational NotesTo create DBMS_SHARED_POOL, run the DBMSPOOL.SQL script. The PRVTPOOL.PLB script is automatically

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3 Summary of DBMS_SHARED_POOL SubprogramsThis table lists the DBMS_SHARED_POOL subprograms and briefly describes them. Table 152-1 … DBMS_SHARED_POOL Package Subprograms Subprogram Description ABORTED_REQUEST_THRESHOLD Procedure Sets the

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

The procedures provided here may be useful when loading large PL/SQL objects. When large PL/SQL objects…The DBMS_SHARED_POOL package provides access to the shared pool, which is the shared memory area … where cursors and PL/SQL objects are stored. DBMS_SHARED_POOL enables you to display the sizes of … fragmentation. This chapter contains the following topics: Overview Operational Notes Summary of DBMS_SHARED_POOL Subprograms

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.3 MARKHOT ProcedureThis procedure marks a library cache object as a hot object. Syntax DBMS_SHARED_POOL.MARKHOT ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.MARKHOT ( hash VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE); Parameters Table 152-4 MARKHOT Procedure Parameters Parameter Description schema

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.4 PURGE ProcedureThis procedure purges the named object or specified heaps of the object. Syntax DBMS_SHARED_POOL.PURGE ( name VARCHAR2, flag CHAR DEFAULT 'P', heaps NUMBER DEFAULT 1); DBMS_SHARED_POOL.PURGE ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER, heaps NUMBER, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.PURGE ( hash VARCHAR2, namespace NUMBER, heaps NUMBER); Parameters Table 152-5 PURGE Procedure

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.1 DBMS_SHARED_POOL Overview, there may be insufficient memory to load the large objects. DBMS_SHARED_POOL is also useful for … shared pool. Additionally, DBMS_SHARED_POOL supports sequences. Sequence numbers are lost when a … sequence is aged out of the shared pool. DBMS_SHARED_POOL is useful for keeping sequences in the shared

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.2 KEEP ProcedureDBMS_SHARED_POOL. KEEP('0034CDFF, 20348871','C'), 0034CDFF being the ADDRESS and 20348871 the

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.1 ABORTED_REQUEST_THRESHOLD ProcedureThis procedure sets the aborted request threshold for the shared pool. Syntax DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( threshold_size NUMBER); Parameters Table 152-2 ABORTED_REQUEST_THRESHOLD Procedure Parameters Parameter Description threshold_size Size, in bytes, of a request which does not try to free unpinned (not \"unkeep-ed\") memory within the shared pool. The range of threshold_size is

Database PL/SQL Packages and Types Reference, Release 19c

DBMS_SHARED_POOL

152.3.5 SIZES ProcedureThis procedure shows objects in the shared_pool that are larger than the specified size. The name of the object is also given, which can be used as an argument to either the KEEP or UNKEEP calls. Syntax DBMS_SHARED_POOL.SIZES ( minsize NUMBER); Parameters Table 152-6 SIZES Procedure Parameters Parameter Description minsize Size, in kilobytes, over which an object must be occupying in the shared pool,

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.2 KEEP ProcedureDBMS_SHARED_POOL. KEEP('0034CDFF, 20348871','C'), 0034CDFF being the ADDRESS and 20348871 the

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.3 MARKHOT ProcedureThis procedure marks a library cache object as a hot object. Syntax DBMS_SHARED_POOL.MARKHOT ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.MARKHOT ( hash VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE); Parameters Table 149-4 MARKHOT Procedure Parameters Parameter Description schema

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.6 UNKEEP ProcedureThis procedure unkeeps the named object. Syntax DBMS_SHARED_POOL.UNKEEP ( name VARCHAR2, flag CHAR DEFAULT 'P'); DBMS_SHARED_POOL.UNKEEP ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.UNKEEP ( hash VARCHAR2, namespace NUMBER); WARNING: This procedure may not be supported in the future if automatic mechanisms are implemented to make this

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.7 UNMARKHOT ProcedureThis procedure unmarks a library cache object as a hot object. Syntax DBMS_SHARED_POOL.UNMARKHOT ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.UNMARKHOT ( hash VARCHAR2, namespace NUMBER DEFAULT 1, global BOOLEAN DEFAULT TRUE); Parameters Table 149-8 UNMARKHOT Procedure Parameters Parameter Description

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.2 DBMS_SHARED_POOL Operational NotesTo create DBMS_SHARED_POOL, run the DBMSPOOL.SQL script. The PRVTPOOL.PLB script is automatically

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.4 PURGE ProcedureThis procedure purges the named object or specified heaps of the object. Syntax DBMS_SHARED_POOL.PURGE ( name VARCHAR2, flag CHAR DEFAULT 'P', heaps NUMBER DEFAULT 1); DBMS_SHARED_POOL.PURGE ( schema VARCHAR2, objname VARCHAR2, namespace NUMBER, heaps NUMBER, edition_name VARCHAR2 DEFAULT NULL); DBMS_SHARED_POOL.PURGE ( hash VARCHAR2, namespace NUMBER, heaps NUMBER); Parameters Table 149-5 PURGE Procedure

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3 Summary of DBMS_SHARED_POOL SubprogramsThis table lists the DBMS_SHARED_POOL subprograms and briefly describes them. Table 149-1 … DBMS_SHARED_POOL Package Subprograms Subprogram Description ABORTED_REQUEST_THRESHOLD Procedure Sets the

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.5 SIZES ProcedureThis procedure shows objects in the shared_pool that are larger than the specified size. The name of the object is also given, which can be used as an argument to either the KEEP or UNKEEP calls. Syntax DBMS_SHARED_POOL.SIZES ( minsize NUMBER); Parameters Table 149-6 SIZES Procedure Parameters Parameter Description minsize Size, in kilobytes, over which an object must be occupying in the shared pool,

Database PL/SQL Packages and Types Reference, Release 18c

DBMS_SHARED_POOL

149.3.1 ABORTED_REQUEST_THRESHOLD ProcedureThis procedure sets the aborted request threshold for the shared pool. Syntax DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD ( threshold_size NUMBER); Parameters Table 149-2 ABORTED_REQUEST_THRESHOLD Procedure Parameters Parameter Description threshold_size Size, in bytes, of a request which does not try to free unpinned (not \"unkeep-ed\") memory within the shared pool. The range of threshold_size is





Was this page helpful?

Integrated Cloud Applications & Platform Services