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.

Report Settings

ToggleIS_PUBLIC_CLASS = 'N'

1 invalid setting

1 - 50

DateDescending	Session	Focus	Description
January 21, 2021	General Database Office Hours	General Database Office Hours	In this Q&A session we discussed: - Cool new features in 21c PLSQL - Understanding date implications when you move your database to the cloud - How to control the volume of audit information with unified auditing - How indexes can have an impact on Views - How much free space you need when reorging a table (a surprising discovery was made) Connor McDonald, Developer Advocate
January 21, 2021	Hands on Lab: Deploy a Kubernetes Cluster Using Oracle Cloud Shell	Hands on Lab: Deploy a Kubernetes Cluster Using Oracle Cloud Shell	Oracle Cloud Infrastructure Container Engine for Kubernetes is a fully-managed, scalable, and highly available service that you can use to deploy your containerized applications to the cloud. Use Container Engine for Kubernetes when your development team wants to reliably build, deploy, and manage cloud-native applications. You specify the compute resources that your applications require, and Container Engine for Kubernetes provisions them on Oracle Cloud Infrastructure in an existing OCI tenancy. Oracle Cloud Infrastructure Cloud Shell is a web browser-based terminal accessible from the Oracle Cloud Infrastructure Console. Cloud Shell provides access to a Linux shell, with a pre-authenticated Oracle Cloud Infrastructure CLI. In addition to the CLI, Cloud Shell provides the following commonly used Kubernetes tools: - A preinstalled version of kubectl, a command line tool for controlling Kubernetes clusters. - A preinstalled version of Helm, a package manager used to deploy applications to Kubernetes clusters. In this tutorial, you set up the Kubernetes configuration file for the cluster (the cluster's 'kubeconfig' file) to enable you to use kubectl to access the cluster from the Cloud Shell environment. IMP: To execute the lab you will need access to an Oracle Cloud Account. If you don’t already own please get your Oracle Cloud Free Tier Account clicking here: http://bit.ly/free_tier_21jan You will benefit of a special offer using the same email address used to register for this Virtual Lab. NB. Please create your Oracle Cloud Free Tier Account the day before of this Virtual Lab. Please provision your cloud account and instance the day before the Virtual Lab or as soon you get this message. We advice to choose London South or Frankfurt as Cloud Home Region. Here you can find Pre-requisites/Setup info: http://bit.ly/lab_steps_21jan Ettore Volpicelli, Head of Developer Marketing - Europe, Middle East and Africa
January 15, 2021	Accelerate Cross-Platform Database Migration with Recovery Appliance	Accelerate Cross-Platform Database Migration with Recovery Appliance	Learn the latest techniques using Recovery Appliance to simplify and speed up cross-platform database migration activities, including moving from non-Multitenant to modern Multitenant Database architectures. Kelly Smith, Senior Principal Product Manager Marco Calmasini, Senior Principal Product Manager Tim Chien, Senior Director of Product Management
January 14, 2021	Hands on Lab: Build a Fully Functional APEX App from a Spreadsheet in 45 minutes!	Hands on Lab: Build a Fully Functional APEX App from a Spreadsheet in 45 minutes!	Get your feet wet learning how to build a fully functional APEX app in less than an hour. In this lab, you learn how to: - Create an APEX App from a Spreadsheet - Navigating and making changes to the APEX Application Mónica Godoy, Principal Product Manager
January 11, 2021	Oracle Cloud Coaching: Compute Fundamentals	Oracle Cloud Coaching: Compute Fundamentals	In this session, learn how to set up Bare Metal, Virtual Machine, and Dedicated Hosts instances and hear about the advanced features and performance OCI compute provides, with a variety of image and shape options. Cloud Coaches are highly skilled solution engineers ready to assist you in your Oracle Cloud development journey. Cloud Coaching Office Hours provides a way for you to get your questions answered. The schedule is as follows: - Learn about a tip or best practice - Ask a question - Pre-submit your questions to cloudcoach_us_grp@oracle.com or ask during the office hours - Learn how to get additional help for your organization. Marcie Samuelsen, Developer Marketing Manager Mark Smith, Manager, Cloud Engineering Tara Van Cleave, Business Development Consultant
December 21, 2020	Visual Builder - What’s New	Visual Builder - What’s New	Learn about the new features added to Oracle Visual Builder in the latest release and how they benefit you. We’ll demonstrate Redwood UI and Oracle JET 9 updates, Improved development experience, and Visual Builder Studio integration for team development and CI/CD. We’ll also discuss what you need to know about upgrades, and the latest learning resources published for developers. Shay Shmeltzer, Director of Product Management
December 17, 2020	Machine Learning 101: Feature Extraction	Machine Learning 101: Feature Extraction	Have 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. This seventh session in the series covered Extraction 101, and we learned about the methods to extract meaningful attributes from a large number of columns in datasets, explore Dimensionality Reduction and how it can be beneficial as a pre-processing for Machine Learning models. Video Highlights 00:53 Oracle Machine Learning Office Hours - next Session 01:59 Machine Learning 101 - Feature Extraction 02:20 Feature Extraction 101 - Introduction 04:20 Feature Selection 06:28 Feature Extraction algorithms 08:25 Attribute Importance 10:05 Singular Value Decomposition (SVD) 11:24 Non-negative Matrix Factorization (NMF) 12:30 Intuition on NMF 15:10 Explicit Semantic Analysis (ESA) 15:47 Feature Extraction 101 Demo 19:32 Explore the data 18:18 Data used for the Demo 20:03 Basic visualization on the data 21:05 Build Attribute Importance (AI) model 23:30 Logistic Regression: Full Model vs. Feature Selection via AI 26:43 Build Singular Value Decomposition (SVD) model 30:00 Relationship between SVD feature vectors and attributes 33:16 Logistic Regression: Full Model vs. Feature Selection via SVD 34:55 Create Principal Components (PCA) projections for test data using the SVD model 35:55 Plot 3-D of top 3 attributes on original data vs. Projected PCA components 39:50 Build Non-negative Matrix Factorization (NMF) model via PL/SQL 41:45 Relationship between SVD feature vectors and attributes 43:20 Logistic Regression: Full Model vs. Feature Selection via NMF 44:44 Create NMF projections for test data using the NMF model 45:10 Plot 3-D of top 3 attributes on original data vs. Projected NMF features 46:54 Comparison with Build Logistic Regression using the built-in Feature Selection 49:20 Comparison with AutoML: Auto Algorithm Selection, Auto Feature Selection and Auto Tune for Logistic Regression 51:15 Q&A Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
December 17, 2020	Consumiendo datos remotos en nuestras aplicaciones de APEX	Consumiendo datos remotos en nuestras aplicaciones de APEX	En esta sesión, Adrián Arguello nos mostrará como consumir datos de bases de datos remotas usando REST Enabled SQL y como utilizar este servicio para crear componentes nativos de APEX. Adrián es Principal Solution Engineer en Oracle y está orientado en promover la transformación de las empresas mediante la innovación utilizando Oracle Cloud y Tecnologías Autónomas. Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
December 17, 2020	Flows for APEX - Model & run process flows within APEX!	Flows for APEX - Model & run process flows within APEX!	Flows for APEX is an open source solution enabling you to design and run process flows within your APEX application. This was developed by expert members of the Oracle APEX community, and it has quickly evolved into a functionally rich process modeling solution. In this special edition of Oracle APEX Office Hours, we will be joined by the creators of Flows for APEX, where they will present and demonstrate the latest version 5 of Flows for APEX. Learn more here: https://apex.mt-ag.com/en/flowsforapex Joel Kallman, Senior Director, Software Development Marc Sewtz, Director of Software Development
December 14, 2020	Oracle Cloud Coaching: Networking and Connectivity	Oracle Cloud Coaching: Networking and Connectivity	Cloud Coaches are highly skilled solution engineers ready to assist you in your Oracle Cloud development journey. Cloud Coaching Office Hours provides a way for you to get your questions answered. The schedule is as follows: - Learn about a tip or best practice - Ask a question - Pre-submit your questions to cloudcoach_us_grp@oracle.com or ask during the office hours - Learn how to get additional help for your organization. In this session, learn how to set up a virtual cloud network with firewall rules and communication gateways that you can choose. Highly skilled solution engineers will show you how to: - Define public or private subnets within your VCN - Add virtual routers to control traffic flow to outside destinations - Secure your cloud network and compute instances Mark Smith, Manager, Cloud Engineering
December 9, 2020	Database In-Memory Duplicate Feature	Database In-Memory Duplicate Feature	AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. In this session we will explore the Database In-Memory DUPLICATE feature with Andy Rivenes (@TheInMemoryGuy) and a special guest from Oracle Database devlopment, Jesse Kamp. Jesse is an Architect in the Database In-Memory development group and has been part of Database In-Memory since the beginning of the product. This will be a great opportunity to learn about the DUPLICATE feature and ask any questions you have about Database In-Memory. Andy Rivenes, Product Manager Maria Colgan, Master Product Manager
December 9, 2020	What’s New in Oracle Spatial Studio 20.1	What’s New in Oracle Spatial Studio 20.1	Want to learn about the latest features in this release to help you create interactive maps and perform spatial analysis on your data? In this session, we will present and demonstrate some of Spatial Studio’s new capabilities like simplified data uploading, GeoRaster visualization, 3D city model and point cloud visualization, new Spatial Analytics category, and access token support. Find out how to get the most out of this self-service application for visualizing and analyzing spatial features in Oracle Database without writing any code. Carol Palmer, Senior Principal Product Manager Jean Ihm, Product Manager LJ Qian, Director of Software Development
December 1, 2020	PL/SQL: The Good Parts	PL/SQL: The Good Parts	Morten Braten will close out a year of PL/SQL Office Hours sessions presenting his favorite aspects of this wonderful database programming language. "In a world where programming languages and frameworks come and go, I like the simplicity and stability of PL/SQL. I have worked with it for over 20 years, and I still have code that was originally written for Oracle 7 that runs happily in production to this day. If used properly and to its full capability, PL/SQL is a powerful, elegant and fun tool. Let's see how..." Steven Feuerstein, Developer Advocate for PL/SQL Morten Braten, Systems Architect and Owner, Educatia AS
November 27, 2020	Creating and Utilizing Custom Templates in Oracle APEX	Creating and Utilizing Custom Templates in Oracle APEX	Oracle APEX templates are centralized, declarative, reusable and customizable components. Universal Theme provides a variety of templates including Classic report ( Alerts, Badge List, Cards, Comments, Search Results, Timeline), Interactive report, and Interactive Grid. Developer can create new and customize existing ones to make more user loving. In this session, Ashish will walk you through different templates and demo how to customize to fit your specific needs. Ashish Sahay is a passionate APEX developer, frequent blogger and an Oracle ACE associate. He is an active contributor to apex.world for various open-source plugins. Founder of Ontoor solutions, where you can find great learning stuff, list of blogs ( Rated content) people writing around the world, Open source Projects and queries. Twitter: @imapexianashish 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
November 26, 2020	Integrando los servicios REST a nuestras aplicaciones APEX	Integrando los servicios REST a nuestras aplicaciones APEX	En esta sesión , Adrián Arguello nos mostró como crear y consumir servicios con Oracle Rest Data Services (ORDS) y Oracle APEX en un primer demo. En la siguiente sesión se mostrará el segundo demo. La presentación la encuentran en https://www.slideshare.net/adrianarguello/integrando-los-servicios-rest-a-nuestras-aplicaciones-apex Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
November 24, 2020	How to Use SQL Plan Baselines and SQL Profiles	How to Use SQL Plan Baselines and SQL Profiles	The Oracle optimizer has many tools and tricks for finding the best plan for each query. But in some cases, it may struggle to find a fast plan. Luckily Oracle Database has many tools to help the optimizer pick a good plan for each query. This session gives an overview of plan baselines and profiles to assist the optimizer. It shows you how they work, explains the differences between them and why you would use one over the other. Highlights of this session include: 01:20 - SQL Profiles, how to create them, why, and what they are 05:00 - SQL Plan Management and baselines, how to create them, why, and what they are 07:30 - SQL Profiles alternative usage - tricks to constraint SQL plans 11:00 - Licensing for SQL Plan Management 12:25 - Using SQL baselines when migrating databases 14:00 - Why should you avoid hints in SQL? 19:15 - Evolving plans with SQL plan management 22:30 - Demo showing how to create SQL Profiles and SQL Baselines and how they're different 29:08 - Using SPM with Real Application Testing 31:00 - Dealing with large data changes 34:10 - Using SQL Profiles and SQL Plan Baselines together 38:20 - Dealing with variable numbers of bind variables for an IN list (e.g. IN (:b1, :b2), IN (:b1, :b2, :b3) 40:30 - How many SQL plan baselines can you have? 42:35 - Managing profiles when changing the columns in a table 45:25 - Using SPM on a few SQL statements 47:05 - Using SPM with Database In-Memory 48:50 - Using SPM on overloaded databases 50:40 - How to get in touch with Nigel with your SPM questions 52:00 - Final recap and comparison Chris Saxon, Oracle Developer Advocate for SQL Nigel Bayliss, Optimizer Product Manager
November 20, 2020	RMAN backup validation: are your backups ready for recovery?	RMAN backup validation: are your backups ready for recovery?	This session reviewed techniques available in RMAN to ensure that backups are valid. Building these steps into regular operations is critical to ensure you are ready for database recovery. Also highlighted is the Zero Data Loss Recovery Appliance ability to automate these RMAN techniques, reduce production database resource overhead, and provide real-time reporting. Kelly Smith, Senior Principal Product Manager Marco Calmasini, Senior Principal Product Manager Tim Chien, Senior Director of Product Management
November 19, 2020	Super Easy Report Printing in Oracle APEX 20.2!	Super Easy Report Printing in Oracle APEX 20.2!	In the Oracle APEX 20.2 release, there have been substantial improvements made in support of printing and native data export. This includes Built-in PDF printing and Excel download, APIs to programmatically generate PDF, CSV, Excel, HTML, JSON and XML files, more language support, and even enhanced integration with BI Publisher and the printing capabilities of Oracle Analytics Cloud. In this session, the product developer and architect of these features, Menno Hoogendijk, will present and demonstrate all of these rich capabilities. Joel Kallman, Senior Director, Software Development Marc Sewtz, Director of Software Development Menno Hoogendijk, Principal Member of Technical Staff
November 19, 2020	Answering all of your questions	Answering all of your questions	In this Office Hours session we discussed: - How to compare large data sets efficiently - How to achieve massive performance even when you need to lock critical resources for serialisation - The anomaly of DML error logging versus triggers on the underlying tables - How to avoid SQL injection with the new SQL Macro features in 19c - Why pipelined functions might slow down even if the SQL within them is fast Connor McDonald, Developer Advocate
November 17, 2020	19 Critical Features Customers Lose When the Leave the Oracle Database	19 Critical Features Customers Lose When the Leave the Oracle Database	The Oracle database is the world's leading converged database for a variety of reasons, but the biggest is unique features critical to customer requirements, especially uptime and performance management, that only Oracle has. In this talk, Franck Pachot describes 19 features customers lose when they leave the Oracle database. As always, we start with announcements, then move into a technical presentation and then open the lines for your questions related to the Oracle database including features, use cases, best practices, and more. The sessions are recorded and the recordings are usually available a few days after the session is held. Franck Pachot, Principal Consultant & Database Evangelist Matthew OKeefe, Senior Corporate Technologist
November 16, 2020	Oracle Cloud Coaching: Identity and Access Management	Oracle Cloud Coaching: Identity and Access Management	In this session, learn how to set up consistent identity enforcement and manage employee, partner, and consumer access to cloud resources with Oracle Identity and Access Management. Highly skilled solution engineers will show you how to: • Log in and navigate through the web console • Configure users and groups • Create compartments and Policies Pre-submit your questions to cloudcoach_us_grp@oracle.com Mark Smith, Manager, Cloud Engineering
November 14, 2020	12 ميزة تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس الآن!	12 ميزة تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس الآن!	يعد الأوراكل أبليكيشن إكسبريس (أبيكس) منصة منخفضة الشيفرة تمكنك من إنشاء تطبيقات مذهلة مرنة وآمنة ، مع ميزات عالمية المستوى ، يمكن نشرها في أي مكان. انضم معنا إلى مطوري أبيكس ومديري المنتجات للتدريب والتعليمات ، حتى تتمكن من تحقيق أقصى استفادة من هذه الأداة المدهشة! في هذه الحلقة الخاصة يستعرض سليم هليّل 12 ميزة وسببا تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس والترقية إلى الإصدارة 20.2 لتبقى على تواصل مع سلسلة أبيكس بالعربي يرجى الضغط على "اشترك" في أعلى هذه الصفحة ومن ثم "الدخول للاشتراك". 00:11 المقدمة 04:27 New Cards Region - قسم البطاقات 25:44 Redwood UI - واجهة ريدوود 28:32 Automations - الأتمتة 35:23 Faceted Search Enhancements - تحسينات البحث متعدد الأوجه 42:52 Report Printing - طباعة التقرير 50:06 REST Data Source Synchronizations - تزامن مصدر بيانات نقل تمثيل الحالة 53:01 REST Data Source Connector Plug-ins - إضافات برمجية لمصادر نقل تمثيل الحالة 57:22 New Web Credential Types - أنواع اعتمادات ويب جديدة 57:49 Developer Experience - تجربة المطور 59:21 New and Improved Items - عناصر جديدة ومحدثة 1:00:33 Miscellaneous - متنوعات 1:01:14 JavaScript Library Upgrades - تحديثات مكتبات الجافاسكريبت 1:01:29 Desupported Features - المزايا الغير مدعومة 1:03:27 الخاتمة Joel Kallman, Senior Director, Software Development Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
November 12, 2020	Security Basics - Passwords and the Oracle Database	Security Basics - Passwords and the Oracle Database	In this session we focused on passwords, including how to control the strength of passwords, how they are stored in the database, how database clients use passwords to authenticate to the database, and how to securely change a password or create a user with a password. Slides for this presentation are available at: https://oradocs-prodapp.cec.ocp.oraclecloud.com/documents/link/LD4A0AB9812EF0ABBB6CD3B97C3AED9B5641AEFFD193/fileview/DFA9FCB4F38C5090A8980D84885AC896FF99C3770277/_AskTom_20201112_Passwords.pptx Here is a guide to the recording; 01:25 Product Announcements - October CPU, Data Safe update, Audit Vault and Database Firewall 20.2, and Oracle Live Labs 09:30 Database authentication options 12:10 Controlling password strength 22:57 Managing password storage and hashing algorithms 36:27 Protecting passwords over the network 38:51 Safely changing a user's password 42:22 The secure way to create a database user Alan Williams, Database Security Product Manager Hakim Loumi, Product Manager/Field Engineer - Database Security Russ Lowenthal, Senior Director of Database Security Product Management
November 10, 2020	Time zone file upgrade	Time zone file upgrade	In the November session, we continued the discussion about datetime handling in the Oracle Database that we started in the October session. In particular, we went through the process of updating the time zone file version. Before viewing the recording for November session, we recommend watching the October session to learn the background of the time zone file upgrade issues. Sergiusz Wolicki, Database Globalization Architect Weiran Zhang, Director of Development
November 10, 2020	Tips for Analyzing PL/SQL Code	Tips for Analyzing PL/SQL Code	How do you deal with PL/SQL code maintenance and code analysis ? An effective code management strategy emphasizes code tracing, profiling, testing and reporting. In this session, Shashank Bark returns to offer best practices and useful techniques to analyze PL/SQL code using various data dictionary views, initialization parameters, and built-in packages. 1. Tracking exceptions in PL/SQL code 2. Tracing and generating reports on PL/SQL source code using DBMS_METADATA package 3. PL/Scope toola 4. Getting the most out of DBMS_UTILITY.FORMAT_CALL_STACK Shashank Barki, Senior Principal Data Engineer Steven Feuerstein, Developer Advocate for PL/SQL
November 8, 2020	Exploring Oracle APEX APIs	Exploring Oracle APEX APIs	Oracle APEX Pakistan Community 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, Shoaib Ahmed will expose some of the APIs that come with Oracle APEX and how to use them. Join us to directly hear from them about their experience with Oracle APEX. 00:11 Introduction by Salim Hlayel 02:11 Intro and Topics by Shoaib Ahmed 03:21 What is an API? 03:47 APEX_AUTOMATION 25:54 APEX_COLLECTION 34:41 APEX_WEB_SERVICE.MAKE_REST_REQUEST 40:51 APEX_UTIL.GET_SINCE 45:44 APEX_UTIL.PREPARE_URL 51:44 Conclusion Joel Kallman, Senior Director, Software Development Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle Application Express (APEX) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
November 5, 2020	Machine Learning 102: Clustering	Machine Learning 102: Clustering	Have 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. This sixth session in the series covered Clustering 102, where we learn more about the methods on multiple dimensions, how to compare Cluster techniques, and explore Dimensionality Reduction and how to extract only the most meaningful attributes from datasets with lots of attributes (or derived attributes). Session highlights: 00:39 Oracle Machine Learning Office Hours - next Session 01:28 Machine Learning 102 - Clustering 02:00 Clustering 102 - Demo Introduction 03:25 Dataset for Demo 03:45 Dataset view 04:40 2-D visualization of subset of Dataset 06:40 k-Means model demo build with k=2 clusters 08:10 k-Means cluster prediction 09:15 k-Means prediction visualization in 2-D and 3-D 11:20 Identify Attributes that explain the prediction for cluster 13:15 Elbow Method to identify ideal number of clusters for k-Means 15:45 Function to build, score and plot k-Means clusters 16:49 Visualizing k-Means from k=2 to k=7 in 3-D 18:05 O-Cluster algorithm demo 21:45 Materializing OML4Py proxy object to a Database table 23:21 O-Cluster model build using PL/SQL 24:55 O-Cluster model settings and attributes 25:45 O-Cluster model views 27:52 O-Cluster cluster prediction 29:20 O-Cluster prediction visualization in 2-D and 3-D 32:00 Expectation-Maximization clustering demo introduction 33:10 E-M clustering model build 37:43 E-M clustering scoring and Attribute Importance 38:13 Identify Attributes that explain the prediction for cluster 39:14 Create a function to build, score and plot an E-M clustering model 39:38 Several E-M clustering results using several available settings 41:20 E-M clustering with Model Search Enable 45:19 E-M clustering models and model views 47:10 E-M clustering scoring via Python and SQL 50:55 Q&A Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
November 3, 2020	Hands on Lab: Extending APEX Applications with Autonomous Database	Hands on Lab: Extending APEX Applications with Autonomous Database	The Developer Playground offers expert-led hands-on-labs on a variety of Oracle technologies. Learn how to extend your APEX Apps with new Autonomous Database features, such as spatial, machine learning and security. Bo English-Wiczling, Director of Program Management, Application Express
October 29, 2020	Spend Less Time Debugging Code with ML-based Log Analytics	Spend Less Time Debugging Code with ML-based Log Analytics	Let’s face it. You love to code but debugging pesky problems is always in the way. Join us in this session to learn how to identify business flows that are behaving abnormally and use machine learning techniques, including pattern recognition, trend analysis, cluster compare and links, among others, to quickly troubleshoot code defects and application performance issues. Speaker: Zubair Ansari, Director of Product Management, Oracle Cloud Observability and Management Platform Marcie Samuelsen, Developer Marketing Manager
October 29, 2020	Modernización de Oracle Forms a Oracle APEX	Modernización de Oracle Forms a Oracle APEX	En esta sesión tuvimos un panel de expertos en proyectos de modernización donde discutimos: - Los beneficios que brinda APEX para la modernización de Forms. - Los retos que pueden presentarse. - Mejores prácticas. - Herramientas propias que han desarrollado para agilizar la modernización o para estimar los costos del proyecto. Enlaces Compartidos en la Sesión: Nueva versión de APEX disponible: 20.2 https://blogs.oracle.com/apex/announcing-oracle-apex-202 #APEXHACK20 https://www.insuminsider.com/apexhack20 Serie de Artículos sobre la Modernización de Oracle Forms a Oracle APEX: http://bit.ly/BPFormsToAPEX Aplicación Final: http://bit.ly/ModernizingFormsToAPEX Proyecto de migración de Forms a APEX: https://github.com/franklingjr/oracle-forms-migration Sesiones Relacionadas: Consejos prácticos para proyectos de modernización de Forms: https://www.youtube.com/watch?v=cs-VeTQU8hc&t=681s Convirtiendo Forms a Apex sin morir en el intento: https://www.youtube.com/watch?v=B-kXZNqZeQE Joel Kallman, Senior Director, Software Development Mónica Godoy, Principal Product Manager
October 29, 2020	Graph Analytics Using the Python API	Graph Analytics Using the Python API	Graph analytics is a powerful tool to analyze your data based on connections and relationships between data entities. With the new Python API in Oracle Graph Server and Client 20.4 you can use Python to access the rich features available with property graph support in Oracle Database. You create a graph from database tables, run PGQL graph queries, analyze the graph with over 50 pre-built graph algorithms, and more. We will demo this new API and show how this can be used with popular data science tools like Jupyter Notebook. Jean Ihm, Product Manager Melli Annamalai, Senior Principal Product Manager Ryota Yamanaka, Regional Product Manager, Spatial and Graph
October 28, 2020	Database In-Memory Pushing Down into Scans	Database In-Memory Pushing Down into Scans	AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. This session will explore how Database In-Memory is able to perform function-based aggregations, filter predicates and single table group bys during the scan of the data. This is very different from the way the row store works and is another example of how Database In-Memory achieves orders of magnitude performance gains for analytic queries. Join Andy Rivenes (@TheInMemoryGuy) and Database In-Memory developer Allison Holloway for some examples and discussion of how this works and how to tell if you're getting benefits. Andy Rivenes, Product Manager Maria Colgan, Master Product Manager
October 28, 2020	Oracle Machine Learning for R: An Introduction	Oracle Machine Learning for R: An Introduction	Join us for a look at Oracle Machine Learning for R (OML4R) – the R interface to in-database machine learning and R script deployment from Oracle. R is the top statistical programming language for data science and computational statistics. OML4R enables you to work with database tables and views using familiar R syntax and functions. For scalable and performant data exploration, data preparation, and machine learning, leverage Oracle Database as a high performance compute engine. Build machine learning models using parallelized in-database algorithms using R Formula-based specification. Invoke user-defined R functions from SQL for deployment in applications and dashboards, where R engines are dynamically spawned and controlled by Oracle Database. Even take advantage of running your R functions in a data-parallel and task-parallel manner. We’ll include a demonstration of OML4R that takes us through the transparency layer, in-database machine learning, and embedded R execution functionality. Video highlights: 01:08 Oracle Machine Learning Office Hours - next Session 02:24 Oracle Machine Learning for R: an Introduction 03:40 Machine Learning Pain Points 04:06 Oracle Machine Learning 05:16 Oracle Machine Learning for SQL 06:11 Traditional Analytics and data source interaction 07:35 Oracle Machine Learning for R 09:45 Proxy objects 10:25 Data types 10:56 OML4R Algorithms 11:35 Scalable Data Analysis - Model Building 14:06 Demo - OML4R Tour in RStudio 18:15 Demo - OML4R overloaded dplyr 18:49 Demo - OML4R Join Data tables 19:50 Demo - OML4R overloaded graphic functions 20:17 Demo - OML4R Machine Learning classification 23:20 Demo - OML4R Embedded R execution 25:13 Demo - OML4R Embedded R execution from SQL Developer 29:34 Demo - OML4R groupApply 31:20 R Consortium 32:07 Why Oracle for Machine Learning with R? 33:35 Q&A Marcos Arancibia, Product Manager, Data Science and Big Data Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
October 22, 2020	RoCE 101: RDMA over Converged Ethernet	RoCE 101: RDMA over Converged Ethernet	Wondering about RDMA over Converged Ethernet? Join us as Craig Brown tells us what Oracle learned from incorporating RoCE into a high-performance engineered system. Craig will discuss what RoCE is; how it improves performance, availability, and security; and what's next in networking advances. Craig is the head of Exadata Systems Development, Integration and Program Management at Oracle Development. About the Exadata Office Hours A monthly opportunity to interact with the Oracle Exadata development experts and technical leadership. Exadata is engineered to deliver dramatically better performance, cost effectiveness, and availability for Oracle databases. Learn how to make the most of Exadata and get your questions answered by Exadata experts! Craig Brown, Senior Director and Exadata Program Manager Cris Pedregal, Senior Technologist Gavin Parish, Senior Principal Product Manager
October 22, 2020	What's new in APEX 20.2	What's new in APEX 20.2	There 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, Director of Software Development
October 22, 2020	Data loading, Hakan factor, Scheduler Timezones and more	Data loading, Hakan factor, Scheduler Timezones and more	In 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, 2020	Getting Started with JSON Document Collections in the Autonomous JSON Database	Getting Started with JSON Document Collections in the Autonomous JSON Database	In 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, 2020	Create Drive Time Areas and Perform Drive Time Distance Analysis	Create Drive Time Areas and Perform Drive Time Distance Analysis	Want 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, 2020	Finding the Longest Common Substring and Gestalt Pattern Matching	Finding the Longest Common Substring and Gestalt Pattern Matching	In 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, 2020	Moving Logs with Oracle Service Connector Hub	Moving Logs with Oracle Service Connector Hub	Enterprise 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