Apurva Tripathi
Author Archives: Apurva Tripathi
Apurva Tripathi
How to Write an Efficient SQL
Writing a good SQL helps your organization in several ways. It has a manifold effect, which many developers do not realize either because they do not care or they do not know. This about the time you can save by writing a good SQL. No need of DBAs to be involved, you can avoid urgent […]
Continue readingHow to Find Expected Time of Completion of an Oracle Query
Especially in case of poorly performing SQLs, all eyes are on the SQL and we’re eager to see when the SQL would complete. Upon completion, we can view the statistics and find ways to improve it. Wouldn’t it be better if there was a way to find the expected time of completion of an Oracle […]
Continue readingHow to Change SQL Plus Settings
I do not like the default size of the SQL *Plus window and prefer to customize it as per my preference. You can also do the same by changing the default parameters of SQL Plus. You can perform the following changing in SQL *Plus: Change cursor size Change command history Change fonts Change layout Change […]
Continue readingPeopleTools 8.53 – Understanding Installation Locations
From PeopleTools 8.5 onwards, the installation locations have been split up to make it easier to perform upgrades and provide maintenance. PeopleTools 8.53 has 5 Installation Locations, which are as mentioned below: PS_HOME PS_APP_HOME PS_CFG_HOME PS_CUST_HOME PIA_HOME As you proceed through the PeopleSoft PeopleTools installation process, you are asked to specify several installation locations. This […]
Continue readingPeopleTools 8.53 – What is a PeopleSoft File Server, Database Server, Application Server, Batch Server and Web Server
A typical PeopleSoft installation consists of several logical components, which are known as PeopleSoft Client, PeopleSoft File Server, PeopleSoft Database Server, PeopleSoft Application Server, PeopleSoft Batch Server and PeopleSoft Web Server. Lets have a look and what all these stand for and how do they differentiate from each other. What is PeopleSoft Client PeopleSoft Client […]
Continue reading