Database Administration & Monitoring

CDB resource plan: shares and utilization_limit

By Franck Pachot . I'm preparing some slides about PDB security (lockdown) and isolation (resource) for DOAG and as usual I've more info to share than what can fit in 45 minutes. In order to avoid the frustration of(…)

Documentum story – Monitoring of WebLogic Servers

As you already know if you are following our Documentum Story, we are building, working and managing, for some time now, a huge Documentum Platform with more than(…)

Manage Azure in PowerShell (RM)

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at(…)

How to destroy your performance: PL/SQL vs SQL

Disclaimer: This is in no way a recommendation to avoid PL/SQL. This post just describes a case I faced at a customer with a specific implementation in PL/SQL the customer (and me) believed is the most efficient way of doing(…)

MariaDB: audit plugin

Why should you Audit your MySQL Instances? First to provide you a way to track user accessing sensible data Secondly to investigate on suspicious queries in all your critical databases Thirdly to comply with law and industry standards(…)

Partitioning – When data movement is not performed as expected

This blog is about an interesting partitioning story and curious data movements during merge operation. I was at my one of my customer uses intensively partitioning for various reasons including archiving and manageability. A couple of days(…)

OTN Appreciation Day : External tables

As part of the OTN Appreciation Day (see https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/) I’m writing about one of my favorite Oracle features: External tables. Traditionally people loaded data in an Oracle database using SQL*Loader. With the introduction of external tables, SQL*Loader became obsolete (in(…)

OTN Appreciation Day – tnsping

By William Sescu Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. I do have a lot of favorite(…)

OTN Appreciation Day : ADVM

Tim Hall had the idea that as many people as possible would write a small blog post about their favorite Oracle feature and we all post them on the same day. Here is my favorite feature: ADVM -(…)

Oracle 12c – Managing RMAN persistent settings via SQL

By William Sescu RMAN persistent settings can be managed in two different ways. Via the RMAN interface – e.g. RMAN> CONFIGURE BACKUP OPTIMIZATION ON; Via SQL – e.g. VARIABLE RECNO NUMBER; EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG(‘BACKUP OPTIMIZATION’,’ON’); There(…)