Thursday, October 28, 2021

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.

Saturday, October 2, 2021

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.