Apurva Tripathi
Author Archives: Apurva Tripathi
Apurva Tripathi
Automated SQL Tuning in Oracle 11g
Oracle Database 11g made it easier for the less experienced to have a shot at SQL tuning, which was earlier considered to be a bastion for veteran SQL tuners. A typical Oracle SQL tuning process had the following steps: Identification of high-resource SQL statements and bottlenecks Generating and interpreting execution plans Extracting data from the […]
Continue reading
1
PeopleTools 8.53 – PeopleSoft Homes
PeopleSoft Home refers to a file system location in which artifacts associated with a PeopleTools runtime environment are located. The various PeopleSoft Homes are intended to serve specific purposes. Until PeopleTools 8.50, all file system content related to a PeopleSoft environment was consolidated within the same directory tree, which was referred to as PeopleSoft Home […]
Continue reading
1
What is Oracle VirtualBox?
Oracle has been on such a buying and renaming spree that it is difficult to identify the products, especially for those who had worked on one of the products before Oracle bought it. We’ll try to provide you with brief history of Oracle products, so that it help you sink in all the information. Also, […]
Continue reading
1
PeopleTools 8.53 – Secure Enterprise Search, SES and Search Framework
Prior to PeopleTools 8.53, search functionality worked by building search engine indexes using custom PeopleCode and Application Engine programs. Each PeopleSoft application used a unique method for creating and maintaining search artifacts like collections and indexes–all of which required search engine-specific calls, commands, syntax, and so on. The PeopleSoft Search Framework consists of PeopleSoft components (pages […]
Continue readingPeopleSoft Development Tools
As a PeopleSoft developer, you will havce a variety of tools available to develop and customize a PeopleSoft application. The tools you end up using will depend on the application installed at the place you’re working. Let’s have a look at the PeopleSoft development tools to gain some familiarity. PeopleSoft Development Tools Application Designer Application Designer is the […]
Continue reading