RE: Q on Session
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Feb 2004 16:31:14 -0800 (PST)
Dennis William
Yup..you are rite, thank for the advice.
JKean
--- DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: Kean Jacinta [mailto:jacintakean@xxxxxxxxx]
> Sent: Wednesday, February 11, 2004 1:11 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx
> > 650-858-1557
> > www.singingsql.com
> >
> > Quoting Kean Jacinta <jacintakean@xxxxxxxxx>:
> >
> > > 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@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at
> > //www.freelists.org/archives/oracle-l/
> > > FAQ is at
> >
> //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at
> > //www.freelists.org/archives/oracle-l/
> > FAQ is at
> >
> //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at
> //www.freelists.org/archives/oracle-l/
> FAQ is at
> //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
