Oaktable World 2015 San Francisco, Oct 26 & 27

August 24th, 2015
Agenda for Oaktable World 2015, located at Creativity Museum, is  time Monday Oct 26 Tuesday Oct 27 8  8:30 - Welcome with Mogens  Toon Koppelaars - hash joins and Bloom filters 9 Mark W. Farnham - Minimizing the concurrency footprint of transactions with Logical Units of Work stored in PL/SQL Kyle Hailey - Virtual Data 10 Kerry Osborne - SQL Translation Framework Kellyn Pot'Vin-Gorman, AWR Warehouse Trending and Analysis with OBIEE 11 Greg Rahn - Taming JSON with SQL: From Raw to Results Marco Gralike - Improving XML performance with the 12c In-Memory Column Store 12 ted talks ted talks 1 Dan Norris - Exadata Database Machine Security Cary Millsap - Performance 2  John Beresniwicz - AWR Ambiguity: What do do when the numbers ...


Uncategorized

Delphix Express – a free version of Delphix

July 7th, 2015
    photo by Yannis (CC 2.0) Announcing Delphix Express, a completely new and free version of Delphix limited to 1 vCPU and 25 GB of managed storage. Unlike the "Free 30-day trial"  version this one is yours to keep for as long as you like. Delphix Express is in pre-release status.. Delphix Express is in pre-release status. If you'd like to join the pre-release program of Delphix Express, email  kyle.hailey@delphix.com  with your company name and country. (or just sign up for our current 30 day trial and you will be sent an invitation to Delphix Express when its ready http://pages.delphix.com/Free-Trial-Request.html)Delphix Express is available currently for VMware and VirtualBox hypervisors. As with ...


Uncategorized

Good new SQL tuning book

June 24th, 2015
People ask me from time to time what are some good SQL tuning books. It's a tough question to answer. There are some seminal books such as "SQL Tuning" by Dan Tow and "Cost Based Optimizer Fundamentals" by Jonathan Lewis, but these are advanced books  that few I know have actually read from cover to cover. If you are looking for practical SQL tuning cookbooks you might want something a little less advanced.  For a practical approach, I love "Refactoring SQL Applications" by  Stephane Faroult which is an easy read, again, it's not a straight forward SQL tuning book. Finally there is a book that ...


Uncategorized

Performance #datachat

June 19th, 2015
    photo by Tom Woodward  Summary of responses to questions from Solarwinds #datachat back in the fall. 1. Why do performance issues happen? Performance issues happen mainly because of bad design.  Performance issues occasionally happen because of hardware undersizing (IO, CPU, Memory, Network) but that's the 20 (or less) of 80/20. At  IOUG a last year someone tweeted out a slide that said 80% of performance problems were from IO and  Kevin Closson tweeted the other 80% are from bad SQL :P  . I thought that was pretty funny. In other words bad SQL , which is part of bad design, is the cause of most performance problems and not I/O ...


Uncategorized

DHCP: Virtualbox vs VMware on laptops

May 28th, 2015
I've been using VMware Fusion on my Mac but it costs about $60. Not that much but Virtualbox is free, so I also have Virtualbox as well. For my VMs I use DHCP and this has caused some problems but mainly on Virtualbox. With VMware Fusion (and VMware Workstation) everything works fine. VMware With VMware, under "Edit Hardware Settings" then "Network Adaptor" I just set the network Mac:  "Share with MAC" PC:  NAT This causes the system to act as a router, isolating the VM's on their own network, while allowing internet connectivity outbound as well as being able to connect to the VMs from my laptop and being ...


Uncategorized

Delphix announces masking acquisition

May 20th, 2015
I'm excited to announce the first acquisition by Delphix (portending many to come). Dephix has just acquired the data masking company  Axis Technology Software. Delphix is integrating the Axis masking technology into the core Delphix product. Masking is a feature that 9 out of 10 customers have asked for after buying Delphix. Delphix eliminates the data cloning bottleneck  for application development environments and naturally the next concern that arises is how to mask the data from production in application development environments. The answer has been to use Axis masking which Delphix has been selling prepackaged together with Delphix in partnership with Axis. Axis was so ...


Uncategorized

Delphix Data as a Service (DaaS)

May 19th, 2015
The capabilities of Delphix can be differentiated from snapshot technologies through the following hierarchy: Data as as Service (DaaS) (Delphix approach to data management) Virtual Data (end-to-end collection and provisioning of thin clones) Thin Cloning Storage Snapshots On top we have the most powerful and advanced data management features that enable fast, easy, secure, audit-able data flow through organizations. DaaS is built on top of other technologies. On the bottom we have the minimal building blocks starting with storage snapshots.  Storage snapshots can be used to make “thin clone” databases. Storage snapshots have been around for nearly 2 decades but have seen minimal usage for database thin cloning ...


Uncategorized

Oaktable World Las Vegas April 15, 2015 at Collaborate

April 8th, 2015
  Wednesday April 15 at Collaborate 2015 Las Vegas room Mandalay K For more information see Pythian's Blog post.       What is Oaktable World ? Oaktable World is a day organized by members of the Oaktable network. The Oaktable network is a network of Oracle database tuning geeks. Among the members are Tanel Poder, Jonathan Lewis, Cary Millsap etc.  Oaktable network was created by Mogens Nørgaard back in 2001 or so and Mogens started organizing underground get togethers, known as Oracle Closed World, during Oracle Open World in 2007, usually at Mogens' "office" at Chevys. In 2010  Oracle Closed World became a bit more ...


Uncategorized

Try Oracle 12c VM with Delphix download

March 25th, 2015
 photo by Jose Maria Cuellar (CC 2.0) Thanks to Leighton Nelson who pointed out  that : Oracle has a pre-installed Linux VM with 12c Delphix as well has a pre-installed   trial version  Download both of these and start them up in Virtualbox and you can start virtualizing your PDBs. The Oracle pre-installed VM has a few eccentricities that have to be addressed before using it. There is no IP address and there is no history of the install and it's missing a glibc library. After we address these in the instructions below you can link to the PDB and then provision that PDB back as a virtual ...


Uncategorized

Remote graphical installs

March 5th, 2015
Most of my servers tend to be Linux VMs on VMware ESX without any graphics desktops setup, so it can be disconcerting trying to install Oralce with it's graphical "runInstaller" being the gate way we have to cross to achieve installation.  Of course there is the silent install, but to do that requires knowing all the secret handshake responses to make the silent installer work. Often the easiest way to get a response file is to capture the responses form a graphical run of the runInstaller. There is another way, and that is using vncserver to run the graphic desktop on another ...


Uncategorized