Oracle9i Connection pooling :confused:

[Lipman Li]

pls see the DISPATCHERS initialize parameter setting below,
DISPATCHERS="(PROTOCOL=tcp)(DISPATCHERS=1)(POOL=on)(TICK=1) (CONNECTIONS=1000)(SESSIONS=4000)"
what's difference between the connection and session? this dispatcher handle 1000 connections, but how to handle 4000 sessions, does it mean user could create multiple sessions with one connection?
thanks

[Mark Spritzler]

Well with pooling all users share those resources. So if you have 1000 connections pooled, you can still have 4000 sessions, it is just that those 4000 sessions will be sharing 1000 connections.
Wether these numbers are good or bad is determined by your Application of them. Will those 4000 all be using connections at the same time, or can you determine the concurrent usage will be less. It is all a give and take and determining what works best for your application.
Mark