Oracle

Filter posts by category

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
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
Oracle

Oracle RAC 11.2.0.3 on VMware ESXi

grid installation

The system was build up to test some tools, i.e. the new Oracle Cloud Control 12c, Toad for Oracle and Spotlight (Quest Software) with their RAC components and the HLMM (Herrmann & Lenz Monitoring Module). And this was not about “certificated” configurations or even to set up a productive environment, but about creating a RAC database with minimum effort.

Oracle RAC 11.2.0.3 on VMware ESXi Blogbeitrag lesen »

By • • 7 minutes of reading
Oracle

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

With Release 11g Oracle introduced the concept of the Automatic Diagnostic Repository (ADR) which (in theory) is an independant directory structure for all kind of logs and traces for the database, listener and other Oracle products. The content is mostly stored twice (as text or traditional trace file and in xml format). So the size of each individual directory can easily become several GB. Nothing to worry for todays disk spaces but annoying if you really need to find some relevant information. The good news is that there is a purge mechanism associated with it so that old logs and

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

By • • 2 minutes of reading
Scroll to Top