Martins Blog

Powered by
WordPress

  • OSWatcher, Tracefile Analyzer, and Oracle Restart 12.2

    You are about to read the second part of this mini-series on TFA and Oracle 12.2. In the previous article I wrote about TFA and Oracle 12.2 single instance. In this short article I am going to have a look at TFA in a 12.2 Oracle Restart environment before rounding it up with an investigation…

  • OSWatcher, Tracefile Analyzer, and Oracle 12.2 single instance

    I have previously written about TFA, OSWatcher et all for Oracle 12.1. Since then, a lot of things have happened and I had an update for 12.2 on my to-do list for far too long. Experience teaches me that references to support notes and official documentation get out of date rather quickly, so as always,…

  • Little things worth knowing: redo transport in Data Guard 12.2 part 2

    In the first part of this article I looked at a number of views and some netstat output to show how redo is transported from the primary database to its standby systems. The long story short is that TT02 (“async ORL multi”) was found sending redo to CDB3 asynchronously whilest NSS2 (“sync”) transferred redo to…

  • Little things worth knowing: redo transport in Data Guard 12.2 part 1

    I have researched Data Guard redo transport quite a bit, but so far haven’t really blogged about some of the details that I have worked out. This is what I am trying to do in this post. In order to have a somewhat meaningful setup, I created a Data Guard configuration with 1 primary and…

  • Little things worth knowing: scheduler jobs and Instance Caging

    While updating material for a training class about Database Resource Management I briefly wondered if Instance Caging should apply for scheduler jobs as well. The obvious answer is “yes”, but I wanted to find proof. I hope I did in the end, and wanted to share how I got there. The test environment My system…

  • Truncated CTAS statements seem to be no longer shortened

    Many bloggers have already discussed that Oracle can truncate the text of a “create table as select” statement to 20 characters depending on your version and patch level. This can be a problem in case a CTAS statement is a resource hog, yet you don’t see the SQL text that is needed for troubleshooting. A…

  • Changes to the Oracle preinstall RPMs in OL 7.3 and OL 7.4

    For quite some time now Oracle has documented the use of the so-called preinstall RPMs to prepare Oracle Linux for the installation of the Oracle database software. I think that’s a great idea if the settings applied by the RPM fit your environment. If I find the time, I’ll write a blog post about what…

  • 12.2 New Feature: the FLEX ASM disk group part 5

    Some time ago I had a very interesting twitter conversation after publishing the first part of this series. The question was whether using ASM templates, which admittedly exist since Oracle 10.1, didn’t provide similar functionality as Flex Disk Groups. In other words, wouldn’t using ASM templates allow you to have high redundancy files on normal…

  • 12.2 New Feature: the FLEX ASM disk group part 4

    Flex Disk Group Properties In the previous 3 parts I shared my investigation into ASM Flex Disk Groups, Quota Groups, File Groups, and how Quota Groups actually enforce space limits. What I haven’t discussed yet was changing properties of a File Group and the effects thereof. Properties I have in mind are related to the…

  • 12.2 New Feature: the FLEX ASM disk group part 3

    In the previous 2 parts of this mini series I introduced the Flex ASM disk group and two related concepts, the Quota Group and File Group. In what should have become the final part (but isn’t) I am interested in checking whether quotas are enforced. (Un)fortunately I have uncovered a few more things that are…