Presentations

2018

Everything You Know Is Wrong: DBA Intuition, Meet Hard-Core Metrics

Handling application performance degradation – especially when an RDBMS as complex as Oracle Database 12cR2 underlies the application – can be a complex, time-consuming, frustrating task. Via actual use cases, stories of painful discoveries, and of course some hard-core metrics, this session will take a look at some of the simplest mistakes even an Oracle DBA can make when probing application performance issues and how to overcome one’s own blind spots when searching for the true root causes of that degradation.

Caveat Nuba Emptor: Matching Your Organization’s 12cR2 Needs To the Best OPC Database

 You’re an Oracle DBA whose CIO has at last agreed to embrace the Oracle Public Cloud (OPC) and now you’re ready to begin your journey. But now you face another difficult task: choosing from an almost dizzying array of options as you start your trek to building your first 12cR2 database in the OPC.

This session will give you some much-needed practical advice using an actual example of implementing an application performance evaluation environment using Swingbench’s TPCDS model to compare the original Oracle Database as a Service (DBAAS) – aka the Database Schema Service – versus its latest and greatest incarnation, Exadata Express and even the newest “bare metal” OPC options so that you can choose wisely, begin your OPC trek, and never regret your decision.

Saving Your Database from Alzheimer’s: Analytic Performance Improvements From Oracle 12cR2 Database In-Memory (DBIM)

Oracle Database 12.2.0.1 (12cR2) significantly improves the performance of Database In-Memory (DBIM) features, offering potentially massive improvements in real-time analytic processing and queries This session takes a deeper look at what the Oracle 12cR2 optimizer is actually doing “under the covers” when it makes its decisions to process a query against IMCS-resident and non-resident tables, including improved In-Memory Joins, leveraging Join Groups, taking advantage of In-Memory Expressions, and utilizing In-Memory Filtering effectively. We’ll look at some real-world performance improvement metrics obtained against an Exadata Express OPC environment that shows how best to tackle using these newest DBIM features.

Leveraging Partitioned External Tables: Primer and Practical Examples

Oracle Database 12c is the first release to offer the capability to access a file in HDFS or HIVE format as an EXTERNAL table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language.

Get Smart! Embrace #SmartDB To Restore Application Code To Its Rightful Place 

Almost every modern IT organization has struggled with the best place to locate crucial application code bases -inside the application server layer, or inside the database itself? The good news is that Oracle Database 12c has helped push the argument towards locating the majority of application code within the database through several key feature sets, especially Edition-Based Redefinition (EBR). This session will offer several practical examples of how any Oracle DBA can build a case for and then implement the best practices of the #SmartDB paradigm within their organization while making their application developer colleagues happier than ever.

2017

Oracle 12cR2 Database In-Memory Adventures with Swingbench TPC-DS

Stop Guessing, Start Analyzing: New Analytic View Features in Oracle Database 12cR2

DBA 2.0 Is Dead. Long Live DBA 3.0!

2016

Migrating and Upgrading to Oracle Database 12c Quickly With Near-Zero Downtime

Regression Analyzed, Tout de Suite: Leveraging Oracle 12c Database Real Application Testing (RAT) Suite

DBA, Heal Thyself: Five Diseases of IT Organizations and How to Cure Them

The Wolf is Always At the Door: Oracle Database 12c Security Solutions

Analyze This! Leveraging Oracle 12c Analytic Functions

2015

The Best of Both Worlds: In-Memory Column Store and Advanced Index Compression in Oracle Database 12.1.0.2

Precisely My Point:  Leverage Attribute Clustering and Zone Mapping in Oracle Database 12.1.0.2

A Smart Optimizer Gets Even Smarter: Demystifying Oracle 12c Database’s New Histograms

Just SQL Often Needed: Leveraging JSON Features in Oracle Database 12.1.0.2

2014

How Hot Is My Data? Leveraging Automatic Data Optimization (ADO) Features in 12c Database for Dramatic Performance Improvements

Blink and You’ll Miss It: Migrating, Cloning and Recovering Oracle 12c Databases At Warp Speed

Something Old, Something New: Leveraging Oracle 12c’s Information Lifecycle Management (ILM) Features for Improved Database Performance

Hands-Free Optimization of Complex Queries in Oracle 12c Using AEP, ARO, and SPDs

2013

An Exploration of the Next Generation of the Oracle Database

Parallelize or Perish: Implementing Oracle 11gR2 Parallelism Features for Maximum Performance

When Smart Scan Plays Dumb, Teach Exadata Some New Tricks

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s