Finding the blocking SQL in a lock wait

July 25th, 2014
One of my pet peeves on Oracle is the inability to find out what SQL took out a lock that another user is waiting. It’s easy to find the waiting user and their SQL with v$session by looking at v$session.event where the event is an “enqueue” (v8 and v9) or “enq: TX – row lock contention” and then looking up their SQL via the v$session.sql_hash_value which joins to v$sql.hash_value for the v$sql.sql_text. So far so good and easy. Second step of finding the blocker is really easy starting in 10g because Oracle has a new field v$session.blocking_session which can be joined back ...


Uncategorized

Excel connect to Oracle – 64bit and 32bit issues

July 24th, 2014
Wow, thanks to Process Monitor   http://technet.microsoft.com/en-us/sysinternals/bb896645 I was able track down why I couldn’t connect to Oracle from Excel. I had wanted to try some of the examples Charles Hooper has posted on connecting to and monitoring Oracle, for example http://hoopercharles.wordpress.com/2010/01/20/excel-scrolling-oracle-performance-charts/ I kept getting the error “Provider not found” Now what kind of trace info is there for an error like this in Excel? None AFAIK. Time to start guessing. I’m on windows 7 64 bit. I have the 64bit 11gR2 Oracle installed.  Excel shows up in task manager as “EXCEL.EXE  *32″. My first guess was, “oh, excel must want the 32bit libraries” so I got the ...


Uncategorized

Delphix 4.1 releases! Oracle 12c PDBs, Sybase, Amazon AWS and Developer Jetpack

July 23rd, 2014
Delphix 4.1 just came out last week. It may sound only like a point release but there is an amazing amount of new technology: AWS: Amazon Web Services / EC2 Support Oracle 12c:  Pluggable Database Support Windows:  Application Data Virtualization Developers: Jetstream Sybase: and SAP ASE Support I'm most excited about Amazon AWS support, Oracle 12c PDB support and developer jet pack , aka Jetstream. More coming on these features in upcoming blogs. AWS Support AWS support is super exciting because as a cloud enabling technology, Delphix is a perfect fit for AWS. AWS is currently hosting a replicated Delphix appliance replicating from our labs in Menlo Park. This ...


Uncategorized

Advance your career contest

July 21st, 2014
Want to advance your career ? We've seen DBAs become managers, managers become directors, directors become VPs and CIOs go from lesser known companies to some of the best known in the world. Why did they get promoted? Because they brought in Delphix. Delphix increases the speed, the agility of IT often enabling development teams to go twice as fast, an increase that is unprecedented. Companies that have this advantage will outperform the competitors. How do you learn Delphix? Up to now you had to buy Delphix but now for a short time we will be giving a few people copies of Delphix for learning purposes. Here's the ...


Uncategorized

I/O benchmarking chat with Uday Vallamsetty from Delphix

July 17th, 2014
Uday Vallamsetty from Delphix performance group just posted a great blog post on evaluating I/O performance in Amazon AWS with EBS.  I had a chance to talk with him a bit about I/O benchmarking and some of the surprises and challenges of I/O benchmarking as well as discuss the importance of producing a report card on any I/O subsystem one is using. Webinar_IO_Benchmarking //


Uncategorized

DevOps & Delphix : Chef recipes

July 16th, 2014
Delphix Engines expose all features via a stable WEB API built on top of HTTP and JSON. Clients choose an HTTP client to interact with Delphix and integrate within their environment. Delphix Engines are bundled with a command line interface which guides users for automation and integration with third party tools. Delphix CLI example Adding a SQL Server Source Environment: Enter these commands through the command line interface: environment; create; set type=HostEnvironmentCreateParameters; set hostEnvironment.type=WindowsHostEnvironment; set hostEnvironment.name=<Source environment name>; set hostEnvironment.proxy=<target host name>; set hostParameters.type=WindowsHostCreateParameters; set hostParameters.host.type=WindowsHost; set hostParameters.host.addresses="<Source ...


Uncategorized

SAP deployed with Delphix

July 15th, 2014
How does Delphix benefit a SAP project? Speed up time to delivery for ASAP implementation methodology Enable adoption of “Continuous Application Delivery” methodology Reduce infrastructure overhead Deliver higher quality projects ASAP methodology is a framework for delivering large IT projects. SAP professionals are familiar with this, however given the size and complexity of SAP projects, many fail to fully adopt it. Delphix helps customers adopt and use ASAP methodology. SAP Projects today are big, hairy beasts. They are 18 months + and it is extremely difficult to do more than one project at a time. Delphix helps SAP customers move to a continuous development model where they are ...


Uncategorized

Orion I/O calibration tool bug

July 14th, 2014
I use fio for all my I/O testing. Why not Orion from Oracle since almost all of my I/O testing and benchmarking has been geared toward Oracle? Several reasons fio is super flexible - able to configure it for almost all types of test active community - updates almost every week, many by Jens Axobe (who wrote much of the Linux I/O layer) reliable - if there are problems, it's open source and one can discuss on the fio commuity email list easy to distribute - just one executable, doesn't require getting for example a full Oracle distribution Orion on the other hand unfortunately has had some ...


Uncategorized

Theory of Constraints: the rise of NoSQL

July 9th, 2014
  http://martinfowler.com/bliki/NoDBA.html Why did NoSQL arise?  The rise of NoSQL makes no sense if you read an article like "Why You Should Never Use MongoDB"  and the ycombinator replies . The I read something like this "Why You Should Use MongoDB" and don't find any reasons just  ranting about why the first article was shoddy. One theory proposed by Martin Fowler is that NoSQL arose as a way to get around the constraint of the DBA bottleneck. When developers want to change the schema or get copies of the source database the DBAs are just seen as an obstacle. The obstacle of provisioning environment is told ...


Uncategorized

kksfbc child completion

July 2nd, 2014
I’ve run into the wait “kksfbc child completion” a few times over the past but found very little written about it. I don’t have an explanation, but I have something that might be as good – a way to reproduce it. By being able to reproduce I at least test theories about it. I ran a tight loop of insert into t value(1); See anything strange? I put “value” instead of “values” so the insert errored out. Thus causing parsing every execute. So this wait seems to be related to parsing. Could run further tests by correcting and adding a different litteral value to ...


Uncategorized