Posts Categorized: Oracle Exadata

COLLABORATE 13 à la Pythian …

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…

Set Up Exadata for Cloud Control 12.1.0.2

I recently helped setup an Exadata X2-8 Database Machine with the latest version of OEM Cloud Countrol (12.1.0.2). 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.

Temporary Tablespaces: to BIGFILE or not to BIGFILE

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.

Select Statement Generating Redo and Other Mysteries of Exadata

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.

Day One at Oracle Open World 2012

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.

Day 1 at Oracle Open World: Did not disappoint

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.

Page 1 of 1212345...10...Last »