| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: MTS question
A copy of this was sent to chuckh_at_dvol.com (Chuck Hamilton)
(if that email address didn't require changing)
On Fri, 17 Apr 1998 15:24:54 GMT, you wrote:
>In v$session, what does SERVER = NONE mean? I only see these in my MTS
>environments.
>
SQL*NET V2 multi-threaded server connections will alowys appear as NONE or SHARED in SERVER column in V$SESSION view depending on whether or not a task is currently being serviced by a shared server.
So, when the status is inactive and they are MTS connected, they will have NONE in the server column since they do not have a server process associated with them.
>select username, server, status from v$session
>user username is not null
>and rownum < 9;
>
>USERNAME SERVER STATUS
>------------------------------ --------- --------
>QDBA DEDICATED ACTIVE
>PSOFT NONE INACTIVE
>QVCDBA SHARED ACTIVE
>PSOFT DEDICATED INACTIVE
>PSOFT NONE INACTIVE
>PSOFT NONE INACTIVE
>PSOFT NONE INACTIVE
>PSOFT SHARED ACTIVE
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Fri Apr 17 1998 - 11:30:40 CDT
 |
 |