Database Reorganization

Johannes Ahrends

Talking about reorganization very often end up into tough discussions about the pros and cons of reorganization. The reason is (…)


read more

Automatic Maintenance and Optimizer Statistic Collection managing with 12c and 11g

Johannes Ahrends  10

Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is (…)


read more

Extended Data Types with VARCHAR2(32767)

Johannes Ahrends  1

In the Oracle 12 New Features Guide you will find this sentence: “The maximum size of the VARCHAR2, NVARCHAR2, and (…)


read more

Flashback Archive second Edition

Johannes Ahrends

Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge (…)


read more

Table Recovery

Johannes Ahrends

Very many customers are using export / import or data pump as a backup solution in case they are losing (…)


read more

Resource Management with Pluggable Database

Johannes Ahrends

There have been many Blogs around Pluggable Databases and very often the bloggers (and DBAs of course) are complaining that (…)


read more

How to limit CPU-Consumption of a database

Johannes Ahrends  1

With the trend to consolidate more and more databases on a single server the question arises how to limit the (…)


read more

Database virtualization and instant cloning … and 12c

Johannes Ahrends

Clone Wars When we’re hearing „Clone“, most people will associate it with Star Wars the Clone Wars … something like (…)


read more

Pluggable Database Management with Toad 12.1

Johannes Ahrends

Multitenant Database Multitenant or pluggable database is probably the most discussed feature in Oracle 12c. For many of us DBAs (…)


read more

My Database becomes invisible

Johannes Ahrends

Invisible Indexes With Version 11g Oracle introduced invisible Indexes and I had several discussions with customers why it makes sense (…)


read more

What can CarajanDB do for you?