Oracle Team

Oracle 12c – Why you shouldn’t do a crosscheck archivelog all in your regular RMAN backup scripts

By William Sescu Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes(…)

Service “696c6f76656d756c746974656e616e74” has 1 instance(s).

By Franck Pachot . Weird title, isn't it? That was my reaction when I did my first 'lsnrctl status' in 12.2: weird service name... If you have installed 12.2 multitenant, then you have probably seen this strange service name registered(…)

12cR2 DML monitoring and Statistics Advisor

By Franck Pachot . Monitoring DML to get an idea of the activity on our tables is not new. The number of insert/delete/update/truncate since last stats gathering is tracked automatically. The statistics gathering job use it to list and prioritize(…)

OUD – Oracle Unified Directory 11.1.2.3, Oracle generates more and more LDAP lookups with every release

By William Sescu After installing OUD some time ago, I was doing some tests to see how it performs, and as long as I do ldap searching on the command line it looks very good. I am running Unified Directory(…)

OUD – Oracle Unified Directory 11.1.2.3 Tuning, It is not always the servers fault

By William Sescu The default configuration which is shipped with OUD is not meant to be ready for enterprise usage. The default settings of OUD are targeted at evaluators and developers who run equipment with limited resources, and so it(…)

12cR2 DBCA, Automatic Memory Management, and -databaseType

By Franck Pachot . This post explains the following error encountered when creating a 12.2 database with DBCA: [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB. or when creating the(…)

When automatic reoptimization plan is less efficient

By Franck Pachot . 11gR2 started to have the optimizer react at execution time when a misestimate is encountered. Then the next executions are re-optimized with more accurate estimation, derived from the execution statistics. This was called cardinality feedback. Unfortunately,(…)

OUD – Oracle Unified Directory 11.1.2.3 Backups Tips and Tricks

By William Sescu Backing up an OUD consists of several components The OUD software itself The OUD back end data The OUD configuration The OUD logical export as a ldif file However, in this post I would like to take(…)

JAN17 Proactive Bundle Patch + Adaptive Statistics control

By Franck Pachot . If you have to create a new database now (I'm writing this in March 2017) for a migration of OLTP database with minimal risks of regression, I would recommend: The latest patchset of Oracle Database 12cR1(…)

Purging Unified Audit Trail in 12cR2

By Franck Pachot . A good thing from 12.2 is that the implementation of Unified Audit Trail has changed a little. It was stored in a weird CLI_SWP$ table but now we have a normal partitioned table named AUD$UNIFIED. In(…)