Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Machine column in V$session

RE: Machine column in V$session

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Sat, 02 Nov 2002 01:28:35 -0800
Message-ID: <F001.004FAA53.20021102012835@fatcity.com>


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: naveen_nahata_at_mindtree.com
>
> 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: 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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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: 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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.com

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: 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 Sat Nov 02 2002 - 03:28:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US