Re: Typically, how many sessions open at one time?

From: <bdbafh_at_gmail.com>
Date: 18 Nov 2005 17:08:07 -0800
Message-ID: <1132362487.123155.324180@o13g2000cwo.googlegroups.com>

its somewhere between 1 and 2 billion:
http://dilbert.com/comics/dilbert/archive/images/dilbert2005113320118.gif

seriously, it depends.

Is connection pooling in the app tier used? Is Oracle Multi threaded server (aka shared server) being used? Are zombied sessions never being killed?

What platform (OS) - is it 32 or 64 bit? Each dedicated server process allocates process memory. At some point all physical memory would be exhausted. At some point all ports on the server would be exhausted (under 64k ports avail).
is pga_aggregate_target being used with a pga_workarea_policy of auto?

-bdbafh Received on Fri Nov 18 2005 - 19:08:07 CST