Or is it TechCast, or simply Online Event? You’ll see them all here because IOUG draws Oracle speakers, experts and presenters from all over the place (and they can call their events whatever they like). What they have in common, though, is professionalism, passion and a goal of bringing you smart and actionable information you can use right away. Whether registering for an upcoming event or looping back to check out ones you missed, you've come to the right place for all things Oracle.
Register for This Session
Oracle Database In-Memory is the industry-leading in-memory database technology, accelerating analytics by orders of magnitude as well as improving hybrid OLTP applications. This session provides an overview of the dual-format technology underlying Database In-Memory and the features that enable analytic processing speeds of billions of rows per second. You will learn about the innovations in Oracle Database 12c Release 2, as well as new features introduced in Oracle Database 18c such as Automatic In-Memory, In-Memory Optimized Arithmetic, and many more performance enhancements.
You will also learn how an Oracle Database In-Memory customer leveraged the technology to move their datawarehouse to the Oracle Cloud, and how they managed to lead the company in enabling timely business and strategic decisions. You will learn how this customer unleashed the power of In-Memory and the results they saw.
In this session, you will:
- Get a broad overview of Oracle Database In-Memory Technology
- Learn about the latest innovations
- Learn from the real-world experiences of an In-Memory customer
Learn More about the Quarterly Database In-Memory Series here
To the Cloud and Back: Processing Data in the Cloud for On-Premises Analytics
Tuesday, October 2, 12:00p.m. - 1:00p.m. Central
Organizations are adopting the cloud for a variety of reasons that span from cost savings, accessibility and more. While the cloud often provides favorable reasons for storing and managing data, there are often times when storing data from the cloud to the on-premises (on-prem) environments is favorable.
In this webinar, your hosts--data integration experts--Mark Van de Wiel and Joe deBuzna, will discuss scenarios in which their customers require that their data be processed in the cloud but then integrated back to their on-prem environment. Your hosts will talk about the challenges and considerations in architecting a solution that enables these requests.
To illustrate how this scenario can be achieved, Mark and Joe will show a demo of an on-prem Oracle Database to Oracle RDS back to on-prem Oracle for real-time analytics. Through the demo, they will show how you can secure your setup, reduce latency and ensure data correctness within a single setup.
What you will learn:
- Why organizations are selecting a hybrid approach to data processing
- Benefits of a hybrid cloud approach
- Considerations for architecting a hybrid cloud approach
Mark Van de Wiel, CTO, HVR
Bio:Mark has over twenty years experience in the data replication, integration, real-time BI and analytics market. Mark is the CTO at HVR and previously held roles at Oracle GoldenGate and Actian.
Joe de Buzna, VP of Field Engineering at HVR
Bio: Joe has nearly twenty years experience in the data integration and high availability market delighting thousands of customers by producing and delivering innovative products and solutions. Joe is currently the VP of Field Engineering at HVR, a real-time data integration solution. He has worked at Oracle GoldenGate, Quest, and started his career as an Oracle DBA.
Winning Performance Challenges in Oracle Standard Editions
Thursday, October, 4, 12:00p.m. - 1:00p.m. Central
Oracle Diagnostics and Tuning packs offer comprehensive valuable performance diagnostics and tuning features such as : AWR, ADDM, ASH, ASH Analytics, etc. These optional packs can be licensed only on top of the Oracle Enterprise Edition. Without these packs, diagnosing performance issues may become a very complex task – even for advanced DBAs. In this session we will explore how you could leverage Oracle’s Statspack report and dictionary views to diagnose performance issues even without using any expensive editions and packs. In addition we will see how Quest tools can help DBAs to diagnose and solve even the most complex performance issues without relying on the Diagnostics and Tuning packs and for all the Oracle Database editions.
Pini Dibask, Product Manager, Database Performance Monitoring, Quest
Bio:Pini Dibask is an Oracle ACE and Oracle Certified Professional with more than 10 years of experience working as a DBA and Database Team Leader. He is currently a Product Manager for database performance monitoring solutions at Quest and passionate about building products people love that solve real-world customer pains. Pini specializes in database performance tuning, high availability, data protection, and other core database areas. He is a frequent speaker at various conferences and database venues around the world including Oracle OpenWorld, IOUG Collaborate, RMOUG, DOAG, OUGN, and others.
Server-Side Development for the Cloud: When TUNING means MONEY!
Tuesday, October, 9, 12:00p.m. - 1:00p.m. Central
When you transition from on-site development to development in the cloud, your system undergoes some significant shifts.
- Hardware resources are no longer static.
- Expense model is flexible (up to even “pay-per-use”)
Previously, as long as your current servers were surviving the workload, it did not matter whether they were 50% or 70% utilized. Now, this difference can be immediately converted to real money because the resource elasticity means that you can give it back (remember, elasticity works both ways!). Considering that the database licensing cost is $47,500 per CPU for the Oracle Enterprise Edition, proper tuning of your system could save enough money to become noticeable to management.
Recently, the author encountered a number of real-world situations where the CPU footprint was successfully decreased after adjusting SQL and PL/SQL routines. This webinar will discuss some of the resulting best practices:
· Research techniques:
o Code instrumentation – In order to solve any performance problem you first need to detect it. DBMS_APPLICATION_INFO allows more granular logging and tracing
o Profiling – Even if you can detect a performance problem, you need to find its exact location. The Hierarchical Profiler is your best resource for that search.
· Coding techniques:
o Avoid context switches between SQL and PL/SQL, or at least decrease its frequency/ cost. Using PRAGMA UDF or WITH-clause functions is very helpful in that regard.
o Don’t reinvent the wheel – There are some very powerful SQL features (analytical functions, PIVOT/UNPIVOT) that are often ignored by the majority of developers.
o Don’t do things multiple times - Various caching techniques can help reuse what is already known.
o Collections in-memory processing are still the fastest way of calculating anything. Wide usage of SET operations decreases the number of context switches as well.
This webinar will demonstrate why server-side developers are mission-critical in 21st century IT departments since it’s all about money. Isn’t it?
- Attendees will learn how cloud-based implementation of databases impacts server-side development requirements
- This webinar will demonstrate the role of SQL and PL/SQL in building well-performing cloud-based solutions.
- Attendees will learn methods for making the code base less CPU-intensive.
Michael Rosenblum, Software Architect/Development DBA, Dulcian Inc.
Bio: Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), PL/SQL Performance Tuning Tips & Techniques (Oracle Press, 2014), contributing author of Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc.), and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award.
Access Our Past Webinars
The Future of DBAs in a World of Autonomous Databases
NEW! This presentation will uncover the reality behind the assertion that Autonomous Databases mean “the Death of the DBA” and detail which parts of Database Administration will be "Autonomous" and which will not. It will also suggest ways current DBAs can expand and update their skills to remain relevant in this new world. It will show that the need for skilled and experienced "data people" will actually increase and expand.
Speaker: Clay Jackson, Database Systems Consultant, Quest
Bio: Clay is a Database Systems Consultant for Quest, specializing in Database Performance Management and Replication Tools. Prior to joining Quest, Jackson was the DBA Manager at Darigold. He also spent over 10 years managing Oracle, SQLServer and DB2 databases and DBAs at Washington Mutual. While at WaMu, Jackson was the Enterprise Database Compliance Officer, with responsibility for Database Security and Disaster Recovery. He was also responsible for Oracle databases at Starbucks and US West. While at Starbucks, he participated in the Oracle 7 Alpha Test, and was part of the Oracle Very Large Database Customer Focus Group. He is also part of the OAK Table Group.
|Access the Archive|
The New Laws of Long Term Storage
Hey storage architects! With the explosion of unstructured data, and new challenges like ransomware and GDPR compliance, the laws of long term storage are changing. And with the rise of cloud storage services, storage architects are being inundated with different options. Join this webinar to understand what alternatives are available, and practical steps you can take the make the right decision for your infrastructure.
- Eric Bassier, Senior Director, Data Center Products and Solutions, Quantum
|Access the Archive|
Dig into Autonomous Database in the Cloud
Join us for the first in a monthly series of webinars where we'll be partnering with Oracle experts on deep-dives into the technology behind the Oracle Public Cloud.
An autonomous future – powered by Oracle
The rise of data as a form of capital, and therefore your enterprise database, will have a direct impact on the future success of your business. Whether you are looking to unlock the value of your application data or just interested in integrating all your data and making it accessible to all your employees, join this session to learn how data management in the Cloud using Autonomous Database Cloud can transform your business and give you a competitive advantage. This session will also include a deep dive of the autonomous technology and show you what a self-driving, self-repairing and self-securing database really means.
- Monica Kumar, Vice President, Product Marketing Database and Big Data, Oracle
- Maria Colgan, Oracle
|Access the Archive|
CodeTalk Series: JSON and PL/SQL: A Match Made in Database
Darryl Hurley of Implestrat and Steven Feuerstein will follow up from their popular first JSON CodeTalk session in 2017 with a session focused on features added in Oracle Database 12c. Release 2 to support manipulation of JSON documents in PL/SQL. We'll also take any and all questions on working with JSON via SQL, support for which was added in Release 1. Want to make your UI developers happy? Then get really good at serving up JSON to them via a PL/SQL API! This CodeTalk session will help you get the expertise you need to do this.
- Steven Feuerstein, Oracle Corporation
- Darryl Hurley, Implestrat
|Access the Archive|
View the full CodeTalk On-Demand Archive
Miss one? Watch IOUG Webcasts On-Demand for FREE! (Membership not required.)