Martins Blog

Powered by
WordPress

  • Creating a RAC 12.1 Data Guard Physical Standby environment (2)

    In the first part of this mini-series you saw me define the environment as well as creating a primary database. With that out of the way it’s time to think about the standby. Before the standby can be created, a few preparations are necessary both on the primary as well as the standby cluster. NOTE:…

  • Creating a RAC 12.1 Data Guard Physical Standby environment (1)

    I have just realised that the number of posts about RAC 12c Release 1 on this blog is rather too small. And since I’m a great fan of RAC this has to change :) In this mini-series I am going to share my notes about creating a Data Guard setup on my 2 node 12.1.0.2.161018…

  • GTT and Smart Scan – the importance of the append hint

    While writing the previous two posts about GTTs and Smart Scan, I stumbled across an interesting observation. When I started putting my thoughts to (virtual) paper, I thought it was going to be a short post. Well, it wasn’t to be, again. Anyway, you might find this interesting. Initial Situation If you read the previous…

  • Smart Scanning GTTs – what about Flash Cache?

    Continuing the example of the previous blog post (is it possible to Smart Scan GTTs?), I am investigating if Smart Scans against GTTs can benefit from Flash Cache, or “optimised reads”. The easiest way to see this in your session is to calculate the change in session counters based on v$mystat or v$sesstat. Other tools…

  • Little things worth knowing: Can I Smart Scan a Global Temporary Table?

    A question that has come up while preparing to deliver another Exadata Optimisation Class is whether you can offload queries against Global Temporary Tables (GTT) or not. There are subtle differences between heap tables and GTTs such as how statistics are handled and where they are stored that merit a little investigation. I have used…

  • Building an RPM for the Oracle database on Oracle Linux 7

    Thinking about automation a lot, especially in the context of cloud computing, I have decided to create a small series of related posts that hopefully help someone deploying environments in a fully automated way. As my colleague @fritshoogland has said many times: the only way to deploy database servers (or any other server for that…

  • Little things worth knowing: when a transient ASM disk failure cannot be fixed in time

    In the previous blog post I used libvirt and KVM in my lab environment to simulate a transient disk failure and how to recover from it. This post takes this example a step further: I am simulating another disk failure, but this time won’t pretend I can fix the issue and put it back. In…

  • Little things worth knowing: transient ASM disk failures in 12c

    For quite some time we have been treated nicely by ASM when it comes to transient disk failures. Since 11.1 (if memory serves me right), transient failures won’t cause an ASM disk to be dropped immediately. This is good, because it can potentially save a lot of time! When a disk is dropped from an…

  • Comparing workloads across databases

    Does this question sound familiar? “We are running the exact same workload in UAT as we do in production, but it behaves completely different. Can you help?” If it does, then you might find the following post useful, provided you are appropriately licensed to use this feature anyway. I have been working on AWR data…

  • Little things worth knowing: using Remote Diagnostic Agent more effectively with profiles

    RDA, or the Remote Diagnostics Agent, has been around for a little while. Over the time, and with the growing number of Oracle’s acquisitions it has become, shall we say, a little more difficult to handle. It appears to me as if every one of them will have its diagnostics handled by RDA making it…