Oracle DBMS_PROCESS
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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 service a 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
DBMS_PROCESS_LIB 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