(Hemant K Chitale) In the 12c MultiTenant architecture, you can backup (and restore) individual PDBs. However, you must also backup the CDB (Root) ! You cannot restore a PDB as a “standalone” database — it has to be restored back to the CDB.

(Jeff Smith) I have a very simple, and not very elegant stored procedure.

(Jan Kettenis) Ever had a case with the Oracle BPM Suite where you wanted to create a BPMN model while hiding the details from the reader? Then the “refine” feature may be what you are looking for. Read on if you want to know more about this feature that has been added since 12c. I actually blogged

(David Fitzjarrell) Histograms, in Oracle or most any other relational database, may be one of the most misunderstood and as a result, underused features. Tales abound of performance problems that histograms create by changing once-good plans to terribly inefficient and wasteful resource hogs.

(Mahir M. Quluzade) Prior to Oracle Database 12c Release 2 have a problem with long identifier name, for example, in 11.2 version you cannot create long name (max 30 Bytes) tables. As you see, from screenshots length of table name column is maximum 30.

(Andrejus Baranovskis) When you get fresh instance of Oracle Java Cloud, you are assigned with one admin and one managed server. If there is requirement to host multiple environments – demo, production, etc. – one managed server is not enough.

(Ivica Arsov) In this blog post I’ll demonstrate a scenario where dropping a potentially ‘unused’ index can have a negative influence on the optimizer’s cardinality estimation. Having columns with logical correlation and skewed data can cause difficulties for the optimizer when calculating cardinali

(Lucas Jellema) Oracle PaaS Service Manager (PSM) provides a command line interface (CLI) with which you can manage the lifecycle of various services in Oracle Public Cloud. This opens the door for scripting (recurring) tasks – such as (re)deployment of applications on ACCS to provisioning new envir

(Kim Berg Hansen) Collation in Oracle 12cR2 gives some more finegrained possibilities for setting up how your data is to sorted and compared linguistically. A lot we could do before with NLS_SORT and NLS_COMP and the likes, but the collation features can both be simpler to use as well as offer more

(Martin Bach) After the baseline has been established in the first part of this series it’s time to measure the effect of the network in this part. The second test will introduce an interesting feature: Using Linux’s own Traffic Shaper/Quality of Services module I will add a delay of 100ms to the Da