Oracle Database - Session
1 - About
One session = One connection = One transaction (one user behind its screen)
For session variable, see Oracle Database - (Application) Context
2 - Articles Related
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.