dbTalk Databases Forums  

how to identify 2 different session on same machine

comp.databases.oracle comp.databases.oracle


Discuss how to identify 2 different session on same machine in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Kamesh
 
Posts: n/a

Default how to identify 2 different session on same machine - 09-12-2004 , 12:00 PM






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

Reply With Quote
  #2  
Old   
Joel Garry
 
Posts: n/a

Default Re: how to identify 2 different session on same machine - 09-13-2004 , 06:24 PM






kamesh_blr (AT) yahoo (DOT) com (Kamesh) wrote in message news:<896a5eff.0409120900.713a725a (AT) posting (DOT) google.com>...
Quote:
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...LATE= DEFAULT


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.