RE: v$session question

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Fri, 25 Jan 2002 10:14:37 -0800
Message-ID: <F001.003FB787.20020125100651@fatcity.com>

What platform?

On HP-UX 11.0 and Oracle 8.1.6.2.0 and w/ Clients on Win/NT 4 Workstations, here is what I get: (last few lines)

SQL> select username, program from v$session; USERNAME PROGRAM

----------- -------------------------------
X468Y02     C:\orant\bin\ifrun60.exe
X0C0AJF     C:\orant\bin\ifrun60.exe
X020C7P     C:\orant\bin\ifrun60.exe
XFZGBMX     C:\orant\bin\ifrun60.exe
X225D64     C:\orant\bin\ifrun60.exe
XDTF9GR     C:\orant\bin\ifrun60.exe

• Kirti

-----Original Message-----
Sent: Friday, January 25, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L

In the past, I was running Oracle 8.1.5 and the clients were running Oracle Forms 4.5. When I queried v$session and looked at the program field I could see what clients where running f45run32.exe.

Now we are on Oracle 8.1.6 and the clients are running Forms60. When I now query v$session the program filed is null?

What view could I query in 8.1.6 to see which users are running ifrun60.exe?

Thanks,
Joe

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Joe LaCascio
  INET: jlacasci_at_wheatonma.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 25 2002 - 12:14:37 CST