Knowledge Base

What should I use - "Oracle Data Redaction" or "Oracle Data Masking"

In 12c Oracle introduced a new feature called "Data Redaction" – Limiting sensitive data exposure by dynamically changing returned data. Since Oracle Data Reduction feature was introduced it feels that a lot of people are confused by this feature with data masking pack, I am getting a lot of questions like:

  • What the difference between "Data Redaction" and "Data Masking"?
  • When should I data redaction and when should I use data masking?
  • Now that I have can use data redaction why should I use data masking?

Read more: What should I use - "Oracle Data Redaction" or "Oracle Data Masking"

Parallel Features in Oracle 11gR2

Oracle 11gR2 brings us new features related to parallelism. The new features are controlled by the PARALLEL_DEGREE_POLICY initialization parameter.

Read more: Parallel Features in Oracle 11gR2

How are Numbers Saved in Oracle

I’ve been asked quite a few times about the difference between number and character columns in Oracle. So I decided to write this article in order to explain how things work.

Many people, mainly those with programing background, assume that Oracle, like programming languages, contains character columns that work like STRING in programing languages, and number columns that work like INTEGER, DOUBLE and similar in programing languages. If this is the case, working with numbers in Oracle is much more efficient than text, the value has a static size of 4 or 8 bytes, the CPU works with number natively in math calculations, and therefore, number columns are better (when relevant).

However, this is not the case.

Read more: How are Numbers Saved in Oracle

Oracle Listener Registration

In Oracle environment, we have a special component that listens to network requests to connect and pass them on to the instance. This is the listener, of course. We need to remember that a single listener can serve several instances, and a single instance can be served by several listeners. So in order to do its job, the listener needs to know all the instances it serves.

Read more: Oracle Listener Registration

Oracle RAC crashing with error "Waited 15 secs for write IO to PST"

Oracle RAC 11g on VMware environment keep crashing, the following errors repeat in the cluster alert log :

"Waited 15 secs for write IO to PST"

Read more: Oracle RAC crashing with error "Waited 15 secs for write IO to PST"

Oracle Patching

Lately, I talked to several customers about Oracle patches, and each time it takes me quite a while to explain how it works. 

So for all of you who don’t know about the different patching options (and what’s new in 12c), here is a short explanation about the topic.

Read more: Oracle Patching