Sorry for the confusion.

My questions are:

1. Why is the machine name in 'MACHINE' column of V$SESSION appended by a
chr(0) for user connections and not for background processes? 

2. And why is the machine name prefixed by 'domain_name\' for user
connections and not for background processes?

Oracle 8.0.6.1.0 WindowsNT

Regards
Naveen

-----Original Message-----
Sent: Friday, November 01, 2002 2:39 AM
To: Multiple recipients of list ORACLE-L



You've got questions, we've got answers; but interrogative sentences may help
the twain to meet.



On Thu, Oct 31, 2002 at 08:28:51AM -0800, Naveen Nahata wrote:
> I have 2 questions regarding the machine column in V$SESSION.
> 
> 1. It shows just the machine name of the server for all the background
> processes, but for all user connections it shows domain\machine_name
> 2. Also for user processes, the machine name is appended with a chr(0)
> whereas for background processes it is not.
> 
> Oracle 8.0.6.1 Windows NT
> 
> Regards
> Naveen
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Naveen Nahata
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
> San Diego, California        -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).

-- 
===============================================================
Ray Stell   [EMAIL PROTECTED]     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Reply via email to