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.

Report Settings

  • IS_PUBLIC_CLASS = 'N'
DateDescendingSessionFocusDescription
January 14, 2021Introducing Oracle Key Vault 21Introducing Oracle Key Vault 21Managing encryption keys and IT "secrets" like passwords and SSH keys is a vital part of modern DevOps. Protecting those keys and secrets from compromise is one of the most important goals in information security This month we will introduce the latest version of Oracle Key Vault, with significant new features that help you better manage and secure your encryption keys and secrets. Key Vault version 21 introduces more powerful RESTful APIs, improved user administration, and better secrets management. Key Vault 21 works with Oracle Database, Oracle MySQL, MongoDB, Oracle ZFS, Oracle Exadata, Oracle GoldenGate, and much more. This month's guest speaker is Peter Wahl, Principal Product Manager for Encryption and Key Management. Join us to learn what's new and how you can best leverage the new features in your environment.

There are TWO identical sessions - just pick the one that works best with your schedule. As always, we start with announcements, then move into a technical presentation and then open the lines for your questions related to database security. The sessions are recorded and the recordings are usually available a few days after the session is held.

Pedro Lopes, Sr. Principal EMEA Field PM
Peter Wahl, Principal Product Manager
Russ Lowenthal, Senior Director of Database Security Product Management
January 14, 2021Hands 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 14, 2021Introducing Oracle Key Vault 21Introducing Oracle Key Vault 21Managing encryption keys and IT "secrets" like passwords and SSH keys is a vital part of modern DevOps. Protecting those keys and secrets from compromise is one of the most important goals in information security This month we will introduce the latest version of Oracle Key Vault, with significant new features that help you better manage and secure your encryption keys and secrets. Key Vault version 21 introduces more powerful RESTful APIs, improved user administration, and better secrets management. Key Vault 21 works with Oracle Database, Oracle MySQL, MongoDB, Oracle ZFS, Oracle Exadata, Oracle GoldenGate, and much more. This month's guest speaker is Peter Wahl, Principal Product Manager for Encryption and Key Management. Join us to learn what's new and how you can best leverage the new features in your environment.

There are TWO identical sessions - just pick the one that works best with your schedule. As always, we start with announcements, then move into a technical presentation and then open the lines for your questions related to database security. The sessions are recorded and the recordings are usually available a few days after the session is held.

Pedro Lopes, Sr. Principal EMEA Field PM
Peter Wahl, Principal Product Manager
Russ Lowenthal, Senior Director of Database Security Product Management
January 13, 2021.NET and Visual Studio - Oracle Office Hours.NET and Visual Studio - Oracle Office HoursAskTOM Office Hours offers free, open Q&A sessions with Oracle Database development experts. Join these sessions for the inside scoop on .NET development on Oracle Database.

Demos and lessons from previous office hours are uploaded to the Oracle .NET YouTube channel: https://www.youtube.com/user/OracleDOTNETTeam

Alex Keh, Senior Principal Product Manager
Christian Shay, Product Manager - .NET at Oracle
January 12, 2021Software Globalization Office HoursSoftware Globalization Office HoursDo you have questions about internationalizing your Oracle Database applications, configuring globalization (NLS) settings in the database, or migrating the database character set to Unicode with the DMU utility? Do you want to know the various datetime data types or do you want to understand why you see all these funny characters on the screen in place of the expected non-English data? To find an answer, just join our session and ask -- we can answer most database globalization questions right away and we will be happy to search for an answer to the remaining ones. Within the limits of our expertise, we will also try to answer globalization questions about products other than Oracle Database.

Sergiusz Wolicki, Database Globalization Architect
Weiran Zhang, Director of Development
January 11, 2021Oracle Cloud Coaching: Compute FundamentalsOracle Cloud Coaching: Compute FundamentalsIn 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, 2020Visual Builder - What’s NewVisual Builder - What’s NewLearn 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, 2020Consumiendo datos remotos en nuestras aplicaciones de APEXConsumiendo datos remotos en nuestras aplicaciones de APEXEn 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, 2020Machine Learning 101: Feature ExtractionMachine Learning 101: Feature ExtractionHave 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, 2020Flows 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, 2020Oracle Cloud Coaching: Networking and ConnectivityOracle Cloud Coaching: Networking and ConnectivityCloud 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, 2020Database In-Memory Duplicate FeatureDatabase In-Memory Duplicate FeatureAskTOM 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, 2020What’s New in Oracle Spatial Studio 20.1What’s New in Oracle Spatial Studio 20.1Want 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, 2020PL/SQL: The Good PartsPL/SQL: The Good PartsMorten 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, 2020Creating and Utilizing Custom Templates in Oracle APEXCreating and Utilizing Custom Templates in Oracle APEXOracle 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, 2020Integrando los servicios REST a nuestras aplicaciones APEXIntegrando los servicios REST a nuestras aplicaciones APEXEn 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, 2020How to Use SQL Plan Baselines and SQL ProfilesHow to Use SQL Plan Baselines and SQL ProfilesThe 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, 2020RMAN 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, 2020Super 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, 2020Answering all of your questionsAnswering all of your questionsIn 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, 202019 Critical Features Customers Lose When the Leave the Oracle Database19 Critical Features Customers Lose When the Leave the Oracle DatabaseThe 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, 2020Oracle Cloud Coaching: Identity and Access ManagementOracle Cloud Coaching: Identity and Access ManagementIn 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, 202012 ميزة تدفعك لترقية إصدارتك القديمة من أوراكل أبيكس الآن!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, 2020Security Basics - Passwords and the Oracle DatabaseSecurity Basics - Passwords and the Oracle DatabaseIn 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, 2020Time zone file upgradeTime zone file upgradeIn 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, 2020Tips for Analyzing PL/SQL CodeTips for Analyzing PL/SQL CodeHow 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, 2020Exploring Oracle APEX APIsExploring Oracle APEX APIsOracle 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, 2020Machine Learning 102: ClusteringMachine Learning 102: 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.

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, 2020Hands on Lab: Extending APEX Applications with Autonomous DatabaseHands on Lab: Extending APEX Applications with Autonomous DatabaseThe 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, 2020Spend Less Time Debugging Code with ML-based Log AnalyticsSpend Less Time Debugging Code with ML-based Log AnalyticsLet’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, 2020Modernización de Oracle Forms a Oracle APEXModernización de Oracle Forms a Oracle APEXEn 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, 2020Graph Analytics Using the Python APIGraph Analytics Using the Python APIGraph 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, 2020Database In-Memory Pushing Down into ScansDatabase In-Memory Pushing Down into ScansAskTOM 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, 2020Oracle Machine Learning for R: An IntroductionOracle Machine Learning for R: An IntroductionJoin 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, 2020RoCE 101: RDMA over Converged EthernetRoCE 101: RDMA over Converged EthernetWondering 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, 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, Director of Software Development
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, 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 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 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) مدير منتج رئيسي - أوراكل أبليكيشن إكسبريس
  • 1 - 50