When you try to run sqr.exe from a client workstation, you may encounter this error (SQR 28) Cannot access the initialization file xxx\pssqr.ini This error is usually encountered when you try to run SQR on the Client Workstation. To run a SQR from a client workstation, you need to navigate to PS_HOME\bin\sqr\ORA\binw and run sqrw.exe When […]
Continue readingWriting 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 readingEspecially 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 readingI 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 readingFrom 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 reading