| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: PeopleSoft8 Oddities
We'll be moving both human resources to Peoplesoft 8 before year's end. I for one am very interested.
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
Sent: Wednesday, August 29, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L
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: Henry.Poras_at_ctp.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).
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 Wed Aug 29 2001 - 17:32:28 CDT
 |
 |