For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
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.