Powered by
WordPress
  • 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…

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

    In the first part of this series I explained the basics and some potential motivation behind the use of ASM Flex disk groups. In this part I would like to complete the description of new concepts. New Concepts related to FLEX ASM Disk Groups With the Flex disk group mounted, the next steps are to…

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

    I knew about the 12.2 FLEX ASM disk group type from other presenters but until now – when researching the feature for the upcoming DOAG HA Day – I haven’t been able to appreciate how cool this is. And I really think it is pretty cool and worth sharing! There is a lot to be…

  • Taming XML data in the v$cell% family of Exadata views

    While researching Exadata 12.2 features that have been introduced with Oracle 12.2.1.1.0 I ran into an old problem of mine, querying the v$cell% views that are new with Exadata 12.1.1.1.0 and Oracle RDBSM 12c Release 1 in a meaningful way. In case you haven’t seen them yet, these views expose cell metrics and other information…

  • 12.2 new features: a first encounter with the new Cluster Health Advisor

    One of the many new manuals that showed up in Oracle Database 12.2 is the Oracle Autonomous Health Framework User’s Guide. This book contains a lot of information, some of which we already know from previous releases, and some new stuff as well. One of the new chapters caught my eye in particular: “Proactively Detecting…

  • DOAG Exaday 2017: a preview

    I am quite excited to have been accepted to speak at the upcoming DOAG Exaday taking place June 20 in Frankfurt. It is the third time I have been lucky enough to present at the event, having spoken both in Frankfurt in Hamburg in previous years. As you can probably imagine by looking at this weblog, I am…

  • A quick look at Oracle 12.2 performance instrumentation

    Thanks to the prep-work done by Andy Colvin, who continuously and boldly goes where no man has gone before, one of our Exadata systems in the lab is now fully upgraded to 12.2.0.1. It comes fully equipped with the matching cellos to support all the cool new features. Exciting times! The reason for this post…

  • Using virt-install/KVM and kickstart to create lots of identical VMs quickly

    In preparation for an upcoming talk about Oracle 12.2 I am planning on getting my feet wet with the Oracle 12.2 Sharding option. It seems to be a very interesting subject to get into, but like all new subjects, they can be intimidating at first due to their complexity. So why not use the instructions…