Oracle Team

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(…)

Always-on Monitoring EM 13C

As the Enterprise Manager Cloud 12c is configured for sending warnings and alerts if a target database is down, what’s happening if the Enterprise Manager Repository database crashes? With Enterprise Manager Cloud Control 12c, a quite good solution is available: after(…)

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(…)

Dataguard Environment and Database Tempfiles

By Mouhamadou Diaw Last day I found a curious message in the backup alert log in a dataguard environment. The message was related to an issue with the resync catalog and was something like 1 2 3 4 RMAN-00569: ===============(…)

GoldenGate 12.2 parameter file check

Today I will talk about the new parameter file checks available to continue the series of blog posts about the new features of GoldenGate 12.2. There are three themes that I will present you: Checkprm utility Info param Getparaminfo Checkprm(…)