RE: Zero-term'd machine in V$SESSION from Winders

2002-05-14 Thread Alexander . Feinstein
Title: RE: Zero-term'd machine in V$SESSION from Winders Rich, I tested on 8.1.7.2 on HP. For Windows client (7.3, 8.0, 8.1) "machine" has null terminator, "terminal" does not. For HP client neither does. For backgrounds "machine" does not, but "termina

RE: Zero-term'd machine in V$SESSION from Winders

2002-05-14 Thread Reardon, Bruce (CALBBAY)
Jesse, Our database is 81714 on NT4. Our clients are a mix of 816 OCI, 817 sqlplus and forms 4.5. The forms 4.5 clients include only the PC name in machine column and it is not chr(0) terminated. Their terminal field is set to 'Windows NT PC' Our 816 & 817 clients have machine set to 'dom

RE: Zero-term'd machine in V$SESSION from Winders

2002-05-14 Thread Jay Mehta
Rich, We do have Win clients, and V$SESSION does show proper values for machine and terminal. Are these sessions for background processes and/or slave processes? Jay -Original Message- Sent: Tuesday, May 14, 2002 4:23 PM To: Multiple recipients of list ORACLE-L So, there I am, creati

Zero-term'd machine in V$SESSION from Winders

2002-05-14 Thread Jesse, Rich
So, there I am, creating a "special" kill user script (don't ask) for one of our instances, 8.1.6.0.0 on Solaris. The problem is that some of the output rows were getting truncated on the output. Here's the proc I had started: CREATE OR REPLACE PROCEDURE Euthanize AS v_printlin