CIO (Chief Information officer) is the stakeholder that controls a major budget in an enterprise in the form of IT (Information technology) – traditionally CIO and his protégés in the form of infrastructure heads, datacenter manager etc. has been a key customer for a lot of service providers, as they are the one’s buying infrastructure [...]
The next profile in our ‘How I Work‘ series is Sasank Vemana. Sasank burst onto the PeopleSoft blogging scene in 2014 with his Sasank’s PeopleSoft Log site, and has been adding entries at a ferocious pace since. He is probably best known for his series of posts on altering the PeopleSoft branding to make it match a corporate palette, as well as configuration and code changes related to UI/UX.
Hexaware Shrink IT, Grow Digital has a fundamental impact on how in future enterprises will consume hybrid cloud services. The initiative is primarily based on the fact that cost of managing datacenters and cloud services should fundamentally fund organizations to focus on digital initiatives, At Hexaware, we strongly feel that in today’s enterprise the CIO’s [...]
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: