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

April 14th, 2014
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 Arup Nanda Dominic Delmolino Marcin Przepiorowski Toon Koppelaars Karl Arao Participation and tracking of the discussion can accomplished by either posting with and  following along with the #datachat  hashtag. Get on TweetDeck or your favorite Twitter tool, search #datachat, add a column and you'll see our chat appear. Always include #datachat in your tweet so you'll be part of the conversation. For an example of a ...


Uncategorized

Maximum manageable storage in VMware versions

April 11th, 2014
  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 in VMFS heap exhaustion and data corruption! More details: Component ESX 3.5 * ESX 4.0 ESX 4.1 ESX 5.0 ESX 5.1 ESX 5.5 vCPUs 4 8 8 32 64 64 RAM 64GB 255GB 255GB 1TB 1TB 1TB Disk Size (VMDK) 2TB 2TB 2TB 2TB 2TB 62TB Number of Disks 60 60 60 60 60 60 RDM Size 2TB 2TB 2TB 64TB# 64TB# 64TB# Max Storage per VM (VMDK) 32TB** 32TB** 60TB** 60TB** 3.63PB Max Storage per VM (RDM) 120TB 120TB 3.75PB 3.75PB 3.75PB NICs 10 10 10 10 10 10 * VMware has EOL support for 3.x **See limits related to VMFS heap at http://dlpx.co/1004424 #RDM size is based on physical-mode RDMs. ...


Uncategorized

Oracle SQL*Net Wait Events

March 24th, 2014
  Introduction 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 other two are simply the time it takes to pack a message before sending it. SQL*Net message to client - time to pack a message (no network time included) possibly tune ...


Uncategorized

Oracle : buffer busy wait

March 21st, 2014
  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 want to read that block. The second user waits until the IO is finished by the first user. Starting in 10g this wait has been given the name "read by ...


Uncategorized

Health Care Crises in Application Development

March 21st, 2014
if someone fraudulently uses your information for medical services or drugs, you could be held liable for the costs 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 ICD  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 be quite damaging. One heuristic for the importance of healthcare information is that ...


Uncategorized

Delphix Modernization Engine

March 18th, 2014
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 for databases. The product can virtualize app binaries, config files, other related files, as well as databases, track changes via TimeFlow, and provision space-efficient virtual copies ...


Uncategorized

Delphix 4.0 Performance Analytics

March 17th, 2014
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 each of those copies would be using their own separate copies of the datafiles, as shown in the image below on the left side. With Delphix, the ...


Uncategorized

Enterprise Performance Tuning in the Age of Agile Data

March 14th, 2014
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: THE UPGRADE UPHILL  CHALLENGE by George Wilson 12 READING EXECUTION PLANS by Jonathan Lewis  Ace Director 18 ANGELS IN THE ARCHITECTURE by Chris Muir & Frank Nimphius 28 PROCESSOR GROUP INTEGRATION IN ORACLE DATABASE 12c by Nikolay Manchev Ace 42 TECHNOLOGY The Ultimate Modernisation Challenge by Mia Urman Ace 35 APPLICATIONS TRANSFORMATION: How Social Can Sales Teams Get With Oracle Sales Cloud by Prity Tewary 24 E-BUSINESS SUITE Speeding Financial Close: Cross-Instance E-Business Suite Transaction Drilldown by Jay Langhurst 14 JD EDWARDS The ERP OBA Implementation Secret by Dale Kaplan & Sagar Malvankar ...


Uncategorized

Oracle Cross Platform Provisioning: Magic from the Mess

March 12th, 2014
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 market by 2017 By 2017, 65% of applications running on Unix in 2012 migrate to x86 Linux    ERP scale-out architectures on x86 platforms will rise from a 10% in 2005 to 80% in 2017    - ...


Uncategorized

Delphix 4.0 released ! The Modernization Engine

March 11th, 2014
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 one at that). The first production version of Delphix, released in 2010, was version 2. Version 2 virtualized Oracle databases. What does virtualizing a database mean? ...


Uncategorized