Explore Oracle Database In-Memory in 12C – Part2

Hi Everyone,

It’s been couple of months that I published my last article. Finally I was able to find some time and published new article in Oracle Experts website media "Allthingsoracle.com" by RedGate

In this article I will cover:

·         Multitenant Architecture compatibility

·         In-Memory Column store in RAC

·         How to manage In-Memory Tables

·         IM Column store Compression Methods

·         How to manage the In-Memory Column

·         Oracle Compression Advisor

·         How to manage In-Memory Tablespace

Please view the article using below link.
Explore Oracle DatabaseIn-Memory – Part2

This article will help users to understand In-Memory architecture, benefits, restrictions, functionality, performance…etc.

I hope you like the article and it will be helpful to you.

Please leave your valuable comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Explore Oracle Database In-Memory in 12C – Part1

Hi Everyone,

It’s been couple of months that I published my last article. Finally I was able to find some time and published new article in Oracle Experts website media "Allthingsoracle.com" by RedGate

In this article I will cover:

·         Oracle In-Memory Dual-Format Architecture

·         In-Memory Column Store

·         In-Memory Column Store Restrictions

·         How to enable In-Memory Column Store

Please view the article using below link.
Explore Oracle Database In-Memory – Part1

You will see more articles on this topic in near future.

This article will help users to understand In-Memory architecture, benefits, restrictions, functionality, performance…etc.

I hope you like the article and it will be helpful to you.

Please leave your valuable comments.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

Oracle In-Memory vs SAP HANA, What is your choice?

This is one of the very important discussions between DBA’s and BASIS Admins. Let’s see what benchmark results say….!

• Oracle Database In-Memory brings breakthrough analytical performance to enable businesses to make real-time decisions rapidly and easily. It is compatible with all existing applications and there is no need to rewrite your application to take advantage of it. In contrast, with SAP HANA the application need to be rewritten

• Oracle Database In-Memory implements state-of-the-art technology to accelerate analytics by orders of magnitude to allow users to get immediate answers to business questions that previously took hours. This same Oracle in-memory technology is proven to speed up SAP applications 2x faster than SAP HANA on SAP's own benchmarks. Read the Benchmark white paper*
   
• Oracle Database In-Memory does not mandate that all data fit in memory. Frequently accessed data can be kept In-Memory while less active data is kept on much lower-cost flash and disk, providing even more cost savings. In contrast, SAP HANA can only handle database sizes that fit in memory
   
• Building on decades of innovation, Oracle Database offers a proven platform with integrated high availability and data protection to deliver a reliable, secure, "always-on" business operation you can count on. Does SAP HANA offer the same high availability capabilities? Read more.
   
• Oracle has been an active leader in publishing benchmarks on transaction processing performance as measured by SAP's own standard application benchmarks (SAP Standard Application Benchmarks). Oracle Database In-Memory now enables real-time analytics on live transactional data. With Oracle, performance optimizations are built in for both transactions and analytics, unlike HANA, which optimizes your database for analytics at the cost of slowing down transactions. Where is the benchmark demonstrating HANA transaction processing performance running the SAP standard application benchmarks on HANA?

 Source: https://www.oracle.com/corporate/features/oracle-powers-sap.html

• Oracle is compatible with Compatible with cloud computing, big data and data warehousing. SAP HANA Database cloud consolidation is also not feasible 

• No new APIs and minimal new DBA commands are required, making Oracle Database In-Memory trivial to implement and maintain. Because HANA is a new “platform” with unique operational procedures and programming practices, a new team or retraining is required.

• Oracle Database In-Memory’s unique dual format enables transparent scale-up and scale-out for analytics and OLTP workloads running together. HANA uses a column format for high-performance analytics, which has severe architectural limitations for OLTP performance and scalability. Scaleup and scale-out are very immature

Source: http://www.oracle.com/technetwork/database/options/dbim-vs-sap-hana-2215625.pdf

Now it’s your time to read the benchmarks white paper and understands the facts and take the decision.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com