Richard Koranteng

Keeping Your Database Up To PAR Isn’t Enough In 2019

Ensuring the database is up to PAR (Performance, Availability, Recoverability) has long been the focus of database administrators everywhere. Although this is still true, it is no longer an accurate depiction of the full scope of a DBA’s responsibilities. Modern businesses operate as online data driven machines. The demand and value placed on data, coupled with the current cyber security concerns means that database administrators have to redefine their focus. This blog is intended for DBA’s looking to a add value in a modern IT world. I will mention technology implementations specific to Oracle databases, however the concepts mentioned in this blog post are applicable to any database platform.

Continue reading…

Flashback An Oracle Data Guard Database

Logical mistake, end of testing cycle, need to rollback database to a previous state? RMAN restore can help, however there’s an easier way: we can address these scenarios with the Flashback technique. In the case of a standalone Oracle database, there is nothing special to take into account when performing flashback. However, performing flashback of a Data Guard environment needs special treatment of the Standby Database to ensure data consistency. This article will show you how to do that:

Continue reading…

How The Whole Blogging Thing Is Working Out For Me, Year 3

Why I Started Writing Blogs

In July 2016, I wrote my first blog on Earlier that year  (June 2016), I made a big career decision to jump into independent consulting. I faced alot of challenges, mainly how to secure my first customer and how to market my capabilities. After months of hard work, I eventually landed my first project, however I was still unclear about how to promote my services. Fast forward a few months later, I figured the best way to market my capabilities was to establish my online brand and provide value to my online audience.

Continue reading…

Disabling Transparent HugePages On RHEL 7

Transparent HugePages (THP) memory is different from standard HugePages memory because the kernel thread allocates memory dynamically during runtime. Standard HugePages memory is pre-allocated at startup, and does not change during runtime. This dynamic memory allocation of THP can cause memory allocation delays during runtime. To avoid performance issues, Oracle recommends that you disable THP on all Oracle Database servers. Oracle recommends that you instead use standard HugePages for enhanced performance.

Continue reading…

I Am Happy AWS Is Leaving Oracle

As you all know, I’m a huge advocate for Oracle’s database technologies and Amazon Web Services IaaS platform. There is no denying that these two corporations have built awesome systems that can be leveraged to support enterprises of all sizes – it’s like a perfect relationship. However, there is trouble in tech paradise.  AWS CEO Andy Jassy says Amazon will be off Oracle databases by the end of 2019. What does this breakup really mean and why should you be excited about it?

Continue reading…