Martins Blog

Powered by
WordPress

  • Runtime Load Balancing Advisory in RAC 12c

    This is a follow-up on yesterday’s post about services in the new 12c database architecture. After having worked out everything I needed to know about TAF and RAC 12c in CDBs I wanted to check how FCF works with PDBs today. While investigating I found out that the Runtime Load Balancing Advisory does not seem…

  • RAC and Pluggable Databases

    In preparation of the OUGN Spring Seminar and to finally fulfill at least a part of my promise from July I was getting ready to research RAC, PDBs and services for my demos. It turned out to become a lot more interesting than I first assumed. RAC and Multi-Tenancy So the first attempt to really…

  • Public appearances first half of 2014

    I had the great fortune to have had many of my abstract accepted for upcoming conferences and other public appearances, the first ones for this year are these: OUG Ireland The first conference I’ll be attending is in Dublin, for OUG Ireland 2014 on March 11.I’m going to help out with RAC Attack and also…

  • Data Guard transport lag in OEM 12c

    I have come across this phenomenon a couple of times now so I thought it was worth writing up. Consider a scenario where you get an alert because your standby database has an apply lag. The alert is generated by OEM and when you log in and check-it has indeed an apply lag. Even worse,…

  • Massive tablespace fragmentation on LMT with ASSM

    I have been asked to investigate another interesting problem worth writing about. It’s worth mentioning here because it deals with a problem I believed to have long since been solved: tablespace fragmentation. However, in this case it was a locally managed tablespace (LMT) with Automatic Segment Space Management (ASSM) enabled. It should be difficult to…

  • Applying GI PSU 12.1.0.1.2 in the lab

    In my previous posts about the first RAC Grid Infrastructure Patchset I document a few issues I encountered that were worth noting. But where things work as advertised I am more than happy to document it too. In a way, the January 2014 GI PSU works as you’d hope it would (at least in my…

  • Applying PSU 12.1.0.1.1 to Oracle Restart

    I was actually hoping I had already written enough about applying the PSU for 12.1.0.1.0 but today I tried to apply the patch to my Oracle Restart home in my lab VM and guess what-it wasn’t as automatic as I thought. I must have performed the classic copy & paste error and applied the patch…

  • HCC error on Exadata after partitioning maintenance

    Recently I have been asked to investigate the following error on an Exadata system. ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type Well, that’s simple I thought! Must be (d)NFS mounted storage, right? Everyone knows that you can have HCC on Exadata (and a few other storage products). So I…

  • Interesting post-install steps for Oct 2013 12.1.0.1.1 PSU

    I have already written about RAC/Grid Infrastructure related patching of 12.1.0.1.0 to 12.1.0.1.1, aka the October 2013 PSU for the database. This post is a follow-up for pure RDBMS-only installations. I initially thought it wasn’t worth blogging about it (and hence the lag between the posts) but I came across an interesting post-apply step that…

  • SQLPlus and white space in the output

    I finally managed to work around My Most Annoying Problem (TM) with SQLPlus in my career. SQLPlus will mess up my output when I am copying/posting something in wordpress or elsewhere. Here’s an example to show you what I mean. The output in SQLPlus in my terminal window is all nice and pretty (it’s a print…