All articles

Listing the extensions available in PostgreSQL

When you follow this blog regularly you probably already now that PostgreSQL is highly extensible. There are quite a couple of extension which ship by default and are ready to use. How can you know what is(…)

SQLcl on Bash on Ubuntu on Windows

By Franck Pachot . I'm running my laptop on Windows, which may sound weird, but Linux is unfortunately not an option when you exchange Microsoft Word documents, manage your e-mails and calendar with Outlook and present with Powerpoint using dual(…)

In-core logical replication will hit PostgreSQL 10

Finally in PostgreSQL 10 (expected to be released this September) a long awaited feature will probably appear: In-core logical replication. PostgreSQL supports physical replication since version 9.0 and now the next step happened with the implementation of logical replication. This(…)

8 + 1 = 9, yes, true, but …

Btw: If you really would do that (the screen shot is from 12.1.0.2): SQL> alter system set sga_target=210m scope=spfile; System altered. SQL> alter system set sga_max_size=210m scope=spfile; System altered. SQL> alter system set pga_aggregate_target=16m scope=spfile; System altered. SQL>(…)

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

Using WebLogic 12C RESTful interface to query a WebLogic Domain configuration

WebLogic 12.2.1 provides a new REST management interface with full accesses to all WebLogic Server resources. This new interface provides an alternative to the WLST scripting or JMX developments for management and monitoring of WebLogic Domains. This blog(…)

Welcome to M|17

Welcome to the MariaDB’s first user conference On the 11th, started at 09:00 this big event at the Conrad Hotel in New York, closed to the One World Trade Center After the short registration process where we(…)

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