Performance Tuning | PeopleSoft Tutorial - Part 2

Tag Archive

Tag Archives for " Performance Tuning "

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

Performance Tuning by Identifying Poor SQLs using v$

To 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 reading

PeopleSoft Performance Tuning Using OEM

PeopleSoft 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 reading