My Oracle Support Banner

How to Increase the Session Auditing Data Stored in the USESSAUD Table Longer Than the Default of Five (5) Days (Doc ID 911702.1)

Last updated on APRIL 27, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
Primavera P6 Professional Project Management - Version 17.12.3.0 to 17.12.3.0 [Release 17.12]
All Platforms

Goal

This document will provide instruction for increasing the session auditing data stored in the USESSAUD table longer than the default of five days.

For execution of any script below, the following is recommended:
For Oracle:
Log into the instance using SQLPlus or equivalent with the privileged user for the schema (for example: privuser)

For SQL Server 2005 or SQL Express:
Launch SQL Server Management Studio and login with SQL Authentication as PRIVUSER

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 For SQL Server:
 For Oracle:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.