Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ V$SESSION
Updated on 2025-10-09 GMT+08:00
View PDF

V$SESSION

V$SESSION displays all session 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

Name of the user that has logged in to the background process
Parent Topic: System Views