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.

its somewhere between 1 and 2 billion:
http://dilbert.com/comics/dilbert/ar...5113320118.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

Thanks for the reply. I also like that Dilbert cartoon.

Our software needs to work in any oracle environment, unfortunately, so
I can give you hard numbers. That's why I'd like to know what the
limit is.

Anyways, here's what typically what we see (based on your questions.)

-connection pooling is typically used in the larger firms, but not
always so.
-About 50% of our clients have shared servers.
-I'd assume our 'Enterprise/Carrier' level customers kill zombie
processes. But, you bring up a good point, and I'll design for that,
thanks.
-Most of our clients are on 32, but we are seeing a steady rise in
64bit clients.
-I don't know what pga_aggregate_target/pga_workarea_policy is. I'll
have to do my homework on it, but assume the resource hog alternative
for now.


Our software is a monitoring tool. And, I want to play around with
utl_tcp package to get information out of each session real time. So,
I created a package with a 'package scope' tcp connection.
Unfortunately, package scope variables are private to each session.
What I'd really like is a tcp connection or a pool of them that can be
shared across many sessions.

Some manuals floating around the internet suggest using dbms_pipes if I
want connections shared across sessions. Unfortunately, I have found
dbms_pipes to have alot of overhead, and they are simply not fast
enough. Eventually the pipes get 'clogged' with a flood of
information. I'm hoping utl_tcp is a lighter weight connection to the
outside world.

If you have another alternative, that would be great. Anyways, if you
can, please still answer the questions. I'd like to know them, just in
case.

thanks again!

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@x.washington.edu
(replace x with u to respond)

"DA Morgan" <damorgan@psoug.org> wrote in message
news:1132370205.447899@yasure...
> 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@x.washington.edu
> (replace x with u to respond)

200K !!! My gosh! What was the Christmas party like?

It wasn't BFG Aerospace, was it?
--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup

Andreas Sheriff wrote:
> "DA Morgan" <damorgan@psoug.org> wrote in message
> news:1132370205.447899@yasure...
>
>>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@x.washington.edu
>>(replace x with u to respond)
>
>
> 200K !!! My gosh! What was the Christmas party like?
>
> It wasn't BFG Aerospace, was it?

Consider that I am in the Seattle area. ;-)
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

"DA Morgan" <damorgan@psoug.org> wrote in message
news:1132553586.700919@yasure...
> Andreas Sheriff wrote:
>> "DA Morgan" <damorgan@psoug.org> wrote in message
>> news:1132370205.447899@yasure...
>>
>>>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@x.washington.edu
>>>(replace x with u to respond)
>>
>>
>> 200K !!! My gosh! What was the Christmas party like?
>>
>> It wasn't BFG Aerospace, was it?
>
> Consider that I am in the Seattle area. ;-)
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@x.washington.edu
> (replace x with u to respond)

Boeing? (not boing :-)

--
Andreas
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer


"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding if you don't eat your meat?!?!"
---

WARNING:
DO NOT REPLY TO THIS EMAIL
Reply to me only on this newsgroup

Andreas Sheriff wrote:
> "DA Morgan" <damorgan@psoug.org> wrote in message
> news:1132553586.700919@yasure...
>
>>Andreas Sheriff wrote:
>>
>>>"DA Morgan" <damorgan@psoug.org> wrote in message
>>>news:1132370205.447899@yasure...
>>>
>>>
>>>>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@x.washington.edu
>>>>(replace x with u to respond)
>>>
>>>
>>>200K !!! My gosh! What was the Christmas party like?
>>>
>>>It wasn't BFG Aerospace, was it?
>>
>>Consider that I am in the Seattle area. ;-)
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan@x.washington.edu
>>(replace x with u to respond)
>
>
> Boeing? (not boing :-)

That would be a reasonable assumption.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)