Educational Workshop - June 29, 2017!

[sam]

UNYOUG Educational Workshop Day
Thursday, June 29, 2017 9:00AM - 4:00PM (breakfast & registration start at 8:00AM)

Rochester Institute of Technology
134 Lomb Memorial Drive
Golisano College of Computing and Information Sciences
Golisano Hall (GOL) Auditorium & Atrium

Click here for area map. (General Parking, Building marked "GOL")

Presentations:

Oracle Cloud Machine
Steve Van Hall, Oracle

GoldenGate, Let’s Get Started
Mike Messina, Rolta AdvizeX

Partitioning and Compression for Performance and Manageability
Mike Messina, Rolta AdvizeX

ZFS Backup Appliance
Sandip Rana, Oracle

Oracle Zero Data Loss Recovery Appliance
Chris Veenstra, Oracle

Query Tuning: Understanding How Cardinalities Influence the Optimizer
Rich Ignizio, Paychex


Agenda:

8:00 - 9:00 Registration and Networking, Continental Breakfast

9:00 - 9:10 Welcome, Sam Brunacini

9:10 - 9:50 Oracle Cloud Machine

10:00 - 11:00 GoldenGate, Let's Get Started

11:00 - 12:00 Partitioning and Compression

12:00 - 1:00 Lunch

1:00 - 2:20 Oracle ZFS Backup & Zero Data Loss Recovery Appliances

2:30 - 3:30 Query Tuning

3:30 - Raffles, wrap-up

Registration:
A continental breakfast and lunch will be provided. We need a count of persons attending to properly plan for this event. If you are planning to attend, please pre-register for the meeting here: http://www.unyoug.com/register.php.

Membership & Fees:
UNYOUG membership is $20 per year. Sponsored by Oracle, Rolta AdvizeX, and RIT!

[sam]

Oracle Cloud Machine
Steve Van Hall, Oracle

Oracle Cloud Machine delivers Oracle Cloud in your data center. Rather than procuring hardware, installing software and managing the system, you easily consume the same cloud services on your premises, just like you do in Oracle Cloud. Oracle Cloud Machine includes a wide range of Oracle Cloud services - Oracle Platform as a Service(PaaS) including Java Cloud Service, Integration Cloud Service, Database Cloud Service and Oracle Compute Infrastructure as a service (IaaS). You can use these cloud services as building blocks to accelerate the development of your innovative applications while maintaining complete control of your data and systems. ORACLE CLOUD MACHINE Operated by Oracle in your data center for your convenience, and available as a subscription, Oracle Cloud Machine delivers the benefit of aligning spending with the revenue realized from applications. Oracle supplies the hardware, installs the software, and handles the day-to-day operations.

[sam]

GoldenGate, Let’s Get Started
Mike Messina, Rolta AdvizeX

With Oracle Database 12c some features are being deprecated like streams and advanced replication. With this deprecation we have to replace this functionality. In this presentation we will introduce Golden Gate as the replacement for these features. We will cover the basic architecture of Golden Gate and it functionality that can more then just a replacement for stream and advanced replication, but a tool that we can utilize for upgrades, consolidation, migrations and Extract Transformation and loading.

* What is Golden Gate
* Why Use Golden Gate
* Golden Gate Architecture
* Golden Gate Requirements/Limitations
* Golden Gate one-way Replication
* Replace Streams
* Near 0 Downtime Platform Migration
* Near 0 Downtime Upgrade
* Near 0 Downtime Maintenance
* Golden Gate Multi-master Replication
* Golden Gate Extract, Transform, Load (ETL)
* Load Your Datawarehouse
* Some Best Practices for Manager Process
* Some Best Practices for Extract Processes
* Some Best Practices for DataPump Processes
* Some Best Practices for Replicat Processes
* Golden Gate Basic Troubleshooting Tips
* Golden Gate Basic Tuning Tips
* Monitoring Golden Gate
* Questions/Discussion * Myth 1: You need a NoSQL DB to scale
* Myth 2: You need to abandon ACID transactions to scale
* Myth 3: You need to de-normalize [no joins] to scale
* Myth 4: You need to manually shard your DB to scale
* Myth 5: You need to re-write your apps to scale

Mike Messina - Senior Managing Consultant at Rolta-AdvizeX

Oracle Database professional with over 20 years experience, I have been honored as an Oracle Ace, achieved the Oracle Certified Database Professional (OCP) 9i and 11g (OCP) and Oracle Database 10g Real Application Clusters Cetified Expert. I have also achived several Oracle Partner specializations including Oracle Exadata Certified Implementation Specialist, Oracle Database 11g Certified Implementation Specialist and Oracle RAC Implementation Specialist. I was blessed to have been able to provide contributions to Rich Niemiec’s Oracle Database 11g Release 2 Performance and Tuning Tips and Techniques Book. I am a frequent presenter at local Oracle Users Groups and privileged to have presented at Open Word 2009/2010, RMOUG 2010/2011/2012 and IOUG Collaborate 2010/2011/2012. My experience includes database performance tuning, database high availability, database disaster recovery, system design, and system development. I have lead many projects for performance improvement, large scale maintenance, database implementation, disaster recovery, high availability and system development projects various environments including medical and hospitals, manufacturing, financial institutions, state and local governments, universities and various federal agencies including the Department of Defense. Specialties: Oracle ACE Oracle Database 10g: RAC Certified Expert/Implementation Specialist Oracle Database 11g Implementation Specialist Oracle Exadata Implementation Specialist Oracle Database Certified Professional (OCP 9i/11g) Database Administration (Oracle(7/8/9i/10g/11g)/MySQL 5/PostgreSQL) Database Disaster Recovery (DataGuard/Golden Gate) Database and SQL Performance Tuning Database Replication (Golden Gate) PL/SQL Oracle Enterprise Manager 10g/11g/12c Oracle Weblogic Application Server (Fusion Middleware 11g)

[sam]

Partitioning and Compression for Performance and Manageability
Mike Messina, Rolta AdvizeX

Using Oracle partitioning features and compression options we can maximize cost savings as well as performance while not sacrificing ease of management. New partitioning features can help us improve performance, combining with Advanced Compression and Hybrid Columnar compression to reduce disk storage costs and inch out some further performance improvements all while making sure it is still easily managed. Show examples and demonstrate cost savings and performance gains and management ease.

Outline
* Touch on industry challenges
* Explosive Data Growth
* Performance
* Costs
* Look at Partitioning Features that improve performance and do not add management overhead
* Examine 11g Advanced Compression and impact using 11g partitioning features
* Show impact of hybrid columnar compressing
* Show how Partitioning and Advanced Compression together help address some of the industry challenges

[sam]

ZFS Backup Appliance
Sandip Rana, Oracle

Regardless of data source—Oracle Database or any other database or application, the ZFS Backup Appliance can backup and restore data faster and more economically than competitive offerings: up to 6X the speed at half the cost, and half or less of the footprint

[sam]

Oracle Zero Data Loss Recovery Appliance
Chris Veenstra, Oracle

Oracle’s Zero Data Loss Recovery Appliance is a ground-breaking data protection solution for Oracle Database that eliminates data-loss exposure by recovering data to the last sub-second without impacting production environments.