Re: viewing user sessions from con

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1164153612.670769.189240_at_h48g2000cwc.googlegroups.com...
>
> old dirtbeard wrote:
>> Hello,
>>
>> In versions of Oracle prior to the inclusion of the Oracle Enterprise
>> Manager, I recall a console where I could see all the active user
>> sessions,
>> terminate them, see the SQL being executed, etc. I used to use this
>> console
>> to help my students with their SQL, debug their code, etc.
>>
>> I have to assume that this functionality still exists, but in the
>> Enterprise
>> Manager, I can only find the most active sessions to view. I know this is
>> a
>> dumb question, but I have spent a lot of time looking, but to no avail.
>> Where can I view the current sessions, kill dead sessions, etc. Thank you
>> in
>> advance.
>
> If you install the 10g client you can still get the old Java based oem.
> It is missing some of the new 10g functionality that is present in the
> web based new oem.
>
> Is that what you are talking about?
>

Hi, yes, but I cannot find the same old console there in the client, either. In the old client, there was a window where one could monitor the session activity, who logged in, what they were doing, the code the were running, etc. With 10g, I cannot find any graphical window that displays user or session activity. I am sure it is there somewhere (it would be great if it were in the Oracle Enterprise manager), but I have not been able to locate it. Thank you.

doug Received on Tue Nov 21 2006 - 19:30:30 CST