Discussion

pr4_log_usage

Can some body tell me what is the exact use of pr4_log_usage table
In our application this tabe is having of millions of records.
DBA is insisting to truncate the table.

Please tell me what will be the impact on prpc.

we are using PRPC V5.1 SP1..

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

August 19, 2009 - 12:08pm

pr4-log-usage table hold the user - System Usage History report .

refer this article for more details

http://pdn.pega.com/DevNet/PRPCv5/KB/21692.asp

July 13, 2016 - 9:32am

Log usage provides high level summary of all requestor sessions across nodes. Accessed by...

  • SMA
  • OOTB Reports
  • Custom Reports on Log-Usage concrete class
  • DB SQL on data_schema.pr_perf_statistics database table

The following facilitates reporting on data_schema.pr_perf_statistics

  • All columns are exposed.
  • There is no PZPVSTREAM column.

REFERENCE

  • Pega Academy > System Administration Specialist (7.1) > Performance Testing > Monitoring and Diagnosing Systems
  • Designer Studio > Developer Help > Contents > Performance > How to analyze system-wide usage with the Log-Usage class