This content has been marked as final. Show 5 replies
Check this out:
The BGPLOG table holds detailed entries from the background processes. This table contains the following columns:
Log_time - Time when log entry was made by background process [Date and Time]
Source - Program generating log entry [system_monitor and data_monitor]
Type - Type of message [information, elapsed time, and error]
Description - Message from the background process
The USESSION TABLE holds entries for the different users logged in P6. The table contains columns for username, user id, login time, etc.
One other point I forgot to mention. You can open and view the tables in the database to see the columns and what kind of data they contain.
You should always refer to Oracle Documentation first. It contains PMDB schema details including details of each tables.
The admin guide contains details related to maintenance of the Primavera database, background jobs and the jobs that you can schedule to clean up the tables you mentioned. In case you do not have the link, it is
You can also refer to http://support.oracle.com if you have a valid SI number. It contains few good notes on how to clean up these tables.