HPE Community
Operating System - HP-UX
1832367 Members
2917 Online
110041 Solutions
New Discussion

HPUX 11.0 and Oracle 8i listing users

 
Gerry Tully
Frequent Advisor

‎09-21-2000 07:58 AM

‎09-21-2000 07:58 AM

HPUX 11.0 and Oracle 8i listing users

We are currently in the process of upgrading to Oracle 8i, java based. When we were at 7.3.4 character based, I could easily tell who was on the system. Now,people are connecting through the web, as it's now a web based application. Is there an easy for me to tell who is connected to the system and what they are doing? Thanks.
Any Ideas?
0 Kudos
Reply
1 REPLY 1
John Palmer
Honored Contributor

‎09-21-2000 08:08 AM

‎09-21-2000 08:08 AM

Re: HPUX 11.0 and Oracle 8i listing users

Well from within Oracle you can get quite a lot of information, check out V$SESSION for a start.

However if they are not using their own Oracle user then it's difficult to know who's who.

You may also find something useful in the Oracle listener log
$ORACLE_HOME/network/log/listener.log
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.