Search

Top 60 Oracle Blogs

Recent comments

October 2011

What the heck is the SQL Execution ID – SQL_EXEC_ID?

Ok, I think it’s time to write another blog entry. I’ve been traveling and dealing with jetlag from 10-hour time difference, then traveling some more, spoken at conferences, drank beer, had fun, then traveled some more, trained customers, hacked some Exadatas and now I’m back home.
Anyway, do you know what is the SQL_EXEC_ID in V$SESSION and ASH views?
Oh yeah, it’s the “SQL Execution ID” just like the documentation says … all clear.

What the heck is the SQL Execution ID – SQL_EXEC_ID?

Ok, I think it’s time to write another blog entry. I’ve been traveling and dealing with jetlag from 10-hour time difference, then traveling some more, spoken at conferences, drank beer, had fun, then traveled some more, trained customers, hacked some Exadatas and now I’m back home.

Anyway, do you know what is the SQL_EXEC_ID in V$SESSION and ASH views?

Oh yeah, it’s the “SQL Execution ID” just like the documentation says … all clear. Um … is it? I’d like to know more about it – what does it actually stand for?! Is it session level, instance level or a RAC-global counter? And why does it start from 16 million, not 1?

 

Xplan utility

A utility to add parent ID and execution order information to plans reported by DBMS_XPLAN. XPlan includes DISPLAY, DISPLAY_CURSOR and DISPLAY_AWR functionality for use in exactly the same way as the DBMS_XPLAN equivalents. Supports versions from 10g onwards. ***Update*** Now available in two formats: 1) as a PL/SQL package and 2) as a collection of three free-standing SQL*Plus scripts (i.e. no installation/database objects needed). January 2009 (updated October 2011)

Runstats utility

A variation on Tom Kyte's invaluable RUNSTATS utility that compares the resource consumption of two alternative units of work. Designed to work under constrained developer environments and builds on the original with enhancements such as "pause and resume" functionality, time model statistics and the option to report on specific statistics. ***Update*** Now available in two formats: 1) as a PL/SQL package and 2) as a free-standing SQL*Plus script (i.e. no installation/database objects needed). January 2007 (updated October 2011)

Xplan utility

A utility to add parent ID and execution order information to plans reported by DBMS_XPLAN. XPlan includes DISPLAY, DISPLAY_CURSOR and DISPLAY_AWR functionality for use in exactly the same way as the DBMS_XPLAN equivalents. Supports versions from 10g onwards. ***Update*** Now available in two formats: 1) as a PL/SQL package and 2) as a collection of three free-standing SQL*Plus scripts (i.e. no installation/database objects needed). January 2009 (updated October 2011)

Simple SQL with and without Inline Views

October 21, 2011 (Forward to the Next Post in the Series) Sometimes it is interesting to take a step back from some of the more difficult to construct SQL statements, and just put together something simple.  The following request recently arrived through an ERP mailing list: “I want to find the last ship date for all the [...]

Friday Philosophy – Should I Be a Twit?

Something I have been pondering for a while now is should I join in with the “happening crowd” and sign up to Twitter? I know, I’m two or three years behind the times on this, but more and more people who I like have signed up – even Doug Burns now uses twitter and he used to be negative about it in the same way as I. I’ve asked a few of these friends what they think.

Tuning Blog Entries

Organizing  some of my past blog entries on Oracle database performance tuning and analysis. I’ll add more notes as well as a separate section on SQL tuning in particular.

ASH

AWR

Why Are My Indexes Still Valid Solution (A Second Face)

I’ve been so busy lately, I just haven’t had any spare time to post. For now, the quick answer to the last quiz is that the second table was indeed an Index Organized Table (IOT). One of the nice benefits of an IOT is that when re-organised, unlike a Heap Table, all indexes remain valid, [...]

APAC OTN Tour: Beijing, China

My flights to China were rather uneventful. The Birmingham to Dubai leg was delayed by an hour due to fog in Dubai. I had a 4 hour connection in Dubai originally, so the delay was no big deal.

Arriving in Beijing was a little unnerving. I misplaced the Chinese version of the hotel address, but had the English version. Finding someone to translate it proved very difficult and as it turned out they translated it incorrectly. Fortunately I found a cached version of the address on my iPad, so that saved by bacon. The second hitch was that I couldn’t get cash with by debit cards. Just a flat-out refusal from any ATM in China. Arrrggghhh! Fortunately, I was able to get cash advances using my credit card. I’m going to pay through the nose for it, but at least I can survive.

Today is the first day of the conference and I had a morning slot. For the English speakers, we had one screen showing our slides in English and one showing the Chinese translation. I was asked to speak more slowly than usual (kinda difficult for me) and as a result I had to reduce the content somewhat. I did a run through last night to make sure my timing was OK with this adjustment.

The conference has a single track, so you get a room full of people from different technical areas. This is always a little unnerving as you worry about the relevance of your material to audience. Here are a couple of photos of the audience I took while I was setting up.

 

Everything seemed to go OK. I hope they understood my accent. :)

With a bit of luck I will get to see some of Beijing over the next couple of days. I’m behing the Great Firewall of China, so some sites (Facebook and Twitter) are blocked completely and many other sites (like Gmail and any other Google related services) seem to come and go. For the time being my blog seems active. If I lose access to it I will update things once I get to New Zealand.

Cheers

Tim…