My Oracle Support Banner

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

Last updated on JANUARY 22, 2024

Applies to:

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


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


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
 For SQL Server:
 For Oracle:

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