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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kean Jacinta
Sent: Tuesday, February 10, 2004 10:56 PM
To: oracle-l_at_freelists.org
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_at_iflexsolutions.com 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_at_yahoo.com]=3D20
> Sent: Wednesday, February 11, 2004 9:20 AM
> To: oracle-l_at_freelists.org
> 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_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
>
>=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_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 - 00:29:45 CST