Re: Oracle Concurrent Users SQLPLus, Unix vs. Windows.
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 14 Oct 2004 17:58:14 -0700
Message-ID: <1097801980.822911_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.
Date: Thu, 14 Oct 2004 17:58:14 -0700
Message-ID: <1097801980.822911_at_yasure>
Mark A Framness wrote:
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<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.
> > > > You are correct, it does soooooo much more than just Oracle. It also > monitors all sorts of server performance characteristics, it also > monitors network performance, it also monitor online program response. > > Anyway
Except for the fact that it appears to provide incorrect answers I'd say you have an excellent tool to work with.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Oct 15 2004 - 02:58:14 CEST