<< XPLAIN style tables | SYSXPLAIN_STATEMENT_TIMINGS system table >>

XPLAIN_THREAD_ID

<< XPLAIN style tables | SYSXPLAIN_STATEMENT_TIMINGS system table >>

Derby Reference Manual

241

Column Name

Type

Length

Nullable

Contents

for UPDATE, 'D'
for DELETE, 'C' for
CALL, 'DDL' for Data
Definition (such as
CREATE TABLE),
'SA' for SELECT
(Approximate), or blank,
indicating the statement
was a comment.

STMT_TEXT

VARCHAR

32,672

false

The text of the
statement.

JVM_ID

VARCHAR

32,672

false

A code indicating
what version of the
JVM was running
when this statement
was captured: '4' for
J2SE_14 (JDK 1.4.0 or
1.4.1), '5' for J2SE_142
(JDK 1.4.2), '6' for
J2SE_15 (JDK 1.5), or
'7' for J2SE_16 (JDK
1.6).

OS_IDENTIFIER

VARCHAR

32,672

false

Contains information
about the operating
system which was
being used when
this statement was
captured.

XPLAIN_MODE

CHAR

true

A code indicating
the XPLAIN mode
which was in use when
this statement was
captured: 'F' for FULL,
or 'O' for ONLY.

XPLAIN_TIME

TIMESTAMP 29

true

Contains the date
and time when
this statement was
captured.

XPLAIN_THREAD_ID

VARCHAR

32,672

false

The JVM thread which
was running when this
statement was captured

TRANSACTION_ID

VARCHAR

32,672

false

An internal identifier
for the transaction
which was active when
this statement was
captured.

SESSION_ID

VARCHAR

32,672

false

An internal identifier
for the session which
was active when