Toad World

Blogs

karen.r.morton
Follow /24 Oct 2014 at 7:54pm / Oracle Blog

What's it look like when you mess up?

This was the Top Activity page from Enterprise Manager today after I inadvertently did something in production that I thought I was doing in test. Yikes! As you can see, activity spiked for almost an hour. So, what did I do? I wanted to try a different...
831 0 /
karen.r.morton
Follow /30 Sep 2014 at 2:40pm / Oracle Blog

Nulls and execution plan operation options

A while back, I was asked to take a look at a situation where a COUNT(*) query was using full table scan instead of an Index Fast Full Scan. The scan of the index would've been faster and used less resources but even with a hint, the full scan was...
744 0 /
karen.r.morton
Follow /29 Sep 2014 at 4:49pm / Oracle Blog

Endorsements on LinkedIn (a bit off topic)

I joined LinkedIn a long time ago as it was all the rage and lots of colleagues were sending me connection requests. I've tried to keep my profile fairly up to date. I've even had a couple of folks reach out to me via LinkedIn. But even in those...
712 0 /
karen.r.morton
Follow /23 Sep 2014 at 8:27pm / Oracle Blog

Trigger nightmares

Some people think triggers are the best thing ever while others think triggers are the ultimate evil. I've never been a fan of triggers and could yammer on about why but there are lots of great articles already readily available that outline why triggers...
864 0 /
karen.r.morton
Follow /10 Sep 2014 at 4:13pm / Oracle Blog

Bug update - patch available

I wanted to provide an update to the bug that I discussed in my post from August 13 . Oracle determined that the bug was one of a series of related bugs and our use case was just a particular slant on the main root cause. You can take a look at Bug 16191689...
807 0 /
karen.r.morton
Follow /29 Aug 2014 at 4:25pm / Oracle Blog

Understanding Optimizer Statistics and Keeping Them Simple - Part 5

Last time, in Part 4 , I reviewed setting statistics collection parameters and the use of dbms_stats.set_*_prefs . In today's post, I will review the individual collection parameters and their values in more detail. Collection Parameters In order...
1417 0 /
karen.r.morton
Follow /19 Aug 2014 at 8:39pm / Oracle Blog

Understanding Optimizer Statistics and Keeping Them Simple - Part 4

Last time, in Part 3 , I reviewed collecting statistics on data dictionary and fixed objects. In today's post, I want to continue our discussion on gathering stats from Part 2 and review setting collection parameters in more detail. Setting Parameter...
2906 0 /
karen.r.morton
Follow /13 Aug 2014 at 8:37pm / Oracle Blog

New Oracle Bug Alert!

While regression testing for an Oracle 11.2.0.1 to 11.2.0.4 upgrade at my current client, a bug was found that I thought would be worth sharing. You can download and then import a test data set if you'd like to recreate the bug behavior yourself....
5323 1 /
karen.r.morton
Follow /6 Aug 2014 at 6:29am / Oracle Blog

Performance reviews and some good advice

I've been very fortunate to work with a great performance engineering team at my current customer site. Like most companies, each person on the team is evaluated annually and has a set of objectives they work towards throughout the year. The team...
899 0 /
karen.r.morton
Follow /31 Jul 2014 at 3:57pm / Oracle Blog

Understanding Optimizer Statistics and Keeping Them Simple - Part 3

Last time, in Part 2 , I reviewed Oracle's automatic statistics gathering mechanism using the DBMS_STATS package to collect statistics on tables and indexes when to collect statistics based on "staleness" the appropriate starting...
2691 2 /