Oracle | DBMS

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

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