Tuning Oracle SQL – Just Another Blog?

On March 23, 2013, in Oracle SQL Tuning, by Stelios Charalambides

Find out why you should read and subscribe to this blog rather than the hundreds of others on Oracle SQL Tuning. Got a tuning problem you can’t solve? Send in your SQLT report!

Top Frequency Histograms

On January 21, 2014, in Oracle SQL Tuning, by Stelios Charalambides

The maximum number of bins in an Oracle frequency histogram is 254 and as we all know there are almost always more than 254 bins for frequency distributions. Oracle 12c has introduced a new concept, to help deal with the problem, the Top Frequency Histogram.

Three Great Things You Didn’t Know About SQLT

On June 29, 2013, in Oracle SQL Tuning, by Stelios Charalambides

SQLT is an amazing tool with a host of user friendly features. This post covers three I’ve found particularly useful; how to use SQLT on a test database where it isn’t installed, how to get rid of histograms and how, when your system is large, you can get the information you need, faster.

Oracle Database Statistics Gathering

On May 26, 2013, in Oracle SQL Tuning, by Stelios Charalambides

What do you know about Oracle Database statistics gathering? What would you like to know? There is a section in the Database Performance Tuning Guide, but how many people take the time to read it? And, once you know what the various procedures are and what they do, how do you decide which ones to use and when? I’ve seen a lot of tuning problems that are statistics related, and I’d like to explore the area more thoroughly, so I’m asking for your help.

Severity One Killer

On May 6, 2013, in Oracle SQL Tuning, by Stelios Charalambides

When there’s a major change in the performance of your database the culprit can usually be found by looking at any changes made around the time that performance degraded, but what if nothing has changed? What do you do then? There are lots of options, but only one that will turn you into a hero!

SQLT Installation: The First Step

On April 20, 2013, in Oracle SQL Tuning, by Stelios Charalambides

Ready to get started with Oracle SQL Tuning? Here’s how to install SQLT, the most useful tool in the tuning toolbox.

10035 trace NOT 10053 trace

On April 13, 2013, in Oracle SQL Tuning, by Stelios Charalambides

How to find where you parse errors are on large systems, If you’re asked for a 10035 trace file, it probably isn’t a mistake.

Buy My Book!

Archives

All entries, chronologically...

Visit our friends!

A few highly recommended friends...