Oracle Exadata

First Exadata Virtual Conference - Jan 19-20, 2012 Concluded

2012-01-22T20:06:00.000-08:00

The First Exadata Virtual Conference held on Jan 19-20, 2012, was a great success and attended by about 300 attendees per session... There were 6 sessions spread over two days in Webcast Format...
If you attended it, please provide us your feedback via this survey.

2012-01-02T07:46:00.000-08:00

Happy New Year! Exadata SIG announces the First Exadata Virtual Conference on Jan 19, Jan 20 (Thur/Friday) 2012. The two day event will be 2 PM to 5 PM EST each day.

Registration url: (please register for each day separately)

Jan 19 https://www1.gotomeeting.com/register/885760088

Jan 20 https://www1.gotomeeting.com/register/702427145

Day 1 - Jan 19, 2012 - Thursday 1:30-5 PM EST Conf kick off at 1:30 PM ET (Arup/Vinod)

Speaker 1> Phil Stephenson – State of Exadata 2012 - 2 PM ET

Speaker 2> Jim Czuprynski - Exadata Database Machine: Understanding Why It Works As Well As It Does 3 PM ET

Speaker 3> Anuj Mohan - Top Exadata features you need to know. 4 PM ET

------------------------------------
Day 2 – Jan 20, 2012 Friday 2-5:30 PM ET 5-5:30 PM - Attendee Feedback and closing session (Shyam)

Speaker 1> Stephen Holder – Smart Scan 2 PM ET

Speaker 2> Kevin Courtney - Exadata Customer Case Studies: Key Considerations when Planning and Executing a Complex Database Consolidation 3 PM ET

Speaker 3> Andy Colvin - Surviving Exadata Patching 4 PM ET

Oracle Exadata Virtual Conference 2012 (Friday Jan 2012)

2011-11-20T13:48:00.001-08:00

Announcing the Exadata Virtual Conference - 2012 on Friday, Jan 20

Exadata SIG along with IOUG is organizing the First Exadata Virtual Conference on Jan 20, 2012. This Virtual only conference will be conducted via day long Web Conference session on Friday Jan 2012. Here are the suggested topics to invite speakers from Customers, Implementer and Oracle:

>Introduction to Exadata / Or Product Roadmap
>Decision process or getting ready for Exadata
>Exadata case study for DW, for OLTP or for DW Consolidation
> Exadata Patching process and support tips
>Other topics like Resource manager, HCC case study etc..
>Multi appliance shop e.g. Exadata + Exalogic, including multi vendor shop experiences like Exadata, Teradata, Netezza etc

Please send your proposals as email to Arup@proligence.com including Title, Abstract, Bio abd Level of Audience (Intro, Intermediate, Advanced). You can also post your interest and suggested topic in the Linked Group for peer comments. We will soon provide the link for attendee registration. It will be free to attend. We request you to become free member of Exadata SIG via http://OracleExadata.org to get all the information about this event.

Oracle Openworld 2011 Announcements, what do you think?

2011-10-15T09:52:00.000-07:00

Oracle Openworld 2011 made a lot of announcements specially around the "engineered" systems or the Exa-Line of products and related appliances. Here is a list (may not be complete!):

Oracle Database Appliance
T-4 SPARC SuperCluster
Exalytics - BI Machine
Oracle BI Machine
Oracle Big Data Appliance

Please provide your opinion on these products, detailed comments can be left here:

Exadata SIG session at Oracle Openworld on Oct 2, 2011

2011-10-01T10:27:00.000-07:00

Come to Moscone West on Oct 2, 2011 (Sunday from 9-5 PM PDT)

Session ID: 27260
Name: Vinod Haval
Title: IOUG: Oracle Exadata A Real Life Example

Session ID: 09105
Name: Rizwan M.K.
Title: IOUG: ExaFamily the magic wand for the Aging application infrastructure

Session ID: 31460
Name: Arup Nanda
Title: IOUG: Exadata for Oracle DBAs

Session ID: 27261
Name: Shyam Nath / Vinod Haval
Title: IOUG: Exadata Customer Panel

Session ID: 29221
Name: Andy Flower
Title: The Impact of Exadata in Your Business Environment

Session ID: 27280
Name: Jan Klokkers
Title: IOUG: Oracle Exadata Database Machine for SAP software

Oracle Openworld - Exadata SIG Meeting on Tue Oct 4, 2011 at 11 AM PDT Moscone West L3 Overlook 3B

2011-09-25T10:18:00.000-07:00

Oracle Openworld - Exadata SIG Meeting on Tue Oct 4, 2011 at 11 AM PDT Moscone West L3 Overlook 3B

This session is IOUG Exadata SIG meeting open to all current and prospective Exadata SIG members.
You will learn all about the SIG's year round activities, monthly webcasts and education library and so on. Come and network with the Exadata SIG board, Oracle Development and Product Management and with fellow SIG members. Ask a question about the recent announcements about Exadata and related products or ask the fellow users about their experiences on Exadata.

Database Appliance from Oracle

2011-09-21T20:20:00.000-07:00

Oracle today (Sep 21) announced a Database appliance which is a two server cluster with 24 cores of CPU, 96 GB memory per server and upto 12 TB of storage. In speculations of the Oracle Webcast today by Mark Hurd, Andy Mendelshon etc., the product was anticipated as Exadata mini or little brother of Exadata, targeted at the Mid-market (SMB), who either cannot afford Exadata or do not need one yet. This little brother weights 160 lbs!

The driving goal here is to keep the product simple and provide Oracle Appliance Manager. So finally Oracle uses the term "appliance" which is used to shy away from as Exadata was not meant to be plug and play. The interesting concept is that customers can license as many cores they want with some restrictions like same number of cores on each server (up to 24 in the box). I believe this is new to Oracle too. The CPU cores drive the cost of the Oracle RDBMs license usually so this can be game changing. The appliance runs Oracle Linux (OEL) and can used used as RAC. It can run one powerful DB instance or multiple say your Dev, Test and QA instances.

So how does it compare with Exadata entry level say 1/4 RACK? While a 1/4 RACK is 60 cores of CPU and 72 TB or storage, the DB appliance is only 24 cores (with ability to license a subset of those) and 12 TB of storage max. It is meant for up to 4 TB databases. Oracle will not license Hybrid Columnar Compression (HCC) or the Smart Scan with this box. Thus some of the "secret sauce" of the Exadata has been preserved. The DB appliance does come with the solid state disk (4 x 73 GB) for improving the redo performance.

With an entry level price for hardware in the range of $50,000, it is could appeal to the mid-market companies. The box will support 11g (11.2.0.2) to begin with.

Oracle Exadata SIG Webcast on July 6, 2011

2011-06-24T09:31:00.000-07:00

Exadata SIG Webcast by Arup Nanda on July 6, 2011 at noon EDT

Exadata for the Oracle DBA by by - Arup Nanda Oracle ACE Director

Abstract: Exadata is, at the heart of it, is an Oracle 11.2 RAC Database. So, why is it so special? What is the magic sauce that makes it fast. Learn the components of the Exadata Database Machine and its building blocks - storage cells, database nodes, inifiniband network, cell offload processing, smart scan, storage index and much more. Learn the additional skills needed to master the administration of the DBM by an Oracle DBA.

Date: Wednesday, July 6, 2011

Time: 9:00 am, Pacific Daylight Time (San Francisco, GMT-07:00)

Meeting Number: 596 690 502

Meeting Password: 123456

-------------------------------------------------------

To join the online meeting (Now from mobile devices!)

-------------------------------------------------------

1. Go to https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=162698872&UID=1257378657&PW=NYjI5NTZiYmYz&RT=MiM0

2. If requested, enter your name and email address.

3. If a password is required, enter the meeting password: 123456

4. Click "Join".

To view in other time zones or languages, please click the link:

https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=162698872&UID=1257378657&PW=NYjI5NTZiYmYz&ORT=MiM0

-------------------------------------------------------

To join the teleconference only

-------------------------------------------------------

Call-in toll-free number: 1-866-682-4770

Conference Code: 6076676

PIN: 123456

-------------------------------------------------------

For assistance

-------------------------------------------------------

1. Go to https://oracleconferencing.webex.com/oracleconferencing/mc

Exadata SIG Webcast on May 4, 2011 - Covers HCC

2011-05-02T09:07:00.000-07:00

Exadata - A real life implementation for Hybrid Columnar Compression (HCC)

This presentation will go through a real life implementation for Hybrid Columnar Compression (HCC) on a datawarehouse tables. It will go over all the HCC options available on Exadata and how to decide which option to pick. We will also go over impact of sorting on HCC ratio.

We will cover the following topics:

Options for Exadata HCC
Using Compression Advisor
Real life compression ratio
Ways to move existing tables/partitions/subpartitions to HCC
Query Performance after using HCC
Effect of sorting on HCC ratio
Summary

Diwakar Kasibhotla Biography:

Diwakar Kasibhotla works on Data warehouse implementations performing role of a Data Architect, Data Modeler, Performance Tuning, ETL/BI for last 15 yrs. Diwakar is currently working as a Sr.Data Architect with OppenheimerFunds Inc in a role as lead Architect for Exadata migrations.

--------------------------
Topic: A real life implementation for Hybrid Columnar Compression (HCC)
Date: Wednesday, May 4, 2011
Time: 9:00 am, Pacific Daylight Time (San Francisco, GMT-07:00)
Meeting Number: 596 688 680
Meeting Password: 123456

-------------------------------------------------------
To join the online meeting (Now from mobile devices!)
-------------------------------------------------------
1. Go to https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=159118602&UID=1236279032&PW=NYWNhNjQxMmEz&RT=MiM0
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: 123456
4. Click "Join".

To view in other time zones or languages, please click the link:
https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=159118602&UID=1236279032&PW=NYWNhNjQxMmEz&ORT=MiM0

-------------------------------------------------------
To join the teleconference only
-------------------------------------------------------
Call-in number: 1-866-682-4770 US
Conference Code: 6076676
Password: 123456

-------------------------------------------------------
For assistance
-------------------------------------------------------
1. Go to https://oracleconferencing.webex.com/oracleconferencing/mc
2. On the left navigation bar, click "Support".

You can contact me at:
philip.stephenson@oracle.com
1-650-607-0663

To update this meeting to your calendar program (for example Microsoft Outlook), click this link:
https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=159118602&UID=1236279032&ICS=MRS1&LD=1&RD=2&ST=1&SHA2=WZOYD8EENwX8ojiFtjMwTGvWhj2bkthI5EiwR2Bp0yo=&RT=MiM0

WebEx will automatically setup Meeting Manager for Windows the first time you join a meeting. To save time, you can setup prior to the meeting by clicking this link:
https://oracleconferencing.webex.com/oracleconferencing/meetingcenter/mcsetup.php

Oracle Exadata Related Sessions in Collaborate 2011

2011-04-08T04:14:00.000-07:00

Check Conference Schedule for any updates.

Date/Time Session Title User Group
Sunday, April 10 2:45 pm - 3:45 pm Physical Ordering of Data: Is it ever Useful? OAUG
Monday, April 11 1:15 pm - 2:15 pm Peering through the cloud: the straight goods on Oracle Exalogic IOUG
Monday, April 11 2:30 pm - 3:30 pm Competing on Appliances: Exadata Exalogic and More... IOUG
Tuesday, April 12 8:00 am - 9:00 am Understanding Oracle and Industry Cloud Computing Directions - A Decision Makers Guide. OAUG
Tuesday, April 12 9:15 am - 10:15 am Is Oracle Exadata for You? IOUG
Tuesday, April 12 9:15 am - 10:15 am Oracle Exadata - A Real Life Example IOUG
Tuesday, April 12 10:30 am - 11:30 am Building a Sustainable Business Execution Platform through Enterprise Architecture OAUG
Tuesday, April 12 11:45 am - 12:15 pm BI and EPM Panel : The Foundation for Success IOUG
Tuesday, April 12 3:15 pm - 4:15 pm Exadata for the Beginners IOUG
Tuesday, April 12 3:15 pm - 4:15 pm Oracle Exadata Intelligent Warehouse for Industry OAUG
Tuesday, April 12 4:30 pm - 5:30 pm Why Are We Fighting? Solving Oracle Database I/O Performance Bottlenecks IOUG
Tuesday, April 12 4:30 pm - 5:30 pm Engineering Oracle ASM Optimal I/O Performance with IDP IOUG
Wednesday, April 13 9:15 am - 10:15 am Exadata Primer for the Executive OAUG
Wednesday, April 13 4:00 pm - 5:00 pm Predictive Analytics for Management Oracle Exalogic and Exadata Cloud Environments IOUG
Thursday, April 14 8:30 am - 9:30 am Introducing the Exalogic Elastic Cloud IOUG
Thursday, April 14 9:45 am - 10:45 am Implementing Exadata: Lessons from the trenches IOUG
Thursday, April 14 9:45 am - 10:45 am Does A Rocket Car Help Your Oracle DBA's Daily Commute? IOUG
Thursday, April 14 9:45 am - 10:45 am Consolidate with Oracle Database 11g IOUG
Thursday, April 14 11:00 am - 12:00 pm One Version of the Truth Doesn't Mean One BI Tool IOUG
Thursday, April 14 11:00 am - 12:00 pm Oracle Exadata Database Machine Technical Overview IOUG
Bottom of Form

March 30, 2011 Webcast: Using Resource Manager for Consolidation on Exadata

2011-03-24T19:50:00.000-07:00

Title: Using Resource Manager for Consolidation on Exadata

Abstract:
Database consolidation is a common goal for many Oracle Exadata customers. Through consolidation, you can capitalize on the extreme CPU, I/O, and memory resources in an Oracle Exadata Database Machine. One important aspect of consolidation is performance, since excessive loads or runaway querie! s from one workload can mar the performance and stability of the other workloads and databases. In this presentation, you will learn how to use Resource Manager to control how databases and workloads within databases utilize CPU, I/O, and other resources. For hosted or cloud environments, you will learn how to configure Resource Manager to ensure consistent and predictable performance. This presentation will include best practice tips and show results from recent Resource Manager tests.

Bio:
Sue Lee is a senior development ma! nager in the Oracle RDBMS division. She is responsible for the Oracle Resource Manager, which provides workload management for mixed workloads, database consolidation, and server consolidation for the Oracle database and Exadata storage. Sue holds a B.S. ! and M.S. in Computer Science from MIT.
----------------------------

Coming soon the next Exadata SIG Webcast on March 30, 2011
Topic: Exadata SIG Webcast
Date: Wednesday, March 30, 2011
Time: 9:00 am, Pacific Daylight Time (San Francisco, GMT-07:00)
Meeting Number: 597 036 296
Meeting Password: 123456

-------------------------------------------------------
To join the online meeting (Now from mobile devices too!)
-------------------------------------------------------
1. Go to https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=154891722&UID=1212458222&PW=NY2NmYzhhNjcz&RT=MiM0
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: 123456
4. Click "Join".

-------------------------------------------------------
To join the teleconference only
-------------------------------------------------------
Audio:
866-682-4770

Exadata Storage Layout : Webcast on Feb 9, 2011, noon EST

2011-02-08T19:55:00.000-08:00

Oracle Exadata SIG Webcast on Feb 9, 2011, noon EST
Title: Exadata Storage Layout (see http://OracleExadata.org for details)

Date: Wednesday, February 9, 2011
Time: 9:00 am, PST
Dial in: 1-866-682-4770 (US)
Meeting Number: 270 356 386
Meeting Password: 123456
List of Toll-Free International Dial-In Numbers: http://twurl.nl/3775vt
Note: Audio will be streamed over the internet.
-------------------------------------------------------
To join the online meeting
-------------------------------------------------------
1. Go to https://oracleconferencing.webex.com/oracleconferencing/j.php?ED=7866298&UID=17535453&PW=NODExY2FmMjNh&RT=MiM0
2. If requested, enter your name and email address.
3. If a password is required, enter the meeting password: 123456
4. Click "Join".

Abstract:
In Oracle 10gR1, Oracle introduced Automatic Storage Management (ASM) and changed the way we think of managing database storage. Exadata is tightly integrated with ASM and provides the underlying disks that have traditionally been presented to ASM by the operating system. Looking at all the various intricacies of cell storage can be a little daunting at first. There are several layers of abstraction between physical disks and the ASM diskgroups many DBA’s are familiar with. If you’ve never worked with Oracle’s ASM product there will be a lot of new terms and concepts to understand there as well. This presentation discusses the various layers of abstraction, from physical disk to grid disk and how they are used to provide storage for the Oracle database. From there, we’ll take a look at the options for carving up and presenting Exadata grid disks to the database tier. The Oracle recommended approach is to create a few large “pools” of disk across all storage cells. While this approach generally works well from a performance standpoint, there are reasons to consider alternate strategies. Sometimes, isolating a set of storage cells to form a separate storage grid is desirable. This provides separation from more critical systems within the Exadata enclosure so that patches may be installed and tested before they are implemented in production. We’ll take a look at how ASM provides fault tolerance and storage virtualization to databases and how all the various pieces work together to provide flexible, high performance storage to the Oracle database.

Bio:
Randy Johnson is a Principal Consultant at Enkitec, a consulting firm specializing in Oracle. Randy has over 18 years of experience with Oracle beginning with Oracle 7 in the early 90's. Much of his career has combined Oracle DBA work with Unix administration duties. Over the last 5 years Randy focused almost exclusively on RAC and ASM. He is also an authority on Oracle backup and recovery via RMAN having written a popular utility for automating RMAN scripts called Dixie. Randy occasionally blogs at blog.enkitec.com.

2011-02-01T21:25:00.001-08:00

My first blog post from the cell text message. Come to my Competing on Appliances talk at RMOUG on feb 17 2011. Shyam

Gartner Jan 2011 Magic Quadrant for DW Database Management Systems

2011-02-01T19:32:00.000-08:00

The Gartner Magic Quadrant for Jan 2011 is out... Ever since I have started following Oracle Exadata and started the Oracle Exadata SIG (http://OracleExadata.org).

In about two weeks, I will be giving a talk titled "Competing on Appliances" at Denver in RMOUG 2011. So this was quite timely!

Teradata has earned the top honors being one of the pioneers in the data warehouse appliance space. Oracle with its three distinct data warehouse solutions: Oracle stand-alone Db 11g, Reference Configurations on variety of hardware and Exadata with Exadata Storage Server, top the next spot. In recent years though, I think the reference configuration or optimized warehouse initiative has faded away as obviously Oracle wants to promote their own H/W stack. Thus, two main options are Oracle DB on traditional hardware and Exadata systems. Keeping in mind that Exadata specially V2 came out in end of 2009, its position is pretty comfortable in the top quadrant. IBM Smart Analytics took the next spot even though Netezza was measured in its own for 2010. Sybase IQ has helped to put SAP on this map too!

Oracle Exadata Sessions at Openworld 2010

2010-09-15T20:24:00.000-07:00

Oracle Exadata SIG meeting on Sunday at Moscone W, 1st Floor, North side.
Time 10:30 AM PT, come meet folks like Robert Stackowiak, VP BI at Oracle and author of upcoming book on Exadata V2, Richard Niemiec, former President of IOUG, Andy Flower, current President of IOUG, Arup Nanda, DBA of the year 2003 and many other Oracle experts!

General Session: Why Standardize on Oracle Database 11g?
Oracle Senior VP Andy Mendelsohn covers the benefits of upgrading to Oracle Database 11g. Learn how customers are reducing IT costs and increasing quality of service for all their enterprise applications.
Monday, September 20 11:00 a.m. Moscone North, Hall D, Session ID: S318964

Oracle Exadata Customer Panel: OLTP and Consolidation Deployment
Hosted by Oracle VP Tim Shetler, this customer panel will cover the online transaction processing (OLTP) and consolidation experiences of Oracle Exadata customers. The conversation will be wide-ranging, addressing performance, installation, management, application design, and DBA experiences. The session also includes an open Q&A in which attendees can interact directly with Oracle Exadata customers.
Monday, September 20 3:30 p.m. Moscone South, Room 307, Session ID: S316819

Oracle Exadata Customer Panel: Deployment Experiences with Extreme Performance
In this session, customers from across the spectrum of industries, applications, and geographies discuss their experiences deploying Oracle Exadata. The conversation will be wide-ranging, addressing performance, installation, management, application design, and DBA experiences. The session also includes an open Q&A in which attendees can interact directly with Oracle Exadata customers.
Tuesday, September 21 1:00 p.m. Moscone South, Room 307, Session ID: S316818

Oracle Database 11g Release 2 Security: Defense in Depth
Securing information transparently and cost-effectively has never been more important. Attend this session to learn the latest on Oracle Database 11g security, from encryption and access control to the latest Oracle Database firewall solutions. This session is lead by Vipin Samar, Oracle's VP of Database Security.
Monday, September 20 3:30 p.m. Moscone South, Room 103, Session ID: S316986

Better Together: Oracle Database, Oracle Exadata, and Oracle's BI Solutions
Learn how to get the most from Oracle Business Intelligence Suite Enterprise Edition and Oracle's BI applications by running them with Oracle Database and Oracle Exadata. In this session, you learn how Oracle Exadata improves BI users' experience with improved performance, as well as how Oracle Business Intelligence Suite Enterprise Edition takes advantage of other Oracle Database features to improve security, enhance analytical content, and simplify manageability.
Tuesday, September 21 2:00 p.m. Moscone West L3, Room 3016, Session ID: S318290

Grid Consolidation Creates the Database Cloud
Oracle Real Application Clusters (Oracle RAC) and Oracle's grid infrastructure enable the consolidation of multiple applications on low-cost server and storage grids, providing unbeatable fault tolerance, performance, and scalability. This session, led by Oracle product manager Bob Thome, demonstrates how Oracle technology delivers key cloud capabilities, providing elastic database services that can be provisioned on demand in minutes.
Tuesday, September 21 11:00 a.m. Moscone South Room 308, Session ID: S317091

Learn more about this year's rich Database track at Oracle OpenWorld.

Oracle Exadata SIG Logo

2010-04-15T05:58:00.000-07:00

Exadata SIG invited SIG members to submit design ideas for Logo. We received several entries and the top four are posted here. Please use the survey below to Vote for your pick for Logo:

Use this url to submit your votes [http://www.surveymonkey.com/s/6NY6HPH]

Logo 1

Logo 2

Logo 3

Logo 4

Use this url to submit your votes [http://www.surveymonkey.com/s/6NY6HPH]

Sun Oracle Database Machine for Data Warehousing (Sep 30)

2009-09-18T18:22:00.000-07:00

Attend the Webcast on Exadata 2, titled "Sun Oracle Database Machine for Data Warehousing" brought to you jointly by Exadata SIG and BIWA SIG.

Speaker: Jean Pierre Dijcks - Data Warehousing Product Mgmt, Oracle

Abstract: On September 15 Oracle announced the second generation of its Database Machine, making an already strong data warehousing product significantly stronger. The new version runs on Sun hardware and offers important new features. Available in full rack, half rack, quarter rack, and basic unit configurations, the Sun Oracle Database Machine can add value at many data warehouse size levels.

The Sun Oracle Database Machine runs on Oracle Database 11g Release 2 and has new features such as:
Smart Flash Cache memory for ultra-fast IO - Reaches 50GB/second on a full rack system (not even counting gains from compression) Exadata Hybrid Columnar Compression - Maximizes data capacity and reduces scan times: think 500GB/second IO Offloaded Data Mining Scoring - Moves CPU-intensive operations from database servers to Exadata storage servers In-Memory Parallel Execution - Caches full tables in memory across nodes: foundation of new TPC-H world record There is plenty more we have not listed above, so come to this TechCast and learn about this major new product!
Web Conference: Link: https://conference.oracle.com/imtapp/app/cmn_jm_hub.uix?mID=158101510

Exadata Story in pictures

2009-09-15T17:58:00.001-07:00

Here is the story of Exadata 2 in pictures:

For Q&A on Exadata 2, click here.

--------------------------------------------

Oracle Exadata II - OLTP Database Machine with SUN Hardware

2009-09-15T17:31:00.000-07:00

Larry Ellison of Oracle unveils the Exadata Version 2: The First Database Machine for OLTP from Oracle using the SUN hardware. What does this mean for HP? It is the end of the HP Oracle Database Machine or the Exadata 1.

The Exadata Database Machine Version 2, made jointly by Oracle and SUN. It is pitched as the world's fastest machine for both data warehousing and online transaction processing (OLTP). Thus is meant for mixed mode loads. It is interesting that Larry, when announcing he Exadata I, last year said that OLTP system have 70% query load. Thus, Exadata 2, is a combination of faster query and write, to target the OLTP and hybtid loads on the large databases.

Exadata 2 uses the industry standard H/W components along with the FlashFire technology from Sun. The Exadata 2 requires Oracle 11g R2 and Oracle Exadata Storage Server Software Release 11.2. Larry claimed that the Sun Oracle Database Machine Version 2 is twice as fast as Version 1 for data warehousing. Oracle (and HP) will no longer make the Exadata 1 now.

The Sun Oracle Database Machine now is not confined to data warehousing applications. The difference is the addition of Exadata Smart Flash Cache based on Sun FlashFire technology to deliver extreme performance and scalability for online transaction processing (OLTP). Thus you can now have say Oracle E-Business Suite (EBS) and your Oracle BI Data Warehouse, all on the same Exadata 2 and the new hardware can handle mixed workload.

Exadata Version 2 will be available in four models:
> full rack (8 database servers and 14 storage servers),
> half-rack (4 database servers and 7 storage servers),
> quarter-rack (2 database servers and 3 storage servers) and
> a basic system (1 database server and 1 storage server).

All four Exadata configurations are available immediately to the customers. Larry said that with the Sun Oracle Database Machine, Oracle customers can store more data and search data more than ten-times faster without making any changes to applications.

Here is the Hardware and Software stack for Exadata 2

Sun's FlashFire memory cards enable high performance OLTP
80% Faster CPUs - Intel Xeon (Nehalem) processors
50% Faster Disks - 600 GB SAS Disks at 6 Gigabits/second
200% Faster Memory - DDR3 memory
125% More Memory - 72 Gigabytes per database server
100% Faster Network - 40 Gigabits/second InfiniBand
Raw disk capacity of 100 TB (SAS) or 336 TB (SATA) per rack

Software from Oracle

Features the world's first flash-enabled database - Oracle 11g Release 2
Hybrid columnar compression for 10-50 times data compression
Scans on compressed data for even faster query execution
Storage Indexes to further reduce disk I/Os
Offloading of query processing to storage using Smart Scans
Smart scans of Data Mining models in storage servers
Applications running on the Sun Oracle Database Machine achieve up to 1 Million I/O Operations per Second to Flash Storage

Exadata SIG at Oracle Openworld 2010 - Click on the Image to Enlarge it

2009-09-13T13:21:00.000-07:00

HO Oracle Database Machine v/s OLTP Database Machine

2009-09-13T13:01:00.000-07:00

YADM - (Yet another database machine), this time it is an OLTP machine to be announced on Tuesday - Sep 15. See the details here "Announcing the World’s First OLTP Database Machine with Sun FlashFire Technology "

The HO Oracle Database Machine and Exadata storage announced in the Oracle Openworld 2008, was mainly targeted to the high end data warehousing. Some of the pioneers to use this were Giant Eagle, LGR Telecomm etc. It was based on HP hardware. This new offering targeted at OLTP databases, is based on Sun hardware.

Oracle Exadata (IOUG SIG)

2009-04-04T11:45:00.001-07:00

The Oracle Exadata Special Interest Group under IOUG has taken off informally with over 100 members now. Please visit the Linkedin site to keep informed about the Oracle Database Machine / Exadata related webcasts. The next one is on April 16th, again check the above site to register for it. These webcasts are brought to you for free.

Oracle University has started offering paid education on Exadata as well. The virtual classes cost $600 and more details are here:

Thanks
Shyam V Nath
http://oracleexadata.org/

Oracle Exadata

2008-09-25T10:56:00.000-07:00

You source of information for HP Oracle Database Platform and Exadata