MAY
06

SA Let’s Talk Oracle Database - CBO and new generation Exadata

Where: Adelaide - Oracle Office - Level 19, 25 Grenfell Street, Adelaide
When: Friday, May 06, 2016 08:30am - 01:30pm

You are cordially invited to the upcoming "Let's Talk Oracle Database " in Adelaide on Friday 6th May.

Session Overview

Intro into the Cost Based Optimizer - Why is the CBO doing a full table scan?

A common issue is confusion on why the Oracle Cost Based Optimizer (CBO) has made the decision the use a full table scan or use that index and not the one that appears more appropriate. The costing figures that the CBO derives and displays in execution plans are often viewed as cryptic, which is unfortunate as these costings are key to CBO decisions. Often the attempt to resolve such issues is to set inappropriate database parameters that introduces as many issues as it tries to resolve. This session looks under the covers of the CBO to see how it precisely derives its various costings and hence how to correctly troubleshoot and resolve inefficient queries when they arise.

Bring a calculator, it might come in handy ☺

Exadata Secret Sauce and Software on Silicon – Database Features

Oracle is soon to release the new generation of the Exadata machine. Not only is it bigger and faster but also has a host of features and capabilities that is unique to the Exadata storage platform including Smart Scans, Storage Indexes, Exafusion, Smart Fusion Block Transfer, Dual Format Columnar Flash Cache, I/O Latency Capping, Hybrid Columnar Compression, Sparse Snapshots and In-Memory Database Fault Tolerance. All these unique features and their enhancements will be discussed. Additionally, Oracle's Software-in-Silicon features extend the concepts of co-engineering hardware and software inherent in engineered systems such as the Exadata. Embedding software which has traditionally sat in the database layer into the hardware layer can yield both performance and security beyond that available of a traditional CPU. This presentation also covers how Oracle Database 12c can leverage Software-in-Silicon features, where the Oracle Database is heading in the future and why you should care.

 

Presenter: Richard Foote, Database Guru and former Oracle ACE Director
Target Audience: Oracle DBAs, Applications Developers, other technical professionals
Time: 8:30 a.m. - 1:30 p.m. (Coffee and Lunch provided)
Date: Friday 6th May 2016
Venue: Oracle, Level 19, 25 Grenfell Street, Adelaide
Registration: Click here to register
Questions: brodie.james@oracle.com

Agenda:

8:30 a.m. - 9:00 a.m. Registration and coffee
9:00 a.m. - 10:00 a.m. Intro to the CBO - Part I
10:00 a.m. - 10:15 a.m. Break
10:15 a.m. - 11:15 a.m. Intro to the CBO - Part II
11:15 a.m. - 11:30 a.m. Break
11:30 a.m. - 12:30 p.m. Exadata Secret Sauce and Software on Silicon
12:30 p.m. - 1:30 p.m. Lunch, Networking and informal Q&A

 

TOP OF PAGE


Please support the AUSOUG partners as they support you.

Silver Partner

Silver Partner

Contact president@ausoug.org.au to become an SA State Partner