Articles tagged with: oracle exadata

Test drove Oracle Exadata with Oracle GL Financial Analytics, the pros/cons, and vision to embrace it within your blueprint

on Thursday, 17 January 2013. Posted in Enterprise Software , Blog

 

 

Oracle’s vision is clear with Exadata , it integrates by design with other Oracle products like Enterprise manager 12c and a game changer in performance.

Exadata came from the Sun Microsystems acquisition; this has proven to be a strategic acquisition. Sun technology enabled Oracle to become one of the leaders in the highly profitable engineered system segment of the hardware business. I believe that products like Exadata and the SPARC SuperCluster will not only continue to drive growth for their hardware business but force the titans to innovate instead of executing.


The vision for the 4 titans SAP, Oracle , IBM and Microsoft is to offer their clients, an option to be in command of all layers of their clients technology stacks, “One Throat to Choke” principle. This is an expression used in business to describe the advantage of purchasing goods or integrated services from a single vendor. That way, when something goes wrong, there is only “one throat to choke.”

Also I believe in the future (next 24 months)the licensing agreements will begin a new phase of bundling hardware and software together.

 I had the opportunity with some folks in California to test drive Exadata. I was impressed the Exadata X3 (X3 stands for third Generation) is a real game-changer, as far as data is concerned, the combination of the huge on-board flash memory with the benefits of Hybrid Columnar Compression, meaning that you could store at least 200TB of data in memory on a full rack of Exadata X3. In other words you should never have to hit spinning disks for your data again.

We installed Oracle financial analytics with GL (General Ledger) and used the 5 interactive dashboards of GL to test Exadata. The financial dashboards were:

1-Profit and Loss

2-Expense

3-Balance sheet

4-Cash Cycles

5-Liquidity

Below is the look and feel of the GL financial dashboards:

 

oracle financial gl interactive dashboards

 

Pros

 1)We pushed the Exadata machine to 100 000 transactions per seconds with no wait as you see below the dark blue color is the user I/O, no latency. Flash Log and machine performance was exceptional.

 

Exadata Output

2)Exadata has a Hybrid Columnar Compression (HCC) is a feature introduced in Oracle Database 11g Release 2 which Oracle allows to be used on Exadata storage, in our testing we had an uncompressed database of 75 Gigabytes, and by using the compression advisor functionality it was reduces 20 times to 3.8 Gigabytes. This feature impressed me the most; it is less talked about , should produce a significant savings on storage.

3)Seamless Integration with Oracle Enterprise Manager, it comes with 3 views Hardware, Software/System and a configuration view that summarizes all components with patch recommendation. (Here is a white paper link that explains the integration in detail.) http://www.oracle.com/technetwork/oem/exa-mgmt/exadata-mgmt-twp-1662642.pdf

4)The adoption of Exadata will necessitate a revamp of the IT support roles to make this single group responsible for the entire frame from storage to the database.

The Exadata machine administrator will need to be versatile and knowledgeable in different areas: Here are my thoughts on the breakdown of the role:

55% Database Administration
25% Cell Administration
10% Linux or Solaris Administration
10% Miscellaneous (Infiniband,other...)

 

Cons

1)Oracle Exadata x3 being a new product has a small footprint and the competition especially from the other titans is ferocious, business case must be thorough, I think best approved using an enterprise consolidation project of many environments, the business case must identify the extent of the existing Information System problems and show a roadmap moving towards a private cloud.

2)The Oracle Exadata, SAP Hana and IBM Neteeza all have similar architectures no ‘wow’ differentiator between them To learn more on this product line, here are some links to help you get started:

Oracle Exadata – Home Page

http://www.oracle.com/us/products/database/exadata/overview/index.html

Overview of the Oracle Exadata - Online Documentation

http://docs.oracle.com/cd/E28271_01/doc.1111/e24473/em_exadata_dbmachine.htm

My next entry will provide you tips and tricks in using Oracle's Unified methodology (OUM) for your project and make my first video on this topic.

I received many inquiries asking me about the technical details of this website: Here are the specifications: The website is built with Joomla 3.0 (open source), database is MySQL, The server is a virtual private server, Operating system is CentOS6(based on Linux) with 2GB RAM and 60GB of Disk Space.

 

 

Copyright 2015 Appsconsultant.com. All rights reserved.