Posts Categorized: Oracle Exadata
As per many previous IOUG/OAUG/Quest shows, Pythian is will be in Denver next week! It was a sunny day in the fall of 1991 when I gave my first paper at International Oracle User Week (IOUW), a pre-cursor to COLLABORATE and a few earlier incarnations called IOUG-Live and IOUG-Alive! It has been a whirlwind of…
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 (220.127.116.11). 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.
Yesterday night, under the backdrop of the magnificent Golden Gate bridge of San Fransisco, Oracle lived up to its name and honored the Oracle ACEs and ACE Directors from all across the world. Lillian and her team did a wonderful job of bringing together almost all the great names in the Oracle World, and it was really nice for me to put so many names to the faces.
The day was action packed with sessions and I presented my Oracle rman:Don’t Forget the Basics to an enthusiastic crowd in Moscone west. The room was close to full with some hanging out at the back. It has been a while since I have presented in a room so close to being full. There was a handful of questions and comments during the session and a group of attendees approached me to follow-up afterwards.