| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q on Session
Here's how it looks based on the V$ tables that track these (The OracleXX
Reference is a good source for this stuff, and the Concepts manual contains the
authoritative definitions - these are all available online for free if you sign
up with Oracle's OTN network.):
A connection is how you establish a session - they map one-to-one for user sessions (not counting those background sessions like SMON), with the connection being what Net8 pays attention to, and the session being what the RDBMS pays attention too, roughly. A user session can be waiting to be asked to do work for the application (status=INACTIVE), or it can be executing SQL.
Every session should have a process, but with MTS a process can handle multiple sessions. The process is what you see from the point of view of your OS, for example with the ps command from UNIX.
Applications can have multiple sessions (and connections) where they choose, sometimes for security reasons, sometimes to maintain independent commit cycles. the V$SESSION table gives the OS process ID of the *client* process (the application process) in the PROCESS column. If you can identify the client process ID, you can see the number of sessions it has with a query on PROCESS=<PIDYouFound>. This works especially well in UNIX - I think the PIDs are kind of funky for Windows apps.
Yours,
Dan Tow
dantow_at_singingsql.com
650-858-1557
www.singingsql.com
Quoting Kean Jacinta <jacintakean_at_yahoo.com>:
> Dear : All
>
> Sorry if my question sound stupid. I really need to
> understand the diff between a session, a connection
> and a process.
>
> 1) An application connected to oracle ...is that
> called a connection or a session or a process ?
>
>
> Thank
>
> JKean
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Finance: Get your refund fast by filing online.
> http://taxes.yahoo.com/filing.html
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Feb 11 2004 - 00:51:39 CST
 |
 |