Browsed by
Monat: Januar 2018

Blog Post: Last Week in Stream Processing & Analytics – 29.1.2018

Blog Post: Last Week in Stream Processing & Analytics – 29.1.2018

This is the 100th edition of my blog series blog series around Stream Processing and Analytics! Happy anniversary As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos and software […]

Blog Post: „ALTER USER SYS ACCOUNT LOCK“ – Der Oracle-12.2-DBA sperrt sich selber aus?

Blog Post: „ALTER USER SYS ACCOUNT LOCK“ – Der Oracle-12.2-DBA sperrt sich selber aus?

Keine Panik, auch der Oracle-12.2-DBA kann sich nicht selbst den Ast absägen, auf dem er sitzt. Aber durch das Sperren des SYS-Acccounts kann er die Datenbank etwas sicherer machen, indem er Remote-Zugriffe als SYS deaktiviert. Wie funktioniert das? Grundlage für … Weiterlesen →

Blog Post: Oracle 12.2 PDB Migration mit dem DataGuard-Broker – „DataGuard on PDB level“

Blog Post: Oracle 12.2 PDB Migration mit dem DataGuard-Broker – „DataGuard on PDB level“

Mit Oracle 12.2 kann der DataGuard-Broker beim Verschieben einer Pluggable Database von einer Container-Datenbank in eine andere helfen. Je nachdem ob die Ausgangsdatenbank eine Primär- bzw. Standby-Datenbank ist, nennt Oracle das Verfahren „PDB Migration“ bzw. „PDB Failover“. Etwas verkürzt wird … Weiterlesen →

Blog Post: Last Week in Stream Processing & Analytics – 22.1.2018

Blog Post: Last Week in Stream Processing & Analytics – 22.1.2018

This is the 99th edition of my blog series blog series around Stream Processing and Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos and software releases from last […]

Blog Post: Monitor backup jobs using RMAN views

Blog Post: Monitor backup jobs using RMAN views

Proper monitoring of backup jobs is one of the crucial elements in ensuring that your databases are well-enough protected against data loss. You can for example grep your backup logs, put some kind of alerting inside your backup scripts, but the most obvious method is just to use Oracle dictionary views. In order to get … Continue reading „Monitor backup jobs using RMAN views“

Blog Post: CDB Views and Query Optimizer Cardinality Estimations

Blog Post: CDB Views and Query Optimizer Cardinality Estimations

Today I faced a performance problem caused by a bad cardinality estimation involving a CDB view in a 12.1.0.2 multitenant environment. While solving the problem I did a number of observations that I try to summarize in this blog post. First of all, when checking the execution plan of a query already running for more […]

Blog Post: DBCA (Oracle 12.2) Vorlage für das Enterprise Manager Cloud Control 13c Release 2 Repository

Blog Post: DBCA (Oracle 12.2) Vorlage für das Enterprise Manager Cloud Control 13c Release 2 Repository

Bekanntermassen braucht der Oracle Enterprise Manager Cloud Control 13c Release 2 genauso wie seine Vorgänger eine Repository-Datenbank. Diese kann eine Oracle 12.1.0.2-Datenbank oder eine Oracle 12.2-Datenbank sein (12.2.0.1). Leider stellt Oracle auf dem Oracle Technet (http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/db-templates-3233309.html) nur DBCA-Vorlagen für Oracle … Weiterlesen →

Blog Post: Last Week in Stream Processing & Analytics – 15.1.2018

Blog Post: Last Week in Stream Processing & Analytics – 15.1.2018

This is the 98th edition of my blog series blog series around Stream Processing and Analytics! As every week I was also updating the following two lists with the presentations/videos of the current week: Presentations from SlideShare Videos from YouTube As usual, find below the new blog articles, presentations, videos and software releases from last […]