Oracle’s FREE SQL Developer tool has matured quickly into a must-have tool for those working with Oracle SQL and PL/SQL. This session has something for everyone, DBAs and developers whether beginner or expert. Attendees will learn new techniques useful in writing code, testing code, tuning, and modeling. Come see why SQL Developer is the favorite…

This presentation will provide a detailed review of NLS data and how it is stored, and retrieved from an Oracle database. It will also try to show some of the updates from UTF8 to AL32UTF8 / AL16UTF16. We will show some common misconceptions about NLS data, and common error messages encountered with corrupt NLS data;…

Version management of the PL/SQL source code in the Oracle Database has always been challenging. Database programmers lack the tools and utilities that make version control easy for developers who code with file based programming languages such as Java and JavaScript. In fact, this is one of the primary reasons why large software teams avoid…

In this presentation, we will review ASM , high level overview of ASM files, disks, ASM extents, and allocation units etc. Then we will review a few of ASM header structures and how ASM identifies the disks etc. We will dump headers using few tools and show the output of those dumps. We will explore…

With data growth abounding, database administrators are constantly challenged to support business-critical data protection requirements. Oracle Recovery Manager has continuously evolved over the past 15 years, with each release offering richer functionality and integration with Oracle' high-availability products to address those requirements. Attend this Oracle Recovery Manager technical session to learn about next-generation backup and…

No matter what other Oracle or 3rd party database tools Oracle DBA's and developers might embrace, SQL*Plus remains a mainstay. However many don't fully realize it's true efficiency potential by not mastering advanced techniques such as Dynamic SQL Scripting (i.e. scripts to generate and run scripts). Oracle ACE Bert Scalzo will demonstrate such techniques and…

The ecosystem of the Oracle Real Applications Cluster (RAC) gives lots of space for creative solutions, optimized concepts and --- intelligent questions! The Grid Infrastructure framework is highly flexible, ASM opens many performant and safe options of mass storage administration and RAC is the measure for scalable database power in the market. But every single…

Diagnosing and resolving Oracle RAC database problems has required extensive knowledge not only of database internals but networking, storage and O/S interactions. Frequently, these issues needed to be escalated to Oracle Support Services delaying their resolution. New in Oracle Database 12c / Rel. 2 is the Cluster Health Advisor that continuously analyses database ASH/AWR data…

In this session we will share some of our experience on upgrading different versions of Oracle databases to the  latest Oracle 12c. Attend this session you will learn the upgrade tools and various upgrade paths that help you plan your upcoming database upgrades. This will include upgrade methods for multitenant databases.  Another focus area of this…

Have you every wondered what it takes to BLOG about technology? This Quick Tip will cover how to start BLOGing, from what not to say, though the process of editing and publishing your BLOG using a few free tools. Presenter: Erik Benner, Enterprise Architect, Mythics