Delphix shines sunlight in data’s cloudy skies

April 23rd, 2014
About year ago or more, Oracle came out with a way create thin clone copies of a database in EM 12c called "Snap Clone". Not sure this makes working with data any sunnier and certainly doesn't add any sunlight to the cloud movement. Snap Clone technology has seen little adoption AFAIK. I'm not aware of a single customer reference yet. Why ? Because Snap Clone doesn't solve the real problem. Snap Clone is complex, depends on cobbling other technologies together, and lacks in crucial features. The real solution is simplicity and end-to-end integration with data source syncing all the way to data provisioning. Snap Clone will provision database ...


Uncategorized

Performance Testing with Agile Data

April 21st, 2014
Performance testing requires full, fresh data Many organizations don’t even attempt to test performance until very late in their development cycle because it is only in the UAT (or equivalent) environment that they have a full copy of their production data set.  Errors and inefficiencies found at this stage are expensive to fix and are often promoted to production due to pressures from the business to meet release schedules. Delphix customers give each developer, or team of developers, a full, fresh copy of the database where they can validate the performance of their code in the UNIT TESTING phase of their projects. ...


Uncategorized

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