Re: what query to ID the specific DBMS session?

From: joel garry <joel-garry_at_home.com>
Date: 2 May 2007 13:32:06 -0700
Message-ID: <1178137926.363634.52740@y80g2000hsf.googlegroups.com>

On May 2, 1:04 pm, "joeNOS..._at_BEA.com" <joe.weinst..._at_gmail.com> wrote:
> Hi all,
> This is a real basic Oracle ignorance of mine... What query can I
> run
> to get the unique ID of the current DBMS session, so if there's 100
> sessions, all logged in as scott/tiger, each one has it's own
> different
> ID?
> thanks
> Joe Weinstein at BEA Systems

Search for sys_context in the docs.

There may be another answer depending on what you want to do once you find out.

--
@home.com is bogus.
18.  Get the lawyer.  http://www.signonsandiego.com/uniontrib/20070502/news_1b2prgn.html

Received on Wed May 02 2007 - 15:32:06 CDT