Oracle | DBMS

Oracle DBMS_PROCESS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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

      

      PL/SQL procedure successfully completed.

START_POOL

Starts a prespawned foreground process pool dbms_process.start_pool(pool_name IN VARCHAR2);

exec dbms_process.start_pool('UW_FRGRND_POOL');

      

      PL/SQL procedure successfully completed.

STOP_POOL

Stops a prespawned foreground process pool dbms_process.stop_pool(pool_name IN VARCHAR2);

exec dbms_process.stop_pool('UW_FRGRND_POOL');

      

      PL/SQL procedure successfully completed.