Skip to Main Content

Office Hours - Past Sessions

Archive

If you weren't able to attend an Office Hours session live, you can still learn from the presentations and Q&A by watching a replay of the session.

DateDescendingSessionFocusDescription
October 22, 2020What's new in APEX 20.2What's new in APEX 20.2There are many new features coming in APEX 20.2. In this session, we will present and demonstrate the marquee features of this latest release.

Joel Kallman, Senior Director, Software Development
Marc Sewtz, Senior Software Development Manager
October 22, 2020Data loading, Hakan factor, Scheduler Timezones and moreData loading, Hakan factor, Scheduler Timezones and moreIn this Office Hours session we discussed loading data without suffering an out, understanding the scheduler timezones, and using the little known Hakan factor to improve the space utilisation of workflow style database tables.

Connor McDonald, Developer Advocate
October 20, 2020Getting Started with JSON Document Collections in the Autonomous JSON DatabaseGetting Started with JSON Document Collections in the Autonomous JSON DatabaseIn this session, I’ll introduce you to the Autonomous JSON Database (AJD). AJD is exciting because it represents the very first time we are offering a dedicated solution for JSON document collection persistence in the Oracle Cloud. It represents our commitment to offering developers tools and solutions that help them solve the problems they face when developing microservices and applications instead of trying to convince them to use a tool that might not be the best fit for them. Like all good solutions, it is scalable and adaptable which means that it can transform into a full-blown Autonomous Transaction Processing database if your needs dictate that in the future. We’ll get hands on in this session and I’ll show you how to launch a new AJD instance and immediately persist and retrieve JSON documents and collections via SQLcl. I’ll also show you how to use the SODA module for Node.JS to work with your AJD instance. Of course, you’re not limited to just Node.JS - we also offer SODA packages for Java, Python, C, REST and PL/SQL so you can choose the package that best fits your needs.

Todd Sharp, Developer Advocate
October 20, 2020Create Drive Time Areas and Perform Drive Time Distance AnalysisCreate Drive Time Areas and Perform Drive Time Distance AnalysisWant to find the nearest pizza place, check if all homes in the city can be reached by fire stations within 10 minutes, or understand the market areas covered by store locations? Drive time/drive distance analysis can answer these and many more business planning questions. For example, defining a trade area requires accurate estimations of travel time and distance of customers to-and-from business location(s).

In this session, you'll learn how to conduct large-scale drive distance/drive time analysis using the Network Data Model (NDM), a part of Oracle Database spatial features. We'll show how to generate network buffers from NDM data models and how to perform queries on them. We'll discuss some use cases of network buffers on trade area analysis and geofencing. We'll also talk about finding the nearest point of interest (a restaurant, a convenience store, or a gas station) in a location-based service and discuss vehicle deviation detection in fleet management to ensure a driver follows a planned route.

Carol Palmer, Senior Principal Product Manager
Jack Wang, Director of Software Development - Spatial and Graph
Xiangtai Hou, Senior Member of Technical Staff
October 20, 2020Finding the Longest Common Substring and Gestalt Pattern MatchingFinding the Longest Common Substring and Gestalt Pattern MatchingIn this session Stew Ashton joins Chris Saxon to discuss a recent question on Ask TOM: implementing the Ratcliff-Obershelp similarity algorithm to rank how similar two strings are.

This works by recursively finding common substrings in the source words. Stew and Chris discuss how to do this using SQL and PL/SQL, comparing the performance of various solutions to find the fastest method.

The winner may surprise you (hint it's not SQL).

Chris Saxon, Oracle Developer Advocate for SQL
Stew Ashton,
October 15, 2020Moving Logs with Oracle Service Connector HubMoving Logs with Oracle Service Connector HubEnterprise customers need the ability to move, mask, filter and validate data i.e. Logs, Metrics, Stream messages, etc. in near real time from many Oracle Cloud Infrastructure services to destination sinks like Object Storage, Streaming, Monitoring for additional processing or compliance storage needs. In addition, Developers need the ability to build event driven applications which react to these events or messages, process the data to take actions in near real time via target services like Functions (for custom processing) and Notifications. In this webinar, we will demonstrate how the Service Connector Hub addresses the above needs, specifically in the context of Observability by moving logs from the Logging Service to Oracle Cloud Infrastructure services such as Object Storage, Streaming, Monitoring, Functions and Notifications for the purposes of archival, integration with 3rd party tools for running analytics, alarming in near real-time, lightweight data transformations and notifications.

Vimal Kocherla is the Product Manager for the OCI Service Connector Hub.

Marcie Samuelsen, Developer Marketing Manager
October 15, 2020Ingest, Analyze, and Manage Your Logs with OCI LoggingIngest, Analyze, and Manage Your Logs with OCI LoggingLearn how to get started with OCI Logging!

OCI Logging is natively integrated with your OCI resources to provide you a centralized view for all your logs – Infrastructure, Audit, Application, and Database. Logging lets you to ingest and manage logs generated by your resources and applications. You can use the powerful analytics engine to search and analyze logs, and use the intuitive rules engine to act in near real-time on any log event.

Mohamed Sleem is a Product Manager in the OCI Observability team where he is responsible for shaping the long-term roadmap & strategy for OCI Logging, Events, Audit, and SIEM. He joined OCI in October 2018, and was previously a Product Manager in Azure. He has also previously been in Product Manager roles working on Search, Indexing, and Analytics technologies in products such as Bing and Microsoft Office.

Marcie Samuelsen, Developer Marketing Manager
October 15, 2020Continuous Database Migrations with PL/SQLContinuous Database Migrations with PL/SQLDatabase migrations need to happen frequently to apply changes in database applications. Those migrations can be small, like adding new objects or changing some procedures or functions. Migrations can also be more extensive, like migrating large tables. In both cases, the database migrations need to be robust and repeatable if something goes wrong. In this PL/SQL Office Hours, we will explore practices to ensure high quality in your PL/SQL database migrations. We will have a look which elements make your database migrations repeatable and give an introduction on how to get started with automated database migrations if you have never done any before.

Highlights

00:00 Introduction from Steven
02:10 Overview of database migrations
06:24 challenges with deployments
10:18 Team performance and delivery
12:37 Characteristics of good migrations
17:49 Maximizing automation of deployments
21:50 Q&A deployment vs migration, release every day?, ebr
25:03 Code for repeatable and non-repeatable database objects
27:26 Migrating tables
36:05 Requirements for migration scripts
38:50 Use an existing logging framework!
40:13 Q&A: Recompile invalid objects after migration; 24x7 shop should use EBR; rely on flashback for undo; CI/D tools

Jasmin Fluri, Data Engineer
Steven Feuerstein, Developer Advocate for PL/SQL
October 15, 2020Oracle APEX India: Email Templates in Oracle APEXOracle APEX India: Email Templates in Oracle APEXThis Office Hours focused on Email Templates in Oracle APEX. Oracle APEX comes with many pre-loaded email sample templates. Developers can use these to build from and they indeed save a lot of development time. Ajay explained about email template options and demonstrated how to use them in your apps.

In the second part of the session, Srihari demonstrated how to leverage Email Templates framework for different requirements such as including images, conditional display of email content, including dynamic tabular data and more.

Demo App: https://github.com/hari639/apex-email-templates

00:36 - Intro by Chaitanya Koratamaddi
08:10 - Exploring Email Templates by Ajay Periwal
25:25 - Q/A
25:35 - Get the Most Out of Email Templates by Srihari Ravva
56:18 - Q/A

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Prashanth Kumar, Principal Member of Technical Staff
October 14, 2020RackWare Enables Container Migration to Oracle Cloud Container Engine for KubernetesRackWare Enables Container Migration to Oracle Cloud Container Engine for KubernetesRackWare, a leader in Cloud Migration and DRaaS, presents an important update to its product portfolio, adding support for Oracle Kubernetes Engine. Pre-existing Container/Kubernetes deployments can now be seamlessly moved to OKE. In addition to minimizing downtime during a Migration, other challenges addressed by RackWare’s new SWIFT solution include overcoming Container version/format mismatches and storage incompatibilities, and conversion to PaaS. This webinar covers the key features of SWIFT, including a live demonstration.

Gilson Melo, Director of Product Management
Marcie Samuelsen, Developer Marketing Manager
October 13, 2020How Oracle stores datetime values and time zone file upgradesHow Oracle stores datetime values and time zone file upgradesIn this session, we talked about how Oracle stores datetime values in table columns. We looked at the internal storage format of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE values. We discussed what time zone regions are and why we may need to update stored datetime values, if a new time zone file version is installed. In the next month, we will continue with description of the time zone file upgrade process.

Sergiusz Wolicki, Database Globalization Architect
Weiran Zhang, Director of Development
October 8, 2020Virtual Lab - Extending your APEX App with Autonomous Database FeaturesVirtual Lab - Extending your APEX App with Autonomous Database FeaturesBuild enterprise apps 20x faster with 100x less code.

You'll learn hands-on how you can extend your APEX applications with new functionality by leveraging the new features that the Autonomous Database brings.

Objectives

We will provision an ATP instance and create an APEX workspace and APEX application, and then add the following features to your APEX application:

- Geospatial functionality
- Machine learning
- Security

We'll go straight into these exciting topics and you'll be doing a lot of coding yourself in the exercises. Participants will get access to an Oracle Cloud Free Tier account.

To execute the lab you will need access to an Oracle Cloud Account.

Please provision your cloud account and ATP instance on the day before the workshop, the provisioning process will take approximately 10 minutes.
During the sign-up process We advice to choose London South or Frankfurt as Cloud Home Region.

You can get your Oracle Cloud Free Tier Account clicking here: http://bit.ly/freetier_8oct
NB. Please create your Oracle Cloud Free Tier Account before to join the workshop using the email address you used to register.

Here you can find Lab steps: https://bit.ly/oracle_APEX_labsteps

Priscila Iruela, Database Business Developement
Victor Martin, Principal Cloud Engineer
October 8, 2020Auditing PostgreSQL and MongoDB with Audit Vault and Database FirewallAuditing PostgreSQL and MongoDB with Audit Vault and Database FirewallIn this session we focused on the flexibility of Audit Vault and Database Firewall - with specific examples of auditing PostgreSQL, MongoDB, Azure SQL, and Oracle Rest Data Services (ORDS) with Oracle Audit Vault and Database Firewall. Using the collector framework, almost any audit source can be captured within the Audit Vault repository, and then used for reporting,analysis, and alerting.

Here is a guide to the recording;
01:50 Product Announcements - October CPU, Data Safe update, and Key Vault 18.5
05:40 Audit Vault and Database Firewall - Beyond Oracle
14:44 PostgreSQL
22:38 MongoDB
30:41 Custom JSON Audit Collection
38:35 Azure SQL - Managed Instance
43:25 REST audit collection
43:45 Oracle Rest Data Services (ORDS)

Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall
Ashok Swaminathan, Sr. Director Product Management, Database Security
Russ Lowenthal, Senior Director of Database Security Product Management
October 6, 2020Hands on Lab: Low Code Development with Autonomous DatabaseHands on Lab: Low Code Development with Autonomous DatabaseLearn how to create an Autonomous Transaction Processing instance, create an APEX workspace, create an APEX application, create Database objects, use SQL Developer Web to access the data and view a data model.

Bo English-Wiczling, Director of Program Management, Application Express
October 4, 2020Modernize Forms Apps and Extend oracle SaaS ERPModernize Forms Apps and Extend oracle SaaS ERPOracle APEX Pakistan Community: Office Hours 2020 #2

The goal of this special series of Office Hours is to bring together the Oracle APEX Pakistan Community, and provide a platform to learn, connect, and collaborate!

In this session, we host two enthusiastic members of the APEX community in Pakistan covering the following featured topics:

* Modernize your Oracle Forms Applications with Oracle APEX by Gul Rahman. Gul will show us how to use PLSQL in Oracle APEX. If you are migrating from Oracle Forms, then this is a great session for you.

* Demo for extending your Oracle SaaS ERP system using Oracle APEX by Imran Shahzad. Imran will demonstrate extending the Oracle HCM SaaS system using Oracle APEX.

Join us to directly hear from them about their experience with Oracle APEX.

00:11 Introduction by Salim Hlayel
01:16 Oracle Forms Modernization Overview by Gul Rahman
06:42 Practical Demo of using PLSQL in Oracle APEX by Gul Rahman
30:16 Extending Oracle Cloud SaaS service Overview by Imran Shahzad
34:35 Practical Demo for Extending Oracle Cloud SaaS by Imran Shahzad
1:05:52 Conclusion by Salim Hlayel

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
September 30, 2020Practical approach to Cloud NativePractical approach to Cloud NativeMany IT teams are considering adapting cloud native but often find it challenging to take the first steps as the technology landscape can be overwhelming as well as the starting point.

In this webinar we will discuss a practical approach to getting started with Kubernetes and Helm Charts, two central cloud native technologies.

Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa
Hassan Ajan, Principal Product Strategy Manager
September 29, 2020Advanced Chatbot Development - the Art of What’s PossibleAdvanced Chatbot Development - the Art of What’s PossibleChatbot frameworks are relatively common, and many developers have already created bots that can address simple use cases such as a simple FAQ bot, or perhaps a voice skill for Amazon’s Alexa. But have you hit the proverbial wall for what’s possible? Are bot engagements reliant on simple sentences and not naturally conversational? Do the bots get lost and unable to follow a non-sequitur conversations? And are they easily confused by the unique terms and jargon used in your industry?

If you’re ready to go beyond the wall, and work in the art of what’s possible, come hear what Oracle Digital Assistant as to offer. You will be pleasantly surprised how Oracle’s leading the charge in enterprise chatbot development.

Don McInnes, Product Manager
Joe Huang, Outbound/GTM Product Management, Oracle Digital Assistant
September 29, 2020Machine Learning 101: ClusteringMachine Learning 101: ClusteringHave you always been curious about what machine learning can do for your business problem, but could never find the time to learn the practical necessary skills? Do you wish to learn what Classification, Regression, Clustering and Feature Extraction techniques do, and how to apply them using the Oracle Machine Learning family of products?

Join us for this special series “Oracle Machine Learning Office Hours – Machine Learning 101”, where we will go through the main steps of solving a Business Problem from beginning to end, using the different components available in Oracle Machine Learning: programming languages and interfaces, including Notebooks with SQL, UI, and languages like R and Python.

Our fifth session in the series covered Clustering 101, where we learned the terminology around Clustering or Segmentation, how to get the data prepared for clustering, how to measure cluster separation, identify potential pitfalls and use cases.

We continued making use of the Oracle Machine Learning for Python (OML4Py) interface for the Autonomous Database on our Demo.

Video Highlights
01:47 Machine Learning 101 - Clustering
02:45 What is Clustering?
04:40 Clustering Algorithms and Methods
07:49 Types of data needed for Clustering
09:30 Workflow and Data Preparation
14:05 Data used in the Demo
14:50 Clustering Model Intuition for k-Means
22:24 k-Means properties
25:53 Features of the Oracle Machine Learning clustering algorithms
28:22 Demo of Machine Learning 101: Clustering
30:24 Demo: selecting subset of data and filtering outliers
32:35 Demo: k-Means model with k=2
36:10 Demo: k-Means model prediction
38:45 Demo: Create a function for building, scoring and plotting k-Means
40:10 Demo: k-Means testing from k=2 to k=7
42:00 Demo: Expectation-Maximization
46:42 Demo: Create a function for building, scoring and plotting Expectation-Maximization
48:00 Demo: Expectation-Maximization testing with max clusters from 2 to 7
51:40 Q&A

Marcos Arancibia, Product Manager, Data Science and Big Data
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
September 24, 2020Hands on Lab: Modernize and Extend Legacy Apps in the Oracle CloudHands on Lab: Modernize and Extend Legacy Apps in the Oracle CloudGet hands-on modernizing or extending legacy applications into a cloud-native microservice-based development framework leveraging the Oracle Cloud.

Keegan O'Hare, Associate Cloud Engineer
Varun Yadav, Cloud Engineer
Wilson Randle, Cloud Engineer
September 24, 2020Cargando datos desde cualquier ambiente a tu Base de Datos Oracle usando APEX_DATA_PARSERCargando datos desde cualquier ambiente a tu Base de Datos Oracle usando APEX_DATA_PARSEREn esta sesión exploramos las opciones para cargar datos a la Base de Datos Oracle. Entre las opciones se encuentra el API APEX_DATA_PARSER, el cual permite analizar archivos XML, XLSX, CSV o JSON.

2:00 Introducción
08:45 Opciones preconstruidas para cargar datos
19:38 API: APEX_DATA_PARSER
34:44 Casos de Uso
52:20 Q&A

La presentación de Rodolfo Rodriguez está disponible en http://bit.ly/APEX_DATA_PARSER

Joel Kallman, Senior Director, Software Development
Mónica Godoy, Principal Product Manager
September 24, 2020Securing Property Graphs with Oracle Label SecuritySecuring Property Graphs with Oracle Label SecurityLearn how to control access to sensitive information at a node and edge level. This session will show how to use Oracle Label Security with property graphs.

Control of access to sensitive information is of concern to managers, information officers, DBAs, application developers, and many others. Oracle Label Security (OLS) is part of Oracle’s defense-in-depth approach to security and is the industry’s most advanced solution for controlling access to data based on data classification. Government agencies align their data classification standards and then use OLS to share data across agencies. Commercial companies use OLS to separate data by geographic boundaries, allowing users from different countries to access data and meet local privacy and compliance requirements.

This session will demonstrate how to apply data classification (e.g. Highly Sensitive, Sensitive, Unclassified) to property graph nodes (e.g. bank accounts) and edges (transactions between these accounts) and control user’s access to these elements.

01:30 Overview of this session
04:37 Property Graph support in the database
11:32 What is Oracle Label Security
16:04 Demo scenario
19:00 Demo (Setting policies and access rights)
28:03 Demo (PGQL query results on Database)
32:26 Demo (PGQL query results on Graph Server)
37:40 Demo (Inserting and deleting nodes and edges)
39:40 Q&A
43:48 Demo (Graph Visualization)

Jayant.Sharma, Product Manager
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
September 19, 2020استخدام خدمات نقل تمثيل الحالة وأوراكل أبيكس - RESTful Servicesاستخدام خدمات نقل تمثيل الحالة وأوراكل أبيكس - RESTful Servicesيعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!

في هذه الحلقة يستعرض الخبير أحمد السعيد خدمات نقل تمثيل الحالة RESTful Services مع أوراكل أبيكس.

لتبقى على تواصل مع سلسلة أبيكس بالعربي يرجى الضغط على "اشترك" في أعلى هذه الصفحة ومن ثم "الدخول للاشتراك".

00:11 – مقدمة الحلقة
00:47 – تعريف بأحمد السعيد
03:34 – ما هي خدمات نقل تمثيل الحالة - RESTful Services
08:40 – APEX و ORDS
12:56 – REST مكونات خدمات ال
13:55 – الموارد
14:08 – أمثلة عملية
46:16 – أسئلة وأجوبة
51:30 – نقاط هامة للمساعدة

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
September 18, 2020Zero Data Loss Recovery Appliance Protection for Exadata Cloud@Customer - Overview and DemoZero Data Loss Recovery Appliance Protection for Exadata Cloud@Customer - Overview and DemoOverview of the Zero Data Loss Recovery Appliance and Exadata Cloud@Customer integration. Demo of the configuration of a ZDLRA Backup Destination for ExaCC and of the enablement of automatic backups for ExaCC Databases using the OCI Cloud Console.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
September 17, 2020Location matters! Map Visualization for APEX developersLocation matters! Map Visualization for APEX developersLocation Data, visualized on a map, is a common requirement for application developers these days. Of course, this is also true for APEX apps: But what's the best way of creating them? In this session, you'll learn everything about the Oracle Maps technology and how to use it in APEX applications.

We will be joined by Honglei Zhu, who is a Principal Member of Technical Staff in the Oracle Spatial product development team, and Carsten Czarski from the APEX development team. Honglei will introduce Oracle Maps and demonstrate how to easily use its JavaScript API to visualize location and analytic data. Then it will be time to integrate this in the APEX application. One way is to use the APEX Plug-Ins contained in the Sample Geolocation Showcase packaged application: Provide a SQL query, configure map attributes and you're ready to go. After that, attendees will learn how to keep full control, by embedding the Oracle Maps JavaScript API, into the APEX application.

This session is for both new and existing APEX developers.

Carsten Czarski, Consulting Member of Technical Staff
Honglei.x.Zhu, Principal Member of Technical Staff
Joel Kallman, Senior Director, Software Development
September 17, 2020Location matters! Map Visualization for APEX developersLocation matters! Map Visualization for APEX developersLocation Data, visualized on a map, is a common requirement for application developers these days. Of course, this is also true for APEX apps: But what's the best way of creating them? In this session, you'll learn everything about the Oracle Maps technology and how to use it in APEX applications.

We will be joined by Honglei Zhu, who is a Principal Member of Technical Staff in the Oracle Spatial product development team, and Carsten Czarski from the APEX development team. Honglei will introduce Oracle Maps and demonstrate how to easily use its JavaScript API to visualize location and analytic data. Then it will be time to integrate this in the APEX application. One way is to use the APEX Plug-Ins contained in the Sample Geolocation Showcase packaged application: Provide a SQL query, configure map attributes and you're ready to go. After that, attendees will learn how to keep full control, by embedding the Oracle Maps JavaScript API, into the APEX application.

This session is for both new and existing APEX developers.

Carsten Czarski, Consulting Member of Technical Staff
Honglei.x.Zhu, Principal Member of Technical Staff
Joel Kallman, Senior Director, Software Development
September 17, 2020General Database Office HoursGeneral Database Office HoursIn this edition of General Database topics, we explored:

- The ins and outs of setting columns to UNUSED, and why DROP COLUMN is almost never needed.

- Critical things you need to be aware of this when using DBMS_JOB and upgrading to 19c

- How to estimate the space gains you'll make from doing a reorganisation after data maintenance, and how to decide if you will really benefit...

Connor McDonald, Developer Advocate
September 15, 2020Count and Sum Millions of Rows Fast with Materialized ViewsCount and Sum Millions of Rows Fast with Materialized ViewsQueries summarizing data by day, week, or year can often process millions of rows leading to long execution times.

Yet the number of rows they return is small with a fixed upper limit. So you can answer these questions much faster by pre-calculating the result and storing it in a table.

Doing this manually is time-consuming and error-prone. Oracle Database offers an automated solution: materialized views (MVs). These store the results of the query. When you run the query in the MV, the database can redirect it to the results in the MV, leading to huge performance gains with no code changes.

Highlights include:

04:15 - Using indexes to speed up aggregation queries
06:45 - Creating materialized views to store the results of queries
09:50 - Enabling query rewrite, so the optimizer can redirect matching queries from the base table to materialized views
15:20 - Limitations of query rewrite
16:45 - Using dbms_mview.explain_rewrite to understand why a query didn't use an MV
18:00 - The impact of data changes on query rewrite
23:00 - Refreshing the data in MVs
29:00 - Creating materialized view logs to enable fast refresh
38:00 - Real-time materialized views
43:40 - Limitations to fast refresh; using dbms_mview.explain_mview to understand these
45:00 - Bitmap-based count distinct for MVs (19c)
53:00 - Using Database In-Memory to speed up aggregation queries
58:15 - MVs and In-Memory comparisons

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
September 10, 2020Keeping your Data Safe - on-premises!Keeping your Data Safe - on-premises!In this session we introduced the availability of Oracle Data Safe for on-premises databases. We discussed the different connectivity options available to connect your databases with Data Safe, including an in-depth demonstration of the new on-premises connector. We reviewed the features available in Data Safe, and demonstrated how Data Safe can help you reduce risk and improve security.

Here is a guide to the recording;
01:21 Product Announcements - New bundle patches for Audit Vault and Database Firewall 12.2 and Key Vault, AVDF 20 early adopter program
03:30 Data Safe for on-premises databases
04:50 Supported Database Deployments (cloud and on-premises)
05:37 Connectivity options
07:30 On-Premises Connector
09:32 Demonstration: Settup up the on-premises connector
18:11 Demonstration: Registering a database using the on-premises connector
22:30 Demonstration: Using Oracle Database Safe to secure a database

Bettina Schaeumer, Senior Principal Product Manager
Pedro Lopes, Sr. Principal EMEA Field PM
Russ Lowenthal, Senior Director of Database Security Product Management
September 9, 2020Getting Started with Serverless Apps on Oracle Cloud InfrastructureGetting Started with Serverless Apps on Oracle Cloud InfrastructureServerless Computing is now available in the Oracle Cloud. Join us for an overview of Oracle Cloud's Functions-as-a-Service and learn how you can use Oracle Cloud’s serverless building blocks - Functions, Events, and API Gateway - to build modern, event-driven microservices.

Dusko Vukmanovic, Product Manager
Greg Verstraeten, Senior Principal Product Manager
Sachin Pikle, Product Strategy Director
September 8, 2020PL/SQL and the Art of OCI ManagementPL/SQL and the Art of OCI ManagementSpecial guest Robert Pastijn, a member of the Database Platform Technology Solutions group, will share with us how he went about building a set of PL/SQL APIs to help manage Oracle Cloud accounts and services. He initially did this to help the database team manager upwards of 60 different cloud accounts under OCI Classic. Then he upgraded his API to take advantage of APEX_WEB_SERVICE package and apply it to OCI services. These APIs are used in Oracle LiveLabs.

01:46 Introduction and overview
02:50 The backstory: managing 60+ domains for database team
05:36 Making to move to PL/SQL, REST and APEX APIs
06:58 The joy of APEX_WEB_SERVICE, with jokes!
09:09 Using JSON_TABLE to make your JSON data relational
05:40 Quick review of REST
11:05 Encapsulating inside a PL/SQL function, adding screens in APEX
15:12 Downside of OCI Classic REST APIs
16:38 Making the switch from OCI Classic to OCI
19:06 Implementing signing via PL/SQL (and Java)
27:36 Improving signing with DBMS_CLOUD
30:37 Always Free Oracle Cloud reminder
30:58 Summary
33:13 Q & A: Use terraform? Access APIs from C++? And more

Chris Saxon, Oracle Developer Advocate for SQL
Robert Pastijn, Senior Principal Technologist (Product Manager/Strategy ProdDev)
September 3, 2020Hands on Lab: Deploying Oracle WebLogic Server on Kubernetes and Oracle CloudHands on Lab: Deploying Oracle WebLogic Server on Kubernetes and Oracle CloudThis workshop will show you how to set up WebLogic on a Kubernetes cluster, using the Operator to manage the WebLogic domains.

Casey Ross, Cloud Engineer
Leah Bracken, Associate Cloud Engineer
Sasanka Abeysinghe, Senior Cloud Engineer
August 27, 2020Graph Algorithms: The Core of Graph AnalyticsGraph Algorithms: The Core of Graph AnalyticsGraph algorithms are the foundation of graph analytics. When you model your data as a graph you can run powerful algorithms on the graph for new insights into your data. A few examples: Centrality algorithms (such as pagerank) can identify influencers in a social network, community detection algorithms (such as sccKosaraju) can identify similar buying patterns, path analysis (evaluating reachability) can identify the impact of changing the design of one component on connected components.

The Property Graph feature of Oracle Database includes over 50 built-in graph algorithms. We will discuss the usefulness of these algorithms in a variety of industries such as financial services, manufacturing, retail, and security. We will give an overview of some of the key algorithms, demonstrate how to use these algorithms in your applications, and show how you can visualize and query the results of a graph algorithm.

Jean Ihm, Product Manager
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
August 27, 2020Oracle APEX India Community Office Hours 2020 #3: Exploring Faceted Search and Key APIsOracle APEX India Community Office Hours 2020 #3: Exploring Faceted Search and Key APIsFeatured topics for this edition:

1. Exploring the Power of Faceted Search in Oracle APEX - Prashanth Raju, Oracle
2. Oracle APEX APIs that Everyone Should Know! - Srihari Ravva, Oracle

Highlights:

00:16: Introduction by Chaitanya Koratamaddi
01:46: Exploring the Power of Faceted Search in Oracle APEX by Prashanth Raju
03:09: What is Faceted Search?
04:31: Faceted Search - Example
06:10: How Does Faceted Search Work?
09:10: Faceted Search - Demo
28:21: Faceted Search Enhancements in APEX 20.1 - Demo
38:59: Summary
40:56: Oracle APEX APIs that Everyone Should Know! by Srihari Ravva
42:21: Exploring Few Useful APIs with Practical Examples
43:10: Sample APEX APIs - Demo

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Prashanth Kumar, Principal Member of Technical Staff
August 26, 2020LiveLabs Database In-Memory WorkshopLiveLabs Database In-Memory WorkshopIn this session Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria) reviewed the new LiveLabs Database In-Memory Fundamentals workshop. How to access the LiveLabs workshop, Oracle Cloud options and some tips on setting up the Lab were discussed.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
August 25, 2020Python and Autonomous Database: Better together for Location AnalyticsPython and Autonomous Database: Better together for Location AnalyticsIn August we discussed the use of Python, and geospatial analysis libraries, in conjunction with the Autonomous Database's spatial features. David walked through a Jupiter notebook and outlined two scenarios. The first used spatial analysis, on a national scale dataset of vehicle accidents, to identify hot spots and cold spots where speeding was a factor or not a factor in the accident. The second scenario involved a spatio-temporal analysis of unemployment statistics. Here's a quick guide to the highlights:

1:00 David provides an overview of Spatial features in the Oracle Database
6:42 He discusses the vast ecosystem of geospatial analysis libraries for Python
8:44 He provides the URL for a PDF version of the Jupiter notebook with the demos
11:35 David introduces the first demo scenario
29:00 He discusses the second demo scenario

David Lapp, Product Manager - Spatial and Graph
Jayant.Sharma, Product Manager
August 25, 2020Why Is the Optimizer Estimating the Wrong Number of Rows?Why Is the Optimizer Estimating the Wrong Number of Rows?The optimizer uses statistics to estimate how many rows it'll fetch from each table. This drives its decisions to on how to access the tables and join them. So the key to a good plan is good row estimates.

So why - even with fully up-to-date stats - does the optimizer sometimes get its estimates so badly wrong?

In this session we investigate two common causes: data skew and correlation. We look at why these lead to inaccurate estimates and what you can do to improve them.

Highlights include:

01:20 - Demo of SQL statements where the optimizer's row estimates are (badly) incorrect
05:40 - Value skew: some values appearing more often than others
06:20 - Frequency histograms
09:25 - Top-frequency histograms
14:25 - Height-balanced histograms
18:00 - Hybrid histograms
23:15 - Range skew: gaps between values
29:45 - Correlation between columns
32:15 - Demo: histogram creation during stats gathering based on column usage
42:40 - Demo: stats for correlated columns
46:00 - Demo: stats on expressions
51:55 - Demo: stats for subqueries
57:10 - Demo: disabling histograms
58:00 - Using table preferences to set non-standard stats gathering options

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
August 25, 2020Oracle Developer Talk: Why choose Cloud Native?Oracle Developer Talk: Why choose Cloud Native?Business are increasingly adapting a cloud native approach, including but not limited to Kubernetes and micro services oriented architecture. What are the benefits to IT-Ops and developers? What does businesses get out of it?

Watch this video to learn how Oracle Cloud Native services empower modern application development using technologies such as Kubernetes, Docker, serverless functions, APIs, and Kafka.

Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa
Hassan Ajan, Principal Product Strategy Manager
August 21, 2020Reduce Cyber Risk with Zero Data Loss Database ProtectionReduce Cyber Risk with Zero Data Loss Database ProtectionLearn about the importance of protecting mission-critical Oracle databases against cyber attacks and how Zero Data Loss Recovery Appliance provides a holistic solution for end-to-end cyber risk protection and recovery.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
August 20, 2020The Exadata sandwich, Linux image, and OEDAThe Exadata sandwich, Linux image, and OEDALessons learned and ongoing challenges building an engineered system, from re-spinning an operating system to building an install-able solution. With Krish Telikicherla and his team.

00:34 Krish and team introduction
01:56 Gavin: Krish’s team at core of engineered systems
03:24 Krish: How deploying Exadata in Cloud differs from on-premises
03:59 Q: Compare your team to a typical software development team
06:56 Q: What is the relationship between Exachk and OEDA?
10:12 Q: How do new technologies get incorporated?
10:42 Secure Fabric
12:12 The interplay between best practices and innovation
14:15 Q: Best Practices: how implemented and enforced?
16:01 Customizations versus upgrades
16:50 Q: Customizations on Exadata on premises
18:42 Understanding risk
19:34 Exadata storage cells not customizable
19:49 Upgrades can get rolled back
20:12 Containers on Exadata DB nodes
20:58 Q: Role of Krish’s team in security
22:38 Q: What are challenges of assembling a new release?
24:54 Great cooperation with other teams to get all technologies integrated
25:47 Secure boot
27:22 Implications to Exadata manufacturing
28:22 Differences between on-premises and at-customer Exadata
29:29 Q: What was the evolution of taking Exadata into the Cloud?
32:25 Q: Is OEDA a directory in the Exadata server?
33:13 KVM, Xen, InfiniBand, and RoCE
34:00 Q: Best practices on premises versus on @Cloud at Customer?
34:42 Customer changes and Cloud@Customer management
35:15 Closing remarks

Cris Pedregal, Senior Technologist
Gavin Parish, Senior Principal Product Manager
Krishnadev Telikicherla, Director of Development
August 20, 2020The Top 12 New Features in APEX 20.1 that Everyone Should Know!The Top 12 New Features in APEX 20.1 that Everyone Should Know!Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Join APEX developers and product managers for trainings and how-to's, so you can make the most of this amazing tool!

Chaitanya Koratamaddi, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies
Joel Kallman, Senior Director, Software Development
Marc Sewtz, Senior Software Development Manager
August 20, 2020Are Database features broken?Are Database features broken?There is a difference between not understanding how a feature works, and calling that feature "broken". Of course, occasionally bugs can throw a spanner into the works as well. In this Office Hours session, we looked at common misunderstandings of how database features work.

AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Connor McDonald, Developer Advocate
August 14, 2020Learn, Connect, and Collaborate!Learn, Connect, and Collaborate!Oracle APEX Pakistan Community: Learn, Connect, and Collaborate!

The goal of this special series of Office Hours is to bring together the Oracle APEX Pakistan Community, and provide a platform to learn, connect, and collaborate!

In this session, we host some of the top enthusiastic members of the APEX community in Pakistan.
Join us to directly hear from them about their experience with Oracle APEX.

00:11 Introduction by Salim Hlayel
01:19 Oracle APEX Pakistan Community by Joel Kallman
13:14 Agenda for the session by Salim Hlayel
13:57 Oracle for Startups by Numan Majeed
20:49 Let's explore the power of APEX by Farid Ghori
42:58 Digital Banking with Oracle APEX by Shoaib Ahmed
56:49 POS and ERP demonstrations by Gul Rehman
1:14:22 Books and Cloud Financials demonstration by Riaz Ahmed
1:25:36 APEX Experience and eCommerce demonstration by Abdul Rehman
1:34:34 APEX in Pakistan by Shayan Ahmed

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
August 13, 2020Introducing Audit Vault and Database Firewall 20Introducing Audit Vault and Database Firewall 20In this session we introduced Audit Vault and Database Firewall release 20. This major release of Audit Vault and Database Firewall (AVDF) comes with increased audit target support, improved usability, and better interoperability with other enterprise systems. During the session we discussed what has changed in the new release and the upgrade path to move from AVDF 12 to AVDF 20. Note that current AVDF 12 customers will want to upgrade before the end of March 2021 and we are offering an early adopter program for customers deploying AVDF20 before the end of September, 2020

Here is a guide to the recording;
01:15 Product Announcements - Data Safe now available on-premises
04:27 Support corner
06:55 History of Audit Vault and Database Firewall (AVDF)
12:15 What's new in AVDF 20
13:57 New user interface
18:35 Expanded target support
30:15 Simplified Database Firewall
32:43 Enhanced enterprise support
37:30 Upgrading to AVDF 20
39:50 Early adopter program
43:08 Database auditing and audit collectin
45:45 Using Database Firewall
51:42 Reporting and alerting
52:35 Active Directory integration
53:14 Third-party integration (SIEM, Splunk)
54:10 High availability

Angeline Janet Dhanarani, Principal Product Manager - Core Database Auditing, Audit Vault and Database Firewall
Russ Lowenthal, Senior Director of Database Security Product Management
August 8, 2020أوراكل أبيكس، نظرة أكثر شموليةأوراكل أبيكس، نظرة أكثر شموليةيعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة!

انضم معنا في حلقة خاصة مع المحترف فاتح المسدي ونظرة أكثر شمولية لأوراكل أبيكس.تعرف لماذا يعتبر أبيكس من أفضل المنصات ليس فقط للمبرمجين الجدد و لكن أيضا للشركات الناشئة بالإضافة إلى بعض النصائح لأفضل الممارسات.

يرجى الضغط على اشترك في أعلى هذه الصفحة ومن ثم الدخول للاشتراك لتبقى على تواصل مع سلسلة أبيكس بالعربي.

00:11 – مقدمة الحلقة
06:47 – الرؤية
07:32 – هدف أكبر من مجرد امتلاك عملك الخاص
09:22 – نقاط هامة لتأسيس شركة ناشئة أو صغيرة
10:13 – الإبداع
11:03 – من أين أحصل على الفكرة؟
14:11 – مثال لحل مشكلة تصلح كمنتج مستقل
17:12 – التغلب على التحيز في التفكير
19:03 – كيف أتأكد من أن المنتج نافع؟
20:33 – المنتج بأبسط شكل
22:22 – أمثلة منتج بسيط
25:16 – قياس النجاح
26:36 – في حال لا يوجد تقدم
27:01 – أمثلة منتجات غيروا الاستراتيجية
28:31 – أين أبيكس من هذا؟
35:11 – أفضل الممارسات
50:41 – السلوك الصحيح
52:56 – Agile Project Management
55:34 – الخاتمة وأسئلة وأجوبة

Joel Kallman, Senior Director, Software Development
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
August 5, 2020Hands on Lab: Low Code Development with Oracle Autonomous DatabaseHands on Lab: Low Code Development with Oracle Autonomous DatabaseThis hands on lab will get you started by helping you to sign up for an Oracle Free Tier, create an Autonomous Transaction Processing instance, create an APEX Workspace, create your first APEX App from a spreadsheet, use Quick SQL to create database objects, use SQL Developer Web to enhance your database objects and finally create and enhance an APEX Application.

Bo English-Wiczling, Director of Program Management, Application Express
Marcie Samuelsen, Developer Marketing Manager
August 4, 2020Machine Learning 102: RegressionMachine Learning 102: RegressionHave you always been curious about what machine learning can do for your business problem, but could never find the time to learn the practical necessary skills? Do you wish to learn what Classification, Regression, Clustering and Feature Extraction techniques do, and how to apply them using the Oracle Machine Learning family of products?

Join us for this special series “Oracle Machine Learning Office Hours – Machine Learning 101”, where we will go through the main steps of solving a Business Problem from beginning to end, using the different components available in Oracle Machine Learning: programming languages and interfaces, including Notebooks with SQL, UI, and languages like R and Python.

In this fourth session in the series we covered Regression 102, with a look at multiple input attributes, attribute selection, feature generation, and a deeper look into diagnosis and potential problems

Video Highlights
00:39 Next Session Announcement: 101 Clustering
01:27 Today's Session: Machine Learning 102
04:10 Demo Part I of IV - Data Preparation
12:15 Sampling Data for using MatPlot Lib with OML4Py
16:10 How to identify the actual attributes that make sense to use
19:55 Data Cleaning
20:50 Data Transformation
23:24 Demo Part II of IV - Data Analysis
23:39 Random sampling for MatPlot Lib visualizations
28:25 Split data into Train and Test
29:40 Demo Part III of IV - Model Building
30:45 Linear Regression
41:00 Support Vector Machines
41:22 Neural Networks
41:50 List of Top Models for prediction
42:44 Demo Part IV of IV - AutoML
43:28 AutoML algorithm selection
44:13 AutoML Neural Networks
46:57 AutoML SVM
47:40 Final ranking of model quality
48:49 AutoML Neural Networks: Predicted vs. Actuals and Residuals
50:00 Machine Learning eXplainability for AutoML Neural Network
51:00 Visualizations in 3-D
52:40 Final conclusions
55:05 Q&A

Marcos Arancibia, Product Manager, Data Science and Big Data
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
August 4, 2020A Preview of Oracle Database 20c PL/SQL EnhancementsA Preview of Oracle Database 20c PL/SQL EnhancementsChris Saxon will take you on a tour of some of the most interesting new features added in Oracle Database 20c, which is currently available as a Preview Release on the Oracle Cloud.

Highlights of this session include:

05:15 - Extended Iterators - more powerful looping constructs
06:00 - Demo of extended iterators
21:50 - Extended iterators recap
24:00 - Aggregate qualified expressions (array type constructors)
25:10 - Demo of aggregate qualified expressions
40:00 - Aggregate qualified expressions recap
45:45 - SQL macros
47:00 - SQL macro performance comparison to other
53:21 - Pragma suppress_warning_6009

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
July 30, 2020PGQL Introduction and Deep DivePGQL Introduction and Deep DivePGQL is a graph query language built on top of SQL, bringing graph pattern matching capabilities to existing SQL users as well as to new users who are interested in graph technology but who do not have an SQL background. This session includes the introduction and deep dive.

Jean Ihm, Product Manager
Melli Annamalai, Senior Principal Product Manager
Ryota Yamanaka, Regional Product Manager, Spatial and Graph
July 23, 2020Oracle APEX para Dispositivos MóvilesOracle APEX para Dispositivos MóvilesEn esta sesión exploramos los aspectos más importantes a considerar cuando necesitamos dotar a las aplicaciones APEX de funcionalidades móviles.

03:45 - Noticias
05:45 - Desarrollo Móvil con Oracle APEX
09: 11 - Tipos de Aplicaciones
14:00 - Consideraciones
19:00 - Componentes de APEX para el desarrollo móvil
28:30 - apex.storage
32:00 - Demo
39:15 - Integración de APEX con GoNative.io
52:00 - Q&A

Joel Kallman, Senior Director, Software Development
Mónica Godoy, Principal Product Manager
July 22, 2020Base Level Feature on Oracle Database 19cBase Level Feature on Oracle Database 19cAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Explore the Database In-Memory option with Andy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria). In this session we will show you the new Base Level feature on Oracle Database 19c with the new 19.8 RU.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
  • 1 - 50