Function Based Indexes in PeopleSoft

by Apurva Tripathi May 28, 2013

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 […]

Read the full article →

Which is the Best Browser to run PeopleSoft on?

by Apurva Tripathi May 24, 2013

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 […]

Read the full article →

Understanding PeopleSoft Trace File for Performance Tuning

by Apurva Tripathi May 22, 2013

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 […]

Read the full article →

How To Check if PeopleTools Patch Is Correctly Applied

by Prashant May 21, 2013

Lets say you just finished applying PepleTools 8.53.03 patch and now when you’re trying to run the application, you’re getting errors. You may be getting errors while booting Application Server, while configuring Web Server, even while accessing PeopleTools Application Designer or some other random error. All these components were working fine before you installed PeopleTools […]

Read the full article →

PeopleTools 8.53: Installing PeopleTools 8.53.03 Patch

by Prashant May 20, 2013

Many visitors have requested to provide steps for applying PeopleTools patch. I hope you have been following our other posts on installing HCM 9.2 on Windows 7 and installing PeopleSoft 9.2 Image on Oracle Virtual Box. PeopleSoft 9.2 Image comes pre-configured with PeopleTools 8.53.02 whereas the PeopleTools 8.53 CDs that are available on don’t […]

Read the full article →

PeopleSoft Trace Analyzer – TraceMagic

by Apurva Tripathi May 20, 2013

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 […]

Read the full article →

SQL Monitoring in OEM 12c

by Apurva Tripathi May 19, 2013

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 and Database Control Basically, the data from the GV$ views, is aggregated and presented in a user-friendly interactive fashion […]

Read the full article →

8 Most In-Demand Tech Skills for 2013-2014

by Apurva Tripathi May 17, 2013

Technology has been moving at such a breakneck pace that if you’ve not started learning the newer technologies, you might be preparing yourself to face the worst – loose your job! Not long ago, some of these skills were considered hot and are no longer a guarantee for success. The time is now – learn […]

Read the full article →

How To Administer PeopleSoft 9.2 Application on Virtual Box

by Prashant May 16, 2013

When you deploy any PeopleSoft 9.2 Image on Virtual Box, it installs all the required components like Database, App server, Web server and Process Scheduler. Depending on your choice at the time of installation, SES can be configured too. When you boot this virtual machine, it will start all the above mentioned components automatically and […]

Read the full article →

SQL Profiles in Oracle

by Apurva Tripathi May 16, 2013

Oracle Databases have an interesting concept called SQL profiles. A SQL profile is a set of information for the optimizer, which is specific to a SQL statement. Conceptually, a SQL profile is to a SQL statement what statistics are to a table or an index. The database can use this information to improve execution plans. […]

Read the full article →

PeopleSoft Performance Benchmarks

by Apurva Tripathi May 15, 2013

Performance is one aspect, which can never satisfy a person on. It is just not enough to keep improving the performance. Oracle understands this and regularly releases Benchmark papers on the same. Advantage of using these benchmarks is that the benchmarks show a level of acceptable performance and you can tune your application to meet […]

Read the full article →

How to Find Oracle Hidden Parameters

by Apurva Tripathi May 11, 2013

Oracle has hundreds of initialization parameters, which are hidden and undocumented. Many savvy Oracle professionals are known to commonly adjust the hidden parameters to improve the overall performance of their systems. However, because these are “undocumented” parameters, most Oracle professionals rely on publications such as “Oracle Internals” to get insights into the proper setting for the […]

Read the full article →

PT8.53: How To Install Application Designer from PeopleSoft Virtual Appliance

by Prashant May 10, 2013

After finishing installation of PT8.53 application using Oracle Virtual Box, next thing you would definitely want to do is to configure Application Designer. PeopleSoft Image that you installed also comes with setup files to help you install App Designer very easily. Before you start with installation and configuration of PeopleSoft Application Designer, make sure that […]

Read the full article →

PeopleTools 8.53 : How To Install Oracle Client from PeopleSoft Image

by Prashant May 9, 2013

PeopleSoft Images are a great way to get started with PeopleSoft within couple of hours. PeopleSoft application installed in Oracle Virtual Box VM, may be accessed from the Windows Client machine where developers/DBA might want to use Oracle Client, App Designer, Data Mover for variety of purposes. For PeopleTools Clients like App Designer, Datamover to […]

Read the full article →

Enabling Automated SQL Tuning in Oracle 11g

by Apurva Tripathi May 9, 2013

You need to identify if Automatic SQL Tuning job is enabled and regularly running. Use the following query to determine if any Automatic SQL Tuning jobs are enabled: SELECT client_name, status, consumer_group, window_group FROM dba_autotask_client ORDER BY client_name; If the Automatic SQL Tuning job is enabled, you will see something like this:       […]

Read the full article →

How to Identify User and SQLs in an Oracle database?

by Apurva Tripathi May 8, 2013

This is a very common scenario for a DBA to be in a situation where a DBA needs to find out one of the following: Which user is running which SQL? A particular SQL is being run by which user? A particular user is running which SQL? As it is evident from these questions – […]

Read the full article →

Automated SQL Tuning in Oracle 11g

by Apurva Tripathi May 7, 2013

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 […]

Read the full article →

PeopleTools 8.53 – PeopleSoft Homes

by Apurva Tripathi May 6, 2013

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 […]

Read the full article →