Oracle character set basics

In this entry I try to explain some basic facts about character sets in Oracle Databases and the most current issues with them. The databases can store different types of information, numbers, dates, characters, raw data (data with a format know by the owner but not necessary by the database) among others, but internally all […]

Read more "Oracle character set basics"

Cluster Health Monitor Database size, or who is filling my clusterware volume?

Inside most installations of Oracle Clusterware 11g exists an “Berkeley DB” database used to store system performance data. This database also exists on the initial release of 12g (12.1.0.1) database, and after that (from 12c patch1 or 12.1.0.2) this “Berkeley DB” is replaced by an Oracle DB (called “Grid Infrastructure Management Repository”) This database is […]

Read more "Cluster Health Monitor Database size, or who is filling my clusterware volume?"

Oracle expdp and impdp hints

The expdp and impdp tools appeared in Oracle 10g many years ago, from that moment these were the “supported” way to export and import information from Oracle Databases (in Oracle proprietary format). In this post I’ll try to explain the most misunderstood/not known points of this tools. An export is not a backup. Well, so […]

Read more "Oracle expdp and impdp hints"