#555555;">Wow, thanks to
#555555;">Process Monitor #2970a6;" href="http://technet.microsoft.com/en-us/sysinternals/bb896645">http://technet.microsoft.com/en-us/sysinternals/bb896645
#555555;">I was able track down why I couldn’t connect to Oracle from Excel.
#555555;">I had wanted to try some of the examples Charles Hooper has posted on connecting to and monitoring Oracle, for example
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:
I received an interesting question as a comment on another post (which I’ll approve as soon as I post this one) and I thought it was interesting enough to add a completely separate post on my thoughts. In essence, the comment was along the lines of this:
“With so much content and articles do you ever run into any problems of plagiarism or copyright violation? My blog has a lot of exclusive content I’ve either written myself or outsourced but it appears a lot of it is popping it up all over the internet without my permission. Do you know any methods to help stop content from being stolen? I’d truly appreciate it.”
I look at this from a number of different perspectives.
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.
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.
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:
How does Delphix benefit a SAP project?
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 no longer delivering one or two massive projects a year, but are delivering smaller, more nimble projects on an on-going basis.
Once we’ve establish what Delphix does for projects, we want to give a few examples.
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
Orion on the other hand unfortunately has had some problems that have made it too undependable for me to trust.
A common criticism of PLSQL is that the "original" array datatype, now called associative arrays are perfect for passing stuff back and forth to 3GL environments (for example .Net), but canno be used within SQL natively, for example:
Last week I’ve gotten a question on how storage indexes (SI) behave when the table for which the SI is holding data is changed. Based on logical reasoning, it can be two things: the SI is invalidated because the data it’s holding is changed, or the SI is updated to reflect the change. Think about this for yourself, and pick a choice. I would love to hear if you did choose the correct one.
First let’s do a step back and lay some groundwork first. The tests done in this blogpost are done on an actual Exadata (V2 hardware), with Oracle version 184.108.40.206.6 (meaning bundle patch 6). The Exadata “cellos” (Cell O/S) version is 220.127.116.11.1.140529.1 on both the compute nodes and the storage nodes.