use V$sesson table, columns SID and PROGRAM



-----Original Message-----
From: ramki [mailto:[Email Address Removed] Friday, June 28, 2002 10:23 AM
To: LazyDBA.com Discussion
Subject: How to find the current session id which i connected through SQL
PlusHi


Hi All,

will any one tell me how to find the current session id which i connected
through SQL Plus.

Thanx in advance
Ramki




*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.
**********************************************************************

Oracle LazyDBA home page