Posts Categorized: Group Blog Posts
Movember is getting to and end… and what a ball we had at Pythian this month! The laughs, pictures and performances will stay in our memories for a long time, and on Facebook, Youtube, Twitter, etc…
I have just received notification of my acceptance into the Oracle ACE program and will enthusiastically support and continue to be an evangelist for the Oracle offerings though most of my heart lies in the same place as many current and previous personnel at this fine company – the CORE database technology.
GoldenGate discard files can get big and cumbersome. To address this, I have build a PL/SQL function to read the discard files thereby reducing the output to one line per error and it also means that I can apply SQL logic to filter out the unwanted entries. Here’s how to do it.
This post is the first in a series of discussions … perhaps you have never had the pleasure of needing to change a character set. If you have not and soon do, purchase a good sleeping bag as you may be at the office late for a few days to get the task accomplished.
I made this blog title intentionally provocative. However it isn’t far from the truth. Don’t believe me? Continue reading :)
Any database upgrade suppose to change SQLs’ execution plans for the better. In 99 cases out of 100 this is exactly what happens. What to do with rest 1% of the SQLs? This blog post is exactly about such unlucky case I have resolved today. Hope that you will learn something out of it. As always let me know what you think using the comments section at the end of the post.
Like every year, Pythian is once again holding a company-wide charity campaign to raise funds and awareness for for men’s health, specifically prostate cancer and male mental health. Sporting and sprouting the mustaches has already begun at Pythian and the game is on. While that happens, blogging fanfare also continues and this Log Buffer Edition in its Log Buffer #293 covers that and more.
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.
My tweet few days ago – “Personally I don’t see the point building ASM on (d)NFS. ASM suppose to exclude unnecessary layers. In NAS case it adds an additional layer.” Since then Oracle people in my Social Media environment helped me to find several legitimate reasons to run ASM on NAS. Thank you folks very much. Now I am sharing our common thoughts with the rest of the community.
While Oracle tech folks doing their best to explain meaning of not so many DNFS configuration file (oranfstab) parameters I still find an official description a bit confusing. Therefore I decided to share my understanding of the DNFS configuration parameters in hope that it will help someone or if my understanding is wrong someone corrects me :) So, if I am wrong please please please feel free to leave comments.