Category Archives: Oracle(E)

VARCHAR2(32768) – Sense or Nonsense?

Maximum Columnsize for VARCHAR2 is now 32k! With Oracle12c you can define a column of data type VARCHAR2, NVARCHAR2 or RAW with a maximum length of 32768 Byte (but not CHAR!). But why is that useful? Datatype CLOB or NCLOB … Continue reading

Gallery | Tagged , , | 3 Comments

Oracle 12c: where have all the processes gone … ?

Multi-Process Multi-Threaded Oracle If you are running Oracle databases on Unix or Linux you probably know that there are many processes even if no user is connected. But if you run Oracle on Microsoft Windows you only see one processes … Continue reading

Gallery | Tagged , , | Leave a comment


Hi I just switched my blog to Unfortunately all comments on current blogs have been removed.

Gallery | Leave a comment

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

As you might have read in my previous blogs I did some tests with Oracle 10g and 11g on Linu 6 Update 1 – and it works even though there is no official support from Oracle. Due to a presentation … Continue reading

Gallery | 4 Comments

Oracle 10g RAC Database with Grid Infrastructure 11.2 on Oracle Enterprise Linux 6U1 64Bit

Yes I know, it’s not supported and looks a bit crazy. But as I was using Linux 6 already with my RAC Database (see other blogs) and had to do some tests with an Oracle 10g database I tried to … Continue reading

Gallery | 5 Comments

It’s so easy to use RMAN for Backups

It’s quite interesting that very many DBAs still use other methods than RMAN to backup their databases. I don’t mean the highend solutions like splitmirror but export / import or offline backups with OS-methods. But it’s so easy to backup … Continue reading

Gallery | 16 Comments

Oracle RAC on VMware ESXi

I needed a RAC environment to test some tools like the new Oracle Cloud Control 12c, Toad for Oracle and Spotlight from Quest Software with their RAC extensions and a monitoring tool from Herrmann & Lenz Services (HLMM). Therefore I … Continue reading

Gallery | 4 Comments