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

Advertising

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.1437655179.txt.gz · Last modified: 2015/07/23 14:39 by gerardnico