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.

DateSessionFocusDescription
September 14, 2023Performance Tuning: Cómo escribir sentencias SQL como un PRO!Performance Tuning: Cómo escribir sentencias SQL como un PRO!Si los comentarios que escuchas continuamente sobre tu aplicación son "La app esta muy lenta" y "El reporte toma mucho tiempo en generarse". Es tiempo de conocer los secretos que hay detrás del lenguaje SQL y cómo la base de datos Oracle interpreta lo que necesitas de ella.

Presentador Invitado: Ronald Vargas
Ronald es Oracle ACE Director y tiene más de 30 años de experiencia en el área de Arquitectura y Gestión de bases de datos Oracle y fue el primer Centroamericano en ser incorporado al Programa Oracle ACE, de cuál forma parte desde el 2011.
Ha sido profesor universitario por más de 12 años y fue instructor de la Oracle University y Oracle Academy durante más de 15 años, impartiendo más de 200 cursos y fue reconocido como uno de los 15 mejores instructores de LAD. Además de estar siempre activo en sus redes sociales, constantemente brinda charlas a instituciones y organizaciones educativas que solicitan su apoyo. Fue Director de Tecnología de LAOUC durante 3 años y ha contribuido a la organización del evento anual de Grupos de Usuarios de América Latina desde sus inicios en el 2010.
Actualmente es Arquitecto de Datos en el Grupo Financiero Improsa en Costa Rica.

Mónica Godoy, Senior Principal Product Manager
September 14, 2023APEX and Property Graphs in Oracle Database 23cAPEX and Property Graphs in Oracle Database 23cIn Oracle Database 23c developers can work with property graphs using SQL. They can create a graph from relational tables and use the new GRAPH_TABLE and MATCH syntax to traverse connections in data. A Property Graph is a 'graph view' of data in relational tables, where implicit connections such as foreign key relationships are made explicit. This enables you to write queries to find highly connected data entities, unravel hierarchical connections, and find anomalous patterns in data.
APEX 23.1 has graph-specific widgets, and there will soon be a plugin to visualize the result of property graph queries.

Learn more and see a preview of graph visualization plugin for APEX!

Presentation: https://www.slideshare.net/ssuser923120/property-graphs-in-apexpptx
Oracle Graph Blog: https://blogs.oracle.com/database/category/db-graph

Chaitanya Koratamaddi, Director of Product Management, Oracle APEX - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Senior Principal Product Manager
August 29, 2023Best practices: Tips and tricks for developers and DBAs to work with spatial dataBest practices: Tips and tricks for developers and DBAs to work with spatial dataThis session is about sharing best practices, valuable tips & tricks for working with spatial data in the Oracle Database. The focus is on vector data. We cover techniques related to performance and storage optimization, validation, operation, processing, and querying that are relevant to application developers as well as database administrators.

Denise Myrick, Senior Program Manager
Karin Patenge, Senior Principal Product Manager | Spatial and Graph Technologies
Ramu Murakami, Spatial and Graph Product Manager
August 22, 2023Use Case: Customer Segmentation Approaches using OML and OACUse Case: Customer Segmentation Approaches using OML and OACCustomer segmentation is a task that is applicable to a wide variety of industries and can bring significant benefits to an enterprise. Oracle Machine Learning enables you to create both supervised and unsupervised machine learning models supporting customer segmentation. Additionally, the visualization capabilities of Oracle Analytics Cloud allow for a rich interface in which to dissect and understand these segments. Join us for this session to explore different approaches to customer segmentation and how to implement them using Oracle Machine Learning and Oracle Analytics Cloud.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Miles Novotny, Solution Engineer
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
August 22, 2023Connecting the Clouds with MegaportConnecting the Clouds with MegaportJoin Megaport guests Gary Taylor - Senior Solutions Architect and Sherlock Doris - Cloud Alliance Director for an update on how Oracle customers can leverage global private connectivity and an overview of Megaport's offerings. Learn about why Oracle and Megaport partnership highlights as well as several use cases. Megport will close with a demo, directly provisioning Megaport services from within the OCI Console.

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

Suzanne Holliday, Senior Principal Product Manager
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
August 22, 2023IF/THEN logic with CASE expressions in SQLIF/THEN logic with CASE expressions in SQLConditional IF-THEN logic is a foundational concept in programming.

But there's no IF statement in SQL!

To do conditional logic in SQL, you use CASE expressions.

Watch the recording to learn how CASE works and use it in

* SELECT & WHERE clauses
* Aggregate and window functions
* PL/SQL code

Highlights include:

02:05 - Basic structure of CASE
04:35 - Simple vs searched CASE expressions
09:00 - Where you can use CASE in SQL
09:45 - Demo of CASE expressions
14:00 - Demo of top-to-bottom processing
20:20 - Using CASE in WHERE
22:55 - CASE in virtual columns
27:15 - Returning many values using CASE
30:40 - Dynamic WHERE clauses
33:10 - Conditional aggregation
35:55 - Demo ways to return many values
40:15 - Demo of "dynamic" where with CASE
44:50 - Demo of CASE inside COUNT, SUM, AVG
50:35 - CASE in PL/SQL
52:25 - CASE expressions vs statements in PL/SQL
55:45 - Extended CASE controls in PL/SQL in 23c
56:50 - Demo of CASE in PL/SQL

Get the scripts: https://bit.ly/SQL-ATOH-case-expressions-script
Learn SQL for free: https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html

Chris Saxon, Oracle Developer Advocate for SQL
August 21, 2023New Features in Visual Builder August 2023New Features in Visual Builder August 2023Get to know the new features in Oracle Visual Builder and Visual Builder Studio in our 2310 version. Learn about the new features and how to use them with live demos.

Blaine Carter, Developer Advocate for Open Source
Shay Shmeltzer, Director of Product Management
August 18, 2023Retention Lock your Cloud Database Backups for Increased Ransomware Protection & highlights for DatabaseWorld at CloudWorldRetention Lock your Cloud Database Backups for Increased Ransomware Protection & highlights for DatabaseWorld at CloudWorldThe Zero Data Loss Autonomous Recovery Service is introducing a new feature which allows backups to be retention locked, providing additional protection against ransomware and malicious users. Backups will have the option to strictly adhere to the backup retention setting specified in the protection policy, so even a ransomware attack or administrator in your OCI tenancy would be blocked in attempting to reduce backup retention time. Join us to see how Recovery Service can help you better prepare against ransomware attacks and malicious users. We will also highlight the Backup & Recovery activities for the upcoming DatabaseWorld at CloudWorld being held Sept 18-21 in Las Vegas.

Alex Goldblatt, Principal Product Manager
Kelly Smith, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
August 17, 2023Javascript running in the Database!Javascript running in the Database!Practical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session, guest speaker Martin Bach covered some of the exciting new features in the database allowing JavaScript to be a full server side code citizen just like PL/SQL. With the plethora of JavaScript libraries out there, the ability to augment existing database features with custom libraries has never been greater!

Connor McDonald, Developer Advocate
USER402656,
August 15, 2023Low-Code and AI for Automating Invoice Processing & Approval Workflow - a customer StoryLow-Code and AI for Automating Invoice Processing & Approval Workflow - a customer StoryTrailcon Leasing is a major player in the transportation industry in Canada, with facilities across the country and a team of 560 active users, covering back office, field technicians, customers, and vendors. Trailcon is servicing more than 30,000 assets of their own and from Canada's largest companies. With a 24/7 operation, Trailcon has been using Oracle Technologies for the last 25 years and APEX since 2020; in this session, you will learn how they used Oracle APEX low-code platform and AI to modernize and implement several automated business processes, including an Invoice Processing module leveraging OCI's Document Understanding and MS365 Integration.

Join us to learn how Trailcon has leveraged these technologies to maintain a leading edge in the rapidly evolving transportation industry.

Our guest speaker:

Giovani Cani is the VP, IT Delivery at Trailcon Leasing Inc. He is a seasoned IT professional with 20+ years of experience spanning the entire IT spectrum. He has a proven track record of delivering digital solutions in the logistics and transportation sector that optimize processes and adapt to ever-changing business challenges and opportunities.

Ashish Mohindroo, Vice President / GM for Oracle APEX
Salim Hlayel - سليم هليّل, Principal Product Manager for Oracle APEX مدير منتج رئيسي - أوراكل أيبكس
August 9, 2023Extend your Oracle Data Safe capability to Amazon RDS for OracleExtend your Oracle Data Safe capability to Amazon RDS for OracleOracle Data Safe is the OCI cloud service providing an integrated set of essential security services for Oracle Databases both in the cloud and on-premises. Join us for August's DB Security Office Hours where we will be introducing Data Safe's support for Amazon RDS for Oracle Database. Database Security product managers will demonstrate Oracle Data Safe ability to monitor Amazon RDS for Oracle Databases and answer any questions you have regarding this exciting new capability or existing Oracle Data Safe capabilities.


Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Bettina Schaeumer, Senior Principal Product Manager
Michael Mesaros, Director of Product Management, Database Security
Richard C Evans, Product Manager, Database Security
August 8, 2023Metode de autentificare și autorizare în APEXMetode de autentificare și autorizare în APEXOracle APEX este proiectat pentru a construi aplicații web care sunt extrem de sigure. Într-o lume a standardelor web în continuă schimbare și a atacatorilor din ce în ce mai plini de resurse care găsesc noi modalități de a pirata site-uri, concentrarea noastră pe securitate înseamnă că aplicațiile dvs. rămân protejate.
Autentificarea este procesul de identificare a cine accesează aplicația, în timp ce Autorizarea definește dacă utilizatorul are permisiunea de a utiliza o aplicație sau părți ale acesteia. Oracle APEX vine cu un set cuprinzător de scheme de autentificare încorporate care simplifică integrarea cu furnizorii de autentificare bazați pe cloud, depozitul LDAP al companiei dvs. sau utilizarea depozitului local de spațiu de lucru Oracle APEX.
Definiți accesul la aplicația, paginile și componentele paginii dvs. cu scheme de autorizare. Utilizați controlul de acces la aplicații încorporat pentru a gestiona utilizatorii și rolurile.

V-am făcut curioși? Vă așteptăm la sesiunea live pentru a explora aceste caracteristici ale platformei APEX.

Speakeri:
Roxana Chiriacescu - Oracle Romania Cloud Presales
Roxana oferă în prezent consultanță tehnică echipei de vânzari cloud (IaaS/PaaS) care acoperă piața din România. Anterior a lucrat timp de 10 ani în Oracle Advanced Customer Services, ajutând clienții in proiectele lor cu Oracle APEX. Roxana promovează APEX din 2009 printre colegi, studenți și profesori, clienți și parteneri Oracle.

Andor Imre - Oracle Partner Success Manager
Andor se concentrează în prezent pe pregătirea technică a partenerilor Oracle în lumea cloud-ului, însă entuziasmul lui pentru APEX a rămas neschimbat din rolurile anterioare cu focus mărit pe APEX din cadrul organizațiilor Presales și Alliances & Channels. Andor promovează adopția APEX printre clienți, parteneri, colegi și pasionați de tech.

Andreea Munteanu, Principal Member of Technical Staff
Fanel Secara, Member Of Technical Stuff(APEX)
Stefan Dobre (APEX), Senior Member of Technical Staff
August 3, 2023What’s New in Flows for APEX v 23.1!What’s New in Flows for APEX v 23.1!Join the Flows for APEX team to see the new features of Flows for APEX v23.1!
This new version adds powerful new features for business modelers, application developers, and system administrators – including task assignment, due dates and priorities, process variable binding, a modernized modeler UI, REST enablement, and basic support for inter-process messaging/messageFlow.

Chaitanya Koratamaddi, Director of Product Management, Oracle APEX - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Senior Principal Product Manager
August 3, 2023Explore the latest features in APEX 23.1 (Chinese)Explore the latest features in APEX 23.1 (Chinese)In this session, Adam Li from the APEX Product Development Team will showcase the latest features of APEX 23.1 in Chinese Language.

Apoorva Srinivas, Senior Product Manager - Oracle APEX
Chaitanya Koratamaddi, Director of Product Management, Oracle APEX - Database Tools | Server Technologies
RoopeshThokala, Product Manager
August 2, 2023Maps in apps - database-driven development with Oracle Spatial in Autonomous Database (EMEA edition)Maps in apps - database-driven development with Oracle Spatial in Autonomous Database (EMEA edition)Join the Autonomous Database PM and the Spatial PM teams in this Learning Lounge session, where they will show how to do database-driven development with Oracle Spatial in Autonomous Database. You will be able to ask your questions in the open Q&A.

- Maps in apps - database-driven development with Oracle Spatial
David Lapp, Senior Principal Product Manager will explain how location is an essential component of modern business applications in both operational and analytics scenarios, and how location is a key to understanding the relationships between business entities such as trade areas, demographics, and traffic patterns. Whether represented as maps, reports, or notifications, the results of location-based analysis, such as "which properties are within a flood hazard zone", are often the only means of relating diverse sources of data.

The Spatial features of Oracle Autonomous Database provide robust geospatial data management and analysis. These features are accessed programmatically with SQL, or using the no-code Oracle Spatial Studio web tool. As a feature of Oracle's converged database, these geospatial capabilities co-exist with a wide range of features supporting database-driven application development.

This session explains how to include maps and location-based analysis in your applications with Oracle Spatial in combination combined with Oracle Application Express (APEX) for low-code application development and Oracle REST Data Services (ORDS) for creating spatial services.

- Open Q&A
Autonomous Database
and Spatial product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

David Lapp, Product Manager - Spatial and Graph
Jayant.Sharma, Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
August 1, 2023Maps in apps - database-driven development with Oracle Spatial in Autonomous Database (Americas edition)Maps in apps - database-driven development with Oracle Spatial in Autonomous Database (Americas edition)Join the Autonomous Database PM and the Spatial PM teams in this Learning Lounge session, where they will show how to do database-driven development with Oracle Spatial in Autonomous Database. You will be able to ask your questions in the open Q&A.

- Maps in apps - database-driven development with Oracle Spatial
David Lapp, Senior Principal Product Manager will explain how location is an essential component of modern business applications in both operational and analytics scenarios, and how location is a key to understanding the relationships between business entities such as trade areas, demographics, and traffic patterns. Whether represented as maps, reports, or notifications, the results of location-based analysis, such as "which properties are within a flood hazard zone", are often the only means of relating diverse sources of data.

The Spatial features of Oracle Autonomous Database provide robust geospatial data management and analysis. These features are accessed programmatically with SQL, or using the no-code Oracle Spatial Studio web tool. As a feature of Oracle's converged database, these geospatial capabilities co-exist with a wide range of features supporting database-driven application development.

This session explains how to include maps and location-based analysis in your applications with Oracle Spatial in combination combined with Oracle Application Express (APEX) for low-code application development and Oracle REST Data Services (ORDS) for creating spatial services.

- Open Q&A
Autonomous Database
and Spatial product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

David Lapp, Product Manager - Spatial and Graph
Jayant.Sharma, Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
July 27, 2023Generación de Reportes con Oracle APEXGeneración de Reportes con Oracle APEXOracle APEX ofrece una gran variedad de opciones para generar reportes dinámicos, personalizados y en diferentes formatos para cumplir con las necesidades de los usuarios.

En esta sesión, mostramos como se pueden generar reportes con APEX utilizando opciones nativas y comerciales:
- Componentes Nativos
- APIs Nativas
- Oracle Analytics Cloud (OAC)
- APEX Office Print (AOP)
- JasperReportsIntegration

Presentadora Invitada: Clarisa Maman Orfali.
Clarisa es Ingeniera en Sistemas de Información con especialización en Oracle APEX desde 2012. Se desempeña como Directora de Soluciones de Negocios y Servicios de Aprendizaje Global de TI en Kiú Software Integration y también es Oracle ACE Director.

Mónica Godoy, Senior Principal Product Manager
July 26, 2023Scalability and Elasticity in Oracle Database Cloud Services:Scalability and Elasticity in Oracle Database Cloud Services:Leverage easy Scalability and Elasticity functions to address growing workload & data demands:
-- OCI Footprint and Available Services
-- Available Oracle Database Cloud Services
-- Selecting the right Oracle Database Cloud Service
HA Requirements
Scale and Performance Requirements
-- Scaling Options for Oracle Database Cloud Services
Scaling Base Database Service
Scaling Exadata Database Service
-- Scalability Automation for Oracle Database Cloud Services
Available OCI Management Interfaces & Tools
-- Monitoring and Alerting for Scalability Automation
Create Notifications for Scalability and Resource utilization
Viewing Your Service Limits, Quotas, and Resource Usage

Join us to learn about Exadata Database Services and BaseDB VM in OCI. AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Eddie Ambler, Product Manager - DBCS, ExaDB-D, ExaDB-C@C
Leo Alvarado, Product Manager, Exadata Cloud Service
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
July 25, 2023Utilizando Oracle APEX para criar um SaaSUtilizando Oracle APEX para criar um SaaSVocê já pensou em usar Oracle APEX para criar um Software as a Service (SaaS)? Nesta sessão do Office Hours, André de Souza compartilhará conosco a sua jornada de sucesso na criação de uma startup, pensada para oferecer ao mercado um SaaS de alta performance 100% desenvolvido em Oracle APEX.

Software as a Service (SaaS) é um modelo inovador de fazer negócios. Nele, o fornecedor cuida de toda a estrutura, enquanto o cliente apenas a utiliza do serviço, via internet, de forma dinâmica e descomplicada.

Além de empresário, consultor e conferencista, André de Souza é um especialista de Tecnologia da Informação com mais de dez anos de experiência em Oracle APEX. Ele é CEO e cofundador da Simplifica Gestão, um SaaS voltado para gestão de pequenas e médias empresas, totalmente desenvolvido em Oracle APEX.

Karina Pastor, Principal Product Manager - Oracle APEX
Mónica Godoy, Senior Principal Product Manager
July 25, 2023Spatial 101 for raster data management using the Oracle DatabaseSpatial 101 for raster data management using the Oracle DatabaseIf you need to manage and efficiently use raster data, here is the session to attend!

Many technologies capture or generate raster data and images: remote sensing, photogrammetry, geospatial thematic mapping ... Rasters are used in a wide variety of application areas: location-based services, geospatial image archiving and serving, environmental monitoring and assessment, geological engineering and exploration, natural resource management, climate modeling, ocean floor surveying and mapping, defense, emergency response, telecommunications, transportation, urban planning, and homeland security.

What is the session about?

GeoRaster is a feature of the Oracle Database that lets you store, index, query, process, analyze, and serve georeferenced raster images and gridded data and its associated metadata. It provides native data types and an object-relational schema to store and manage multidimensional arrays, grid layers, and digital images that can be referenced to positions on the Earth's surface.

What will you learn during this session ?

- What are rasters and how they compare with vector data
- The data structures used in the database to store rasters
- How do we import rasters from files ?
- How do we view rasters ?
- How to we process and analyze rasters

Albert Godfrind, Spatial and Graph Solutions Architect
Denise Myrick, Senior Program Manager
Ramu Murakami, Spatial and Graph Product Manager
July 25, 2023One workload, two clouds and the magic in between... A discussion with Julian Dontcheff, Managing Director and Global Database Lead at AccentureOne workload, two clouds and the magic in between... A discussion with Julian Dontcheff, Managing Director and Global Database Lead at AccentureJoin this session to learn from Julian Dontcheff, Accenture how the Oracle Database on OCI is helping customers solve multicloud challenges in a split-stack multicloud architecture.
Julian and Database Multicloud Product Management will discuss the merits of the Oracle Database features on OCI for multicloud security, performamance, AI - Automation and license mitigation, as well as vendor lock-in.

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

Suzanne Holliday, Senior Principal Product Manager
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
July 21, 2023Announcing Oracle's Zero Data Loss Recovery Appliance RA23Announcing Oracle's Zero Data Loss Recovery Appliance RA23Join us for a discussion on the recently announced next generation Zero Data Loss Recovery Appliance RA23! This latest generation continues our history of innovations with increased capacity and performance for enterprise-grade database backup and recovery needs.

Dan Holeva, Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
July 18, 2023How to modify constraints in Oracle DatabaseHow to modify constraints in Oracle DatabaseFrom time to time, you may need to change a constraint. For example, adding values to a CHECK constraint IN list or changing the columns in a unique constraint.

Sadly there's no syntax to make these changes. You need to drop and recreate the constraint with the new criteria.

Watch the recording to learn how to make these changes while the application is online & keep your data safe!

Highlights include:

- 00:30 The problem with changing constraints
- 03:00 Reasons for changing constraints
- 12:20 Changing CHECK constraints
- 20:00 Demo of changing CHECK constraints
- 30:10 Adding/removing NOT NULL constraints
- 33:00 Changing columns in a UNIQUE constraints
- 35:30 Demo changing NOT NULL & UNIQUE
- 39:00 Changing PRIMARY KEY
- 43:30 Changing FOREIGN KEY
- 47:35 Adding a surrogate key to a table
- 53:30 Demo changing PRIMARY & FOREIGN keys
- 57:30 Summary

Read the blog post https://bit.ly/change-constraint-blog
Get the scripts https://bit.ly/SQL-ATOH-change-constraints-script

Learn SQL for free https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html

Chris Saxon, Oracle Developer Advocate for SQL
July 12, 2023Understanding Oracle Python driver's new Thin mode and how to help Oracle's driver development strategy (NA)Understanding Oracle Python driver's new Thin mode and how to help Oracle's driver development strategy (NA)Join this free session by Oracle product managers and developers to learn about the Oracle Python driver's new Thin mode that connects to Oracle Database without needing Oracle Instant Client. Additionally, discover how you can collaborate with Oracle to influence new driver features that address your business challenges and needs.

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Veronica Dumitriu, Principal Product Manager
July 12, 2023New LiveLabs In-Memory Advanced FeaturesNew LiveLabs In-Memory Advanced FeaturesAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Explore the Database In-Memory option with Andy Rivenes (@TheInMemoryGuy). In this session we explored using the new Database In-Memory LiveLabs Advanced Features lab that was recently released. We showed how to get started with LiveLabs and then ran through the Join Groups lab based on an attendee request.

Andy Rivenes, Product Manager
July 12, 2023Back to Basics – Protecting data with row-level and column-level security using Oracle VPD.Back to Basics – Protecting data with row-level and column-level security using Oracle VPD.Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

July's DB Security Office Hours will focus on a core security feature of Oracle Database Enterprise Edition that has been available since 1999 with Oracle Database 8i. Oracle VPD, also known as row-level security or fine-grain access control, allows you to create security policies to control database access at the row and column level.

Dan Morgan, Technical Director of Database and Cloud Security, Oracle Consulting Services, and Oracle ACE Director Alum, will join Richard C. Evans, Oracle Database Security Product Manager, for this month’s presentation. Together, they will cover the business case for Oracle VPD, compare it to other Oracle solutions, and provide a demonstration you can use on the Oracle DB Security LiveLabs environment or an Oracle Autonomous Database.

Daniel Morgan, Technical Director Oracle Database Security
Pedro Lopes, Sr. Principal EMEA Field PM
Richard C Evans, Product Manager, Database Security
July 12, 2023Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database (EMEA edition)Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database (EMEA edition)Autonomous Database Learning Lounge series presents: Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database

Join the Autonomous Database PM and the Graph PM teams in this Learning Lounge session, where they will demonstrate how you can use graph queries and graph analytics to find new relationships in existing data in your autonomous database. You will be able to ask your questions in the open Q&A.

- Graphs Made Easy: Find New Insights in Your Data
Melliyal Annamalai, Distinguished Product Manager
will explain how modeling your data as a graph can help you find connections in data. With graphs you can uncover money laundering in financial transactions, traverse linked components in manufacturing data, search for connected parts in a supply chain inventory, find impacted nodes in a telecommunication network failure, and more. Graph Studio in Oracle Autonomous Database makes it easy for developers to get started with graph queries and graph analytics. You can create, query, analyze, and visualize graphs using automated graph modeling tools, a SQL-like graph query language, and pre-built graph algorithms, all using data in tables in your autonomous database. Melli will walk through an example of finding fraud in financial transactions and show you how you can get started with graphs in minutes.
- Open Q&A
Autonomous Database
and Graph product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Jayant.Sharma, Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
Melli Annamalai, Senior Principal Product Manager
July 12, 2023Understanding Oracle Python driver's new Thin mode and how to help Oracle's driver development strategy (JPAC)Understanding Oracle Python driver's new Thin mode and how to help Oracle's driver development strategy (JPAC)Join this free session by Oracle product managers and developers to learn about the Oracle Python driver's new Thin mode that connects to Oracle Database without needing Oracle Instant Client. Additionally, discover how you can collaborate with Oracle to influence new driver features that address your business challenges and needs.

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Veronica Dumitriu, Principal Product Manager
July 11, 2023Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database (Americas edition)Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database (Americas edition)Autonomous Database Learning Lounge series presents: Graphs Made Easy: Find New Insights in Your Data with Graph in Autonomous Database

Join the Autonomous Database PM and the Graph PM teams in this Learning Lounge session, where they will demonstrate how you can use graph queries and graph analytics to find new relationships in existing data in your autonomous database. You will be able to ask your questions in the open Q&A.

- Graphs Made Easy: Find New Insights in Your Data
Melliyal Annamalai, Distinguished Product Manager
will explain how modeling your data as a graph can help you find connections in data. With graphs you can uncover money laundering in financial transactions, traverse linked components in manufacturing data, search for connected parts in a supply chain inventory, find impacted nodes in a telecommunication network failure, and more. Graph Studio in Oracle Autonomous Database makes it easy for developers to get started with graph queries and graph analytics. You can create, query, analyze, and visualize graphs using automated graph modeling tools, a SQL-like graph query language, and pre-built graph algorithms, all using data in tables in your autonomous database. Melli will walk through an example of finding fraud in financial transactions and show you how you can get started with graphs in minutes.
- Open Q&A
Autonomous Database
and Graph product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Jayant.Sharma, Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
Melli Annamalai, Senior Principal Product Manager
June 29, 2023Cargando aplicaciones APEX a un servicio de distribución digitalCargando aplicaciones APEX a un servicio de distribución digitalEn esta sesión Andrés Díaz presento las ventajas que ofrecen las aplicaciones web progresivas, sus funcionalidades y cómo puedes desplegar aplicaciones desarrolladas en APEX en un servicio de distribución digital como Google Play Store.

Presentación: https://docs.google.com/presentation/d/1YWo3FrV8UUjXi33YSUEbUq_X-WWaXDBx/edit?usp=drive_link&ouid=100089879469797363509&rtpof=true&sd=true

Andrés Díaz es Team Leader en ITG Software

Mónica Godoy, Senior Principal Product Manager
June 28, 2023Journey to the Oracle Cloud: From on-premises to Exadata Cloud@CustomerJourney to the Oracle Cloud: From on-premises to Exadata Cloud@CustomerJoin us to learn about Exadata Database Services and BaseDB VM in OCI. AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Agenda:
-- OCI Footprint and Services
-- Available OCI Management Interfaces
-- Available Oracle Database Cloud Services
-- Exadata Database Service Deployment Options
-- Exadata Database Service Management Options
-- Billing & Licensing Models
-- BYOL Option
-- License Included Option
-- Universal Cloud Credits (UCC)
-- Exadata Database Service Architecture
-- Cloud Management Responsibilities & Interfaces
-- System Configuration and Scaling options
-- Multi-VM and Node Subsetting
-- Backup & Recovery
-- HA with Data Guard & Active Data Guard
-- Open Q&A

Eddie Ambler, Product Manager - DBCS, ExaDB-D, ExaDB-C@C
Leo Alvarado, Product Manager, Exadata Cloud Service
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
June 27, 2023REST and Spatial: an excellent fitREST and Spatial: an excellent fitWith spatial features included for free with all editions and services of Oracle Database, you can store, manage, process, and query all forms of spatial workloads and data sets and create maps to visualize and interact with your data.
REST interfaces have become popular for connecting applications together in a simple and flexible way.
This session is focused on accessing and working with spatial data via such REST interfaces. We will look at three complementary approaches:
- Spatial Studio with its ability to consume and expose GeoJSON REST endpoints
- Oracle Rest Data Services that can publish and update spatial data
- Spatial Studio’s own REST API that lets you use its features via REST endpoints.

Albert Godfrind, Spatial and Graph Solutions Architect
Karin Patenge, Senior Principal Product Manager | Spatial and Graph Technologies
Ramu Murakami, Spatial and Graph Product Manager
June 22, 2023Low Code eSports Analytics with Oracle APEXLow Code eSports Analytics with Oracle APEXTune in to find out how the Oracle Solution Engineering team runs Formula 1 & eSports data analysis using Oracle APEX. We will discuss a newly created Hands-on Lab that will help you get up and running with your own data analysis from your favourite game! We will also show you how to customize your low-code app like a pro!

Apoorva Srinivas, Senior Product Manager - Oracle APEX
Chaitanya Koratamaddi, Director of Product Management, Oracle APEX - Database Tools | Server Technologies
RoopeshThokala, Product Manager
June 21, 2023Embedding AI/ML in applications using OML in Autonomous Database (EMEA edition)Embedding AI/ML in applications using OML in Autonomous Database (EMEA edition)Autonomous Database Learning Lounge series presents: Embedding AI/ML in applications using OML in Autonomous Database

Oracle Machine Learning and Autonomous Database Product Management will introduce Oracle Machine Learning in-database capabilities, as well as Python, R, REST and the latest no-code UI options for this component that is included with every Autonomous Database.

- Introduction to Oracle Machine Learning concepts and capabilities in ADB
Mark Hornick, Senior Director of Product Management
will introduce concepts surrounding in-database machine learning from SQL, Python, R and REST APIs, along with OML components exclusive to Autonomous Database. He will highlight the benefits of using machine learning in ADB, common use cases, and the upcoming features.
- Oracle Machine Learning UI for Autonomous Database
Marcos Arancibia, Senior Principal Product Manager
will show a quick live demo of the different UI options available for using OML with Autonomous Database and the no-code OML AutoML UI.
- Oracle Machine Learning for Developers: Python and R Third-Party packages, REST APIs and Model Monitoring
Sherry LaMonica, Consulting Member of Technical Staff
will demo how to use Conda environments for third-party Python and R packages with Autonomous Database, show how to use ML models deployed to OML Services using the REST API for real-time scoring, followed by invoking user-defined Python and R functions through REST and SQL APIs, and the use of Model Monitoring for detecting the need to replace an ML model in production.
- Open Q&A
Autonomous Database product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
June 20, 2023Embedding AI/ML in applications using OML in Autonomous Database (Americas edition)Embedding AI/ML in applications using OML in Autonomous Database (Americas edition)Autonomous Database Learning Lounge series presents: Embedding AI/ML in applications using OML in Autonomous Database

Oracle Machine Learning and Autonomous Database Product Management will introduce Oracle Machine Learning in-database capabilities, as well as Python, R, REST and the latest no-code UI options for this component that is included with every Autonomous Database.

- Introduction to Oracle Machine Learning concepts and capabilities in ADB
Mark Hornick, Senior Director of Product Management
will introduce concepts surrounding in-database machine learning from SQL, Python, R and REST APIs, along with OML components exclusive to Autonomous Database. He will highlight the benefits of using machine learning in ADB, common use cases, and the upcoming features.
- Oracle Machine Learning UI for Autonomous Database
Marcos Arancibia, Senior Principal Product Manager
will show a quick live demo of the different UI options available for using OML with Autonomous Database and the no-code OML AutoML UI.
- Oracle Machine Learning for Developers: Python and R Third-Party packages, REST APIs and Model Monitoring
Sherry LaMonica, Consulting Member of Technical Staff
will demo how to use Conda environments for third-party Python and R packages with Autonomous Database, show how to use ML models deployed to OML Services using the REST API for real-time scoring, followed by invoking user-defined Python and R functions through REST and SQL APIs, and the use of Model Monitoring for detecting the need to replace an ML model in production.
- Open Q&A
Autonomous Database product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
June 20, 2023OracleDB for Azure Hub-and-spoke Network Toplogy Best PracticesOracleDB for Azure Hub-and-spoke Network Toplogy Best PracticesJoin this session to learn about using Oracle Database Service for Azure (OracleDB for Azure) connected to a hub-and-spoke network which requires extra setup in Azure to enable internet control message protocol (ICMP) messages to reach the spoke networks. This setup is required for the Path MTU Discovery (PMTUD) protocol to work properly and all network traffic to flow correctly.

Without these steps, you can experience hanging connections caused by a failure to correctly negotiate the maximum segment size (MSS) between Azure and Oracle Cloud Infrastructure (OCI) resources across the multicloud network link. This Multicloud Happenings session explains the best practices for the optimal setup.

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

Emiel Ramakers, Principal Cloud Architect - Multicloud Specialist
Suzanne Holliday, Senior Principal Product Manager
Thomas Van Buggenhout, Principal Solution Architect
June 20, 2023Simple SQL with Oracle Database 23cSimple SQL with Oracle Database 23cOracle Database 23c includes over 300 new SQL features. Watch the recording for an overview of key enhancements to make it easier than ever to write Oracle SQL

Highlights include:

- 2:50 What's in 23c
- 5:35 When is 23c available
- 09:50 Overview of the schema for the demo
- 13:30 DROP IF EXISTS & CREATE IF NOT EXISTS
- 15:50 DB_DEVELOPER_ROLE
- 16:40 SELECT without FROM
- 17:35 Usage domains
- 25:40 Annotations
- 32:40 Table-values constructor
- 34:50 Properties from domains; case-insensitive search; display and order expressions; constraints
- 39:10 Better error messages
- 40:45 Group by alias, SUM over intervals, FLOOR & CEIL on datetime values
- 48:25 UPDATE: Direct joins & RETURNING OLD & NEW values
- 51:40 Boolean data type in SQL
- 54:30 Automatic SQL Transpiler
- 57:30 Schema-level privileges

Get 23c Developer Release https://www.oracle.com/23cFREE
Learn SQL for free https://devgym.oracle.com/pls/apex/dg/class/databases-for-developers-foundations.html

Chris Saxon, Oracle Developer Advocate for SQL
June 16, 2023De-Mystifying Deduplication for DatabasesDe-Mystifying Deduplication for DatabasesJoin us for an enlightening, historical perspective of backup deduplication technologies in the market. We will also show how general purpose storage deduplication differs from Oracle RMAN and Zero Data Loss Recovery Appliance database-optimized solutions.

Alex Goldblatt, Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Senior Director of Product Management
June 15, 2023APEX 23.1 and server-side JavaScript: Explore the power of GraalVM/MLEAPEX 23.1 and server-side JavaScript: Explore the power of GraalVM/MLEIn this session, we were joined by Stefan Dobre, Salim Hlayel, and Lucas Braun from the Oracle development and product management teams to hear about the new JavaScript capabilities in Oracle 23c and how they perfectly blend in with the world's most popular low-code engine, APEX. JavaScript code - powered by GraalVM/MLE - seamlessly integrates with SQL and PL/SQL and can now be managed directly in the database, all through APEX' brand-new object browser. Using community JavaScript modules is as easy as pasting a URL into APEX and clicking a button.

We showed hands-on how such community modules can be imported to extend your APEX applications. Using Email Validation, QR Code generation, and Markdown conversion, all in Server-Side JavaScript.

Find the Q&A for the live session here: https://forums.oracle.com/ords/apexds/post/office-hours-apex-23-1-and-server-side-javascript-explore-t-0497

Useful links:
APEX + Server-Side JavaScript
https://apex.oracle.com/go/mle-lab

JavaScript Developer's Guide
https://apex.oracle.com/go/js-dev-guide

Introduction to JavaScript in Oracle Database 23c Free - Developer Release
https://apex.oracle.com/go/js-23c-blog1

Using JavaScript community modules in Oracle Database 23c Free - Developer Release
https://apex.oracle.com/go/js-23c-blog2

Chaitanya Koratamaddi, Director of Product Management, Oracle APEX - Database Tools | Server Technologies
Marc Sewtz, Director of Software Development
Mónica Godoy, Senior Principal Product Manager
June 15, 2023What parts of my database are busy?What parts of my database are busy?Practical and useful information to solving common issues and getting the best out of your Oracle Database. In this latest session we covered:

- easier LOB managment facilities in SQL
- using SQL profile/outlines
- the order of predicate evaluation in a WHERE clause
- what is INTERNAL_FUNCTION when seen in the EXPLAIN PLAN?
- what are the busiest tables in the database?
- Dealing with complex hierarchy SQL requirements

Connor McDonald, Developer Advocate
June 14, 2023Database Security Office Hours – Learn what’s new in Oracle Key Vault 21.6Database Security Office Hours – Learn what’s new in Oracle Key Vault 21.6June’s DB Security Office Hours will focus on Oracle Key Vault (OKV) 21.6. Product Manager of TDE and OKV, Peter Wahl, will walk you through the latest capabilities of OKV including the ability to mark private keys as non-extractable, create asymmetric keys using the OKV APIs, additional deployment options for Microsoft Azure and Amazon AWS, and many more features you’ll want to hear about.

Join the Database Security product management team on the second Wednesday of the month at 10:00 am US Central time for Database Security Office hours. We hold these sessions each month to keep you updated on what's new with Oracle Database security. We cover announcements about new features, products, and capabilities followed by a discussion of some technical topic. Each session ends with an opportunity for open Q&A about database security.

Pedro Lopes, Sr. Principal EMEA Field PM
Peter Wahl, Principal Product Manager
Richard C Evans, Product Manager, Database Security
June 14, 2023Oracle Database In-Memory Summit 2023 Session 2Oracle Database In-Memory Summit 2023 Session 2We are organizing summit again - Oracle Database In-Memory Summit 2023.

SAVE THE DATE !!!! Its FREE, Its OPEN to all & VIRTUAL (Need Zoom)

The Summit consists of 2 sessions. You can register for both. Customer presentations will be different.
Session 2 : Tuesday June 13th, 2023 08:00PM-10:00PM PST
Agenda
• Keynote presentation
• Use Cases and Roadmap of Database In-Memory
• What’s new in Database In-Memory 21c and 23c
• Best Practices
• Several Customer presentations
• Q&A

Exciting agenda planned for the summit with keynote presentations, roadmap updates, new features and customer presentations. Summit will also be a great opportunity to interact directly with Oracle Product Management and Development. You will hear the Vision, Use Cases, Best Practices, and Roadmap of Database In-Memory. You will also hear from Customers who will share their experiences and success using Database In-Memory. in addition, you will also hear from Thought Leaders on why In-Memory technology is a must have for Real-time Analytics. Join and ask questions or share your own experiences. Share your feedback and provide inputs to strategy and direction of Database In-Memory.

Oracle Database In-Memory transparently accelerates analytic queries by orders of magnitude, enabling real-time analytics. It implements most innovative and state-of-the-art algorithms to achieve real-time performance. Analytics that previously took minutes and hours to run can now complete in seconds.

"The ability to make instant decisions on live data is essential for an enterprise to be considered real-time. Oracle’s Database In-Memory is the industry-leading in-memory technology, allowing organizations to enable real-time analytics on any data source, in order to maximize agility, efficiency, and profitability" - Tirthankar Lahiri, SVP, Data and In-Memory Technologies at Oracle

Read the latest reports from Forrester and Gartner and you will see how Database In-Memory is playing a significant role in Translytical analytics (Transaction+Analytics) and Operational use cases. “Oracle Database In-memory is a game changer for OLTP, DW, and mixed workloads. It dramatically improves the performance of all type of analytical queries.” AVP Data Management, McKesson Health Solution.

We look forward to seeing you at the 2023 summit

Thank you,
Oracle Database In-Memory Team

Ranjan Priyadarshi, Sr Director, Product Management
SHASANK CHAVAN, Vice President, In-Memory Database Technologies
TirthankarLahiri, Senior Vice President, Data and In-Memory Technologies
June 13, 2023Oracle Database In-Memory Summit 2023 Session 1Oracle Database In-Memory Summit 2023 Session 1We are organizing summit again - Oracle Database In-Memory Summit 2023.

SAVE THE DATE !!!! Its FREE, Its OPEN to all & VIRTUAL (Need Zoom)

The Summit consists of 2 sessions. You can register for both. Customer presentations will be different.

Session 1 : Tuesday June 13th, 2023 08:00AM-10:00AM PST
Agenda
• Keynote presentation
• Use Cases and Roadmap of Database In-Memory
• What’s new in Database In-Memory 21c and 23c
• Best Practices
• Customer presentations
• Q&A

Exciting agenda planned for the summit with keynote presentations, roadmap updates, new features and customer presentations. Summit will also be a great opportunity to interact directly with Oracle Product Management and Development. You will hear the Vision, Use Cases, Best Practices, and Roadmap of Database In-Memory. You will also hear from Customers who will share their experiences and success using Database In-Memory. in addition, you will also hear from Thought Leaders on why In-Memory technology is a must have for Real-time Analytics. Join and ask questions or share your own experiences. Share your feedback and provide inputs to strategy and direction of Database In-Memory.

Oracle Database In-Memory transparently accelerates analytic queries by orders of magnitude, enabling real-time analytics. It implements most innovative and state-of-the-art algorithms to achieve real-time performance. Analytics that previously took minutes and hours to run can now complete in seconds.

"The ability to make instant decisions on live data is essential for an enterprise to be considered real-time. Oracle’s Database In-Memory is the industry-leading in-memory technology, allowing organizations to enable real-time analytics on any data source, in order to maximize agility, efficiency, and profitability" - Tirthankar Lahiri, SVP, Data and In-Memory Technologies at Oracle

Read the latest reports from Forrester and Gartner and you will see how Database In-Memory is playing a significant role in Translytical analytics (Transaction+Analytics) and Operational use cases. “Oracle Database In-memory is a game changer for OLTP, DW, and mixed workloads. It dramatically improves the performance of all type of analytical queries.” AVP Data Management, McKesson Health Solution.

We look forward to seeing you at the 2023 summit

Thank you,
Oracle Database In-Memory Team

Ranjan Priyadarshi, Sr Director, Product Management
SHASANK CHAVAN, Vice President, In-Memory Database Technologies
TirthankarLahiri, Senior Vice President, Data and In-Memory Technologies
June 12, 2023Forms, Tipuri de rapoarte și metode de căutare într-un raportForms, Tipuri de rapoarte și metode de căutare într-un raportPentru a veni în sprijinul nevoilor de business complexe, APEX oferă opțiuni multiple de manipulare și vizualizare a datelor. Pornind de la cea mai simplă și anume, inserarea datelor cu ajutorul unui formular (Forms), afișarea lor in diferite tipuri de rapoarte până la căutarea cu ajutorul fațetelor (Faceted Search) și a filtrelor inteligente (Smart Filters).
În general, Smart Filters și Faceted Search sunt instrumente puternice pentru îmbunătățirea experienței cu aplicațiile Oracle APEX, permițând utilizatorilor să găsească rapid și ușor informațiile de care au nevoie.
În APEX, Smart Filters pot fi adăugate la rapoartele interactive, la grilele interactive și la rapoartele clasice și pot fi personalizate pentru a se potrivi nevoilor aplicației. Filtrele pot fi configurate pentru a folosi o varietate de tipuri de intrări, cum ar fi selecția de date și cursoarele de interval, fiind salvate pentru utilizare ulterioară.
Faceted Search permite utilizatorilor să rafineze rapid și ușor rezultatele căutării prin selectarea mai multor fațete deodată, fiind o opțiune mai bine orientată și mai personalizată. De asemenea, putem descoperi modele sau secțiuni în date care nu pot fi evidențiate în urma unei simple căutări prin cuvinte cheie.
V-am făcut curioși? Vă așteptăm la sesiunea live pentru a explora aceste caracteristici ale platformei APEX.

Co-speaker: Georgiana Oancea – Oracle Cloud Technology Consultant
Georgiana face parte din echipa de ingineri care oferă consultanță tehnică echipelor de vânzări Oracle Cloud (IaaS/PaaS) din regiunea Benelux.
În ultimii șapte ani la Oracle, Georgiana a acumulat o vastă experiență ca inginer în Presales și consultant tehnic, acoperind Oracle Technologies.
Pasiunea Georgianei pentru dezvoltarea aplicațiilor APEX datează din 2015, când a fost identificată nevoia dezvoltării de aplicații interne pentru monitorizarea și raportarea mai eficientă a proiectelor comune ale echipelor de vânzări și consultanților tehnici. După ce a dezvoltat mai multe aplicații APEX pentru echipele interne, Georgiana a lucrat o perioadă ca specialist APEX ajutând clienții în proiectele lor cu Oracle APEX.

Andreea Munteanu, Principal Member of Technical Staff
Fanel Secara, Member Of Technical Stuff(APEX)
Stefan Dobre (APEX), Senior Member of Technical Staff
June 7, 2023Delivering successful Data Lakes with Autonomous Data Warehouse (EMEA edition)Delivering successful Data Lakes with Autonomous Data Warehouse (EMEA edition)Join the Autonomous Database PM team in this Learning Lounge session, where they will talk about how to deliver successful Data Lakes with Autonomous Database. You will be able to ask your questions in the open Q&A.

Outline
Delivering successful Data Lakes with Autonomous Data Warehouse

- Alexey Filanovskiy, Senior Principal Product Manager
will explain how Data Lakes are the new reality for many companies who want to maximize business output from their data capital. Unfortunately, it is estimated that 85% of data lake projects fail. What can you do to be part of a success story? This session will describe the challenges and how to overcome them. We’ll highlight the best practices for building data lakes that simplify data integration, offer open access and deliver sophisticated analytics. You will see how to get value from all your data - even when that data is distributed across multiple clouds.

Open Q&A

- Autonomous Database product managers
will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Alexey Filanovskiy, Senior Principal Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
June 6, 2023Delivering successful Data Lakes with Autonomous Data Warehouse (Americas edition)Delivering successful Data Lakes with Autonomous Data Warehouse (Americas edition)Join the Autonomous Database PM team in this Learning Lounge session, where they will talk about how to deliver successful Data Lakes with Autonomous Database. You will be able to ask your questions in the open Q&A.

Outline
Delivering successful Data Lakes with Autonomous Data Warehouse

- Alexey Filanovskiy, Senior Principal Product Manager
will explain how Data Lakes are the new reality for many companies who want to maximize business output from their data capital. Unfortunately, it is estimated that 85% of data lake projects fail. What can you do to be part of a success story? This session will describe the challenges and how to overcome them. We’ll highlight the best practices for building data lakes that simplify data integration, offer open access and deliver sophisticated analytics. You will see how to get value from all your data - even when that data is distributed across multiple clouds.

Open Q&A

- Autonomous Database product managers
will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Alexey Filanovskiy, Senior Principal Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
June 6, 2023Oracle Machine Learning: What's New and What's Next?Oracle Machine Learning: What's New and What's Next?Over the past year, we’ve introduced a lot of new capabilities for Oracle Machine Learning, and there’s more on the way. Join us for this session on new OML features, including data and model monitoring, a new notebook user interface, third-party R and Python package support on ADB, and date and time support for OML4Py, among others. We’ll show a few code examples and demonstrate the new notebook interface, and then review the OML roadmap, including 23c features and offer a preview of the no-code data monitoring UI.

Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
May 31, 2023Integrate, Load and Analyze all your data with Autonomous Database Data Studio (EMEA edition)Integrate, Load and Analyze all your data with Autonomous Database Data Studio (EMEA edition)Autonomous Database Learning Lounge series presents: Autonomous Database Data Studio

Autonomous Database Product Management will introduce the new Autonomous Database Data Studio, a new built-in application that unites the Data Tools of the Autonomous Database into a single, integrated user interface. It incorporates all the following tools and capabilities:
- Loading data, with the Data Load tool
- Finding and understanding data, with the Catalog
- Transforming data, with Data Transforms
- Analyzing data and preparing Analytic Views, with Data Analysis
- Providing immediate insights from your data, with Data Insights
In addition, spreadsheet add-ins are available for both Microsoft Excel and Google Sheets, to facilitate easy self-service data analysis, and collaboration with other teams.

- Open Q&A
Autonomous Database product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Ashish M. Jain, Essbase Analytics Product Manager
Marcos Arancibia, Senior Principal Product Manager, Autonomous Database
William (Bud) Endress, Director of Product Management, Analytic Views, Autonomous Database
May 30, 2023Migrating Oracle Machine Learning Models from Development to ProductionMigrating Oracle Machine Learning Models from Development to ProductionEven when machine learning models produce useful results, they only add value to an organization when their insights are regularly available to end users. Traditional solutions for migrating models across development, staging, and production databases offer challenges in model storage and management, causing delays and failures in model deployment. Join us for this Office Hours session to learn how Oracle Machine Learning streamlines the process of exporting and importing models across databases and platforms.

Ethan Shmargad, Technical SE
Mark Hornick, Senior Director, Product Management, Data Science and Machine Learning
Sherry LaMonica, Consulting Member of Technical Staff, Oracle Machine Learning Product Management
May 30, 2023Oracle Database Service for Azure Cross-region Disaster Recovery Best PracticesOracle Database Service for Azure Cross-region Disaster Recovery Best PracticesJoin this session to learn about cross-region disaster recovery best practices for Oracle Database Service for Azure with a split stack architecture: app deployed in Azure and the Oracle Database on OCI, with Data Guard providing the most resilient, enterprise DR solution.

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

Sinan Petrus Toma, Principal Product Manager
Suzanne Holliday, Senior Principal Product Manager
Tammy Bednar, Senior Director of Product Management, Exadata Cloud Services
  • 1 - 50