| Session [message #50581] |
Fri, 22 March 2002 07:02  |
kiran srirama
Messages: 14
Registered: March 2002
|
Junior Member |
|
|
Hi all,
v$session shows all the currents sessions in a database. is there any query which returns the current session without asking for any inputs.
Basically, how do i identify the session.
Could sys_guid() help me in association with this.
Thanks
Kiran Srirama
|
|
|
|
| Re: Session [message #50686 is a reply to message #50581] |
Mon, 01 April 2002 18:48  |
Irfan Hashim
Messages: 5
Registered: April 2002
|
Junior Member |
|
|
hi,
what i have understood is below:
(a) issue command SHOW USER at SVRMGR prompt to find out the current username
(b) select from v$session informaton about this current username by using WHERE clause in the select query.
i hope this was you were asking for.
IRfan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
