470,811 Members | 1,268 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,811 developers. It's quick & easy.

how to identify 2 different session on same machine

Hi Folks,

how to identify 2 different session on same machine, same/nearly same
logon time that is running on a oracle server.

We have different sid,serial# but how to identify they both are
different. Given the sqls running in there sessions were different

Thanks for your time.
Pravesh Karthik
Jul 19 '05 #1
1 3961
ka********@yahoo.com (Kamesh) wrote in message news:<89**************************@posting.google. com>...
Hi Folks,

how to identify 2 different session on same machine, same/nearly same
logon time that is running on a oracle server.

We have different sid,serial# but how to identify they both are
different. Given the sqls running in there sessions were different

Thanks for your time.
Pravesh Karthik


There are a number of answers to your question, but I'm not real sure
what the question is. Perhaps the osuser or machine columns have what
you need? It varies by application and configuration. If you have a
single remote user with two sessions, it may be a tossup.

comp.databases.oracle is a decremented group.

See http://members.cox.net/oracleunix/readme-cdos.htm

jg
--
@home.com is bogus.
http://hosted.ap.org/dynamic/stories...MPLATE=DEFAULT
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by hxc98 | last post: by
2 posts views Thread by Mike Kansky | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.