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 -----------------------------------------------------------------