Share this page
PPM_USAGE_MONITORING
This table stores the PPM usage monitoring information.
Foreign Keys
This table does not have any foreign keys.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
USERNAME |
NOT NULL |
VARCHAR2(200) |
Username of the log-in user |
|
LOGON_SESSION_ID |
NOT NULL |
NUMBER |
User session identifier |
|
MODULE |
NULLABLE |
VARCHAR2(255) |
The module the user visited |
|
PAGE |
NULLABLE |
VARCHAR2(255) |
The page the user visited |
|
FIRST_TIME |
NOT NULL |
DATE |
Date when the user's first hit happened |
|
LAST_TIME |
NOT NULL |
DATE |
Date when the user's last hit happened |
| COUNT | NOT NULL | NUMBER | The user's hit count |
| CREATION_DATE | NOT NULL | DATE | Date when the record was created |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
PPM_USAGE_MON_IX1 |
UNIQUE |
|
USERNAME |
| PPM_USAGE_MON_IX2 | NONUNIQUE | CREATION_DATE | |
| PPM_USAGE_MON_IX3 | NONUNIQUE | MODULE, PAGE |
