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 (more...)
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 (more...)
Choosing a block size for the P6 PMDB database is not a difficult task. In fact, taking the default of 8k is going to be just fine. Block size is one of those things that is always hotly debated. Everyone has their personal preference and can sight plenty of good (more...)
The Oracle RDBMS has an excellent repository of performance data that is collected automatically. It's called Automatic Workload Repository, or AWR for short. The AWR is a snapshot-based collector of database information. This includes not only the information from V$SYSSTAT, but also snapshots of other configuration information like database parameter (more...)
Attending conferences like Collaborate 13 gets me thinking deeply about the process and technologies we use in the P6 suite. If in can think of a single Oracle technology with the most bang-for-the-buck, it would be hands down Database Partitioning.
Partitioning is part of Oracle RDBMS Enterprise Edition. You might (more...)
This is my first post and it is coming, appropriately, from Collaborate 13 in Denver. Conferences always spawn new ideas for me and the idea for this blog came after OpenWorld 2012. I'm here to present a “Quick Start” guide to Reporting and Analytics. No easy task. These are truly (more...)