Oracle 12c DBUA and Datapatch

Johannes Ahrends

Meanwhile all customers applying Oracle databases should work on switching their database to Oracle 12c. While for Standard Edition Users (…)


read more

Move Partitions between Tables

Johannes Ahrends  5

You might wonder why you should move a partition from one table to another but actually there are several reasons. (…)


read more

Oracle 12c Unified Auditing – Part 2

Johannes Ahrends

Unified Auditing was introduced with Oracle 12c 12.1.0.1 and one idea is to combine standard auditing (AUD$) with fine grained (…)


read more

Oracle 12c Unified Auditing – Part 1

Johannes Ahrends  13

With Oracle 12c it is all getting better! And that includes the new auditing possibilities as well, which can be (…)


read more

Manage Audit Data

Johannes Ahrends  4

Over the last couple of years I was asked repeatedly because the SYSTEM Tablespace is constantly growing. The reason 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

VARCHAR2(32767) – Sense or Nonsense?

Johannes Ahrends

Maximum Columnsize for VARCHAR2 is now 32k! With Oracle12c you can define a column of data type VARCHAR2, NVARCHAR2 or (…)


read more

Automatic Memory Management – it’s great isn’t it?

Johannes Ahrends

As you might have read in my previous blogs I did some tests with Oracle 10g and 11g on Linu (…)


read more

Oracle RAC 11.2.0.3 on VMware ESXi

Johannes Ahrends  1

The system was build up to test some tools, i.e. the new Oracle Cloud Control 12c, Toad for Oracle and (…)


read more

Do you really need one year old Logs and Traces for your Oracle Database?

Johannes Ahrends

With Release 11g Oracle introduced the concept of the Automatic Diagnostic Repository (ADR) which (in theory) is an independant directory (…)


read more

What can CarajanDB do for you?