Oracle Exadata Virtual Conference 2012 (Friday Jan 2012)

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?

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

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: ExaFamily  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

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

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

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

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

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

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

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.

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

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!