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

Data Center of the Future – now

January 30th, 2015
  photo by youflavio In a recent blog post Eric D. Brown defined an Agile Data Center as An Agile Data Center is one that allows organizations to efficiently and effectively add, remove and change services at the speed of the business, not the speed of technology - Eric D. Brown In follow up post he said that a Agile Data Center could be implemented by Software Defined Data Center (SDDC) for example using machine virtualization to spin environments up and down. With SDDC, it is possible for companies to replace their data center’s infrastructure with a virtualized environment and then deliver services and software as a ...


Uncategorized

10046.pl by Clive Bostock

January 28th, 2015
Note: This is a reposting of an old blog post that was on dboptimizer.com but is no longer accessible More trace file analyzer tools at  http://ba6.us/node/177 Related blog post: Oracle “Physical I/O” ? not always physical with a 10046 parser specifically for I/O parsetrc.pl and readme Often when I have a 10046 trace file, especially when looking at I/O issues, I want a histogram of I/O response time.  To get I/O response time I’ve hacked out incomple awk scripts from time to time, always meaning to write a more complete one, well now I don’t have to. It’s already been done! Here is a cool perl script from Clive ...


Uncategorized