top of page

Advances in SQL Tuning Techniques at HOTSOS

Writer: kyle Hailey
kyle Hailey
Nov 30, 2009
1 min read

Late breaking news – I’ll be speaking at the 2010 HOTSOS conference!


Advances in SQL Tuning Techniques

In the past few years some novel SQL tuning techniques have appeared such Oracle 10g’s SQL profiles, 11g’s SQL baselines , extended execution statistics, Tuning by Cardinality Feedback, Visual SQL Tuning, Oracle 11g’s real time SQL monitoring and plan stability. Find out what about these methods and how to best harness them easily and effectively on your system.

Learning objectives:

1) How to identify queries that are potentially suboptimal

2) How to analyze the query

3) What steps to take to come up with an optimal and stable plan

HOTOS is my favorite Oracle conference both for the high caliber of the speakers as well as the participants. Here is the impressive speaker list for 2010:

I’ll also be teaching a 2 day Oracle performance and tuning seminar on the following dates and locations:

Melbourne Feb 22-23

Sydney Feb 25-26

Singapore Mar 1-2

Hong Kong Mar 4-5

3 Comments


Guest
7 days ago

 Online government facilities are becoming increasingly important throughout India. Resources covering Sarkari Portals can help citizens understand where to look for public services and discover websites relevant to their everyday administrative needs.

Like

Guest
Oct 30

This Bhulekh UP guide is informative and accessible. The explanation is straightforward, making the topic easier to understand. I appreciate resources that help readers learn about digital land records through clear and useful information.

Like

Guest
Oct 30

The Aadhaar Card Status guide is easy to understand and informative. I like the straightforward language because it makes the topic approachable. Readers interested in Aadhaar services may find this resource helpful for understanding general status-related information.

Like

Kyle Hailey

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

San Franisco, Ca 94131

415-341-3430  (please text initially before calling)

bottom of page