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.

DateAscendingSessionFocusDescription
February 6, 2018PL/SQL 101 Office HoursBlock StructureAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. PL/SQL 101 Office Hours focuses on PL/SQL topics for beginners. In February, we took a look at the PL/SQL block. It is the fundamental, ahem, building block of PL/SQL program units. Without a solid grasp of blocks you can't write high quality PL/SQL APIs to your underlying data.

We also answered questions on pipelined table functions, when commits and rollbacks happen in PL/SQL program units, differences between local and global data, and more

Check out this LiveSQL script for block examples: https://livesql.oracle.com/apex/livesql/file/content_F6ZN8QFHPZY7IHOQ21QGARY50.html Feel free to check it out yourself.

Sign up for Office Hours sessions at https://asktom.oracle.com

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
February 6, 2018JavaScript and Oracle Database Office HoursConnection ManagementThis Office Hours explores the intersection of JavaScript and Oracle Database with Developer Advocates and Product Managers within Oracle. Each session will begin with a brief lesson or tutorial before turning to open Q&A. Don't forget to bring your questions! This month's focus will be on connection management with node-oracledb. Dan McGhan will briefly cover the basics of getting connected to Oracle Database, connection pooling, and threads in Node.js.

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Dan McGhan, Developer Advocate for JavaScript
February 7, 2018.NET and Visual Studio - Oracle Office HoursODP.NET CoreAskTOM 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, ODP.NET Core, and ODAC 12.2c Release 1 Update 1.

Alex Keh, Senior Principal Product Manager
Christian Shay, Product Manager - .NET at Oracle
February 8, 2018SQL Office HoursAnalytic FunctionsAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Learn how to make the most of SQL with Chris Saxon, of the AskTOM answer team.This session will focus on problems you can solve using SQL analytic functions. It will also show you can use 12c's pattern matching (match_recognize) to solve these problems in another way.

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
February 13, 2018Multitenant Office HoursApplication ContainerAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join Patrick Wheeler to get answers to your questions on the Oracle Database Multitenant architecture.In this session, we'll focus on the Application Container functionality, introduced with 12.2. If you want to deploy your application as SaaS, then this is the session for you! We will also take questions on any other aspect of Multitenant.

Can Tuzla, Senior Product Manager
Patrick Wheeler, Senior Director, Product Management, Oracle Multitenant
Siyu Liu, Product Manager
February 14, 2018Express and Schema Database Cloud ServiceDatabase Cloud Services - Express and SchemaAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Come and ask Todd anything on Express and Schema Cloud Services... This month he will start out with an overview of Exadata Express and discuss innovative customer use cases.

Todd Bottger, PM Director, Oracle Database Cloud Services - Express and Schema
February 14, 2018In-Memory Office HoursConfiguring the IM Column StoreLearn how easy it is to enable Database In-Memory and populate objects in the IM column store.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
February 15, 2018Database Administration Office HoursPartitioning/VLDBThis session is an introduction to Partitioning. Learn how to get started with partitioning with Connor McDonald, of the AskTOM answer team. We will focus on the various partitioning types, how to get the most of them, and where it might trip you up.

Connor McDonald, Developer Advocate
February 16, 2018Database Backup and Recovery Office HoursRMANAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. In this session of Backup and Recovery Office Hours, we will focus on RMAN and Flashback, but we will be happy to take questions on other aspects of B&R!

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Director of Product Management
February 20, 2018Oracle Spatial and Graph Office HoursIntroduction to Property GraphsThis month, Xavier Lopez (PM Senior Director) and Zhe Wu (Graph Architect) will share a brief intro to what property graphs can do for you, and take your questions - on property graphs or any other aspect of Oracle Database Spatial and Graph features. With property graphs, you can analyze relationships in Big Data like social networks, financial transactions, or IoT sensor networks; identify influencers; discover patterns of fraudulent behavior; recommend products, and much more -- right inside Oracle Database.

Zhe Wu, Architect
Jean Ihm, Product Manager
Xavier Lopez, Senior Director, Product Managmenet
February 20, 2018SmartDB Office HoursThe SmartDB ManifestoShould the database be just a persistence layer, or a full-fledged processing engine? Explore with Bryn Llewellyn and Toon Koppelaars the #SmartDB paradigm for building secure, high performance applications on Oracle Database through PL/SQL APIs. In this first session we will present the #SmartDB Manifesto.

ToonKoppelaars, Consulting Member of Technical Staff
February 21, 2018Upgrades and Migrations Office HoursUpgrades and MigrationsAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Ask Roy and Mike questions about your database upgrade and migration scenarios.

Mike Dietrich, Master Product Manager Database Upgrade and Migrations and Cloud
Roy F Swonger, Vice President, Database Upgrade and Utilities
February 23, 2018Database Cloud Service Office HoursDatabase Cloud ServiceAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join us to get answers to all your questions about Oracle Database Cloud Service.

Aalok Muley, Senior Director, Database Product Management
Adrian Galindo, Principal Technologist
Kris Bhanushali, Sr. Principal Product Manager
February 26, 2018Oracle Sharding Office HoursOracle ShardingAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join Srinagesh Battula and other members of the Oracle Sharding team to get your questions about sharding in Oracle Database answered.

Mark Dilman, Senior Director, Software Development
Nick Wagner, Director, Product Management
NageshBattula, Sr. Principal Product Manager
February 28, 2018Ask Me Anything Oracle Database Office HoursOracle DatabaseAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Gerald Venzl will be available to answer your questions on database architecture, using Docker with Oracle Database, Oracle Express Edition, and many more.

Gerald Venzl, Senior Principal Product Manager
Maria Colgan, Master Product Manager
March 6, 2018PL/SQL 101 Office HoursError ManagementIn our March 2018 session, we explored error management, from raising to handling exceptions. We took a look at SAVE EXCEPTION with FORALL, LOG ERRORS, when it makes sense to "swallow up" an exception - though preferably not with WHEN OTHERS THEN NULL. Check out the resources for this session for links to articles and LiveSQL scripts that will allow you to explore all these topics on your own time!

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
March 6, 2018JavaScript and Oracle Database Office HoursAsync Patterns and LibrariesThis Office Hours explores the intersection of JavaScript and Oracle Database with Developer Advocates and Product Managers within Oracle. Each session will begin with a brief lesson or tutorial before turning to open Q&A - this month, we focus on Aynch Patterns and Libraries. Don't forget to bring your questions!

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Dan McGhan, Developer Advocate for JavaScript
March 8, 2018SQL Office HoursPivoting OperationsAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Learn how to make the most of SQL with Chris Saxon, of the AskTOM answer team.

This session will kick off by looking at how to convert rows to columns with PIVOT.

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
March 8, 2018Database Security Office HoursDatabase Security, including Audit Vault, Transparent Data Encryption, and Data MaskingAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. The database is at the heart of every application; it is critical to every enterprise that their data be secure. Oracle Database offers a multitude of enterprise-strength security tools and we are eager to help you leverage them fully in your organization.

Russ Lowenthal, Director of Database Security Product Management
March 13, 2018JSON in the Database Office HoursJSON FunctionsAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Explore JSON in Oracle Database with product managers and developers.

Beda Hammerschmidt, Consulting Member of Technical Staff
March 13, 2018Python and Oracle Database Office HoursConnection Management in cx_OracleJoin this free AskTOM Q&A session to get your Python cx_Oracle questions answered each month by Oracle product managers, developers and evangelists.

Each session has a theme, but feel free to ask us about anything having to do with cx_Oracle.

Anthony Tuininga, Consulting Member of Technical Staff
Blaine Carter, Developer Advocate for Open Source
Christopher Jones, Senior Principal Product Manager
March 14, 2018Express and Schema Database Cloud ServiceDatabase Cloud Services - Express and SchemaAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Come and ask Todd anything on Schema and Express Cloud Services!

Todd Bottger, PM Director, Oracle Database Cloud Services - Express and Schema
March 14, 2018Java and Oracle Database Office HoursBest practices for speeding up and scaling out your Java applicationsThe is a two parts video, packed with best practices and new DB18c features.

Part I - View and discuss how to make your Java applications go faster with the Oracle database.

a) Optimizing Database Connectivity
- Client-side Connection Pool: UCP
- Server-side Connection Pool: DRCP
- De-prioritization of Failed Nodes (new)
- Lightweight Connection Health check (new)

b) Optimizing Statements Processing
- Prepared Statements
- Statements Caching
- ResultSets Caching with Change Notification
- Proxy ResultSets Caching : CMAN Traffic Director Mode (new)
- Array Operations: fetch, DML

c) Optimizing Network Traffic
- Network Data Compression
- Tuning Session Data Unit (SDU)
- Use of Zero Copy features: SecureFiles LOBs
- Sessions Multiplexing: CMAN

d) In-Place Processing
- Java and PL/SQL stored procedures
- Looking into Database Operations as Micro-Services (integration with
Kubernetes).

Part II - Learn and discuss how to scale out Java workload horizontally scale applications

i) Java APIS for Sharded DBs
ii) Scale Java workload with UCP Shared Pool for Sharded databases
iii) Scale Java applications with UCP Shared pool for Multitenant databases
iv) Scale Java applications with the upcoming Asynchronous Database Access API
v) CMAN in Traffic Director Mode (new)

KuassiM, Director of Product Management
Nirmala Sundarappa, Principal Product Manager
March 15, 2018Database Administration Office HoursDatabase AdministrationAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Connor McDonald, Developer Advocate
March 16, 2018Database Backup and Recovery Office HoursZero Data Loss Recovery ApplianceAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. In this session, we will talk about and take questions first on our fantastic Zero Data Loss Recovery Appliance (ZDLRA), but you are then welcome to any and all questions on Oracle Database backup and recovery technologies.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Director of Product Management
March 20, 2018SmartDB Office HoursSmartDBShould the database be just a persistence layer, or a full-fledged processing engine that runs business logic too? Use these sessions to explore with Bryn Llewellyn and Toon Koppelaars the #SmartDB paradigm for building secure, high performance applications on Oracle Database through PL/SQL APIs.

ToonKoppelaars, Consulting Member of Technical Staff
March 21, 2018Upgrades and Migrations Office HoursUpgrades and MigrationsAttended by 35-40 people, this session included lots of discussion about data pump migrations, how to recover from or retry a failed upgrade, and topics like data guard rolling upgrade in a hybrid cloud environment.

Mike Dietrich, Master Product Manager Database Upgrade and Migrations and Cloud
Roy F Swonger, Vice President, Database Upgrade and Utilities
Bill Beauregard, Senior Principal Product Manager
March 23, 2018Database Cloud Service Office HoursDatabase Cloud ServiceAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join us to get answers to all your questions about Oracle Database Cloud Service.

Aalok Muley, Senior Director, Database Product Management
Adrian Galindo, Principal Technologist
Kris Bhanushali, Sr. Principal Product Manager
March 26, 2018Oracle Sharding Office HoursOracle ShardingAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join Srinagesh Battula and other members of the Oracle Sharding team to get your questions about sharding in Oracle Database answered.

Mark Dilman, Senior Director, Software Development
Nick Wagner, Director, Product Management
NageshBattula, Sr. Principal Product Manager
March 28, 2018Ask Me Anything Oracle Database Office HoursOracle DatabaseAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Gerald Venzl will be available to answer your questions on database architecture, using Docker with Oracle Database, and more.

Chris Saxon, Oracle Developer Advocate for SQL
Gerald Venzl, Senior Principal Product Manager
March 28, 2018In-Memory Office HoursWhy are column store scans faster than row store scansThis In-Memory Office Hours session explored why Database In-Memory scans are so much fast than traditional row-store scans. We answered the basic question "Why not just cache the entire table in the buffer cache?" by describing the technology used by Database In-Memory and then showing a demonstration of running the same query with Database In-Memory enabled and the table fully cached in the buffer cache. Watch the session and see for yourself why Database In-Memory is so much faster.

Andy Rivenes, Product Manager
Gregg Christman, DB Performance Senior Product Manager
April 3, 2018PL/SQL 101 Office HoursFetching a Single RowIn March, we explored the nuances of fetching a single row. You have a number of implementation choices and it is definitely not a one-size-fits-all. Steven reviewed the most common options (implicit cursor (SELECT-INTO), explicit cursor, cursor FOR loop) and touched on dynamic SQL. He then answered questions about options for multi-row fetching, table operator and table functions and more. Here's a quick guide to the highlights:

First 12 minutes: some philosophical musings and an overview of single row fetching
12:30 - Explicit Cursors
14:45 - Declaring records based on explicit cursors
16:15 - The benefits and drawbacks of the cursor FOR loop (for single row fetches)
19:42 - Multi-row fetching options
24:00 - Table operator and table functions
31:15 - Use LiveSQL as source of examples

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
April 3, 2018JavaScript and Oracle Database Office HoursNew Release FeaturesIn this Office Hours, we'll take a look at some of the new features of node-oracledb v2.2.0 before taking questions.

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Dan McGhan, Developer Advocate for JavaScript
April 4, 2018Global Data Services Office HoursGlobal Data ServicesOracle GoldenGate and Oracle Active Data Guard allow for distribution of application workloads across replicated databases, but when applications are spread across geodistributed databases, it is a challenge to efficiently use all the databases for best performance and availability. In this AskTom Office hours session, hear from Oracle Product Development experts about how the Global Data Services feature of Oracle Database provides region-based workload routing, load balancing, and service failover across replicas while enabling a seamless distributed private data cloud for your IT. Learn how you can load-balance read/write workloads in active/active Oracle GoldenGate and load-balance read-only workloads across Oracle Active Data Guard reader farms, among numerous other use cases. Note: At 2:03, GDS is introduced. At 4:25, GDS architecture is discussed. AT 8:15, Deployment steps are covered. For use cases, pls go to 15:58.

Mark Dilman, Senior Director, Software Development
Nick Wagner, Director, Product Management
NageshBattula, Sr. Principal Product Manager
April 10, 2018JSON in the Database Office HoursJSON FunctionsIn the April 2018 session, Mark Drake (JSON and XML Product Manager) reprises his "Everything Developers Need to Know About Integrating JSON into Oracle Database.

7:25 SODA - Simple Oracle Document Access
9:30 SODA for REST
13:28 SODA for Java
19:05 Demo: the Movie Ticketing application
29:50 The JSON document store
32:00 Querying JSON with SQL
45:04 Piecewise updates of JSON documents
45:55 The amazing Dataguide feature

Beda Hammerschmidt, Consulting Member of Technical Staff
April 11, 2018Express and Schema Database Cloud ServiceDatabase Cloud Services - Express and SchemaAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Come and ask Todd anything on Schema and Express Cloud Services!

Todd Bottger, PM Director, Oracle Database Cloud Services - Express and Schema
April 12, 2018Database Security Office HoursDatabase Security Assessment ToolThe Database Security Assessment Tool (DBSAT) is one of the most-downloaded database utilities, and at the same time one of the easiest to use! Join special guest Pedro Lopes, Product Manager for DBSAT, as we cover what is new in DBSAT version 2.0.1. We'll take your questions on how the tool works, how DBSAT can be used to find unnecessary risk in your database environment, and how you can use DBSAT as part of your database security program.

00:00 Why is DBSAT Needed?
12:44 Introducing DBSAT
28:23 Demonstration of DBSAT
36:19 Accelerate Compliance with EU GDPR
39:11 DBSAT Summary
42:23 Q&A

Pedro Lopes, Sr. Principal EMEA Field PM
Russ Lowenthal, Director of Database Security Product Management
April 12, 2018SQL Office HoursExternal TablesChris discusses methods for creating auto-increment primary keys and loading CSV data into Oracle Database. The CSV options SQL*Loader, external tables and using SQL Developer.

Start - slides discussing the above
17:00 - handling implicit string-to-date conversions via NLS parameters
20:12 - SQL Developer import/export options
22:57 - Dynamic CSV to columns converter using Polymorphic Table Functions

Chris Saxon, Oracle Developer Advocate for SQL
Keith Laker, Senior Principal Product Manager
April 17, 2018SmartDB Office HoursCode ClassificationToon Koppelaars presents his thoughts on how best to classify the types of code that should reside inside the database. Along the way, he offers recommendations for a sound database design, and much more.

5:44 Recommendations for a sound database design
12:00 Data Integrity Constraints
16:11 Data Logic Code
17:30 Classifications: Query-only Business Logic, Transaction Business Logic, Data Logic
21:21 Avoiding a big pile of PL/SQL code: separate schemas and more
24:32 Vertically materialize APIs per page
25:43 Q&A

ToonKoppelaars, Consulting Member of Technical Staff
April 19, 2018Database Administration Office HoursDatabase AdministrationAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts.

Connor McDonald, Developer Advocate
April 19, 2018Upgrades and Migrations Office HoursUpgrades and MigrationsThis month's session started with a half hour about fallback strategies: what to do if you run into a problem during the upgrade, compared with options for fallback after an upgrade.

Our Q&A segment (33:10) then covered topics such as comparing DBUA vs command-line upgrade, using RMAN to restore an earlier version database into a later version environment, and quite a discussion about patching.

Mike Dietrich, Master Product Manager Database Upgrade and Migrations and Cloud
Roy F Swonger, Vice President, Database Upgrade and Utilities
Bill Beauregard, Senior Principal Product Manager
April 20, 2018In-Memory Office HoursJoin PerformanceAndy Rivenes (@TheInMemoryGuy) and Maria Colgan (@SQLMaria) focused on a deep dive into hash joins and how they are used with Database In-Memory to make joins lightning fast. The session began by reviewing how traditional hash joins work and then addressed Bloom filters and how Database In-Memory uses them to effectively turn hash joins into scan and filter operations. The use of Join Groups was then discussed as a way to further enhance join performance in 12.2 and beyond.

Andy Rivenes, Product Manager
Maria Colgan, Master Product Manager
April 20, 2018Database Backup and Recovery Office HoursDatabase Backup Cloud ServiceDid you know that the Oracle Database Backup Cloud Service provides end-to-end security and makes it easy to add storage capacity as needed? In this Office Hours session, Marco Calmasini presents in detail on the Database Backup Cloud Service. If you are using this service, or considering signing up for it, watch this session and subscribe to be notified of future sessions.

Kelly Smith, Senior Principal Product Manager
Marco Calmasini, Senior Principal Product Manager
Tim Chien, Director of Product Management
April 20, 2018Database Cloud Service Office HoursDatabase Cloud ServiceAskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. Join us to get answers to all your questions about Oracle Database Cloud Service.

Aalok Muley, Senior Director, Database Product Management
Adrian Galindo, Principal Technologist
Kris Bhanushali, Sr. Principal Product Manager
April 23, 2018Oracle Sharding Office HoursOracle ShardingOracle Database with Sharding is a globally distributed multi-model (relational & document) cloud-native (and on-premises) DBMS. It is built on shared-nothing architecture where data is horizontally partitioned across databases that share no hardware or software. It provides linear scalability, fault isolation and geographic data distribution for shard-amenable applications. Sharding does all this while rendering strong consistency, full power of SQL, and the Oracle Database ecosystem. In this session, Nagesh Battula, Product Manager, shows how to deploy a sharded DB and elastically scale your transactions, database capacity and concurrent users.

1.52 – Introduction to Oracle Sharding
4:08 – Benefits of Sharding
6:28 – Architecture and Key Features
21:02 – Data Modeling and Application Considerations for a Sharded Database (SDB)
29.51 - Sharded Schema Creation
36:14 – Direct Routing against an SDB
41:23 – Proxy Routing for reporting workload
48:35 – Results of Oracle Sharding Scalability Characterization study

Mark Dilman, Senior Director, Software Development
Nick Wagner, Director, Product Management
NageshBattula, Sr. Principal Product Manager
April 24, 2018Oracle Spatial and Graph Office HoursHow To Model and Construct Graphs with Oracle DatabaseHow To Model and Construct Graphs with Oracle Database

To use property graphs, first, you’ll need a graph model. For a new user, modeling and generating a suitable graph for an application domain can be a challenge. In April’s session, Albert described key steps required to model a graph, using an HR example. Then Zhe showed how to construct a meaningful graph using ODI, Java/SQL APIs, or various utilities supporting various data sources (Database or other file formats).

NOTE: If you missed February’s session, please watch the recording prior to this session:
https://asktom.oracle.com/pls/apex/f?p=100:551:::NO:551:P551_CLASS_ID:3401&cs=11ED98BAEBB81DD95ADED292AE0744349

Highlights [timestamps based on Steven's 5/2 edited version]:
00:00 - Speaker intros
01:40 - Graph Architecture Overview
04:52 - Designing Graphs: what is a graph model, comparison with relational, considerations on moving from a relational to a graph model, some graph modeling examples (HR and customer orders)
24:56 - Constructing Graphs – overview of available options
26:34 - Constructing Graphs using Oracle Data Integrator (demo starts at 29:55)
39:50 - Using DAL APIs to programmatically create a graph
41:00 - Read from a data source and use DAL APIs to programmatically create a graph
42:20 - Generate a Property Graph (.opv/.ope) directly from relational tables (views)
44:10 - Generate a Property Graph (.opv/.ope) directly from CSV Files
44:50 - Construct a property graph with SQL
47:05 - Resources and wrapup

Zhe Wu, Architect
Albert Godfrind, Spatial and Graph Solutions Architect
Jean Ihm, Product Manager
May 1, 2018PL/SQL 101 Office HoursAssociative Arrays (Index-By Tables)Collections - associative arrays, nested tables, and varrays - are in-memory structures you can use to work with lists of data. They also play a critical role in the bulk processing feature of PL/SQL (BULK COLLECT and FORALL). Steven kicks offs the session with a review of enhancements to associative arrays in 12c and 18c. He and Chris then answer questions on collections and other topics

06:25 Qualified Expressions( (18c)
09:30 String-Indexed Arrays
15:55 MULTISET operator vs. SQL
19:08 Instead Of Triggers
23:12 LOG ERRORS and PL/SQL Errors
32:46 FORALL, Memory, LIMIT
41:48 Partitioning Tables

Chris Saxon, Oracle Developer Advocate for SQL
Steven Feuerstein, Developer Advocate for PL/SQL
May 1, 2018Optimizer and Statistics Office HoursStatistics and Optimizer Settings for Proof of Concept TestingIf you are running an Oracle Database proof of concept or benchmark focusing on performance, what optimizer settings should you use? What statistics do you need to gather and how should you gather them? In this session Nigel Bayliss shows how you can get consistent results and avoid burning time chasing problems. Covers Oracle Database 12c Release 1 onwards.

3:55 The Adaptive Optimizer (12.1)
8:44 The Mechanics of Adaption
12:03 Adaptive Optimizer Settings
16:18 Recommended Defaults
18:53 12.1 Proof of Concept Recommendations
21:26 12.2+ Proof of Concept Recommendations
34:35 Regathering Statistics
42:24 Dynamic Sampling and Parallel
44:55 More General Recommendations

Chris Saxon, Oracle Developer Advocate for SQL
Nigel Bayliss, Optimizer Product Manager
May 1, 2018JavaScript and Oracle Database Office HoursREST APIsExplore the intersection of JavaScript and Oracle Database with Developer Advocates and Product Managers within Oracle. Each session will begin with a brief lesson or tutorial before turning to open Q&A. Feel free to bring your questions!

This session will focus on creating REST APIs.

Anthony Tuininga, Consulting Member of Technical Staff
Christopher Jones, Senior Principal Product Manager
Dan McGhan, Developer Advocate for JavaScript
May 1, 2018Python and Oracle Database Office HoursBatch Statement Execution with executeMany()Python developers building applications on Oracle Database will be delighted with the performance features added in the latest release of cx_Oracle! The theme this month at Office Hours was Batch Statement Execution with executeMany() showing how to supercharge INSERT, UPDATE and DELETE statements.

14:00 - demonstrations by Anthony Tuning
17:00 - key new features in cx_Oracle 6.3

Anthony Tuininga, Consulting Member of Technical Staff
Blaine Carter, Developer Advocate for Open Source
Christopher Jones, Senior Principal Product Manager
  • 1 - 50