CarajanDB Experten-Blog

Filter posts by category

Uncategorized

Toad 12 and Oracle 12

data redaction

Is it by chance that within an interval of a few days both Oracle announced Oracle 12c and Dell Software announced Toad for Oracle v12? When I first saw Toad 12 (which was the first one), I was wondering about the features. As I generally don’t like reading documents I tried myself and immediately found a new feature named “Jump”. This helps a lot finding useful tools like the various compare options but is able to scan your directories and even the entire internet for additional information. So if you are new to Toad use it to find the tools;

Toad 12 and Oracle 12 Blogbeitrag lesen »

By • • 3 minutes of reading
Oracle

VARCHAR2(32767) – 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 32767 Byte (but not CHAR!). But why is that useful? Datatype CLOB or NCLOB are fit better for pure text fields of a certain size. They can be handled in chunks instead of manipulating the entire text at once and with the SecureFile option which is now default for CLOB and BLOB in Oracle12c the storage is much more efficient.

VARCHAR2(32767) – Sense or Nonsense? Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

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 and all Actions are connected to it as threads. With Oracle 12c it’s now possibe to run an instance with very few processes and all tasks are running as threads. This is named “Multi-Threaded Oracle“.

Oracle 12c – Where have all the processes gone …? Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Using Umlaute in US7ASCII – doesn’t work, does it?

Creating an Oracle database with character set U7ASCII should be an exception nowadays. So if you try dbca (database configuration assistant) in Oracle 11g you don’t even have the choice by default. But it’s still possible – in all current Oracle versions. If that’s what you really wanted – I don’t know!

Using Umlaute in US7ASCII – doesn’t work, does it? Blogbeitrag lesen »

By • • 5 minutes of reading
Uncategorized

Quest Backup Reporter

backup-overview

Since April 21st there is the new Quest Backup Reporter. With this it is really simple to create reports on Oracle RMAN backups. The backup reporter gets the data from the control files and/or the RMAN catalog, if this exists. It is very interesting that in the control file more information about the backup is saved than in a RMAN catalog and this is exactly the reason why you can use both sources simultaneously with the backup reporter.

Quest Backup Reporter Blogbeitrag lesen »

By • • 2 minutes of reading
Uncategorized

Switch from WE8 Character Set to Unicode

As mentioned in my blog “Character Set Conversion with CSALTER – Does that actually work?” it is however possible to change the character set of the database with CSSCAN or CSALTER, but that does not help if you saved US7ASCII characters in the database, as it is quite usual in Europe, because only the data dictionary is being adjusted but not the data in the tables.

Switch from WE8 Character Set to Unicode Blogbeitrag lesen »

By • • 7 minutes of reading
Oracle

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 for the German Oracle User Group (DOAG) I did some tests with Automatic Memory Management and in this blog I like to share some experiences with you.

Automatic Memory Management – it’s great isn’t it? Blogbeitrag lesen »

By • • 7 minutes of reading
Uncategorized

Changing the IP Addresses in a RAC Cluster in the Oracle 11g Release 2 (11.2.0.3)

Due to moving into the new office I had to change several configurations in my infrastructure. Sure, the Linux and Windows systems were changed very quickly, the virtual machines did not cause any problems either. The switch of my RAC cluster then was a little bit more difficult, because it is not all done by changing the entries in the /etc/hosts, there is actually much more required.

Changing the IP Addresses in a RAC Cluster in the Oracle 11g Release 2 (11.2.0.3) Blogbeitrag lesen »

By • • 4 minutes of reading
Scroll to Top