Oracle

12c multitenant: Cursor sharing in CDB

By Franck Pachot . In multitenant, there are two goals: consolidation within the same container database and isolation of pluggable databases. I see multitenant consolidation as an extension of schema consolidation. What is not possible in schema consolidation, such as(…)

Conversion to Flex ASM with asmca takes 5 minutes

By Franck Pachot . In 12c Oracle recommands Flex ASM. You can opt for it at Grid Infrastructure installation, but it's very easy to convert to it later from asmca. It has to configure(…)

Any reason to change the C## common user prefix?

By Franck Pachot . In 12.1.0.1 the common user prefix was set to C## by an underscore parameter. In 12.1.0.2 it's a documented parameter and you can change it. But is there any reason for that?(…)

Resource Manager plan from OEM vs. command line

By Franck Pachot . You are rather GUI or command line? Let's compare what you can do with them when you want to create a Resource Manager plan, and what is missing in the GUI.

Easy transport of SQL Tuning Sets with OEM

By Franck Pachot . When you want to transport a SQL Tuning Set between production and test for example, you have to pack it into a table, then export the table, import it into the target database, and unpack the(…)

GTT in Exadata are eligible to SmartScan

By Franck Pachot . I wanted to check if Exadata predicate offloading can occur on Global Temporary Tables. Actually, I thought it did not and I was wrong. I was ready to post that as an hypothesis for(…)

Standard Edition 2 testing the 16 thread limitation

By Franck Pachot . From 12.1.0.2 the Standard Edition - now called Standard Edition 2 - has a few limitations that were not there in SE and SE1. One of them is the limitation to 16 threads. Let's see how(…)

EM 13c target is fully broken !!

At a client’ site I decided to install the Enterprise Manager Cloud Control 13c. I did not encountered any special problem :=) , then I installed an agent 13c on the development plattform and added targets as usual, but at(…)

The taboo of ‘underscore parameters’

By Franck Pachot . Oracle provides lots or parameters that can control the behavior of the software. The default values are probably the best ones most of the time. Hundreds of parameters are documented and we can set them to(…)

Enable 10046 Tracing for a specific SQL

Available methods to enable 10046 trace are described in My Oracle Support Note 376442.1. You can enable 10046-tracing – on session level (alter session) – for other sessions (e.g. with oradebug, the package DBMS_MONITOR or DBMS_SYSTEM) What is not(…)