Database Administration & Monitoring OCM 12c preparation: documentation 18.12.2015 by Oracle Team By Franck Pachot . The OCM exam advice says: Be prepared to use the non-searchable documentation during the exam, to help you with correct syntax. I've checked that I can find quickly the documentation related with each topic listed. Here(…)
Database Administration & Monitoring OCM 12c preparation: Explain fast refresh 17.12.2015 by Oracle Team By Franck Pachot . There are some rules to be able to fast refresh a materialized view (which means, refresh it so that it is not stale, and without running the whole query). Documentation is in the Datawarehouse Guide, but(…)
Database Administration & Monitoring, Oracle OCM 12c preparation: Transportable Tablespaces 15.12.2015 by Oracle Team By Franck Pachot . I use transportable tablespaces a lot since 8i, here are just a few examples. Same disclaimer here as in the first post of the series: don’t expect to get those posts close to what(…)
Database Administration & Monitoring, Database management pg_dump: [archiver (db)] query failed: ERROR: schema “sys” does not exist 15.12.2015 by Daniel Westermann As I could not find any information about this error when I faced it this is just a short hint: If you try to use pg_dump or pg_dumpall out of a(…)
Technology Survey SQL Server 2016: new T-SQL commands COMPRESS and DECOMPRESS 14.12.2015 by Stéphane Haby In live from the JSS2015 (Journée SQL Server 2015) in Paris, we saw that the CTP3.1 has been available in the night of these 2 days. One new feature available for this release in the T-SQL(…)
Operating systems, Technology Survey Windows Server 2016: Containers 14.12.2015 by Stéphane Savorgnano One of the new feature which will come with Windows Server 2016 is the Containers. Microsoft made available its fourth technical preview of his Windows Server 2016 platform some days ago. This new Technical Preview brings with it and for(…)
Database Administration & Monitoring Parallel sequential scans are coming to PostgreSQL 11.12.2015 by Daniel Westermann It didn’t made it into the upcoming PostgreSQL 9.5 release but it will probably be coming in 9.6: Parallel sequential scans. If you take a look at the development documentation some new parameters showed up: max_parallel_degree: The(…)
Operating systems Mail mit Format und Priorität aus Linux 10.12.2015 by Oracle Team Ausgangslage Ein Kunde hat mit kürzlich danach gefragt, wie ich den Output eines Scripts auf einer Linuxplattform per Mail sauber formatiert versenden kann. Als Beispiel nehmen wir folgendes: ____________________________________________________________________________________________________________________ File System free space on fed22v1.localdomain ____________________________________________________________________________________________________________________ | | | Mb-Total(…)
Development & Performance SQL Server Extended Event: Eine Deadlock-Event aus der “system_health” Überwachung 10.12.2015 by Stéphane Haby Wie Sie vielleicht wissen, gibt es eine Überwachung über Extended Events: system_health. Kürzlich fragt mich ein Kunde an, um ein zufälliges Deadlock-Problem zu analysieren...
Database Administration & Monitoring, Database management Monitoring tools for PostgreSQL – POWA 09.12.2015 by Daniel Westermann The last posts introduced the logging system, pg_stat_statements, pg_activity and pgcluu. This post will look at POWA: PostgreSQL Workload Analyzer. For getting the most out of POWA the following extension(…)