Database management

Stay with non-CDB or go to CDB?

By Franck Pachot . This is a question that starts to be raised quite frequently. Oracle released the multitenant architecture 1.5 year ago. And now says that the previous architecture – known as non-CDB – is deprecated. What does(…)

When to gather workload system statistics?

By Franck Pachot . This month we started to give our Oracle Tuning Workshop. And with a new workshop comes new questions. We advise to give to the optimizer the most accurate statsistics that we can have. That(…)

Oracle OPatch and “Archive not applied” error

Recently, I have installed an Oracle 11.2.0.4 RDBMS on a server, and I wanted to install the latest Patch Set Update (PSU) 11.2.0.4.4 from October 2014. During the execution, I fell on the error “Archive not applied” and the job(…)

NLS_LANG on Windows in Europe: WE8MSWIN1252 or WE8PC850?

By Franck Pachot . In europe we have accents and non US7ASCII characters. We need special characterset. I’m not talking about Unicode here that solves all the problems. If you have a Java application, you have no problem: it’s(…)

Insert into GTT: bulk with APPEND_VALUES

By Franck Pachot . This post is about the case I had where a GTT was generating too much undo. The effects were amplified by the fact that the database was in flashback logging (see Jonathan Lewis answer in(…)

Managed Backup with SQL Server 2014

In a previous blog post called Backup a SQL Server database from On-Premise to Azure, I presented the different tools to backup your on-premise databases on Azure Storage. SQL Server Managed Backup to Windows Azure was one of(…)

Oracle multitenant dictionary: upgrade

By Franck Pachot . This is a second part of the previous post about metadata link. I’ve shown how a sharing=metadata function becomes a sharing=none function when it is changed in the pdb – i.e when not having(…)

Oracle multitenant dictionary: metadata links

By Franck Pachot . As in previous posts (1 and 2) I’m still playing with multitenant dictionary. You may wonder why I’m spending time to do unsupported things that we will never be able to use in(…)

Oracle multitenant dictionary: object links

By Franck Pachot . I’ve described Oracle 12c metadata and object links internals in a previous post. But before that, the first time I investigated on it, I made a wrong assumption because I was looking at AUDIT_ACTIONS(…)

Creating a schema synonym in Oracle – an unsupported feature

By Franck Pachot . Ivica Arsov (@IvicaArsov) has made an interesting comment about AUDIT_ACTIONS object link table. I’ll blog about it soon, but in the meantime when checking its definition in cataudit.sql it came upon the following:(…)