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

Home -> Community -> Mailing Lists -> Oracle-L -> from V$SESSION - SERVER = NONE?

from V$SESSION - SERVER = NONE?

From: Charlie Mengler <charliem_at_mwh.com>
Date: Wed, 26 Jul 2000 06:54:04 -0700
Message-Id: <10570.113007@fatcity.com>


On one of my Oracle server systems I'm running MTS on port 1521 and I've defined port 1529 to be for non-MTS (DEDICATED?) connections.

What does a SERVER type of "NONE" indicate?

FWIW - Oracle V7.3.4.3 on V2.6 Solaris.
Machines that have all capital letters in their names are PC's. Machines that have all lower case letters in their names are "front end" Suns in a 3 tier architecture.

  1 select distinct machine, server
  2* from v$session
SQL> /
#:-)

MACHINE SERVER
------------ ---------

AP001        NONE
AP007        NONE
AP014        NONE
ATPC1        NONE
CR004        NONE
DCPC3        NONE
FIN009       NONE
FIN014       NONE
FIN024       NONE
FLPC         DEDICATED
FLPC         NONE
LGSTX011     NONE
LGSTX017     DEDICATED
LGSTX017     SHARED
MKTG010      NONE
SAPC1        NONE
SLPC6        NONE
apollo       DEDICATED
atlas        DEDICATED
centaur      DEDICATED
medusa       DEDICATED
pan          DEDICATED
titan        DEDICATED
zeus         DEDICATED
zeus         SHARED
             DEDICATED

26 rows selected.

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              10641 Scripps Summit Ct   
858-831-2229                                  San Diego, CA 92131    
There is a fine line between vision & hallucination. Don't cross it!
Received on Wed Jul 26 2000 - 08:54:04 CDT

Original text of this message

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