Flashback Functions – One Name, different Techniques

Johannes Ahrends

Since version 9i there is the term “Flashback” in the Oracle Technology. However it is often hard to harmonize the (…)


read more

Be careful when setting the DBTIMEZONE!

Johannes Ahrends  5

Why you should not set the DBTIMEZONE to a “Location Time Zone” format in Oracle. First of all, the DBTIMEZONE (…)


read more

Second SCAN-Listener

Johannes Ahrends

Since Oracle 12c you create and use a second (or even more) SCAN-Listener for Load-Balancing, Failover, etc. This can be (…)


read more

Prevent PDB creation in a Single Tenant environment

Johannes Ahrends  1

How do I prevent the creation of a second PDB in a Single Tenant environment? At last Oracle introduced a (…)


read more

Datapump or Flashback Database

Johannes Ahrends

Do you need Datapump? At nearly every customer I’m visiting there is a need to take export dumps of the (…)


read more

inMemory on Oracle RAC

Johannes Ahrends  4

In my last blog I described my first experience with inMemory at a customer side. I was really impressed about (…)


read more

Oracle inMemory – First experiences

Johannes Ahrends

With Oracle 12.1.0.2 the brand new database option named inMemory has been introduced. There are many blogs and articles out (…)


read more

Optimized Multitentant Database Configuration

Johannes Ahrends

Talking to customers about Multitenant database several of them complained that you need to install all database features regardless if (…)


read more

Data Guard Protection Modes

Johannes Ahrends  3

The availability and consistency of the Standby Database changed evermore throughout the last years and by that the loss of (…)


read more

What can CarajanDB do for you?