I was presented with test results which showed that IN query was about 100 times faster than OR query. Where OR query took minutes to run, IN query took seconds! Ok, I said to myself, it is time to start digging. Here are my findings.
At $work we have a need for a little job daemon that would poll jobs and process them. But there is more than one type of job, so the solution that we need will have to be a little more complex. To get to my goal, I decided that I would have a generic Poller class. For each type of job to monitor and run, I will create a different object with parameters to tell it how often to poll, how to poll and what to do with the stuff it poll. Sounds good? Perfect, then let’s go.
It is evident and beyond doubt now that the new media technologies like Twitter and Facebook are not going to wipe-out the blogs, rather they are complimenting each other very nicely and it seems they were made for each other. This Log Buffer Edition enhances this match, and presents you Log Buffer #272.
After completing your Oracle VM and Oracle VM Manager installation (see my previous blog posts here) you are ready to start your friendship with Oracle VM technology. However to make your life and experience even more enjoyable I would suggest you to follow a few simple steps listed here.
These days, to craft basic emails, I go with Email::Simple. For the more heavy stuff with attachements and what-nots, I reach out for Email::MIME. Together, they make a pretty awesome duo. But… (come on, admit it, you knew there was going to be a ‘but’)
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…
This is just a quick post to share my first 3.1.1 Oracle VM Manager (OVMM) troubleshooting experience. After the initial installation I rebooted the server, tried to access OVMM https://ovmmhost:7002/ovm/console and received the following error in a browser screen…
It happens to be very short blog post as installation the Oracle VM Manager 3.1.1 under Dom0 host isn’t different from installing the previous version. For all tricks that you need to use please see my Oracle VM Manager 3.0.3 under Dom0 post.
I’ve recently upgrade couple of exadata to 18.104.22.168 and want to share the experience. I hope this short note will help someone to make the decision, calculate estimation and prepare for maintenance. I am going to talk about upgrade from the version 22.214.171.124 BP10 to 126.96.36.199 BP2.
I had a chance to talk to several Oracle Database Appliance users at the annual Collaborate 2012 conference last month in Las Vegas. And a common theme in this discussions, as well as discussions with Pythian clients, is an interest in using the ODA as a large-scale consolidation platform. I found this interesting and decided to dig a little further.