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 (more...)
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 (more...)
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.
With VMware, under “Edit Hardware Settings” then “Network Adaptor” I just set the network
- Mac: “Share with MAC”
- PC: NAT
This causes (more...)
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 (more...)
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
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 (more...)
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
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 (more...)
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 (more...)
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
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, (more...)