Database / Cloud / Automation

rdbms

How To Rename An Oracle PDB

June 11, 2019 Richard Koranteng Blogs Technology

The concept of a multitenant database was introduced in Oracle database 12c. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that houses pluggable databases (PDB).

Oracle Database 18c Silent Installation On RHEL 7

March 24, 2019 Richard Koranteng Blogs Technology

This blog describes silent installation and configuration of Grid Infrastructure 18c (64bit) and Oracle Database 18c (64bit) on RHEL 7. The implementation described in this blog is based on a server installation with a minimum resource allocations required by Oracle.

Flushing Shared Pool In Production DB

April 19, 2017 Richard Koranteng Blogs Technology

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.

Faster Run-Time In Oracle 12c Data Pump Import

August 10, 2016 Richard Koranteng Blogs Technology

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.