Toad World

Blogs

karen.r.morton
Follow /30 Jul 2014 at 10:00am / Oracle Blog

Understanding Optimizer Statistics and Keeping Them Simple - Part 2

In Part 1 of this series , I provided a brief overview of what statistics are and what they do. In this post, I'll discuss gathering statistics. Gathering statistics often seems hard. Well, to be more precise, it's not so much the gathering...
3014 2 /
karen.r.morton
Follow /28 Jul 2014 at 12:49am / Oracle Blog

Understanding Optimizer Statistics and Keeping Them Simple - Part 1

I've been speaking and writing about optimizer statistics for many years, but it seems like everywhere I go - be it a speaking engagement or a client site - I'm always asked about gathering statistics and how they are used. So, I thought I'd...
1654 1 /
karen.r.morton
Follow /14 Jul 2014 at 12:42am / Oracle Blog

How to Flush a Single SQL Statement from the Shared Pool

I've been working on a few issues this past week that affected a single SQL statement in the production environment. The statement was using bind variables but for certain bind variable values, the plan would change to use a different (sub-optimal...
18118 0 /
karen.r.morton
Follow /26 Jun 2014 at 8:03pm / Oracle Blog

Programming for the Future

I wanted to share something that is a bit off topic, but I think has relevance to the future about those who will follow behind us to do our jobs in the future. This week my company, Accenture Enkitec Group, sponsored a Young Programmer's Camp...
1509 0 /
karen.r.morton
Follow /22 Jun 2014 at 10:20pm / Oracle Blog

Tracing Code with DBMS_MONITOR

In my previous post, I discussed adding instrumentation to your code by registering key tasks with module and action names using DBMS_APPLICATION_INFO. In this post, I want to show you how to use the module/action pairs to start and stop tracing using...
2733 1 /
karen.r.morton
Follow /17 Jun 2014 at 2:59pm / Oracle Blog

Instrumenting Your Code using DBMS_APPLICATION_INFO

Code instrumentation is a necessity if you really want to find and fix Oracle SQL performance issues. Instrumenting your code is simply a way for you to identify portions of your code that are important to you. I'd even go so far as to say that even...
2837 2 /
karen.r.morton
Follow /16 Jun 2014 at 11:25pm / Oracle Blog

Hello World....I mean Toad World!

I just wanted to make an introductory post to introduce myself and get my feet wet here in the Toad World pond! I've been around Oracle for quite a while - 23 years now (wow!). I'm sure I've crossed paths with many of you in some form or...
1449 1 /