Slide
‹#› of 37
Application Server / Database
uCritical success factor – managing database
sessions:
ØAlmost impossible to have one session per
connection
ØCost of opening/closing sessions is high.
uOpportunity:
ØTotal number of physical sessions at any point in time
is fairly small.
uGood idea:
ØCreate connection pool with a fixed number of
connections (using
Autoextend option).
ØServe them to incoming requests as needed.
uProblems:
ØA single physical session can serve requests from
different logical sessions at
different points in time.
ØCannot trust ANYTHING defined at the session level.
