Doug's Oracle Blog - Comments

Doug Burns: 10053 Trace Files - Different Plan in Different Environments

nospam@example.com (Doug Burns) — Tue, 02 Apr 2013 08:57:56 +0100

You're welcome. Now I just need to pull my finger out and actually come up with some better examples

Howard Rogers: 10053 Trace Files - Different Plan in Different Environments

nospam@example.com (Howard Rogers) — Mon, 01 Apr 2013 23:08:53 +0100

Makes a big difference, so thanks for that! With two browser windows, opened side-by-side, snapped to half-screen each, the new approach makes it a lot easier to follow along. Much appreciated.

Doug Burns: 10053 Trace Files - Different Plan in Different Environments

nospam@example.com (Doug Burns) — Sat, 30 Mar 2013 00:03:11 +0000

I've had a first crack at the line number thing. I think I personally prefer including bits of the trace file in the post itself as I find the flipping back and forwards slightly annoying, but others seem to prefer the full file. I'll probably use a combination of both ...

Doug Burns: 10053 Trace Files - Different Plan in Different Environments

nospam@example.com (Doug Burns) — Thu, 28 Mar 2013 10:24:21 +0000

Hi Howard, Good suggestion, thanks. I'll hopefully have a bit of time to faff around with the options and suggestions over the next few days and see what sticks. Hope all's well!

Howard Rogers: 10053 Trace Files - Different Plan in Different Environments

nospam@example.com (Howard Rogers) — Wed, 27 Mar 2013 03:07:49 +0000

Just a suggestion: line numbers. Instead of saying things like "next we go into a long section...", something like "Line Numbers 445 - 598376 is a long section..." It makes it easy to understand where you are, without you having to embed sections of the file in your blog post (which, with something this big, is probably not a great idea!). Embedding discrete sections as I see you are thinking of doing would also take away the experience of navigating the file as-is. I think seeing it as a whole, and being guided to the good bits, without missing out the fact that there are swathes of dross, would be prefereable. But line numbers are then essential so we know where we're supposed to be looking!