AZORA Meeting January 26, 2017 – Meet and Hear: Biju Thomas, Charles Kim, and Jerry Ward

Arizona Oracle User Group (AZORA)


When:   Thursday January 26, 2017 – 12:30 pm to 3:30 pm

Where:   Republic Services – 1st Floor Training Rooms
14400 N 87th St (AZ101 & Raintree), Scottsdale, AZ

At January’s AZORA meeting we’ll have a total of four presentations; two sessions running at the same time in different rooms. (see descriptions below)

Bring a partner to make sure your organization does not miss out on any of the content.

We’ll have pizza for lunch and cookies later in the day thanks to the generosity of OneNeck IT Solutions and Viscosity North America.

Once again, Republic Services will host (thank you Republic) in two of their brand-new training rooms on the first floor.

When:           January 26, 2017 (Thursday) 12:30 pm – 4:00 pm

Where:         Republic Services
1st Floor Training Rooms
14400 N 87th St (AZ101 & Raintree)
Scottsdale, AZ

Agenda (see abstracts and speaker profiles below)

Time                   TopicPresenter
10:00 - 10:30Registration and Coffee
10:30 - 11:30Rich Niemiec, Viscocity Chief Innovation Officer and Oracle ACE DirectorInnovation, the Cloud, Big Data, the Internet of Things and What’s Coming Next: Preparing for the Future of IT
11:30 - 12:30Jerry Ward, Viscosity Managing DirectorFall in love with Oracle APEX
12:30 - 13:15Lunch
13:15 - 13:45Benoit Chaffanjon, Global Oracle Solution Center Chief Architect & CTOOracle Solution Center Overview

Speakers and Abstracts

Biju Thomas – OneNeck IT Solutions

Biju Thomas is Oracle ACE Director, Oracle Certified Professional and Certified Oracle Database SQL Expert. He is Principal Solutions Architect at OneNeck IT Solutions. Biju has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He spends time mentoring DBAs, performance tuning and architecting Oracle solutions. He is a frequent presenter at Oracle conferences and writes articles for Oracle technical journals. He has authored Oracle certification books published by Sybex since Oracle8i, all versions including Oracle Database 12c OCA. Biju blogs at and you can follow him on twitter (@biju_thomas) or Facebook (oraclenotes) for daily Oracle Tidbits.

Oracle Database 12c New Features for 11gR2 DBA

SLIDES: 2017_AZORA_Db12c_NewFeatures

Oracle Database 12c comes with large number of features – from as small as a default value of parameter to core database architecture with Multitenant. This session will show the 11g DBAs and Developers how they can quickly start using few of the 12c features and understand some behavior changes. Session will also cover the features introduced in Session will focus on the changes and features you can expect when you upgrade your 11g database to 12c.
The session will focus on the changes in 12c database compared to 11g database, and introducing new 12c features that come with an upgrade. We will cover features like (not limited to)
– Upgrade runs in parallel (using instead of catupgrd.sql)
– TRUNCATE has a new CASCADE option
– How many DB Writer processes allowed
– What is COMMON_USER_PREFIX parameter for
– Why READ privilege when we have SELECT privilege
– Row limiting
– Faster approximate count
– Rename a disk within an ASM diskgroup
– Datapump Import without generating archivelogs
– What is SPARE6 column in SYS.USER$ for
– And many more (over 30 features and tips)

Introduction to Oracle Databases in the Cloud

SLIDES 2017_AZORA_Cloud_Database

Larry Ellison announced during 2016 Open World that Oracle Database 12c Release 2 will be released on the cloud first. Cloud is the direction Oracle is promoting. Oracle database cloud service may be suitable for many of the workloads you have today. It may be time for DBAs to get familiar with the cloud offerings on Database as a Service (DBaaS) from Oracle. This session will introduce you to the various database cloud services available, real world use cases and a live demo. You will also learn how to connect to a database in the cloud using SQL Developer, logging into the host machine running the database, migrating data to the cloud and few best practices. Even if you do not move your database to the cloud, moving the database backups to the cloud may be an attractive option!
Database Cloud Service offers elastic database services for application development, test and production deployment. The service delivers an easy to use web console user interface and RESTful API to provision and administer Oracle Database. The Exadata Cloud Service brings the full power of Exadata to the Oracle Cloud. For small and medium sized databases, you have Oracle Database Exadata Cloud Service. And finally if you don’t need a full database instance but still want the power of Oracle Database for your app development projects try the Oracle Database Schema Cloud Service.
– Participants will understand and know the various cloud DaaS and DBaaS offerings available.
– They will learn basic database and host connectivity using familiar tools
– Learn how to use backup as a service to perform databases backups to the cloud
– understanding various cloud offerings will help them choose appropriate cloud service

Charles Kim – Viscosity North America

Charles Kim is a co-founder and President of Viscosity North America, an Oracle ACE Director, and a VMware vExpert. Charles is an Oracle Certified DBA, a Certified RAC Expert and a Certified Exadata Implementation Specialist. Charles specializes in Exadata, RAC, and Virtualization (VMware and Oracle VM) and authored 7 books:

Oracle Database 11g New Features for DBA Developers
Linux Recipes for Oracle DBAs
Oracle Data Guard 11g Handbook
Virtualize Business Critical Oracle Databases
Oracle Exadata Exadata’s Handbook
Hadoop As A Service
Oracle ASM 12c Pocket Reference Guide

Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft and has over 23 years of Oracle experience. Charles sat on the panel of oracle experts at VM World and Oracle OpenWorld for virtualization and Linux. Charles was one of the founding members of the virtualization SIG that launched in 2011 at Oracle OpenWorld. Charles is currently the Vice President of the Cloud Computing SIG for the IOUG.

Bullet Proof Your Data Guard Environment

SLIDES Bulletproof Your DG BP 1.1

Compliance to industry best practices can easily be achieved. This session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. Attendees will learn how to setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard).

The session concentrates on:
o Building the Physical Standby
o Monitoring and Maintaining the Physical Standby
o Configuring Data Guard Broker
o Performing Backup and Recovery with RMAN
o Setting Archive Retention
o Performing Switchovers and Failovers
o Integrating Data Guard with OEM 13c
o What is new in Oracle Data Guard 12.2

Gerald Ward – Viscosity North America

Jerry Ward is a co-founder of Viscosity North America. Jerry has served as a consulting Architect for the VHA, Kellogg Brown and Root, Invesco, Fidelity National Financial, Dresser Rand, Ericsson, Nortel Networks, and the Human Genome Sequencing Center (BCM). Jerry has worked with Oracle technology since 1991, including Oracle database version 6+ and Oracle Applications version 9+.

He has been featured in the Houston Chronicle, Venice Magazine, 002 Houston, KXAN Austin, Tyler Morning News, Gulfscapes Magazine, and other business publications.

Building Faceted Search Navigation in Apex with Oracle JET and PL/SQL Pipelines

Faceted navigation is arguably the most significant search innovation of the past decade. Leveraged by retail sites including Amazon, Home Depot, and Zappos, Facted search allows users to quickly narrow a massive result set by giving them guides (the facets) of the major groups of their results. In this session, we discuss both thick and thin ways of doing this, from enterprise applications like Oracle Endeca to simple methods using PL/SQL pipelined functions. We show you a retail use case and how a working PL/SQL faceted database search, Apex application, and Oracle JET extensions.