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!

Join Us for an Advisor Webcast

On September 15, 2014, in Exadata Tuning, by lesley

On September 16th at 11am EST, join us for an ADVISOR WEBCAST: Exadata Smart Scan Deep Dive . This 1 hr session will include in-depth topics. Click to find out what’s covered and how to sign up.

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.

Buy My Book!

Archives

All entries, chronologically...

Visit our friends!

A few highly recommended friends...