July 2017

DevOps and Webinars- July 19th and July 25th

Doing three or four webinars in a month doesn’t seem like a big deal until you actually try to do it…and present at two or three events and make sure you do everything for your job outside of that, too.  Suddenly you find yourself scrambling to keep up, but I’m known for taking on a few too many things at once… </p />
</p></div></div>

    	  	<div class=

New member of the OakTable Network

A quick one to say that I am very happy to be a new member of the OakTable Network.

bdt's oracle blog

Exadata 12c PX Adaptive Offloading

Here is yet another case when you may not see as much offloading on your Exadata as you expect.

I was recently investigating a simple select count(*) query producing a lot of buffered read events:

select count(*) from whs.trans partition (sys_p10236650) f

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
resmgr:pq queued 1 0.00 0.00
Disk file operations I/O 1 0.00 0.00
cell single block physical read 41 0.00 0.04
enq: KO - fast object checkpoint 3 0.00 0.00
reliable message 1 0.00 0.00

Friday Philosophy – Improving Your Working Life

If I got you all to write down the top 5 things that make working bearable, and then got you to make a list of the top 5 things that make working enjoyable, I have a suspicion there will be one thing high on the “Enjoyable” list that may not even be on the “Bearable” list:

Being in a good team.

This one thing can make a real difference to your working life. I know this is true for me and it’s something I’ve heard other people say a lot. The team you are in can make up for a lot of negative things about any given job. I’ve found myself in roles where I am unsuitable for the task, or under a ridiculously high workload, even being paid much less than I know I am worth. But if I have been in a good team, working with people I like (well, at least some of them!) it makes it all a lot better. A lot, lot better. Think about the jobs or roles you have most enjoyed in your life. In any of them did you not like the team you were in?

Upgrading an Amazon EC2 Delphix Source, Part I

For a POC that I’m working on with the DBVisit guys, I needed a quick, 12c environment to work on and have at our disposal as required.  I knew I could build out an 11g one in about 10 minutes with our trust free trial, but would then need to upgrade it to 12c.

Disable snapshots to Delphix Engine

This is a simple prerequisite before you upgrade an Oracle source database and takes down the pressure on the system, as well as confusion as the database upgrades the Oracle home, etc.

Simply log into the Delphix Admin console, click on your source group that the source database belongs to and under Configuration, in the right hand side, you’ll see a slider that needs to be moved to the “disable” position to no longer take interval snapshots.

Role of # in SQL*Plus

The # character is for commenting in SQL*Plus, right?

The character # has been mostly used for comments in many languages, such as shell scripts and python. Interestingly # is legal syntax in SQL scripting as well; but is it considered a comment? The answer is no; it's not. The purpose of # in SQL scripts is very different. and you should be very careful using it.

Entering # tells SQL*Plus to temporarily pauses what has been entered before and execute everything after that #sign, as if in a different session. Here is a usecase. Suppose you are writing this query:

SQL> select *
  2  from v$sesstat
  3  where

Little Things Doth Crabby Make – Part XXI. No, colrm(1) Doesn’t Work.

This is just another quick and dirty installment in the Little Things Doth Crabby Make series. Consider the man page for the colrm(1) command:

Little Things Doth Crabby Make – Part XX – Man Pages Matter! Um, Still.

It’s been a while since I’ve posted a Little Things Doth Crabby Make entry so here it is, post number 20 in the series. This is short and sweet.

I was eyeing output from the iostat(1) command with the -xm options on a Fedora 17 host and noticed the column headings were weird. I was performing a SLOB data loading test and monitoring the progress. Here is what I saw:

Apache Impala Internals Deep Dive with Tanel Poder + Gluent New World Training Month

We are running a “Gluent New World training month” in this July and have scheduled 3 webinars on following Wednesdays for this!

The first webinar with Michael Rainey is going to cover modern alternatives to the traditional old-school “ETL on a RDBMS” approach for data integration and sharing. Then on the next Wednesday I will demonstrate some Apache Impala SQL engine’s internals, with commentary from an Oracle database geek’s angle (I plan to get pretty deep & technical). And in the end of the month, a Gluent customer Vistra Energy will talk about their journey towards a modern analytics platforms.

All together this should give a good overview of architectural opportunities that modern enterprise data platforms provide, with some technical Apache Impala hacking thrill too!

Offload, Transform & Present – The New World of Data Integration