Oracle 12cR2 DBMS

Oracle DBMS_PROCESS Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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

START_POOL

STOP_POOL

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