Database Administration & Monitoring

ODA – 32GB template but got a database with 16GB SGA???

I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a(…)

Purging Unified Audit Trail in 12cR1

By Franck Pachot . When you want to empty a table you have two methods: delete and truncate. If, for any reason (see previous post) the Unified Audit Trail has become too big, you cannot directly delete or truncate(…)

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