Posts by Gwen Shapira
The consistent message, both from Oracle and from independent data architects has been: “Hadoop will not replace Oracle. Each system has its strengths and they can be used side by side to offer wider range of data storing and processing possibilities”.
It seems that most professionals understood and agreed with this message, because this year the question I am hearing most is “Which data should we store in Hadoop and which in Oracle”.
I can’t claim to have the definitive answer, but I can offer some pointers and start the discussion.
I hope that by now you’ve all heard about the fun that is pluggable databases. Oracle 12c will allow you to have multiple databases within the same instance. It is not often that Oracle makes a major architecture change that opens new possibilities. As a consultant it is certainly exciting, I can now imagine new and better-than-ever solutions for my customers.
I’ve been attending OOW every year since I moved to San Francisco in 2007. I always enjoy the event – great speakers, parties, crowds, meeting old friends, hearing new product announcement. I like the excitement. This year the event is particularly exciting for me: For the first time, I’m attending as a speaker and not just as attendee. I’ll be speaking quite a bit actually, on rather diverse list of topics. Here’s what my week look’s like?
The Ottawa Oracle User Group (OOUG) were kind enough to invite me to give a whole morning full of presentation.
The group was ultra engaged and asked a lot of good questions, so my usual 50 minute Big Data presentation ended up taking 100 minutes, and the rest of the content had to be squeezed a bit. I hope everyone had a good time.
If you are interested in the topic of ODA performance, but missed the webinar or if you want to hear it again, you can view our recording here. I also uploaded the slides to slideshare, so you can take a better look at our benchmark results and study our consolidation methods at your own pace.
For the third consecutive year, NoCOUG is hosting an international SQL challenge. In this challenge, the Wicked Witch of the West needs help in creating a magic spell to ensure that the Third Annual Witching & Wizarding Ball is a grand success. Here’s the challenge…
The forwarded case didn’t have many details. Its a 9i system that started experiencing ORA-4031 errors sporadically over the last few weeks. Marc suggested using R to explore how the various SGA components changed sizes over the last few weeks and see whether we can find any interesting trends that can indicate memory leaks. So we did just that. The first step is to get the actual data out of the system, and we used the following query
Thanks to everyone who attended my presentation “Queues, Pools and Caches” at Hotsos 2012. I had a blast and I hope you did too. I posted the slides and paper on SlideShare for your enjoyment. The paper is by far more complete and contains a lot of material I had to leave out of the slides. There were many questions asked after the presentation, so I thought I’ll post a short FAQ to address those:
The chances of getting my hands on 18 servers each with 12 cores, 48g RAM and 84T storage each all connected by InfiniBand are not that great. But I can play with the software, and so can you. Unlike Oracle’s Exadata, almost every software component that is available on the Big Data Appliance is also available for download. So, lets roll our own Big Data appliance!
It was fun presenting today at Portland and I’m looking forward to continuing my user group marathon at Denver tomorrow and on Thursday. Since many people asked me where they can find my slides, and I predict that few more will keep asking about them over the next few days, I uploaded my Big Data and NoSQL presentations to SlideShare. You can find them here:

Recent Comments