This is an old revision of the document!

Oracle Database - Session

> Database > Oracle Database

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.1504257531.txt.gz · Last modified: 2017/09/01 11:18 by gerardnico