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.

Quick Intro: How to use Database Links with Oracle Autonomous Dedicated?

 Quick Into: How to use Database Links with Oracle Autonomous Dedicated.

There is a very good blog post by Jeffrey Cowen Senior Principal Product Manager at Oracle on How to use Database Links with Oracle Autonomous Dedicated.

Here is a quick recap.

• Only TCP connections are currently supported.
• Easy Connect syntax or the complete descriptor must be used.
• There is no access to the local tnsnames.ora file for editing.
• Create the DB Link and test it.
• OCI Egress Rules on the Autonomous Dedicated Infrastructure subnet must be open on port 1521 using Network Security Group (NSG) or a security list.
• If connecting your On-Prem to Autonomous you will need to make sure the scan or hostname used is resolvable by your source server through DNS lookup or a host file. 
• If connecting over VPN or FastConnect you must ensure that the On-Prem firewall is not blocking or timing out 1521 traffic for long queries.
• GLOBAL_NAMES is set to TRUE in OCI database services which requires the database link and the database to have the same name. This parameter is modifiable if needed. 
• If connecting to a public IP Address, the Autonomous Dedicated Infrastructure subnet will need proper route rules and network features enabled in the VCN such as a NAT Gateway if using a private subnet (recommended).

Enjoy this blog post on How to use Database Links with Oracle Autonomous Dedicated.

Cheers.

Oracle Database World 2021 In-Memory Sessions

 Oracle Database World 2021 In-Memory Sessions.

Oracle is hosting a new event called Oracle Database World 2021. Here is a summary of these very useful Oracle Database In-Memory sessions for Oracle Database World 2021:

•     Database In-Memory: Real Time Analytics, Supercharged, Andy Rivenes and Shasank Chavan
•     Superfast Event Stream Processing with a Converged Database, Tirthankar Lahiri and Shasank Chavan
•     Hands On Lab: Boost Analytics Performance with Oracle Database In-Memory, Andy Rivenes and Markus Kissling

Enjoy this blog post summarizing these very useful In-Memory Sessions at Oracle Database World 2021.

Cheers.

Oracle Database 21c New Features: In-Memory Vector Joins

 In-Memory Expressions in Oracle Database 21c: A Quick Primer.

This blog post by Andy Rivenes Product Manager at Oracle highlights this exciting new feature with Oracle Database In-Memory 21c.

Here is a quick summary:

• In-Memory Deep Vectorization is a new framework that has been added to Database In-Memory. 
• In-Memory Deep Vectorization is a SIMD-based (single instruction, multiple data) framework that supports vectorization for higher-level query operators in the query plan.
• In-Memory vectorized joins is the first feature that takes advantage of this new In-Memory deep vectorization framework. 
• This new feature speeds up in-memory joins and is transparent to the user.

Enjoy this blog post  highlighting this exciting new feature with Oracle Database In-Memory 21c.

Cheers.

You can now upgrade Grid Infrastructure to 19c on Gen2 Exadata Cloud@Customer

 You can now upgrade Grid Infrastructure to 19c on Gen2 Exadata Cloud@Customer.

This blog post by Prince Mathew Principal Product Manager at Oracle highlights this new announcement for Gen2 Exadata Cloud@Customer.

Here is a brief summary of this new upgrade to 19c capability on Gen2 Exadata Cloud@Customer.

• Run a precheck before upgrade to the 19c Grid Infrastructure version to identify and resolve compatibility issues in advance.
• Even if a precheck is not run, an implicit precheck will always be run as part of the GI upgrade workflow to ensure that the cluster is ready for an upgrade.
• Upgrade existing VM Clusters to 19c Grid Infrastructure version which is now a required step before upgrading databases on the cluster to 19c.
• The GI version upgrade to 19c is applied in a rolling manner across the cluster and does result in downtime for running database workloads. 

GI upgrade is a planned activity.

Enjoy this blog post announcing this much needed new upgrade capability for Gen2 Exadata Cloud@Customer.

Cheers.

Oracle Database In-Memory Youtube Channel and Summit Videos

Oracle Database In-Memory Youtube Channel and Summit Videos.

Session 1 & Session 2 Agenda:

• Oracle Database In-Memory: Warp Speed for the Enterprise!, Tirthankar Lahiri (40 minutes)
• Leverage Technology & Use In-Memory for Acceleration, Rich Niemiec (30 minutes)
• What’s new in Database In-Memory, Shasank Chavan (20 minutes)
• Best Practices for Getting Started, Andy Rivenes (20 minutes)

Session 3 Agenda:

• Utilizing Oracle In-Memory to improve Application Performance, Ahmed Alomari (30 minutes)
• Customer Presentations
  • Lufthansa - Oracle In-Memory Application for reduced latency in maintenance processes, Thorsten Pensky (40 minutes)
  • In-Memory Datawarehousing at STEF, Benoît Colas (40 minutes)

Session 4 Agenda:

• Utilizing Oracle In-Memory to improve Application Performance, Ahmed Alomari presentation (30 minutes)
• Customer Presentation
  • Hisense Database In-Memory case study (40 minutes), Dong Qu, Yu Xiao

Enjoy this blog post summarizing these very useful In-Memory Videos on their official Youtube Channel.

Cheers.