Differences

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Text|String|Character)

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
db:oracle:session [2010/06/11 14:45]
gerardnico created
db:oracle:session [2017/09/06 19:29] (current)
gerardnico ↷ Page moved from oracle:session to db:oracle:session
Line 1: Line 1:
 ====== Oracle Database - Session ====== ====== Oracle Database - Session ======
  
 +===== About =====
 +One session = One connection = One transaction (one user behind its screen)
  
 +For session variable, see [[context]]
 ===== Articles Related ===== ===== Articles Related =====
 {{backlinks>​.}} {{backlinks>​.}}
 +
 +===== 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|userenv]] context.
 +
 +===== V$session =====
 +When the username is null, this is server activity not client activity. The program runs oracle.exe.
 +
 +
 +
db/oracle/session.1276260316.txt.gz · Last modified: 2010/06/11 14:45 by gerardnico