Apurva Tripathi
Author Archives: Apurva Tripathi
Apurva Tripathi
Function Based Indexes in PeopleSoft
Those who have not comes across performance issues in PeopleSoft, especially PeopleSoft on Oracle might not be aware of this thing called performance issues due to function based indexes. PeopleSoft has given a lot of headache to Oracle database engineers as well as customers when it comes to function based indexes. By definition, a function-based […]
Continue reading
4
Which is the Best Browser to run PeopleSoft on?
It has been quite a few years that I completely switched over to Firefox and Chrome. I don’t not even remember how the IE performs. Though I’ve read that IE has improved a lot over the years, I was happy sticking to Firefox and Chrome. I was working with a user on performance issues when […]
Continue reading
2
Understanding PeopleSoft Trace File for Performance Tuning
Making sense of a PeopleSoft trace file is absolutely essential for resolution of performance issue(s). You may face an issue where users are complaining of slow performance and OEM is not capturing the SQL – you have two options: Find the SQL using PeopleSoft trace or enable a database trace. You should first try to […]
Continue reading
3
PeopleSoft Trace Analyzer – TraceMagic
PeopleSoft trace files contain tons of information and depending on the kind of information you need from a trace file – it can turn out to be a daunting task. Wouldn’t it be nice if there was a tool to analyze the PeopleSoft trace files? If you are ready to make sense of *.tracesql files […]
Continue readingSQL Monitoring in OEM 12c
SQL Monitoring was instrumented and available for command line use in the first release of the Oracle Database 11g. The graphical user interface to monitor active running SQL made its debut in Grid Control 10.2.0.5 and Database Control 11.1.0.7. Basically, the data from the GV$ views, is aggregated and presented in a user-friendly interactive fashion […]
Continue reading