CST_SQL_TIMINGS

This table stores SQL performance data from background processing runs.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_SQL_TIMINGS_PK

SQL_TIMING_ID

Columns

Name Datatype Length Precision Not-null Comments
SQL_TIMING_ID NUMBER 18 Yes Indicates the surrogate key of the table record.
APPLICATION_SHORT_NAME VARCHAR2 64 Indicates the short name of the application.
CLASS_NAME VARCHAR2 900 Indicates the class name of the Java program.
SQL_NAME VARCHAR2 100 Indicates the name given to the SQL statement by the Java program.
SQL_TIME NUMBER 18 Indicates the execution time in milliseconds.
SQL_ROWS NUMBER 18 Indicates the number of rows processed when greater than 0. A -1 indicates a query, commit, rollback, or dbms statement. A -3 indicates an error.
SQL_ID VARCHAR2 13 Indicates the SQL identifier of the SQL statement.
SQL_STATEMENT VARCHAR2 4000 Indicates the SQL statement that was executed.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
PARENT_REQUEST_ID NUMBER 18 This is the request ID of the parent job if the current job is a child job.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_SQL_TIMINGS cst_cp_requests REQUEST_ID

Indexes

Index Uniqueness Tablespace Columns
CST_SQL_TIMINGS_N1 Non Unique FUSION_TS_TX_DATA JOB_DEFINITION_NAME, "REQUEST_ID"
CST_SQL_TIMINGS_N2 Non Unique FUSION_TS_TX_DATA REQUEST_ID, "SQL_TIME"
CST_SQL_TIMINGS_N3 Non Unique CST_SQL_TIMINGS_N3 PARENT_REQUEST_ID
CST_SQL_TIMINGS_U1 Unique FUSION_TS_TX_DATA SQL_TIMING_ID