PPM_PERFORMANCE_LOG

This table stores log information about PPM Center performance.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PERFORMANCE_LOG_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

LOGGER_TYPE

NOT NULL

VARCHAR2(50)

 

USER_ID

NULLABLE

NUMBER

 

NAME

NOT NULL

VARCHAR2(50)

 

TYPE

NULLABLE

VARCHAR2(50)

 

PAGE_URL

NULLABLE

VARCHAR2(512)

 

EXEC_TIME

NOT NULL

NUMBER

 

SQL

NULLABLE

VARCHAR2(4000)

 

PARAMETERS

NULLABLE

VARCHAR2(4000)

 

EXCEPTION

NULLABLE

VARCHAR2(512)

 

NODE_NAME

NOT NULL

VARCHAR2(512)

 

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_PERFORMANCE_LOG_N1

NONUNIQUE

1

CREATION_DATE

Sequences

This table does not use any sequences.