Discussions
Categories
- 382K All Categories
- 2.1K Data
- 207 Big Data Appliance
- 1.9K Data Science
- 447.5K Databases
- 220.8K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 24 Multilingual Engine
- 518 MySQL Community Space
- 464 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 475 SQLcl
- 3.9K SQL Developer Data Modeler
- 186K SQL & PL/SQL
- 20.9K SQL Developer
- 292.8K Development
- 7 Developer Projects
- 125 Programming Languages
- 289.5K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 23 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 143 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 245 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
My application is using Oracle DB 12c In-memory option. What do I need to do to make it use DAX?
Do I have to use the open DAX APIs to make the Oracle DB 12c in-memory use DAX when running on M7 and T7 systems?
Best Answer
-
For ODB 12c the capability to use DAX on M7 chip is already built into the integration of the HW and SW collectively and it works extremely well --
Our Oracle Optimized Solutions Team has taken advantage of these new features and has incorporated the usage of this within the Oracle Optimized Solution for Secure Oracle Database
Additionally, we have shown how to migrate and update clientele ODBs from older versions running on Power AIX, x86 Linux, and SPARC Solaris to ODB 12c gaining all of the advantages that SPARC M7 offers with ODB 12c including the capability to run analytics not only extremely fast but also very securely.
There are a set of "Architecture Matters" Articles that demonstrate this today that also include a step by step process of migration but more importantly upgrading to ODB 12c and having them run on M7 Architecture today.
We have gotten great feedback and usage of these articles by customers and folks in the field at Oracle - Please review them here:
https://community.oracle.com/docs/DOC-922079
https://community.oracle.com/docs/DOC-922080
https://community.oracle.com/docs/DOC-922081
https://community.oracle.com/docs/DOC-994773
Article 3 in this series shows a comparison of running a traditional transaction that takes 109 seconds to run but then having that same transaction run In-Memory in parallel fashion on M7 DAX taking only 2 seconds. EM Express is used to also show the transaction plans and DTrace as well as busstat is used to show the DAX functionally working without making any changes to the original transaction and getting a 54 times improvement for real time mode of operation. What was the transaction attempting to do? Please read the article and see - it is something we always deal with ourselves on an everyday basis when we make purchase of particular products.
BTW - we intend on extending these with additional articles on In-Memory with DAX on M7 as well as with additional focus on Security. Why? Because Architecture Does Matter with all of this in mind.
Answers
-
For ODB 12c the capability to use DAX on M7 chip is already built into the integration of the HW and SW collectively and it works extremely well --
Our Oracle Optimized Solutions Team has taken advantage of these new features and has incorporated the usage of this within the Oracle Optimized Solution for Secure Oracle Database
Additionally, we have shown how to migrate and update clientele ODBs from older versions running on Power AIX, x86 Linux, and SPARC Solaris to ODB 12c gaining all of the advantages that SPARC M7 offers with ODB 12c including the capability to run analytics not only extremely fast but also very securely.
There are a set of "Architecture Matters" Articles that demonstrate this today that also include a step by step process of migration but more importantly upgrading to ODB 12c and having them run on M7 Architecture today.
We have gotten great feedback and usage of these articles by customers and folks in the field at Oracle - Please review them here:
https://community.oracle.com/docs/DOC-922079
https://community.oracle.com/docs/DOC-922080
https://community.oracle.com/docs/DOC-922081
https://community.oracle.com/docs/DOC-994773
Article 3 in this series shows a comparison of running a traditional transaction that takes 109 seconds to run but then having that same transaction run In-Memory in parallel fashion on M7 DAX taking only 2 seconds. EM Express is used to also show the transaction plans and DTrace as well as busstat is used to show the DAX functionally working without making any changes to the original transaction and getting a 54 times improvement for real time mode of operation. What was the transaction attempting to do? Please read the article and see - it is something we always deal with ourselves on an everyday basis when we make purchase of particular products.
BTW - we intend on extending these with additional articles on In-Memory with DAX on M7 as well as with additional focus on Security. Why? Because Architecture Does Matter with all of this in mind.