Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 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.