CarajanDB Experten-Blog

  • All
  • General
  • Oracle
Uncategorized

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c

Starting with Database Version 11g, Oracle offers with Direct NFS an integrated NFS-Client, which is independent from the underlying OS-based NFS-Client. This allows direct access to the NFS storage for the Oracle Instance and realizes Oracle’s own optimizations. In addition, one can implement multipathing over four parallel ports, independently from any switches, NIC bonding or teaming. The Oracle Instance configures the communication with the NFS automatically and thus facilitates the configuration under RAC. Using Oracle Direct NFS, shortly dNFS, also provides using NFS Storage with Oracle Instances on Windows systems.

Oracle Direct NFS configuration using Linux or Windows with 11g and 12c Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

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

AMT 01

Theoretically, the Automatic Maintenance Tasks which controlled the automatic optimizer statistics can easily configured via Cloud Control. The problem is that, with version 12c, the database comes by standard only with the Enterprise Manager Database Express 12c. With EM Express you can only get to know that Automatic Maintenance is in use or it is not (Configuration > Used database features). In the “standard” Enterprise Manager 11g the appropriate configuration option still was installed (Server > Automated Maintenance Tasks). So the only way with 12c beside Cloud Control is the command line. The following works with both 12c and 11g.

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

By • • 3 minutes of reading
Oracle

Extended Data Types with VARCHAR2(32767)

JA-Blog-042514-1

In the Oracle 12 New Features Guide you will find this sentence: “The maximum size of the VARCHAR2, NVARCHAR2, and RAW data types has been increased from 4,000 to 32,767 bytes“ Increasing the allotted size for these data types allows users to store more information in character data types before switching to large objects (LOBs). This is especially useful for brief textual data types and the capabilities to build indexes on these types of columns.” ( Oracle® Database New Features Guide 12c Release 1 (12.1) E17906-16 Page 1-13 What great news! Especially if you want to upgrade your database to

Extended Data Types with VARCHAR2(32767) Blogbeitrag lesen »

By • • 7 minutes of reading
Uncategorized

Flashback Archive second Edition

Flashback Archive becomes more and more my top Oracle feature as it is easy to implement and has a huge advantage for all kind of applications and compliance of course. So in my blog from January 2014 I already explained the idea of flashback data archive. Some of you might found some time to test and wondering about additional features or behaviors they wouldn’t have expected.

Flashback Archive second Edition Blogbeitrag lesen »

By • • 5 minutes of reading
Uncategorized

Dbvisit Standby 7.0 the refurbished standby database solution for Oracle

01 Dbvisit Standby 7

The new version of Dbvisit Standby is released, so I will take this cause to describe the “Smart Alternative” in detail. Of course this release will bring us also new features. Now we do not only create a standby database with some clicks by minutes. With the new version we can define an exact point in time, which our standby database shall reflect. Altogether the DBA gets a simple opportunity to provide reporting and testing databases. In the next lines I will give an overview how you can create a new database composed of your existing data within 10 minutes.

Dbvisit Standby 7.0 the refurbished standby database solution for Oracle Blogbeitrag lesen »

By • • 6 minutes of reading
Uncategorized

Table Recovery

Very many customers are using export / import or data pump as a backup solution in case they are losing a table or some content for several years now. But as the database size increases the size of the export and more problematic the time needed for the export increases as well. Most recently one of my customers was facing the problem that the time window he specified for the ordinary backup, the export and some batches was no longer sufficient. Instead the batch run hasn’t finished when the users came back to work in the morning. So the question

Table Recovery Blogbeitrag lesen »

By • • 4 minutes of reading
Uncategorized

Resource Management with Pluggable Database

There have been many Blogs around Pluggable Databases and very often the bloggers (and DBAs of course) are complaining that the individual pluggable databases are competing for resources since there is only one SGA, one set of Redo logs and one Undo-Tablespace.That’s true and should be taken into account whenever production databases are being consolidated into one container. But for the CPU and degree of parallelism it is possible to limit the usage or prioritize some PDBs. In addition to the already existing Resource Plans (which can be used within any pluggable database as well) Oracle introduced CDB Resource plans

Resource Management with Pluggable Database Blogbeitrag lesen »

By • • 3 minutes of reading
Uncategorized

Flashback Query

It was in 2001 when the Oracle Open World came to Germany and a well known representative from Oracle announced Oracle9i with the exciting new features. One of those was named “Flashback Query” and in his speech he said something similar to: “with our new Flashback technology you are able to query past data no matter if it is days, weeks or even months old”. Wow that’s ambitious and it will probably open the arena for new applications. Unfortunately the reality was slightly different to the announcement: Flashback Query is relying on the undo information stored in the Undo-Segments. Let’s

Flashback Query Blogbeitrag lesen »

By • • 4 minutes of reading
Scroll to Top