Martins Blog

Powered by
WordPress

  • CloneDB in Oracle 12.1.0.2

    I personally really like CloneDB, a way to thin-clone an Oracle database over NFS. This can be quite interesting, and I wanted to update my blog for 12.1.0.2.3 (April PSU). Tim Hall has a good example for 11.2.0.2 and later with further references. My setup is as follows: server3 (Oracle Linux 7.1) uses Oracle Restart and…

  • Fixing a problem with the ASM spfile preventing RAC 12c from starting

    This is a little note to myself on how to fix a corrupt spfile in clustered ASM. I hope you find it useful, too. Let’s assume you made a change to the ASM (server) parameter file that causes an issue. You are most likely to notice this once CRS is restarted but parts of the…

  • Little things worth knowing: Data Guard Broker Setup changes in 12c

    One of the problems I have seen when deploying Data Guard for systems such as RAC One Node and policy managed databases was the static listener configuration you needed in 11.2. This has changed with 12c for the better if you are using Grid Infrastructure. http://docs.oracle.com/database/121/DGBKR/install.htm In the section about static listener registration a little…

  • JSON support in Exadata 12.1.2.1.0 and later

    Some time ago Oracle announced that RDBMS 12.1.0.2 has built-in support for JSON processing. A little later it was also mentioned that you have support for JSON in the Exadata storage servers for offloading. This is probably a lot more exciting to users of JSON than it is to me as I’m not a developer.…

  • IO Resource Manager for Pluggable Databases in Exadata

    Another interesting topic that goes over and above the CDB Resource Manager Plans I described earlier this week is the implementation of IORM Plans for Pluggable Databases. Pluggable Databases are an interesting object for studies, and I like to research things. When 12c came out there was no support for offloading initially, it is required that…

  • Testing 12c CDB Resource Plans and a little bit about OEM Express

    Inspired by Sue Lee’s presentation at Enkitec’s E4 conference I decided to re-run my test suite to work out how you can use Database and I/O Resource Manager in Oracle 12.1.0.2.2 to help consolidating databases in the new Multi-Tenant architecture. I should point out briefly that the use of Multi-Tenant as demonstrated in this article…

  • Smart Scan enhancements in Oracle Exadata 12c-inline LOBs

    As part of the 12c release of the database and cellos Oracle introduced the ability to perform Smart Scans on inline LOBs. The enhancement is certainly for Secure Files only. And as always, if you would like to read up about Secure Files you can head over to Tim Hall’s website for the details. To…

  • If you use swingbench take note of sbutil

    This is going to be a very short post for a change. I have used Swingbench extensively and really love the tool. Many thanks to Dominic Giles! Recently he announced a new tool on his blog that you can use to inflate your data volume. So instead of using the “-scale” argument when executing oewizard…

  • Additional information on Oracle 12c big table caching

    Teaching is on the things I like doing, and currently I am investigating the Oracle 12c features around caching data in the various memory areas. Since the In-Memory (cost) option has been discussed by other far more knowledgeable people I would like to share some findings about the big table caching here. Some Background In…

  • Exadata Fast Data File Creation

    This post is the result of some testing I performed on Exadata data file creation. You may know that Exadata offloading incorporates SQL optimisations as well as some infrastructure work. For quite some time Exadata allowed the DBA to create data files a lot quicker than on traditional systems. This has been documented before, for…