All articles

Failed to set logmining server parameter MAX_SGA_SIZE to value XX

When you see something like this in your GoldenGate error log when you try to start an extract: 2017-04-12 14:51:38 ERROR OGG-02039 Oracle GoldenGate Capture for Oracle, extxxx.prm: Failed to set logmining server parameter MAX_SGA_SIZE to value 24. 2017-04-12 14:51:38(…)

PostgreSQL 10 is just around the corner, time to dare the switch?

Some days ago Robert Haas published a great blog post about the features you can expect for the upcoming PostgreSQL 10 (probably in September this year). Beside of what Robert is describing in his blog: Do you(…)

Documentum – Deactivation of a docbase without uninstallation

At some of our customers, we often install new docbases for development purposes which are used only for a short time to avoid cross-team interactions/interferences and this kind of things. Creating new docbases is quite easy with Documentum but it(…)

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

Trace files segmented in multiple parts as a workaround for bug 23300142

Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc(…)

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

Can I do it with PostgreSQL? – 14 – optimizer hints

This is a question that comes up quite often: How can I use optimizer hints in PostgreSQL as I can do it in Oracle? Well, you cant, and the reasons are this: Poor(…)

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