JKean
I'm really glad that you got an answer to your question. I would like to
gently suggest that you make it a priority to become familiar with Oracle's
concepts. This way you will avoid asking questions that could easily be
answered in Oracle's manual. Just an idea.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: Kean Jacinta [mailto:jacintakean_at_yahoo.com]
Sent: Wednesday, February 11, 2004 1:11 AM
To: oracle-l_at_freelists.org
Subject: Re: Q on Session
Dear: Dan Tow
Now i really get it.I should visit OTN network often,
since i am not familiar with lot's of fundamental
concept abt oracle.
THANK AGAIN :)
JKean
- Dan Tow <dantow_at_singingsql.com> wrote:
> 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
> >
>
> >
>
>
> 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
>
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Wed Feb 11 2004 - 11:49:15 CST
