Iwant to optimize the number of Oracle connections of all components in order to create the connections that actually need and remove them from the pool when not in use.
In the amministration guide --> Metastorm Process Engine-->Connections
"
The following database connections are used by the Engine:
- A single database connection for each Client request. The lifetime of the connection is the lifetime of the request.
- A single database connection for each Event Manager request. The lifetime of the connection is the lifetime of the request.
- Two database connections, used by the Alert Generator. These connections are held continuously by the Alert Generator.
- Two database connections, used by the Event Manager. However, these are created only on demand (unlike the Alert Generator’s connections).
Additional database connections may be generated by external database MBO operations or from a script, where the author has decided to do their own database handling.
If tracking the numbers of database connections held, note that COM+ and ADO.NET database pooling means that the numbers of connections held over time is 'smoothed out'.
"
We would like to know the relationship that exists between threads / connections, as does the number of connections when using the connection MSTM and if when you reach the maximum number of connections is set and there are threads waiting, they expect is a free allowed, or him is assigned a breached the maximum number of connections.
can someone help me?
