Oracle Database In-Memory promises an incredible performance boost for analytic queries. But how do you determine if you have an analytic workload that will benefit from Database In-Memory? This presentation will review what Database In-Memory is and how it works, and then we will talk about what types of workload will benefit from Database In-Memory.…

Oracle Database In-Memory promises an incredible performance boost for analytic queries. But how do you determine if you have an analytic workload that will benefit from Database In-Memory? This presentation will review what Database In-Memory is and how it works, and then we will talk about what types of workload will benefit from Database In-Memory.…

Setting up an Oracle Analytics Cloud (OAC) instance can be a little tricky. Learn the ins and outs of this fairly new Oracle offering in this session. Topics covered will be OAC parts and pieces, how to navigate in the Cloud environment, creating the database and OAC instance, building out an application and analysis and…

Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, the Oracle IoT Cloud,  a Cardboard Pizza Box, a Raspberry PI, and APEX.  Track weather and assets in the field without spending a ton of money?  We connect a raspberry PI to the FAA’s network and utilize a radio based interface to track business aircraft…

Visualizing Air Traffic Data with the FAA’s Satellite-based Surveillance System, the Oracle IoT Cloud,  a Cardboard Pizza Box, a Raspberry PI, and APEX.  Track weather and assets in the field without spending a ton of money?  We connect a raspberry PI to the FAA’s network and utilize a radio based interface to track business aircraft…

Understanding how applications and clients communicate with databases is key to succeessful deployments. This presentation teaches the basics of the Oracle Server networking by discussing the various components of OracleNet. We will discuss the various ways to connect to the database through the network and some tips to help simplify many of the challenges Oracle networking can pose.

Oracle 12c and 18c Multitenant Container databases were designed to consolidate databases. The provisioning and management advantages of using pluggable databases greatly simplify database operations. However, the database security model becomes more complex to accommodate pluggable databases. This session will provide a deep dive into authentication and authorization when using the multitenant option, including users,…

Oracle 12c and 18c Multitenant Container databases were designed to consolidate databases. The provisioning and management advantages of using pluggable databases greatly simplify database operations. However, the database security model becomes more complex to accommodate pluggable databases. This session will provide a deep dive into authentication and authorization when using the multitenant option, including users,…

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…