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!