Martins Blog

Powered by
WordPress

  • TABLE ACCESS INMEMORY FULL – but there may be more

    While preparing to teach a class this week I have had the time to look into the In Memory (cost) option a bit closer. I noticed a few interesting things along the way and would like to share one of these here. Background One of the questions I was asking myself was: “What happens if I…

  • Little things worth knowing: automatic generation of extended statistics in 12c Part II

    In my last post I demonstrated an example how to use a PL/SQL package to monitor a workload in order to identify correlated columns. Such columns are good candidates for the creation of extended statistics since the optimiser does not assume that information stored in different columns may be related. Before starting my tests I…

  • Little things worth knowing: automatic generation of extended statistics in 12c

    When you are migrating to Oracle 12c I hope you might this post useful. I came across this feature when researching what’s new with Oracle 12c (and yes I still find lots of new ones I haven’t noticed before). This one is a bit hidden away in section 2.2.4.3 Automatic Column Group Detection of the 12c New…

  • Example of Full Transportable Export to create a 12c PDB

    The Cool Stuff Oracle has introduced a new way of transporting data from one platform to another in 12c. The new feature is called “Full Transportable Export”. This enhancement works from 11.2.0.3 and later and is a great way to move data, as it allows for an easy-to-use combination of Export Data Pump and Transportable Tablespaces.…

  • 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…