1. System Tables and Views Reference
  2. System Tables and Views 
  3. SYS.V$SESSION

SYS.V$SESSION

This view contains data for each current connection in TimesTen. There is no corresponding SYS.GV$SESSION system view.

Usage with TimesTen Scaleout

This view is not supported in TimesTen Scaleout.

Usage with TimesTen Classic

This view contains data for the database to which the application is connected.

Related view

None

Columns

There are columns in this view that are not supported. The data returned for these columns may contain meaningless data. The Description field in this table describes the column as an unused column and instructs you to ignore the value.

Column name Type Description

SADDR

BINARY(8)

Column unused by TimesTen. Ignore value.

SID

NUMBER

Connection identifier

SERIAL#

NUMBER

Column unused by TimesTen. Ignore value.

AUDSID

NUMBER

Column unused by TimesTen. Ignore value.

PADDR

BINARY(8)

Column unused by TimesTen. Ignore value.

USER#

NUMBER

User identifier

USERNAME

VARCHAR2(30) INLINE

User name

COMMAND

NUMBER

Column unused by TimesTen. Ignore value.

OWNERID

NUMBER

Column unused by TimesTen. Ignore value.

TADDR

VARCHAR2(16) INLINE

Column unused by TimesTen. Ignore value.

LOCKWAIT

VARCHAR2(16) INLINE

Column unused by TimesTen. Ignore value.

STATUS

VARCHAR2(8) INLINE

Status of the connection:

  • ACTIVE: The connection is currently executing a SQL command.

  • INACTIVE: The connection is not currently executing a SQL command.

SERVER

VARCHAR2(9) INLINE

Column unused by TimesTen. Ignore value.

SCHEMA#

NUMBER

Data returned is the same as the USER# column.

SCHEMANAME

VARCHAR2(30) INLINE

Data returned is the same as the USERNAME column.

OSUSER

VARCHAR2(30) INLINE

Database or client user name on operating system.

PROCESS

VARCHAR2(24) INLINE

Column unused by TimesTen. Ignore value.

MACHINE

VARCHAR2(64) INLINE

Operating system machine name

PORT

NUMBER

Column unused by TimesTen. Ignore value.

TERMINAL

VARCHAR2(30) INLINE

Column unused by TimesTen. Ignore value.

PROGRAM

VARCHAR2(48) INLINE

Operating system program name

TYPE

VARCHAR2(10) INLINE

Column unused by TimesTen. Ignore value.

SQL_ADDRESS

BINARY(8)

Column unused by TimesTen. Ignore value.

SQL_HASH_VALUE

NUMBER

Column unused by TimesTen. Ignore value.

SQL_ID

VARCHAR2(64) INLINE

SQL command identifier of the SQL statement that is currently being executed

SQL_CHILD_NUMBER

NUMBER

Column unused by TimesTen. Ignore value.

SQL_EXEC_START

DATE

Timestamp when the SQL command currently being executed started. The value is NULL if SQL_ID is NULL.

SQL_EXEC_ID

NUMBER

Column unused by TimesTen. Ignore value.

PREV_SQL_ADDR

BINARY(8)

Column unused by TimesTen. Ignore value.

PREV_HASH_VALUE

NUMBER

Column unused by TimesTen. Ignore value.

PREV_SQL_ID

VARCHAR2(64) INLINE

SQL command identifier of the last SQL statement executed

PREV_CHILD_NUMBER

NUMBER

Column unused by TimesTen. Ignore value.

PREV_EXEC_START

DATE

SQL execution start of the last SQL statement executed

PREV_EXEC_ID

NUMBER

Column unused by TimesTen. Ignore value.

PLSQL_ENTRY_OBJECT_ID

NUMBER

Column unused by TimesTen. Ignore value.

PLSQL_ENTRY_SUBPROGRAM_ID

NUMBER

Column unused by TimesTen. Ignore value.

PLSQL_OBJECT_ID

NUMBER

Column unused by TimesTen. Ignore value.

PLSQL_SUBPROGRAM_ID

NUMBER

Column unused by TimesTen. Ignore value.

MODULE

VARCHAR2(64) INLINE

Name of the currently executing module as set through OCI

MODULE_HASH

NUMBER

Column unused by TimesTen. Ignore value.

ACTION

VARCHAR2(64) INLINE

Name of the currently execution action as set by OCI

ACTION_HASH

NUMBER

Column unused by TimesTen. Ignore value.

CLIENT_INFO

VARCHAR2(64) INLINE

Client information as set by OCI

FIXED_TABLE_SEQUENCE

NUMBER

Column unused by TimesTen. Ignore value.

ROW_WAIT_OBJ#

NUMBER

Column unused by TimesTen. Ignore value.

ROW_WAIT_FILE#

NUMBER

Column unused by TimesTen. Ignore value.

ROW_WAIT_BLOCK#

NUMBER

Column unused by TimesTen. Ignore value.

ROW_WAIT_ROW#

NUMBER

Column unused by TimesTen. Ignore value.

TOP_LEVEL_CALL#

NUMBER

Column unused by TimesTen. Ignore value.

LOGON_TIME

DATE

Start time of the connection

LAST_CALL_ET

NUMBER

Column unused by TimesTen. Ignore value.

PDML_ENABLED

VARCHAR2(3) INLINE

Column unused by TimesTen. Ignore value.

FAILOVER_TYPE

VARCHAR2(13) INLINE

Column unused by TimesTen. Ignore value.

FAILOVER_METHOD

VARCHAR2(10) INLINE

Column unused by TimesTen. Ignore value.

FAILED_OVER

VARCHAR2(3) INLINE

Column unused by TimesTen. Ignore value.

RESOURCE_CONSUMER_GROUP

VARCHAR2(32) INLINE

Column unused by TimesTen. Ignore value.

PDML_STATUS

VARCHAR2(8) INLINE

Column unused by TimesTen. Ignore value.

PDDL_STATUS

VARCHAR2(8) INLINE

Column unused by TimesTen. Ignore value.

PQ_STATUS

VARCHAR2(8) INLINE

Column unused by TimesTen. Ignore value.

CURRENT_QUEUE_DURATION

NUMBER

Column unused by TimesTen. Ignore value.

CLIENT_IDENTIFIER

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

BLOCKING_SESSION_STATUS

VARCHAR2(11) INLINE

Column unused by TimesTen. Ignore value.

BLOCKING_INSTANCE

NUMBER

Column unused by TimesTen. Ignore value.

BLOCKING_SESSION

NUMBER

Column unused by TimesTen. Ignore value.

FINAL_BLOCKING_SESSION_STATUS

VARCHAR2(11) INLINE

Column unused by TimesTen. Ignore value.

FINAL_BLOCKING_INSTANCE

NUMBER

Column unused by TimesTen. Ignore value.

FINAL_BLOCKING_SESSION

NUMBER

Column unused by TimesTen. Ignore value.

SEQ#

NUMBER

Column unused by TimesTen. Ignore value.

EVENT#

NUMBER

Column unused by TimesTen. Ignore value.

EVENT

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

P1TEXT

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

P1

NUMBER

Column unused by TimesTen. Ignore value.

P1RAW

BINARY(8)

Column unused by TimesTen. Ignore value.

P2TEXT

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

P2

NUMBER

Column unused by TimesTen. Ignore value.

P2RAW

BINARY(8)

Column unused by TimesTen. Ignore value.

P3TEXT

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

P3

NUMBER

Column unused by TimesTen. Ignore value.

P3RAW

BINARY(8)

Column unused by TimesTen. Ignore value.

WAIT_CLASS_ID

NUMBER

Column unused by TimesTen. Ignore value.

WAIT_CLASS#

NUMBER

Column unused by TimesTen. Ignore value.

WAIT_CLASS

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

WAIT_TIME

NUMBER

Column unused by TimesTen. Ignore value.

SECONDS_IN_WAIT

NUMBER

Column unused by TimesTen. Ignore value.

STATE

VARCHAR2(19) INLINE

Column unused by TimesTen. Ignore value.

WAIT_TIME_MICRO

NUMBER

Column unused by TimesTen. Ignore value.

TIME_REMAINING_MICRO

NUMBER

Column unused by TimesTen. Ignore value.

TIME_SINCE_LAST_WAIT_MICRO

NUMBER

Column unused by TimesTen. Ignore value.

SERVICE_NAME

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

SQL_TRACE

VARCHAR2(8) INLINE

Column unused by TimesTen. Ignore value.

SQL_TRACE_WAITS

VARCHAR2(5) INLINE

Column unused by TimesTen. Ignore value.

SQL_TRACE_BINDS

VARCHAR2(5) INLINE

Column unused by TimesTen. Ignore value.

SQL_TRACE_PLAN_STATS

VARCHAR2(10) INLINE

Column unused by TimesTen. Ignore value.

SESSION_EDITION_ID

NUMBER

Column unused by TimesTen. Ignore value.

CREATOR_ADDR

BINARY(8)

Column unused by TimesTen. Ignore value.

CREATOR_SERIAL#

NUMBER

Column unused by TimesTen. Ignore value.

ECID

VARCHAR2(64) INLINE

Column unused by TimesTen. Ignore value.

SQL_TRANSLATION_PROFILE_ID

NUMBER

Column unused by TimesTen. Ignore value.

PGA_TUNABLE_MEM

NUMBER

Column unused by TimesTen. Ignore value.

SHARD_DDL_STATUS

VARCHAR2(8) INLINE

Column unused by TimesTen. Ignore value.

CON_ID

NUMBER

Column unused by TimesTen. Ignore value.

EXTERNAL_NAME

VARCHAR2(1024) NOT INLINE

Column unused by TimesTen. Ignore value.

PLSQL_DEBUGGER_CONNECTED

VARCHAR2(5) INLINE

Column unused by TimesTen. Ignore value.

ELEMENTID

TT_INTEGER NOT NULL

Element id for the element to which the application is connected. Ignore this column for TimesTen Classic.