GV_SESSION

GV_SESSION displays information about all current sessions. Only administrators can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas. When the thread pool is enabled (enable_thread_pool is set to on), all session information is displayed. When the thread pool is disabled (enable_thread_pool is set to off), the sessions connected by users are not displayed. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

**Table 1** GV_SESSION columns
Name	Type	Description
inst_id	numeric	Not supported. The value is NULL.
saddr	raw	Not supported. The value is NULL.
sid	bigint	Session ID.
serial#	integer	Sequence number of the active background thread.
audsid	numeric	Not supported. The value is NULL.
paddr	raw	Not supported. The value is NULL.
schema#	numeric	Not supported. The value is NULL.
schemaname	name	Name of the user logged in to the backend.
user#	oid	OID of the user who has logged in to the backend thread. The OID is 0 if the backend thread is a global auxiliary thread.
username	name	Name of the user logged in to the backend process. username is null if the backend thread is a global auxiliary thread.
command	numeric	Not supported. The value is NULL.
ownerid	numeric	Not supported. The value is NULL.
taddr	character varying(16)	Not supported. The value is NULL.
lockwait	character varying(16)	Not supported. The value is NULL.
machine	text	Host name of the connected client, as reported by a reverse DNS lookup of client_addr. This column will be non-null only for IP connections and only when log_hostname is enabled.
sql_id	bigint	SQL OID.
client_info	text	Client information
event	text	Queuing status of a statement. The value can be: waiting in queue: The statement is in the queue. Empty: The statement is running.
sql_exec_start	timestamp with time zone	Start time of SQL statement execution.
program	text	Name of the application connected to the backend.
status	text	Overall status of this backend. The value can be: active: The backend is executing a query. idle: The backend is waiting for a new client command. idle in transaction: The backend is in a transaction, but there is no statement being executed in the transaction. idle in transaction (aborted): The backend is in a transaction, but there are statements failed in the transaction. fastpath function call: The backend is executing a fast-path function. disabled: This state is reported if track_activities is disabled in this backend.
server	character varying(9)	Not supported. The value is NULL.
pdml_status	character varying(8)	Specifies whether to enable a DML parallel execution in the current session.
port	numeric	Port number of the current session.
process	character varying(24)	Process ID of the current session.
logon_time	timestamp(0) without time zone	Login time of the current session.
last_call_et	integer	Duration when the status of the current session changes last time.
osuser	text	OS username of the server.
terminal	character varying(30)	Not supported. The value is NULL.
type	character varying(10)	Not supported. The value is NULL.
sql_address	raw	Not supported. The value is NULL.
sql_hash_value	numeric	Not supported. The value is NULL.
sql_child_number	numeric	Not supported. The value is NULL.
sql_exec_id	numeric	Not supported. The value is NULL.
prev_sql_addr	raw	Not supported. The value is NULL.
prev_hash_value	numeric	Not supported. The value is NULL.
prev_sql_id	character varying(13)	Not supported. The value is NULL.
prev_child_number	numeric	Not supported. The value is NULL.
prev_exec_start	timestamp(0) without time zone	Not supported. The value is NULL.
prev_exec_id	numeric	Not supported. The value is NULL.
plsql_entry_object_id	numeric	Not supported. The value is NULL.
plsql_entry_subprogram_id	numeric	Not supported. The value is NULL.
plsql_object_id	numeric	Not supported. The value is NULL.
plsql_subprogram_id	numeric	Not supported. The value is NULL.
module	text	Name of the running module, which is set by calling DBE_APPLICATION_INFO.SET_MODULE.
module_hash	numeric	Not supported. The value is NULL.
action	text	Name of the current operation in the current module, which is set by calling DBE_APPLICATION_INFO.SET_MODULE or DBE_APPLICATION_INFO.SET_ACTION.
action_hash	numeric	Not supported. The value is NULL.
fixed_table_sequence	numeric	Not supported. The value is NULL.
row_wait_obj#	numeric	Not supported. The value is NULL.
row_wait_file#	numeric	Not supported. The value is NULL.
row_wait_block#	numeric	Not supported. The value is NULL.
row_wait_row#	numeric	Not supported. The value is NULL.
top_level_call#	numeric	Not supported. The value is NULL.
pdml_enabled	character varying(3)	Not supported. The value is NULL.
failover_type	character varying(13)	Not supported. The value is NULL.
failover_method	character varying(10)	Not supported. The value is NULL.
failed_over	character varying(3)	Not supported. The value is NULL.
resource_consumer_group	character varying(32)	Not supported. The value is NULL.
pddl_status	character varying(8)	Not supported. The value is NULL.
pq_status	character varying(8)	Not supported. The value is NULL.
current_queue_duration	numeric	Not supported. The value is NULL.
client_identifier	character varying(64)	Not supported. The value is NULL.
blocking_session_status	character varying(11)	Not supported. The value is NULL.
blocking_instance	numeric	Not supported. The value is NULL.
blocking_session	numeric	Not supported. The value is NULL.
final_blocking_session_status	character varying(11)	Not supported. The value is NULL.
final_blocking_instance	numeric	Not supported. The value is NULL.
final_blocking_session	numeric	Not supported. The value is NULL.
seq#	numeric	Not supported. The value is NULL.
event#	numeric	Not supported. The value is NULL.
p1text	character varying(64)	Not supported. The value is NULL.
p1	numeric	Not supported. The value is NULL.
p1raw	raw	Not supported. The value is NULL.
p2text	character varying(64)	Not supported. The value is NULL.
p2	numeric	Not supported. The value is NULL.
p2raw	raw	Not supported. The value is NULL.
p3text	character varying(64)	Not supported. The value is NULL.
p3	numeric	Not supported. The value is NULL.
p3raw	raw	Not supported. The value is NULL.
wait_class_id	numeric	Not supported. The value is NULL.
wait_class#	numeric	Not supported. The value is NULL.
wait_class	character varying(64)	Not supported. The value is NULL.
wait_time	numeric	Not supported. The value is NULL.
seconds_in_wait	numeric	Not supported. The value is NULL.
state	character varying(19)	Not supported. The value is NULL.
wait_time_micro	numeric	Not supported. The value is NULL.
time_remaining_micro	numeric	Not supported. The value is NULL.
time_since_last_wait_micro	numeric	Not supported. The value is NULL.
service_name	character varying(64)	Not supported. The value is NULL.
sql_trace	character varying(8)	Not supported. The value is NULL.
sql_trace_waits	character varying(5)	Not supported. The value is NULL.
sql_trace_binds	character varying(5)	Not supported. The value is NULL.
sql_trace_plan_stats	character varying(10)	Not supported. The value is NULL.
session_edition_id	numeric	Not supported. The value is NULL.
creator_addr	raw	Not supported. The value is NULL.
creator_serial#	numeric	Not supported. The value is NULL.
ecid	character varying(64)	Not supported. The value is NULL.
sql_translation_profile_id	numeric	Not supported. The value is NULL.
pga_tunable_mem	numeric	Not supported. The value is NULL.
shard_ddl_status	character varying(8)	Not supported. The value is NULL.
con_id	numeric	Not supported. The value is NULL.
external_name	character varying(1024)	Not supported. The value is NULL.
plsql_debugger_connected	character varying(5)	Not supported. The value is NULL.