Oracle DBMS_PROCESS
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Manages pre-spawned server processes. By default the Oracle Database can pre-spawn foreground processes to improve the performance of client connections. A pre-spawned 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
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtprocess.plb
Subprograms
 
CONFIGURE_POOL
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
Starts a prespawned foreground process pool dbms_process.start_pool(pool_name IN VARCHAR2);
exec dbms_process.start_pool('UW_FRGRND_POOL');
 
STOP_POOL
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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx