Blog

Servicename or not?

Johannes Ahrends

Few weeks ago I had issues with naming conventions: In one of my projects a cloning software should be used. (…)

read more

OTN Appreciation Day – Thanks OTN

Johannes Ahrends

Many people shared their favorite Oracle feature as blog post. Currently Oracle 12.1 is the most actual version but 12.x (…)

read more

Multitenant in a Dataguard Environment

Johannes Ahrends  2

Actually I have a project where we are going to set up a high availability infrastructure with RAC and Dataguard. (…)

read more

7 easy steps to configure HugePages for your Oracle Database Server

Johannes Ahrends  8

Hugepages and Large Pages If you run a Oracle Database on a Linux Server with more than 16 GB physical (…)

read more

Flashback Query – Part 3

Johannes Ahrends

In my last blog about Flashback Query “Flashback Query – Part 2” I had to admit that with Oracle Database (…)

read more

Flashback Query – Part 2

Johannes Ahrends

In my last blog “Flashback Functions – One Name, different Techniques“, I wrote about Flashback Functions. In this blog I (…)

read more

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

What can CarajanDB do for you?