Skip to content

DBA Data[Home] [Help] [Dependency Information]

TABLE: JTF.JTF_PF_SESSION_SUMM

Object Details
Object Name: JTF_PF_SESSION_SUMM
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_PF_SESSION_SUMM
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JTF_PF_SESSION_SUMM_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSESSIONID
JTF_PF_SESSION_SUMM_N1 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDAY
JTF_PF_SESSION_SUMM_N2 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSERID
JTF_PF_SESSION_SUMM_N3 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_NAME
Columns
Name Datatype Length Mandatory Comments
DAY DATE
Yes
SEQID NUMBER
Yes
SESSIONID NUMBER

USER_NAME VARCHAR2 (100)
USERID NUMBER

SUM_EXECT_JTF NUMBER

SUM_THINKT_JTF NUMBER

CNT_PAGES_JTF NUMBER

SUM_EXECT_OAF NUMBER

SUM_THINKT_OAF NUMBER

CNT_PAGES_OAF NUMBER

SUM_EXECT_FORM NUMBER

SUM_THINKT_FORM NUMBER

CNT_PAGES_FORM NUMBER

CNT_PAGES_ALL NUMBER

UCNT_PAGES NUMBER

UCNT_FLOWS NUMBER

UCNT_USERS NUMBER

UCNT_APPS NUMBER

UCNT_RESPS NUMBER

UCNT_LANGS NUMBER

STARTT NUMBER
Yes
ENDT NUMBER
Yes
CNT_FAIL NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DAY
,      SEQID
,      SESSIONID
,      USER_NAME
,      USERID
,      SUM_EXECT_JTF
,      SUM_THINKT_JTF
,      CNT_PAGES_JTF
,      SUM_EXECT_OAF
,      SUM_THINKT_OAF
,      CNT_PAGES_OAF
,      SUM_EXECT_FORM
,      SUM_THINKT_FORM
,      CNT_PAGES_FORM
,      CNT_PAGES_ALL
,      UCNT_PAGES
,      UCNT_FLOWS
,      UCNT_USERS
,      UCNT_APPS
,      UCNT_RESPS
,      UCNT_LANGS
,      STARTT
,      ENDT
,      CNT_FAIL
FROM JTF.JTF_PF_SESSION_SUMM;

Dependencies

[top of page]

JTF.JTF_PF_SESSION_SUMM does not reference any database object

JTF.JTF_PF_SESSION_SUMM is referenced by following:

SchemaJTF
ViewJTF_PF_SESSION_SUMM#