Performance live discussion on twitter, 12pm PST Tue April 15

Confio software is hosting a live discussion on twitter tomorrow Tuesday April 15 at 12pm PST on the subject of Oracle performance.

I’ll be online answering performance questions and have invited many other friends to participate. Some friends who’ve said they’ll be there are

Participation and tracking of the discussion can accomplished by either posting with and  following along with the #datachat  hashtag.

Get (more...)

Maximum manageable storage in VMware versions


Maximum manageable storage per VM by ESX version

  • 4.1: 32TB (vmdk) / 120TB (RDM)
  • 5.0: 60TB (vmdk) / 3.75PB (RDM)
  • 5.1: 60TB (vmdk) / 3.75PB (RDM)
  • 5.5: 3.63PB (vmdk) / 3.75PB (RDM)

Note that the 60TB limit for 5.0 and 5.1 requires Update 1. Without this the limit is 24TB.

Exceeding the limits on ESX < 5.5 can result (more...)

Oracle SQL*Net Wait Events


Unfortunately, what Oracle calls “Network Waits” have little to do with Network but and almost exclusively to do with the time it takes to pack messeges for the network before they are sent.
Client = you, the tool, sqlplus, application
Not the client, the other side = the shadow process is communicating to the client

Of the three waits, only “more data” is possibly related to network issues and that’s not even clear, the (more...)

Oracle : buffer busy wait

Oracle 10 and 11

Buffer Busy Waits usually happen on Oracle 10 and 11 mainly because of insert contention into tables or Indexes.  There are a few other rare cases of contention on old style RBS segments, file headers blocks and freelists.
Before Oracle 10 and 11 there was one other major reason which was readers waiting for readers, ie one user does a phyiscal IO of a block into memory and a second user (more...)

Health Care Crises in Application Development

The demand for healthcare application development is exploding and has been exploding over the past couple of years because of

  • Obama Care – Affordable Care Act
  • Regulatory – HITECH and HIPAA Privacy Acts
  • IDC 10
  • Pro-active Health Care (versus reactive health care)
  • Mobile devices

but to develop applications for health care requires the data to be masked. Why does masking data matter and matter especially for health care? If patient information gets out it can (more...)

Delphix Modernization Engine

Delphix Modernization Engine is built on version 4 of our Agile Data Platform. Delphix built the Modernization Engine to help companies trying to migrate or consolidate data centers (including migration to private, public clouds) or retire/rationalize application portfolios. The product is designed to dramatically reduce project risk, as well as time and run-rate IT costs. Key functions include:

Virtualize entire application stacks: Delphix can now do for applications and file systems what we already did (more...)

Delphix 4.0 Performance Analytics

This is super cool, fine grain powerful performance analytics in Delphix 4.0 just released!

To understand what the analytics shows, it is important to understand the role Delphix plays and where  Delphix sits in the architecture of data.  Delphix is used to provide clones of a data. The most well know Delphix data cloning example is the use case of cloning Oracle databases. If I had three normal copies of an Oracle database, then (more...)

Enterprise Performance Tuning in the Age of Agile Data

The new Oracle Scene magazine is out. Checkout pages 48-50 for an article by  me.

Here are the awesome contents of Oracle Scene magazine Spring 2014:

  • READING EXECUTION PLANS by Jonathan Lewis  Ace Director 18
  • ANGELS IN THE ARCHITECTURE by Chris Muir & Frank Nimphius 28
    • The Ultimate Modernisation Challenge by Mia Urman Ace 35

Oracle Cross Platform Provisioning: Magic from the Mess

Linux is taking over the workloads from the shrinking market share of

  • IBM AIX pSeries
  • Solaris Sparc Servers
  • HP-UX Itanium
because Linux provides a reliable and less expensive platform. The costs reductions per users according to IDC for using Linux over UNIX can be  on the order of 1/5 the price per end user
Legacy RISC Systems Cost  $1,425/User versus Linux at $ 256/User 
- IDC 2012
The LINUX systems will represent the marjority of the (more...)

Delphix 4.0 released ! The Modernization Engine

Delphix is amazing technology. I’ve been at Delphix for almost 4 years. The first year I was at Delphix was the first year Delphix was released on the market. Even from that first release Delphix revolutionized how we managed and think about data. Data goes from an onerous massive burden to instead a  fast, easy,  powerful resource. As one customer put it data goes from being your enemy to being your friend (and a powerful (more...)