Dennis William
Yup..you are rite, thank for the advice.
JKean
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> 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_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
>
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
-----------------------------------------------------------------
Received on Wed Feb 11 2004 - 18:31:14 CST