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

DaLoverhino wrote:
> In a very large scale production environment, typically how many
> session might you see open on an Oracle instance at any one time? I
> know it's probably highly variable, but what's the most you have seen
> it?
>
> Is it over 50k session?
>
> I need to make some design decisions on software, and knowing a
> ballpark figure can help guide me in the early stages. Thanks for any
> feedback.

I've seen tens of thousands, probably in the neighborhood of 50K, ... but it would not be the way I would want thing to be today.

The system, for those interested, the internal directory of a very large aerospace company when they had about 200K employees.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)