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.