Oracle | DBMS

Oracle DBMS_PROCESS Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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: Packages and Types Reference

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

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');