Database Administration & Monitoring

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.

Transactional DDL

When you are working on Oracle you probably learned that each DDL does an implicit commit in the background. There is no way to have DDLs wrapped in a real transaction (with the exception of the “create schema” command which(…)

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

Install PL/JAVA in Postgres Plus Advanced Server 9.5

While doing a project at a customer we came to a point where we needed to install pl/java into Postgres Plus Advanced Server 9.5. If you follow the official documentation you will probably fail(…)

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

Sudden drop of the page life expectandy but don’t panic yet!

A couple of weeks ago, I had an interesting discussion with one of my customer about the page life expectancy (aka PLE). He asked me if monitoring the metric value is a best practice because he often noticed a big(…)

SQL Server Database failed to generate a checkpoint

Last time, I experienced a strange error when I tried to perform an integrity check or a simple checkpoint of a database: One or more recovery units belonging to database ‘mydatabase’ failed to generate a checkpoint. This is typically caused(…)

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