Tag: IOUG

Have you ever wondered what is the purpose of the locking mechanism in Oracle Database and how to avoid unnecessary performance issues due to lock waits - whether on premise or in the cloud. In this session, we will explore the locking mechanism in Oracle Database from A to Z. You will learn the following…

Simply automating your business processes is not enough. You need processes that are dynamic, and change over time based on real-time data from many data sources. Predictive analytics, machine learning, self-documenting hardware, point and click integrations, and automated regression and performance testing is the future for ERP, EPM, analytics, and integration professionals. The future is…

This session will provide a blue print for customers to achieve Maximum Availability using  using Oracle RAC and Data Guard. We will go over the internals of the Architectures involved along with recommendations on each layer so Customers can attain maximum availabiliity.

Database security starts with a baseline and some basics in configuration. Planning security with database creation and a place to start is important when either starting to work with the databases or starting with security. Practical first steps along with a configuration baseline will be take aways from this session.

Reducing work done by the database is key to improving performance in Oracle-intensive applications. The Server Result Cache allows applications to virtually eliminate work done when processing repeated queries. For applications dealing with growing data sets, this ability can be very beneficial. The presentation will begin by focusing on SQL Query Result Cache and PL/SQL…

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 can still make considerable headway into deciphering performance issues and correcting them.

A new database architecture called sharding was introduced in Oracle 12cR2 database for linear scalability and complete fault isolation for OLTP workloads. This Oracle sharding architecture partition horizontally partitions data across discrete Oracle Databases (shards). All shards collectively form a single logical database. Come to this session to learn this new architecture and the related new features in Oracle 18c. We will share our experience with Oracle sharding through our POC project: what type of application best fit to this sharding architecture, how to deploy sharded database and how to implement replications for massive scalability and complete fault isolation on commodity hardware with local storage. Some of lessons learned will be shared and discussed in the session

In this session, Blaine Carter will demonstrate how to REST enable your database using Oracle Rest Data Services (ORDS). He will demonstrate how to use SQL Developer to create and deploy REST services in ORDS. First Blaine will "Auto Rest" enable a table and a PL/SQL package.  Then he will secure the API and create…

In just a few years, mainstream VR headsets like the Oculus are transforming the way businesses interact with computing. Virtual and Augmented Reality are key leading the way.  With new API's announced from Facebook (Oculus) and other headset vendors, the platform is opening up to business applications.  In this session, we show you how to…

Data security is critical for a business. Data is not just providing the business processes, workflows and intelligence but are the assets for the company. Protection of the data in databases and in-transit is important if on-premise or in the cloud. They might even been traveling between the two. The skill is mitigating the risk…