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…

Secure Your Joomla Website With 2FA

I recently upgraded my Joomla! site to version 3.9.2. As I was reading through the post installation messages I noticed that Two-Factor Authentication was available. How exciting, finally another layer of security around user authentication. Apparently the Two-Factor Authentication was added to the Joomla! core as of version 3.2: I’m a little late to the game but this feature is so cool and easy to implement that I have to spread the word.

Continue reading…

Flushing Shared Pool In Production DB

The Oracle Database Server is made up of two main components; the instance and database. The instance consists of memory structures and background processes, whiles the database is a collection of physical database files. If we look at the Oracle Database architecture we can see that there is an organized layout for the memory structures, in which we can find the main memory structure and it’s sub-memory structures.

Continue reading…

Faster Run-Time In Oracle 12c Data Pump Import

I remember when Data Pump was introduced in Oracle 10g database; it was ground-breaking at that time with all the cool features such as the ability to pause and resume an operation or even export/import an entire tablespace. Well if you thought that was exciting then hold on to your seat for what you are about to hear. Oracle 12c database allows you to suppress the generation of redo during a Data Pump import. 

Continue reading…

OBIEE Pre-req Check Failure on OEL 5.11

Did I Just Hit a Bug

A client recently asked me to provision Oracle Business Intelligence Enterprise Edition (OBIEE) on Oracle Enterprise Linux (OEL) 5.11 in their pre-prod environment. Even though this was my first time provisioning OBIEE on this specific version of the OS, I was still very confident that it would be a fairly easy deployment since I had recently deployed the same version of OBIEE on RHEL.

Continue reading…