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 readingIt 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 readingOracle 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. […]
Continue readingPerformance 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 […]
Continue readingYou 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: […]
Continue readingThis 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 – […]
Continue readingOracle 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 readingTo a user, an application is never fast enough to satisfy his/her needs. Similarly, to a database administrator, an application is never fast enough to satisfy the needs of the user community. Perception and unreasonable expectations are definitely a cause. However, , insufficient hardware, poorly tuned application code, a poorly tuned database, or an architecture that doesn’t […]
Continue readingPeopleSoft Admins or PeopleSoft DBAs or Oracle DBAs know the importance of finding, analyzing, and correcting resource-intensive SQL statements. Those shops which run PeopleSoft on Oracle can make use of Oracle Enterprise Manager (OEM) in isolating and analyzing troublesome SQL statements. Using OEM, a DBA can quickly discover the SQL statements most responsible for performance degradation and then drill […]
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 readingWhile running a PeopleSoft appengine program, especially in case of Payroll Interface appengine program, PI_PIRUN, you are likely to encounter a situation where the app engine program fails with an error, which is similar to “…..did not complete in allowed time (50 seconds). Killing process (2, -1)” If the process is submitted to the process […]
Continue reading