Over the years I have dealt with performance problems with nVision reporting on General Ledger on various Financials systems in various kinds of businesses. Different businesses use nVision very differently, and have different challenges, but I have produced an approach that mostly works well at most customers. I have collected that advice in to a document that I have recently published on my website (http://www.go-faster.co.uk/docs.htm#nVision Tuning.Generic.pdf).
There are some performance improvements that require physical storage options to be set on tables or indexes. One particular technique that I will take as an example for this article is index compression. A good example in PeopleSoft is the tree node table, PSTREENODE. It drives many security and hierarchical queries. It is not updated very frequently, only as new trees are brought on. Many of the indexes are good candidates for compression. Oracle can calculate the optimal prefix length using
Sometimes you'll need to known when an environment was last refreshed and may not have the details of this. One way to approximate this using the PeopleTools tables is to look at the process request table.
Specifically you can use a query like this to check the first process that was run:
Occurs when a user attempts to run a process through the process scheduler:
Process Profile defined for user ID %2 is invalid (65,111) The process profile assigned to the user ID is either not valid or blank. Update the User Profile for the user ID in the Maintain Security component with a valid process profile.
PeopleTools > Security > User Profiles Enter user's ID
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
PeopleSoft Tipster Blog
So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.
Next up in our ‘How I Work‘ series is Dan Iverson. Dan – together with partner-in-crime Kyle – runs the PSAdmin.io blog. If you’re a PeopleSoft administrator and connected to the Internet then there’s no doubt that you’ll have heard of their blog as they’re really prolific and have posted some great content.