Home » RDBMS Server » Server Administration » How to find session Id
How to find session Id [message #50003] Fri, 22 February 2002 09:53 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
How I can find my current session using SQL statement. I need to read the session that I am currently using for this SQL.

Thanks

Report message to a moderator

Re: How to find session Id [message #50005 is a reply to message #50003] Fri, 22 February 2002 09:56 Go to previous messageGo to next message
saleem
Messages: 65
Registered: January 2002
Member
select username, osuser, sid, serial#, program
from v$session

this will show you all the sessions active on the db and then you can figure out from there which one is you.

Report message to a moderator

Re: How to find session Id [message #50007 is a reply to message #50003] Fri, 22 February 2002 10:50 Go to previous message
saleem
Messages: 65
Registered: January 2002
Member
the 'osuser' column should show the identity of the p.c. that is connected.

Report message to a moderator

Previous Topic: Re: AUTOMATIC OPENING OF ORACLE DATABASE
Next Topic: Re: fast retrieval of images from oracle..plz help...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 08 10:56:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.