Oracle 18c: Data Warehousing New Features

    Nov 12, 2017 2:22:39 AM by Skant Gupta

    This article was written by Skant Gupta and Joel Perez in Oracle OTN.

    Full Index of Oracle Cloud Articles: Sir.CloudDBaaSjoelperez

    If you want to be updated with all our articles send us the Invitation or Follow us:

    Joel Perez’s LinkedIn:

    Skant Gupta's LinkedIn:

    or Join our LinkedIn group: Oracle Cloud DBaaS Data Warehousing will be the focus of the first Autonomous Database Service in Oracle 18c, so, this implies.. many new features will exist for this area. Many people.. including me.. we are so eager to see how the autonomous conception will work on Data Warehouses since it was announced that a new Autonomous Database for Datawarehouse will be just a thing of load tables.. running queries and that's it.. that's what Oracle Corp. said and really we are so eager to see how close could be what we imagine in comparison to reality. Meanwhile, let's see some technical Oracle 18c New Features for Data Warehousing and you will start to realize how all this will be working.. Key 18c Features to Enhance Data Warehouses DATABASE INFRASTRUCTURE

    • Autonomous health framework
    • Standby support for nologging ops


    • Online partition merge
    • Partitioning scheme online conversion of a table
    • Private temporary tables


    • SQL language
      • Enhanced approximate query processing
      • Enhanced analytic views, incl. MDX interface
    • In-Memory
      • In-memory external tables
      • In-memory for NVRAM
      • Automatic in-memory management
    • Optimizer and SQL processing
      • Inline external tables
      • Polymorphic table functions
      • Better fine-grained cursor Invalidation – Enhanced SQL Plan Management
    • And much more

    If you want to read rest to the article, go across this link : Oracle 18c: Data Warehousing New Features

    If you want to be updated with all our articles send us the Invitation or Follow us:

    Joel Perez’s LinkedIn:

    Skant Gupta’s LinkedIn:

    LinkedIn Group: Oracle Cloud DBAAS Facebook Page: OracleHelp

    Tags: Oracle Cloud DBaaS

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on and with more than 30 article published in Oracle Technical Network.