Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure

Quick Into: Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure

There is a very good blog post by Ranganath Srirangapatna Ramachandra Principal Product Manager at Oracle on Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure.

Here is a quick recap.

• Automatic failover AKA Fast-start Failover in Oracle Data Guard.
• Automatic Failover allows Autonomous Data Guard to automatically fail over to your standby Autonomous database in the event of an outage on your primary database.
• Automatic failover rapidly fails over the standby Autonomous database to the primary database role without requiring any manual steps.
• Automatic failover is optional and can be enabled/disabled on your Autonomous Container Databases with Autonomous Data Guard.
• Both maximum performance and maximum availability protection modes are available with automatic failover. 
• Automatic failover guarantees zero data loss in Maximum Availability mode.
• Automatic failover ensures no data is lost that is more than the amount of data (in seconds) specified by the FastStartFailoverLagLimit configuration property in Maximum Performance mode. 
• FastStartFailoverLagLimit is set to 30 seconds and applies only to maximum performance mode. Automatic failover is only possible when the configured data loss guarantee can be upheld.
• Oracle automatically troubleshoots and repairs the failure conditions related to the primary database and reinstates it to the standby database role after an automatic failover occurs.
• You can perform a switchover operation to change the database roles to the original state after the failed primary is reinstated to the standby database.

Enjoy this blog post on Automatic failover for Autonomous Data Guard enabled Autonomous Databases on Exadata Cloud at Customer and Dedicated Infrastructure.

Cheers.

Creating Non-CDB Database in ExaCS - Step by Step

This is a short step-by-step using dbaascli on how to create an Oracle Non-CDB database in Oracle Exadata Cloud Service (ExaCS). Here, we will see high-level steps with example to create 19c Non-CDB Database in ExaCS 

There is a very good blog post by Sathis Muniyasamy Principal Cloud Architect at Oracle detailing the following steps.

• List Available Images
• Download the Image
• Create DB Home
• Create Database
• Verify the Database
• Viewing the Non-CDB Database and Home in OCI Console

Enjoy the Oracle Non-CDB database in Oracle Exadata Cloud Service (ExaCS).

Cheers.

Oracle Database 21c now supports Enhanced In-Memory External Tables

Oracle Database 21c now supports Enhanced In-Memory External Tables.

This blog post by Andy Rivenes Product Manager at Oracle highlights this exciting new feature in 21c to the already expansive array of features boasted by Oracle Database In-Memory.

Here is a brief summary.

• With In-Memory 21c, external tables allow an application to populate data in the IM column store that exists outside Oracle Database without the need to to first having to materialize the data within the database.
• In-Memory 21c allows an application to take advantage of Oracle Database's rich feature set to query and analyze that data and perhaps combine it with other application data that resides within Oracle Database. 
• With Oracle Database 21c, Database In-Memory provides partition support for that external data to allow even more flexibility in managing fast analytics on many different types of data.

Enjoy this blog post announcing this exciting new capability now available for Oracle Database In-Memory.

Cheers.

Oracle Database 21c New Feature: Full Text Columns with In-Memory

 Oracle Database 21c New Feature: Full Text Columns with In-Memory.

This blog post by Andy Rivenes Product Manager at Oracle highlights this exciting new feature in 21c to the already expansive array of features boasted by Oracle Database In-Memory.

Here is a brief summary.

• In the previoius versions, Oracle Database In-Memory did not support predicates for non-scalar documents e.g. if you were using domain indexes for Oracle full text index, XML Search Index, or JSON Search Index then these were not populated in the IM column store. This resulted in degradataion of performance for searching non-scalar types of data. 
• Now in Oracle Database 21c In-Memory, there is new support  to store, or populate, these types of domain-specific indexes.
• The new 21c In-Memory Full Text Columns feature provides a faster way to perform searches on text type data.
• Full Text Columns do not require maintaining a separate Oracle Text index.
• Full Text Columns now support various types of application workloads within the Oracle converged database.

Enjoy this blog post announcing this exciting new capability now available for Oracle Database In-Memory.

Cheers.

Oracle Analytics Cloud uses Oracle Database In-Memory for faster results

Oracle Analytics Cloud uses Oracle Database In-Memory for faster results.

This blog post by Bret Grinslade Senior Product Director at Oracle highlights this exciting new announcement by Oracle Analytics Cloud.

Here is a brief summary.

• In Oracle Analytics Cloud, the new in-memory engine provides Automatic Caching, which is in-turn built on Oracle Database In-Memory.
• Built on Exadata and the advanced Oracle Database query engine, Automatic Caching for datasets offers query performance improvements without any changes to existing customer datasets.
• In-Memory is very helpful for larger datasets or datasets with complex calculations.
• The new caching engine is available in Oracle Analytics Cloud in Oracle Cloud Infrastructure (OCI).
• Some of the best performance improvements are for more complex scenarios e.g. Datasets with multiple users using shared workbooks see query performance improving as more queries are run.
• Users can noticeably observe the most performance benefits when employing complex filters and calculations. 
• These performance benefits now come with the same security and ease-of-use that, you get with an Oracle Analytics Cloud dataset.
• The best part of this new combination is that customers already have it.
• Starting with Release 6.1, all customers using Oracle Analytics Cloud on OCI Gen2 have been automatically upgraded: You can continue to use datasets with Automatic Caching, and when the data is reloaded, it will use in-memory technology.

Enjoy this blog post announcing this exciting new combination now available for Oracle Analytics Cloud.

Cheers.

Oracle Database In-Memory Important Documentation & Resources

Oracle Database In-Memory Important Documentation & Resources.

This excellent blog post by Andy Rivenes Product Manager at Oracle summarizes useful resources for Oracle Database In-Memory.

Technical Information

• Oracle Database In-Memory Data Sheet
• Oracle Database In-Memory Technical Brief
• Oracle Database In-Memory Quick Start (one page brief)
• Oracle Database In-Memory Quick Start Guide
• Oracle Database In-Memory Implementation Guidelines Technical Brief
• Oracle Database In-Memory: In-Memory Aggregation
• When to Use Oracle Database In-Memory
• Why Exadata Is The Best Platform For Database In-Memory
• Oracle Database In-Memory Advisor
• Benchmark Results Reveal the Benefits of Oracle Database In-Memory for SAP Applications
• Enterprise Data Architecture
• Database In-Memory Guide
• Exadata System Software User's Guide

Application Information

• Oracle Database In-Memory with Oracle's JD Edwards EnterpriseOne
• Performance Characterization of Oracle JD Edwards EnterpriseOne with Oracle Database In-Memory
• Using Oracle Database In-Memory with Oracle E-Business Suite
• Oracle Database, Cloud and IT Infrastructure for SAP

Videos

• OOW 2018 New York City cab demo
• Tirthankar Lahiri presents In-Memory Database Architectures at the IMC Summit
• Database In-Memory Real-Time Analytics Demo
• OOW 2017 DBIM Temperature Demo
• Oracle Database In-Memory: What's new in 12.2
• Customers discuss the benefits of Oracle Database In-Memory
• Database In-Memory Introduction
• Juan Loaiza explains everything you need to know about Oracle Database In-Memory using the Wikipedia demo
• Juan Loaiza explains how Software-in-Silicon will optimize Oracle Database In-Memory at Oracle Openworld 2014
• Larry Ellison Launches Database In-Memory
• Oracle ACE Directors Talk about Oracle Database In-Memory
• Oracle Application teams explain how Database In-Memory will improve their performance
• Panel discussion on Oracle Database In-Memory hosted by Juan Loaiza
• Tirthankar Lahiri explains how Database In-Memory has been optimized for Intel processors

Other Database In-Memory Information

• Ask TOM Office Hours
• Database In-Memory YouTube Channel

Technical Briefs/Other Links

• How to generate a SQL Monitor Report - Updated for 19c!
• SQLMaria - Getting the most out of Oracle SQL Monitor
• SQL Monitor Technical Brief
• How to generate an Optimizer Trace

Presentations/Hands On Labs

• LiveLabs - Boost Analytics Performance with Oracle Database In-Memory Workshop
• OOW Hands On Lab Guide
• OOW Hands On Lab Scripts
• SSB Schema Export Files - GitHub
• Conference Hands On Lab Guide
• OOW 2019 Tips and Tricks Presentation
• ilOUG DBIM By Example Presentation (output)
• AskTOM Office Hours Scripts - GitHub
• AskTOM Office Hours Base Level Feature 19c presentation (pdf)

MOS Notes

• Release Schedule of Current Database Releases (Doc ID 742060.1)

• Oracle Database In-Memory Option (DBIM) Basics and Interaction with Data Warehousing Features (Doc ID 1903683.1)

Database Patches

My Oracle Support Notes:

• Master Note for Database Proactive Patch Program (Doc ID 888.1)
• Overview of Database Patch Delivery Methods for 12.1.0.2 and older (MOS Note: 1962125.1)
• Overview of Database Patch Delivery Methods for 12.2.0.1 and greater (MOS Note: 2337415.1)

    Proactive Patch Information notes available based on release:

• Oracle Database 21c Proactive Patch Information (MOS Note: 2796590.1)
• Oracle Database 19c Proactive Patch Information (MOS Note: 2521164.1)
• Database 18 Proactive Patch Information (MOS Note: 2369376.1)
• Database 12.2.0.1 Proactive Patch Information (MOS Note: 2285557.1)
• Database 12.1.0.2 Proactive Patch Information (MOS Note: 2285558.1)

License Info

• Licensing Information User Manual
• Authorized Cloud Environments
• Licensing Oracle Software in the Cloud Computing Environment

Other Related Blogs

• Optimizer Blog
• Data Warehouse Blog
• SmartScan Deep Dive Blog (currently unavailable - some posts on DBIM blog)
• SQLMaria
• Mike Dietrich's Upgrade Blog

Enjoy this blog post summarizing useful resources for Oracle Database In-Memory.

Cheers.

Utilizing Memoptimized Rowstore in non-Exadata Database Environments

Utilizing Memoptimized Rowstore in non-Exadata Database Environments.

This blog post by Andy Rivenes Product Manager highlights the fact that Memoptimized Rowstore is Available in non-Exadata Database Environments.

Here is a brief summary.

• Memoptimized Rowstore was first introduced in Oracle Database 18c.
• Memoptimized Rowstore is made up of two components: Fast Lookup and Fast Ingest. 
• These new features at the time were for Exadata On-Prem and Cloud environments only; However, they are now available in non-Exadata environments in 21c and in 19c starting with the 19.12 RU.
• The Memoptimized Rowstore Fast Ingest feature enables fast data inserts into Oracle Database: This enables support for applications that generate lots of informational data that has important value in the aggregate but that don't require full ACID requirements e.g. Internet of Things (IoT) Apps with rapid "fire and forget" type workloads.
• Memoptimized Rowstore Fast Lookup feature supports SELECT queries on primary key values: This Very Fast Lookup feature can be helpful for applications that require very high-frequency reads.

Enjoy this blog post highlighting this very useful capability.

Cheers.