Re: Oracle Concurrent Users SQLPLus, Unix vs. Windows.

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 13 Oct 2004 18:57:57 -0700
Message-ID: <1097719163.656054_at_yasure>


Mark A Framness wrote:

> Greetings,
>
> I am working with a system and application performance monitoring
> tool.
>
> One of the Oracle counters it has is "Oracle Concurrent Users" which
> everything seems to point at says it is the number of users logged
> onto Oracle at the given sample.
>
> However, using Windows SQL+ I log onto Oracle and this does nothing to
> the "ORacle Concurrent Users" number, then I go to Unix and log onto
> Oracle using the Unix SQL+, guess what? My tool registers another
> "Oracle Concurrent User". I tried to ask one of our SEs about this and
> she essentially pointed me at the user manual definition (bless her
> soul she is very helpful but I need more).
>
> I queried a DBA about this and he told me there are no differences and
> the view he looked at showed increased users when logging on via
> Windows SQL+.
>
> The question is properly what is my tool exactly looking at but if you
> know of any differences between Windows and Unix versions of SQL+ it
> would probably point this out to me. Yes, I have my big book or Oracle
> DBA aracana out and am pouring through it.
>
> Thanks
> Mark

Have no idea. But I certainly wouldn't have purchased a tool just to perform a simple SELECT statement against v$session.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Oct 14 2004 - 03:57:57 CEST

Original text of this message