October 2017

Free eBook: DevOps and the DBA, The Last Frontier!

The first edition of the free eBook is available for download at Delphix!

It took us a bit to get the final updates to the eBook version completed and I want to thank everyone at Delphix who helped get the content updated with the latest additions, including the bossman, Eric Schrock and for helping me keep it all organized and finalized, shoutouts to Rita Rosenberg.

Autonomous Database

Larry Ellison has announced Oracle 18c to be the Autonomous Database, the no-human labor, and self-driven, database. Here is a quick recap of what it is behind the marketing words. My opinion only.

What I Learned At Oracle Open World 2017

My Oracle Open World started with a beautiful Sunday-morning run across San Francisco’s Golden Gate Bridge annual event organized by Oracle’s SQL Developer team (thanks Jeff)! Monday morning another group met for our annual San Francisco Bay Swim at the Dolphin Swim club; thanks to the Oracle Developer Community for providing coffee, pastries, and cool towels (thanks Jennifer)!

Oracle’s Open World was a little cozier this year; most sessions were at Moscone and hotels in close proximity making it easier to get from event to event. More time in sessions and less time in transit; good swap.

12c Parse

Following on from a comment to a recent posting of mine about “bad” SQL ending up in the shared pool and the specific detail that too much bad SQL could cause contention problems while staying virtually invisible, there’s a related note today on the ODC (formerly OTN) forum of a little change in 12.2 that alerts you to the problem.

Try executing the following anonymous block (on a non-production system):

Where in the World is Goth Geek Girl, Week 41

So now that I’m finished just taking it easy, playing hooky from Oracle Open World and Oak Table World…uh, yeah….

Indexing Seminar: Why Small Classes? (A Small Plot Of Land)

Firstly, a huge thank-you to everyone who has enroled in one of my “Indexing Internals and Best Practices” Seminars running soon is Australia. The feedback and overall reaction has been extremely positive and I can’t wait to present all the material I’ve been putting together these past few weeks. There are currently limited places still […]

Driving for Change- Women of Oracle

Somehow I’ve made it a pastime of pointing out how many times women are passed up for recognition while men are promoted around them. Its not that the men were identified as better or worse than women, but just about how heavily we scrutinize and limit women while everyone else passes them by. Now I’m going to ask the Oracle folks to not take this personally, but hopefully take it as a call to arms, but I know how we love to shoot the messenger.  Hopefully you already know that I will have no qualms about deleting abusive or threatening comments to this post, so please think twice before doing and really think on what I’m posting here.

ODA X7

ODA X6-2

So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion.

The main feedback from the X6-2 series were:

  • not enough cores when consolidating multiple databases in M, L and HA
  • not enough storage on HA when compared with X5-2
  • Standard Edition on HA would be great for cheaper RAC
  • The position of the ‘Large’ version of ODA Lite was not clear

ODA X7-2S

The Small version of the ODA Lite has the same number of cores as in X6-2: 10 cores in one socket. Those are Intel Xeon Silver 4114 processor (2.2GHz). Some more memory: 6x32GB instead of 4x32GB, so 192GB expandable to 384GB as before.

Parsing

Here’s a quick quiz.

According to the Oracle 12.1 Database SQL Tuning Guide the first stage of parsing a statement is the Syntax Check, which is followed by the Semantic Check, followed by the Shared Pool Check. So where you do think the statement text will be while the Syntax Check is going on ?

 

 

 

 

 

 

And the answer looks like ….

 

 

 

… the shared pool. Here’s a simple test, cut-n-paste from SQL*Plus running under 12.1.0.2 in the SYS schema (I’ve also done this in the past with older versions):

 

 

 

Snapshots from OpenWorld so far

Bridge Run on Saturday

 

20171001_075143

 

20171001_075242

 

Swim in the bay on Monday