Database Administration & Monitoring

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

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

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