All articles

Is your DBA_FEATURE_USAGE_STATISTICS up-to-date?

By Mouhamadou Diaw Last day we were doing a licensing review for a client. As many dbas may already know, this require to execute some oracle scripts at OS level and database level. Among these scripts we have the(…)

Speaking at the next SQL Nexus at Copenhagen 2017

On May 2nd, I will have the chance to speak during the next SQL Nexus event in Copenhagen (1 -3 may) about SQL Server 2016 and availability groups and if I have(…)

Oracle 12c – Is VKTM always your top process?

By William Sescu If VKTM is always your top cpu consuming process, then this blog might be something for you. Especially in virtual environments, I have seen often the VKTM process as the top process, even if the VM was(…)

Oracle 12c – How to Recover lost DataGuard Broker Configuration Files

By William Sescu If you are using RMAN to back up your database, you are already doing the right thing. However, RMAN does not take care of everything. e.g. it is not backing up the following things, to mention just(…)

Introducing AlwaysOn availability groups on Linux

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That(…)

Oracle 12cR2: Online tablespace encryption

By Franck Pachot . By default, all data is visible in the datafiles. Transparent Tablespace Encryption (TDE) can be used to get them encrypted. It requires Enterprise Edition plus Advanced Security Option. Except in the Oracle Cloud when it is(…)

12cR2: Recover nonlogged blocks after NOLOGGING in Data Guard

By Franck Pachot . You can accept to do NOLOGGING operations on bulk loads or index build according that you do a backup just after, and that your recovery plan mentions how to load the data again in case(…)

Oracle 12c – Recreating a Controlfile in a Data Guard environment with noresetlogs

By William Sescu Sometimes you might run into situations where the controlfile does not represent the backups and archivelogs correctly, because of a mismatch of the control_file_record_keep_time and the RMAN retention. The controlfile has non circular and a circular records.

12c Unified Auditing and AUDIT_TRAIL=DB in mixed mode

By Franck Pachot . Oracle enables some auditing by default, and if you don't do anything, the tables where it is stored will grow in SYSAUX. Don't wait to get an alert when it is too late. Everything that fills(…)

BLOG Technoark 2017 Conference – Blockchain, beyond the bitcoin.

BLOG Technoark 2017 Conference – Blockchain, beyond the bitcoin. and How applying Blockchain for Enterprise security and data management. I post a brief personal impression of the TechnoArk Conference 2017 in TechnoArk center(…)