Tag: IOUG

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…

With Oracle Database 19c a new tool will become available: The AutoUpgrade Tool will upgrade hundreds and thousands of databases or PDBs fully unattended automatically. You will only need one config file. And everything else, from preupgrade to fixups to upgrade and finally postupgrade and time zone adjustments, everything gets handled by the tool. Regardless…

Recent Oracle Database releases include significant new features that streamline user administration, reduce database attack surfaces, and protect personally identifiable information, and other sensitive data. In this session learn about the new way to authenticate and authorize database users in Active Directory. Explore review recent security innovations including privilege analysis, database vault simulation mode, data…

Get hands-on and learn the features of the Python cx_Oracle interface for Oracle Database. In this session learn efficient techniques for connection management, statement handling, and more. If you want to use Python and Oracle Database, this session is for you. Basic programming skills in any language are required.

It's now easier than ever to host many test environments comprised of a multitude of platforms and database versions using virtualization. On anything: even your laptop or a consumer grade NAS. VMs and Containers are both good options. DBAs and Developers can still manually build VMs using VirtualBox but Vagrant makes the process much easier…

This presentation will look at which 19c new features that should be investigated for use.  This presentation will also look at which 18c new features that should be investigated for use (such as Snapshot Carousel, PDB Switchover, In-Memory External Tables, Merge Partition Online, Advances in the Approximate Query, Polymorphic Tables, Standby Nologging, and Password-less Schema Creation…

Relational Databases are extremely sophisticated, but their extensive functionality makes it challenging for them to achieve hyperscale. Some have turned to alternative technologies such as key value stores, which exclude most of the functionality of Relational Databases in order to make scaling easier. However, increasingly more people are seeking a solution that achieves extreme scalability…

Understanding database security is critical for every DBA and beginning DBAs may not have all the necessary knowledge or resources to properly secure their databases.  This session will introduce DBAs to the basics of database security and how to secure their databases by highlighting key database risks and providing resources useful in database hardening. Starting…

Many DBAs and Architects think they understand Oracle database replication. But it is often only physical replication, as performed by Data Guard, rather than logical replication as done by GoldenGate, Streams and others. There are 3 fundamental principles that govern how these logical replication tools operate, centred on conversion, identification, and conflict handling of the…

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.…