Oracle Database - Session

1 - About

One session = One connection = One transaction (one user behind its screen)

For session variable, see Oracle Database - (Application) Context

3 - Session Id

  • SESSIONID - The auditing session identifier. You cannot use this attribute in distributed SQL statements.
  • SID - The session ID.

You can get the current values for a session with the help of the userenv context.

4 - V$session

When the username is null, this is server activity not client activity. The program runs oracle.exe.

db/oracle/session.txt ยท Last modified: 2017/09/06 19:29 by gerardnico