Original Broadcast: April 25, 2017 The purpose of this presentation is to provide real-world augmented database migration procedures that allowed us to successfully achieve the migrations of 54 business critical databases to Exadata x5-2 of different sizes and Operating Systems. The presentation will layout the different possible migration technologies that meets the business demands such…

Original Broadcast: April 25, 2017 Security configuration and features are available at many levels in Oracle Exadata Database Machine. Attend this session and learn security fundamentals directly from Oracle Development.  This session will focus on the storage and OS layers with an overview of the database-layer security options and best practices. We will outline necessary…

When considering high availability the key focus is aimed at maintaining the database and its associated systems. Oracle offers customers a comprehensive set of database high availability capabilities that seamlessly work together to help reduce both planned and unplanned downtime. In addition, Oracle Maximum Availability Architecture (MAA) provides customers with a best practices blueprint that…

Attendees are introduced to new and improved features of Oracle 12c directly impacting application development. Special emphasis is given to features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: IDENTITY columns, improved SEQUENCEs, INVISIBLE columns, improved defaults, JSON enablement, APPROX_COUNT_DISTINCT function, security enhancements, PL/SQL interoperability improvements, outer-join improvements,…

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…