Search

Top 60 Oracle Blogs

Recent comments

March 2014

Oracle Midlands : Event #3 – Registration Open

Registration is now open for Oracle Midlands Event #3 on Tuesday 20th May..

As I mentioned in a previous postChristian Antognini will be the speaker for both the sessions this time. He’ll be covering “12c Adaptive Query Optimization” and “Row Chaining and Row Migration Internals”.

Red Gate Software have kindly offered to sponsor the event again, so registration is free!

I’ve already registered. :) Please make the effort to come along and support the event!

Cheers

Tim…

300 : Rise of an Empire

I went to see 300 : Rise of an Empire yesterday.

My feelings on this were a bit of a mixed bag. I was not the biggest fan of the original 300 movie at the cinema, but I have subsequently warmed to it. This film adds a bit more story about the lead up to the first film and fills in more details about what happened after, so it is kind-of like a combined prequel-sequel. Visually it was quite similar to 300, but it felt a little more low budget to me, like a longer, high budget episode of the Spartacus TV series…

The action sequences tended to follow a similar pattern of,

New Version Of XPLAN_ASH Utility

A minor update 4.01 to the XPLAN_ASH utility is available for download.

As usual the latest version can be downloaded here.

These are the notes from the change log:

- More info for RAC Cross Instance Parallel Execution: Many sections now show a GLOBAL aggregate info in addition to instance-specific data

- The Parallel Execution Server Set detection and ASSUMED_DEGREE info now makes use of the undocumented PX_STEP_ID and PX_STEPS_ARG info (bit mask part of the PX_FLAGS column) on 11.2.0.2+

- Since version 4.0 added from 11.2.0.2 on the PX *MAX* DOP in the "SQL statement execution ASH Summary" based on the new PX_FLAGS column of ASH it makes sense to add a PX *MIN* DOP in the summary to see at one glance if different DOPs were used or not

ADDM Compare in EM12c

I’m often present to overhear comments like the following when issues arise:

  • I *think* someone changed something.
  • I bet some DBA changed a parameter!
  • I know is running that process I told him/her not to!

Making assumptions vs. having data is a good way to alienate peers, coworkers and customers.

Norway bound

I cant wait to get to Norway again for this year’s OUGN conference.

If you’re in Europe…this should be on your must-attend list every year.

It’s awesome fun.

I’ll be talking about Clone DB, Optimizer Stats and Analystics in SQL

http://ougnvarseminar2014.sched.org/

Upcoming Speaking Engagements

After about four months without any speaking engagements, over the next three months I’ll have the opportunity to speak at several events. I’m looking forward to meet you at one of them!

April 3, I’ll be in Baden-Dättwil to speak about “ASH Analytics” at an event organized by SOUG. Since this is a new presentation covering some stuff that I wrote for the second edition of TOP, I’m looking forward to see how it works.

April 29/30, I’ll be in Berlin for presenting a 2-day seminar about the query optimizer. The event is organized by DOAG. Also in this case the content is based on the second edition of TOP. By the way, there are still a handful of free seats… so, if you are interested, don’t wait too long to subscribe.

May 20, during the evening, I’ll be in Birmingham to speak at an event organized by Oracle Midlands. I’ll give two presentations: “Adaptive Query Optimization” and “Row Chaining and Row Migration Internals”.

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have changed in 12.1.0.1 – so I ought to re-run some tests to make sure that the articel is up to date if it’s likely to be read a few times in the next few days.

Unfortunately, although I often add a URL to scripts I’ve used to confirm results published in the blog, I don’t usually include a script name in my blog postings  to remind me where to go if I want to re-run the tests. So how do I find the right script(s) ? Typically I list all the likely scripts and compare dates with the date on the blog; so here’s what I got for “lock”.

Juggernaut

One of the problems of “knowing” so much about Oracle is that the more you know the more you have to check on each new release of the software. An incoming ping on my posting “Lock Horror” reminded me that I was writing about 11.2.0.1, and the terminal release is 11.2.0.4, and the whole thing may have changed in 12.1.0.1 – so I ought to re-run some tests to make sure that the articel is up to date if it’s likely to be read a few times in the next few days.

Unfortunately, although I often add a URL to scripts I’ve used to confirm results published in the blog, I don’t usually include a script name in my blog postings  to remind me where to go if I want to re-run the tests. So how do I find the right script(s) ? Typically I list all the likely scripts and compare dates with the date on the blog; so here’s what I got for “lock”.

SnapLogr - A smart way to display debug information

So during the last 14 days I've had an infection, which required me to take large amounts of penicillin, which got me so tired, that I really could not do that much work on my codemonth project. But still, I couldn't really let go of everything. So I decided to build an easy to use debug/logger utility that ships the messages to the web for easy digest, and for more pleasing looks.

UKOUG Operating System and Storage Event – 28th May

Just a quick note to say the call for papers is open for the UKOUG Operating System and Storage Event in Birmingham on the 28th May. To quote the website,

“This event will cover Linux and Solaris Administration, Storage and Network Administration, Virtualisation and Engineered Systems.

UKOUG Operating Systems & Storage Event takes place in Birmingham on 28th May and will become a key event for DBAs, OS, Network and Storage Administrators who support an Oracle Infrastructure.”

Hope to see you there!

Cheers

Tim…