RE: Pls guide me :Q regarding Application connection
- From: Kean Jacinta <jacintakean@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 10 Feb 2004 22:37:23 -0800 (PST)
Yes, now i understand . Thank You so much : )
JKean
--- "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx> wrote:
> An inactive session state merely means that the
> session is not currently =
> executing a SQL statement. For most client-server
> applications, most of =
> your connections will be inactive most of the time.
>
> Justin Cave
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx =
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Kean Jacinta
> Sent: Tuesday, February 10, 2004 10:56 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Pls guide me :Q regarding Application
> connection
>
>
> I did a sql query=20
>
> SELECT SID, SERIAL#, STATUS
> FROM V$SESSION
> WHERE USERNAME =3D 'DEVTOWN';
>
> The status show that is inactive eventhou i have a
> connection to the application. Pls explain further.
>
> Thank you
>
> JKean
>
>
>
> --- k.sriramkumar@xxxxxxxxxxxxxxxxxx wrote:
> > Hi Kean,
> >=20
> > Query v$session with the application user name
> that
> > should give you some =3D
> > idea.
> >=20
> > Best Regards
> >=20
> > Sriram Kumar=3D20
> >=20
> > -----Original Message-----
> > From: Kean Jacinta
> [mailto:jacintakean@xxxxxxxxx]=3D20
> > Sent: Wednesday, February 11, 2004 9:20 AM
> > To: oracle-l@xxxxxxxxxxxxx
> > Subject: Pls guide me :Q regarding Application
> > connection
> >=20
> > Dear : All
> >=20
> > Can someone help me . I have this application
> making
> > a
> > connection to oracle database.
> >=20
> > Is there are way i can find out how many
> connection
> > is
> > connection to the database by this application
> ?=3D20
> >=20
> > If yes pls guide me through .=3D20
> >=20
> > Thank You
> >=20
> >=20
> > JKean
> >=20
> >=20
> >=20
> >=20
> > __________________________________
> > 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:=20
> > 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
> >
>
-----------------------------------------------------------------
> >=20
> >=20
> > DISCLAIMER:
> > This message contains privileged and confidential
> > information and is =3D
> > intended only for the individual named.If you are
> > not the intended =3D
> > recipient you should not
> > disseminate,distribute,store,print, copy or =3D
> > deliver this message.Please notify the sender
> > immediately by e-mail if =3D
> > you have received this e-mail by mistake and
> delete
> > this e-mail from =3D
> > your system.E-mail transmission cannot be
> guaranteed
> > to be secure or =3D
> > error-free as information could be =3D
> > intercepted,corrupted,lost,destroyed,arrive late
> or
> > incomplete or =3D
> > contain viruses.The sender therefore does not
> accept
> > liability for any =3D
> > errors or omissions in the contents of this
> message
> > which arise as a =3D
> > result of e-mail transmission. If verification is
> > required please =3D
> > request a hard-copy version.
> >
>
----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> >
>
----------------------------------------------------------------
> > To unsubscribe send email to:=20
> > 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:
