How to Identify User and SQLs in an Oracle database?
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 – […]
Continue readingAutomated 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 readingPerformance 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 readingPeopleSoft 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 readingHow 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 reading