Dissecting 171017 BP, PSU, RU and RUR

Starting today I will quarterly write a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. So what oracle internal objects were changed in 170117? VERSION PATCH OWNER TYPE TOTAL ——————– ——– —————————— —————————— ———- 11.2.0.4 BP SYS PACKAGE BODY 1 11.2.0.4 PSU …

Continue reading

v$sga, v$sgainfo and v$sgastat matching bytes challenge

Those days I was challenging myself to make an exact match and correlate all lines returned by a select on v$sga, v$sgainfo and v$sgastat. The biggest problem on those v$ views is that they bring different visions of the same thing (SGA), and I could never make a exact match of the bytes before. Now …

Continue reading

OCM 12c – The Saga

I decided to write this article to tell all the saga from the planning to the results of the OCM 12c Certification Exam that I did last month. So, with this, maybe I can inspire other people to try to get a OCM credential too! =] Well, shortly after I passed the OCM 11g in …

Continue reading

Oracle ACE Level Up!!

Hello everyone, I’m happy to announce that this week the Oracle ACE Program upgraded my ACE status one level up! =] I have started as ACE Associate in Oracle Community in 15th January 2016, after some years of writing technical articles in English and Portuguese specially in this blog and Oracle Technology Network. During the …

Continue reading

OCM 12c Preparation – Create RAC databases

After install the RAC software, this topic asks to create a new RAC database. This means that if you fail to install, you will have no way to create a RAC DB or services (nex topic), resulting in a lot of lost points. So it’s mandatory to do the previous topic and this with all …

Continue reading