I did a sql query
SELECT SID, SERIAL#, STATUS
FROM V$SESSION
WHERE USERNAME = '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,
>
> Query v$session with the application user name that
> should give you some =
> idea.
>
> Best Regards
>
> Sriram Kumar=20
>
> -----Original Message-----
> From: Kean Jacinta [mailto:jacintakean_at_yahoo.com]=20
> Sent: Wednesday, February 11, 2004 9:20 AM
> To: oracle-l_at_freelists.org
> Subject: Pls guide me :Q regarding Application
> connection
>
> Dear : All
>
> Can someone help me . I have this application making
> a
> connection to oracle database.
>
> Is there are way i can find out how many connection
> is
> connection to the database by this application ?=20
>
> If yes pls guide me through .=20
>
> Thank You
>
>
> 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
>
>
>
> DISCLAIMER:
> This message contains privileged and confidential
> information and is =
> intended only for the individual named.If you are
> not the intended =
> recipient you should not
> disseminate,distribute,store,print, copy or =
> deliver this message.Please notify the sender
> immediately by e-mail if =
> you have received this e-mail by mistake and delete
> this e-mail from =
> your system.E-mail transmission cannot be guaranteed
> to be secure or =
> error-free as information could be =
> intercepted,corrupted,lost,destroyed,arrive late or
> incomplete or =
> contain viruses.The sender therefore does not accept
> liability for any =
> errors or omissions in the contents of this message
> which arise as a =
> result of e-mail transmission. If verification is
> required please =
> request a hard-copy version.
>
> 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 Tue Feb 10 2004 - 23:56:18 CST
