how to identify 2 different session on same machine

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Kamesh
    #1

    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
    Tags: None
    • Joel Garry
      #2
      Re: how to identify 2 different session on same machine

      kamesh_blr@yaho o.com (Kamesh) wrote in message news:<896a5eff. 0409120900.713a 725a@posting.go ogle.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/C/CA_TRAIN_DERAILS?SITE=ORBAK&SECTION=HOME&TEMPLATE=DEFAULT

        Comment

        Previous template Next
        Working...