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