• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. V$SESSION

V$SESSION

V$SESSION stores all information about the current session.

Table 1 V$SESSION columns

Name

Type

Description

sid

bigint

OID of the background process of the current activity

serial#

integer

Sequence number of the active background process, which is 0 in DWS.

user#

oid

OID of the user that has logged in to the background process

username

name

User name of the user that has logged in to the background process