The connection pools create and open database connections when they are first needed. When you start the P6 EPPM server, it will allocate one or two connections for initialization routines. The server will allocate and open more connections when the pool cannot satisfy requests from the current pool. You can set the connection pool settings for:
Note: Gantt applets will use the Regular pool when loading data and the Transactional pool when creating or updating data.
A P6 EPPM application operation requires a database connection, so it asks the connection pool for a database connection. If the connection pool contains a connection that is not currently leased, it returns that connection. If it doesn’t have a connection available it will check to see if its current allocated count is below 50 (which is the default in the Maximum Connections setting). If the count is below 50, it will create a new database connection and open it, put it in the pool, and return it to the caller. The caller uses the connection, then releases it when they end the session.
If the pool could not allocate a connection because all 50 connections were leased, it will keep checking for the next 30 seconds (which is the default in the Lease Request Wait Timeout setting). If a connection becomes available within that 30 seconds, it will return that connection. If a connection does not become available, it will log the following error: “Error: Lease request timeout while waiting for a connection to become available. Database <dbname>” and the caller will have to try again at a later time.
To set your connection pool settings:
Note: The defaults will provide optimal performance in most environments. Change them only if you are certain a change is needed. Contact My Oracle Support for more information.
The default is 4m.
Enter anything from 4m-12h.
The default is 1m.
Enter anything from 10s-1h.
If a request for a database connection times out, the user can reload the page and attempt to connect to the database again.
The default is 30s.
Enter anything from 5s-2h.
The default for Regular and Transactional is 50 and the default for Long Running is 100.
Enter anything from 5-15000.
The default is 120.
The default is false.
The default is 3.
You can enter anything from 3-5.
Choose false if you want each connection to be leased only for the MaxLeaseDuration period.
The default for Regular is false. The default for Long Running and Transactional is true.
The default for Regular is 2m, with a range of 5s-4h.
The default for Long Running is 15m, with a range of 5s-6h.
Note: During the summarization process, queries may take a long time to execute if the project has a high number of WBS nodes. If you receive timeout errors, set your Long Running maximum lease duration to at least 30 minutes.
The default for Transactional is 10m, with a range of 5s-6h.
Related Topics |
Legal Notices
Copyright © 1999, 2015,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, July 29, 2015