Tag: Database & Technology

Oracle Databases are a target of cyber-attacks by hackers looking to obtain sensitive data such as credit card numbers and personally identifiable information used in identify theft.  Even though databases are not externally accessible, they are still a target as most cyber-attacks penetrate the network perimeter and look for high value targets within your internal…

Oracle Database 19c is now available, and it builds on Oracle Databases 19c and 12cR2. This session explores how developers and DBAs can work together to start using 10 of the top ( and mostly free)  features that make it easier to get the job done.

Learn about the essentials for becoming comfortable with, even fluent in, the use Oracle JET charts in APEX. Whether you use APEX for standalone applications, to extend on-prem or Cloud applications, the same charting features apply. Start using them! Data visualization is “in” – so attend and become comfortable with adopting JET charts now.

This year saw the introduction of Oracle Autonomous Database, a series of cloud services that enable anyone to rapidly build a secure, highly available and elastic database optimized for any workload. With the introduction of Automatic Indexing, Oracle Autonomous Database and Oracle Database on Exadata will now automatically adapt to changing workloads. But what does Automatic Indexing look like on the road?  In this session, we'll explain the motivation behind this new capability and provide a first look at it in action. We will also illustrate how it can simplify your approach to application tuning and accelerate new application development.

Transform your ability to quickly respond to the challenge of ensuring high performing DB’s. The key to this transformation is to expertly use the advisor framework which underlies tools such as ADDM, SQL Tuning Advisor, Segment Tuning.  These tools provide actionable advice to the DBA seeking to solve performance problems, but getting at this information can be painstaking.  This presentation shows you many undocumented ways to proficiently use the underlying data to quickly get to tuning solutions.

How often do you get the chance to start over and do things the way you want?  That's what we did with Unified Audit in Oracle Database 12c.  Join us to review why we created this greaet new feature, learn about some of the many things you can do with Unified Audit, and hear our…

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. We will also examine what aspects of a SQL query benefit from Database In-Memory and provide some guidelines for use with commercial applications and applications where you cannot change the code. Lastly we will take a look at some actual SQL Monitor reports to demonstrate where Database In-Memory provides benefit and show how a time-based approach can be used to help quantify the benefit of Database In-Memory.

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…

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…