You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBMS_SHARED_POOL


1 to 20 of 439 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

DBMS_SHARED_POOL

151.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

151.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

151.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 151-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 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

151.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 151-4 MARKHOT Procedure Parameters Parameter Description schema

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

DBMS_SHARED_POOL

151.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 151-5 PURGE Procedure

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

DBMS_SHARED_POOL

151.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

151.3 Summary of DBMS_SHARED_POOL SubprogramsThis table lists the DBMS_SHARED_POOL subprograms and briefly describes them. Table 151-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

151.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 151-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

151.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

151.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 151-8 UNMARKHOT Procedure Parameters Parameter Description

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