select sid,serial#,osuser,username,program,machine from $session;
----- Original Message -----
From: "john qi" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, August 30, 2002 6:14 PM
Subject: session id


| Hi lists,
|
| How can I get the session id for my current session?
|
| Thanks,
|
| John
|
| __________________________________________________
| Do You Yahoo!?
| Yahoo! Finance - Get real-time stock quotes
| http://finance.yahoo.com
|
| --------
| Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
| To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
| Tell yer mates about http://www.farAwayJobs.com
| By using this list you agree to these
terms:http://www.lazydba.com/legal.html
|


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.384 / Virus Database: 216 - Release Date: 8/21/2002

Oracle LazyDBA home page