Musings about COLLABORATE, the 9th version of which is happening in Las Vegas USA from April 7-11 2014.
One of the biggest selling features of Oracle’s flagship engineered system – Exadata – is the storage offloading capabilities. Storage offloading allows data to be filtered as soon as it is read from storage, reducing the amount of data that database hosts need to process. The storage layer is a shared-nothing MPP architecture and in…
Like many previous IOUG/OAUG/Quest shows, Pythian will be in Denver next week!
OEM 12c Cloud Control looks daily for new targets, placing them in a queue for admin promotion to managed objects. Details and troubleshooting info follow.
I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (126.96.36.199). A few documents do exist for this process. However I found a few inconsistencies and problems; I think the existing documents I found were written on older versions of OEM and older versions of the tools. I’m publishing my final procedure here with hopes that it helps you, but as always please cross-reference this with the appropriate documentation before doing anything in your own environment.
The environment was an Exadata environment undergoing pre-production stress testing. We used Real Application Testing to take a highly-concurrent OLTP workload, and replayed the workload with the synchronization parameter set to FALSE, effectively increasing concurrency beyond the original test system. AWR showed a large volume of buffer busy activity.
Like many good stories, this one also started with an innocent question from customer: “I often check “SELECT COUNT(*) FROM TABLE;” on our old 10.2.0.4 cluster and the new Exadata. The Exadata is slower than our old cluster by few minutes. Exadata is not good at count(*) ? or other problem?” Here’s how I fixed it.
Disclaimer: much that follows is pure speculation on my part. It could be completely wrong and I’m putting it out there in the hopes that it’ll eventually be proven one way or the other.
Follow these steps when setting up interfaces in a policy-routed Exadata system, they should be helpful.
Tuesday morning at OOW is always occupied by this forum, an opportunity for authors and other persons to receive heads up on what’s coming down the pipe from Oracle. The following notes are musings from yours truly as I attended the forum today.