Oracle Blog

Primavera Inside Out

Tuesday Sep 17, 2013

This is the first in a series of posts about Oracle Optimizer Statistics and the P6 application. Over the past six months, I've done a lot of rethinking about the best process for maintaining optimizer statistics given the type of data in the PM database and the variety of queries coming from the application. I need to emphasize that this by no means constitutes general guidance with regard to Oracle Optimizer Statistics for any other applications. These recommendations are only applicable to the Primavera products and, in this case, only to P6 8.x. My hope is for a more nuanced approach to optimizer statistics to better achieve performance, scalability and stability goals.[Read More]

Friday Sep 13, 2013

Auditing in P6 is primarily an opt-in only function--you need to turn it on first. But one type of auditing is on-by-default: Session Auditing. Rows in the usession table are deleted by the application when the user logs off. The Usession Audit trigger captures an image of the usession table row during delete. The resulting rows in the usessaud table provide valuable perspective into application usage.[Read More]