Search

Top 60 Oracle Blogs

Recent comments

September 2014

Order of Operation

One response to my series on reading execution plans was an email request asking me to clarify what I meant by the “order of operation” of the lines of an execution plan. Looking through the set of articles I’d written I realised that I hadn’t made any sort of formal declaration of what I meant, all I had was a passing reference in the introduction to part 4; so here’s the explanation.

 

By “order of operation” I mean the order in which the lines of an execution plan start to produce a rowsource. It’s worth stating this a little formally as any other interpretation could lead to confusion; consider the following simple hash join:

12.1.0.2 Introduction to Zone Maps Part I (Map Of The Problematique)

Zone Maps are new index-like structures that enables the “pruning” of disk blocks during accesses of the table by storing the min and max values of selected columns for each “zone” of a table. A zone is simply a range of contiguous blocks within a table. Zone Maps are similar in concept to Exadata storage […]

Eight days to go – Who are you voting for in the NH Republican Senatorial Primary?

SLOB Patch. AWR Post-Processing Script (awr_info.sh) Fix.

BLOG UPDATE 2015.01.20: Please Note! This patch has been deprecated. Please go to kevinclosson.net/slob to get the latest SLOB kit with the latest awr_info.sh.

BLOG UPDATE 2014.09.11: Please note: the following is a link to a more recent update of the awr_info.sh script. This version adds DB Time, DB CPU and Logical I/O: click here. The MD5 sum for this version of awr_info.sh is:  a28a38b11040bb94f08a8f817792c75c

Why we should eliminate corporate INCOME taxes.

Another message from “Farnham for US Senate”

Lately, there has been a lot of news about “corporate inversion.” Essentially a large US based corporation essentially buys a foreign company based in a country with lower corporate income tax rates, but designates that the acquisition is now actually the top of the corporate structure. With this stroke of paperwork (producing nothing), the net income after taxes is improved for the stockholders. Aside from the public relations (which might be costly, especially in consumer products), this is what management should do: Maximize the returns to stockholders.

This is just a new wrinkle in the idiocy and waste that is taxing corporations on income.