Database Administration & Monitoring

Does the wal segment size matter in PostgreSQL?

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the(…)

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first(…)

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log: 2017-04-12 14:56:08 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, extimch.prm: Replication of UDT and ANYDATA from redo logs is not supported with the(…)

Welcome to M|17, part 2

Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate(…)

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

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