OK, the subject is a bit redundant. We recently upgraded our HR system to
PeopleSoft8, and I have noticed some strange stuff with 2-tier connections.
Just thought I'ld toss this out and see if anyone else has seen the same
kind of stuff.
In the past, when a user logged on 2-tier, an entry would be made to
v$session when the user logged on, and it would remain till the user logged
off. V$session.program would also show something like C:\...\ptools.exe and
v$session.osuser as the PC user. Now, however, sessions seem to pop in and
out. I have seen sessions come and go on v$session. I have also had a user
connect, be idle, shut down the listener, have them run something, and get a
Cannot Connect error. Also, v$session.program now shows PSAPPSRV with an
osuser of the osuser which spawned the application server. If I trace the
session back to v$process and look at the spid, the UNIX process points to a
dedicated shadow process as expected, not the appserver. The appserver,
however, must be touched or how would it know the osuser? (I haven't had a
chance to test this with the appserver shut down). Man that's confusing.
If anyone out there is interested in this stuff I will be glad to post more
if and when I find it.
Henry
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
