Oracle DBMS_PROCESS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Manages prespawned server processes. By default the Oracle Database can prespawn foreground processes to improve the performance of client connections. A prespawned process refers to a process that has been spawned but does not have a session yet. When a user connects to the database or a service process is needed, the process performs further initialization as needed. The procedures in this package configure the number of foreground processes for a connection pool, start a connection pool, and stop a connection pool.
AUTHID DEFINER
Dependencies
V$PROCESS_POOL    
Documented Yes
Exceptions
Error Code Reason
ORA-456 Prespawn not enabled
ORA-457 Prespawn pool not found
ORA-458 Prespawn pool already started
ORA-459 Prespawn pool not started
ORA-460 Process pool invalid configuration value(s)
First Available 12.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtprocess.plb
Subprograms
 
CONFIGURE_POOL (new 12.2)
Configures the minimum number of prespawned processes, the number of prespawned processes in a batch, and the initial number of pre-spawned processes for a foreground connection pool dbms_process.configure_pool(
pool_name   IN VARCHAR2       DEFAULT SYS_DEFAULT_FOREGROUND_POOL',
min_count   IN BINARY_INTEGER DEFAULT 10,
batch_count IN BINARY_INTEGER DEFAULT 20,
init_count  IN BINARY_INTEGER DEFAULT 0);
exec dbms_process.configure_pool('UW_FRGRND_POOL', 50, 100, 0);
 
START_POOL (new 12.2)
Starts a prespawned foreground process pool dbms_process.start_pool(pool_name IN VARCHAR2);
exec dbms_process.start_pool('UW_FRGRND_POOL');
 
STOP_POOL (new 12.2)
Stops a prespawned foreground process pool dbms_process.stop_pool(pool_name IN VARCHAR2);
exec dbms_process.stop_pool('UW_FRGRND_POOL');

Related Topics
Built-in Functions
Built-in Packages
DBMS_CONNECTION_POOL
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
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-2017 Daniel A. Morgan All Rights Reserved