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 MAY 09, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.0 and later
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:

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