Agenda for Oaktable World 2014, located at Creativity Museum, is
||Monday Oct 26
||Tuesday Oct 27
||Mark W. Farnham – Minimizing the concurrency footprint of transactions with Logical Units of Work stored in PL/SQL
||Kyle Hailey – Virtual Data
Kerry Osborne – SQL Translation Framework
|Kellyn Pot’Vin-Gorman, AWR Warehouse Trending and Analysis with OBIEE
||Greg Rahn – Taming JSON with SQL: From Raw to Results
Marco Gralike – Improving XML performance (more...)
photo by Yannis (CC 2.0)
On the delphix.com website there is a “Free Trial” download which is a fully functional 30 day trial version of Delphix. Unlike the 30-day trial version, Delphix Express is yours to use, as long as you’d like.
Delphix Express is a free version of Delphix limited to 1 vCPU and 25 GB of managed storage.
Delphix Express is in pre-release status. If you’d like to join (more...)
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
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 (more...)
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
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 (more...)
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...)