Kscope13 Presentations

Check out the presentations listed below.



"Where Did My CPU Go?" -- Monitoring & Capacity Planning Adventures on a Consolidated Environment
Karl Arao , Enkitec
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: The Database - Subtopic: Tuning

This session will focus on CPU monitoring and capacity planning. The session will highlight scenarios that are typically encountered on a massively consolidated environment, where, let's say you have over thirty databases and you want to know how much CPU cores they are using at a particular time interval. Before touching on the cool tricks, a deep dive into important CPU metrics is a MUST. In Oracle world the CPU is not just the "Green Thing" in the Enterprise Manager. It's actually much more than that. The session will discuss the usual CPU monitoring tools in OEM, visualization enhancements that can be made by AWR analytics, and how these can be applied to critical capacity planning scenarios.

Back to Top
A Consolidation Success Story
Karl Arao , Enkitec
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: The Database - Subtopic: DBA

In today's competitive business climate, companies are under constant pressure to reduce costs without sacrificing quality. Many companies see database and server consolidation as the key to meeting this goal. Since its introduction, Exadata has become the obvious choice for database and server consolidation projects. It is the next step in the evolutionary process. But managing highly-consolidated environments is difficult, especially for mixed-workload environments. If not done properly the quality of service suffers. This session will tell the tale of a large real estate investment company that successfully consolidated their global operations onto a Maximum Availability Architecture Exadata platform. Applications sharing this environment include PeopleSoft Financials, PeopleSoft HR, Portal, and OBIEE. Accurate provisioning and management of system resources was absolutely essential to their success. This session will share lessons learned and the tools you'll need to ensure that your consolidation story has a happy ending.

Back to Top
Introduction to Regular Expressions in Oracle
Galo Balda , Texas Health and Human Services Commission (HHSC)
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: The Database - Subtopic: SQL

Oracle support for regular expressions has been around since version 10g Release 1. However it's common to find developers that aren't aware of this powerful functionality. Oracle SQL support for regular expressions lets application developers implement complex pattern-matching logic in the database, which is useful for these reasons: By centralizing pattern-matching logic in the database, you avoid intensive string processing of SQL results sets by middle-tier applications. By using server-side regular expressions to enforce constraints, you avoid duplicating validation logic on multiple clients. In this session we'll talk about common used operators, pattern matching conditions and functions provided by Oracle.

Back to Top
Can Collections Speed Up Your PL/SQL?
Patrick Barel , AMIS Services
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: The Database - Subtopic: PL/SQL

Collections (array-like structures in PL/SQL) are used in two of the most important performance features of PL/SQL: BULK COLLECT for data retrieval and FORALL for data modification. Collections are also used in Table Functions, leveraging all the PL/SQL power in the SQL environment. In this session you will learn the basics about the collections and how to use them. The session will touch on the similarities and the differences between the different types.

Back to Top
Optimizer Hints: Top Tips for Understanding and Using Them
Maria Colgan , Oracle Corporation
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: The Database - Subtopic: Tuning

The most powerful way to alter an execution plan is via hints; but knowing when and how to use hints correctly is somewhat of a dark art. This session explains in detail how Optimizer hints are interpreted, when they should be used, and why they sometimes appear to be ignored. By attending this session you will arm yourself with the knowledge of how to apply the right hints, at the right time.

Back to Top
Hands-on Training: How to Prevent Suboptimal Execution Plans
Maria Colgan , Oracle Corporation
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: The Database - Subtopic: Hands-on Training

This session shows the process of analyzing and resolving the most common SQL execution performance problems including, poor cardinality estimations, bind peeking issues, selecting the wrong access method, and more. You will learn how to identify and quickly resolve these issues and develop a toolkit of queries and techniques to determine the root cause of any plan regression.

Back to Top
Oracle Optimizer: An Insider's View of How it Works
Maria Colgan , Oracle Corporation
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: The Database - Subtopic: DBA

With each new release the Optimizer evolves as we strive to find the optimal execution plan for every SQL statement. Understanding how the Optimizer operates and what influences its choices helps you provide the necessary information to make that nirvana a reality. This session explains in detail, how the latest version of the Optimizer works and the best ways you can influence its decisions.

Back to Top
Exadata and the Optimizer
Maria Colgan , Oracle Corporation
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: The Database - Subtopic: Tuning

Knowing when and how to take advantage of each of Exadata's performance enhancing features can be a daunting task even for the Oracle Optimizer, whose goal has always been to find the optimal execution plan for every SQL statement. This session explains in detail how the Oracle Optimizer costing model has been impacted by the introduction of the performance-enhancing feature of the Exadata platform. It will show through the use of real-world examples what you can do to ensure the Optimizer fully understands the capabilities of the platform it is running on without having to mess with initialization parameters or Optimizer hints.

Back to Top
Oracle Databse 12c: A Beta Tester's Perspective
Bobby Curtis , BIAS
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: The Database - Subtopic: DBA

As Oracle Database 12c is adopted by many organizations there will be struggles to understand the new architecture of pluggable Oracle databases and how this architecture will benefit the organization. Oracle has enhanced Oracle Database 12c to help organizations reduce costs while providing a scalable solution for business needs. In this session, you will learn tips and workarounds with implementing Oracle Database 12c along with how your organization should be thinking about Oracle Database 12c. Takeaways: * Overview of Oracle Database 12c Pluggable Database Features * Overview and tips for upgrading to Oracle Database 12c -- single instance * Tips and workarounds for implementing pluggable database with Oracle Database 12c * Tools used to monitor pluggable databases -- EM Express and OEM 12c

Back to Top
Programming PL/SQL with Testing in Mind: A Practical Approach
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: The Database - Subtopic: PL/SQL

Nowadays testing is a crucial and integral part of programming software. But how do you apply testing techniques in the complex world of PL/SQL programming? Testing PL/SQL is challenging because the PL/SQL programs are often larger than Java programs and the outcome of tests are dependent on data in the database. This session shows you their test strategy, which starts at the programming stage. Their strategy includes special test procedures for PL/SQL programs, an API for creating sets with test data, and the use of a debugging framework to resolve issues efficiently. In this way they created high-quality software, which can be easily tested and maintained.

Back to Top
Fuzzy String Matching in Oracle
Dominic Delmolino , Agilex Technologies
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: The Database - Subtopic: SQL

Many database developers are familiar with the basic SOUNDEX function used to provide basic similarity matching for names. This presentation goes beyond SOUNDEX to examine more advanced approaches for string and name matching, including details about the UTL_MATCH built-in package. The session will also explore implementations of the NYSIIS, MetaPhone, and Caverphone phonetic matching algorithms in SQL and PL/SQL. Finally the session will explore how combinations of these techniques can be used for data cleansing in large-scale environments.

Back to Top
Converting MapReduce to SQL Using Parallel Query
Dominic Delmolino , Agilex Technologies
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: The Database - Subtopic: SQL

While it is relatively trivial to both convert MapReduce code into pipelined PL/SQL functions and (in 12c) even run Java-based MapReduce code inside the Oracle database, one can often do better by converting MapReduce algorithms into basic SQL statements which leverage the Parallel Query processes. This session will cover the fundamentals of the MapReduce implementation primitives and how they map to straightforward SQL commands. The attendee will benefit by learing how to seamlessly adapt in combined Oracle / Hadoop environments where workload can be moved between Oracle and Hadoop.

Back to Top
Bye-bye CONNECT BY - Using the New Recursive SQL Syntax
Dominic Delmolino , Agilex Technologies
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: The Database - Subtopic: SQL

Hierarchical queries in Oracle have always been a challenge, even for advanced SQL practitioners, with Oracle-specific SQL language elements which are not part of the SQL standards. Beyond the SQL-92 standard, the ANSI SQL:1999 standard added the definition of a recursive query which has now been adopted by Oracle. This presentation will talk about how to translate common CONNECT BY statements and use the new construct to solve more esoteric problems. The attendee will benefit by using this new standard, portable construct for hierarchical queries in Oracle and other databases.

Back to Top
Next Generation Parallel Execution in Oracle 12c
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: The Database - Subtopic: SQL

Database release 11 added dynamic behavior to parallel execution, allowing the optimizer to decide what DOP a statement shall be executed with, whether to execute it immediately, or to queue it until the required resources become available. Release 12c extends the dynamic parallel execution framework and introduces revolutionary new features to the optimizer. This presentation reviews the 11g parallel execution features, compares static and dynamic parallel execution scenarios, and gives best practices. Integration of dynamic parallel execution with Oracle Resource Manager, improvements of the parallel execution framework in Oracle database release 12c, the new 12c data distribution feature for parallel execution, and the 12c optimizer feature 'adaptive execution plans' are discussed.

Back to Top
Scaling to Infinity: Making Star Transformations Sing
Tim Gorman , Evergreen Database Technologies
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: The Database - Subtopic: Tuning

Dimensional data models (a.k.a. star schemas) are a crucial component of the presentation layer of data warehouses and data marts, because that is the format in which business intelligence analysts expect to find their data. Yet, so many decision-support environments based on Oracle attempt to live with star schemas without using star transformations. The reasons vary from lack of understanding to practical impediments related to ETL processing. This presentation will explain the justification for the star transformation mechanism, including comparisons to other execution plans, how to implement, how to optimize, and how to troubleshoot.

Back to Top
SQL Tuning Methodology for Developers
Kyle Hailey , Delphix
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: The Database - Subtopic: SQL

As a developer how does one know the impact of their SQL code on the system? How can the SQL load be verified and most importantly if the load of the SQL is high and/or SQL performance is slow, how can one tune the SQL? This presentation will show to identify high load SQL and most importantly how to analyze a SQL statement to identify bottlenecks and tune the SQL. For analyzing poor performing SQL statements, we will follow a solid step by step method using Visual SQL Tuning (VST). Visual SQL Tuning (VST) is a method of laying out the tables and joins of a query graphically indicating key features of the query in the graphics. With VST, you'll learn how to quickly visualize any coding errors in the query, discover flaws in the underlying database schema, and most importantly, find the best execution path through the query.

Back to Top
Oracle 12c and 11gR2 New Features for Developers: What You Need to Know
John King , King Training Resources
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: The Database - Subtopic: SQL

New features of the Oracle database geared to developers will be discussed and demonstrated. Attendees will be introduced to the new and improved features of Oracle that directly impact application development. Oracle Database 12c is not in production at the time of this abstract's submission. If Oracle 12c has not become generally available by the start of the conference, this session will discuss Oracle 11c features exclusively.

Back to Top
Oracle Database Tools 101: How Does All This Stuff Get Built Anyway?
John King , King Training Resources
When: Jun 25, 2013, Crossover Sessions, 5:30 pm - 6:30 pm
Topic: The Database - Subtopic: No Subtopic

If you've been an Essbase/Hyperion, Applications, or BI user you may wonder what all the "hubbub" on the other side of Kscope is all about. Or maybe you're curious -- "I know there's a database under the covers and lots of developers; what do they do?" If you want to know about the underpinnings of your favorite Oracle software, this session is for you. We'll talk about how it all fits together: database, SQL, PL/SQL, ADF, Forms, APEX, and more (without too many boring details)! Attending this session will improve your understanding of and ability to communicate with the "bit-twiddlers" in your organization.

Back to Top
What's New in Security in the Latest Generation of Database Technology
Thomas Kyte , Oracle Corporation
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: The Database - Subtopic: No Subtopic

This session will look at various database features in the latest generation of database technology every developer needs to be aware of - and how to implement your application with security in mind.

Back to Top
Tom's Top Twelve Things About the Latest Generation of Database Technology
Thomas Kyte , Oracle Corporation
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: The Database - Subtopic: No Subtopic

The session will be taking a look at the latest generation of database technology and zeroing in on twelve high-impact capabilities, looking at what they are and why they are relevant.

Back to Top
A Holistic Approach to Database Security
Robert Lockard , Oraclewizard
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: The Database - Subtopic: DBA

For years we have been locking down the software to protect information. This presentation puts the focus where it belongs: identifying, protecting, and selecting the correct tools to protect your data.

Back to Top
Maximum Application Availability with the Next Generation of Oracle Database Technology
Kuassi Mensah , Oracle Corporation
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: The Database - Subtopic: No Subtopic

Fast Connection Failover and TAF allow failing over connections and queries but do not guarantee transaction outcome, failover transactions, or mask outages. This session will cover these topics. This session covers upcoming Oracle database availability capabilities including: (i) Transaction Guard for checking and guaranteeing transaction outcome; (ii) Application Continuity for attempting to mask outages by failing over connections and replaying session contexts, queries, DML, and DDL. Other new HA features include recoverable errors, fast dead connection detection and adaptive connection retries. Application developers and DBAs will learn how to use these features for maximum application availability.

Back to Top
SQL Performance Solutions: Refactor Mercilessly, Index Wisely
Karen Morton , Enkitec
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: The Database - Subtopic: SQL

Achieving good SQL performance can often seem like a magic act where you never know if the trick is going to work or not. Sometimes it works (performance is good) and sometimes it doesn't (performance is bad). What can you do to eliminate the guesswork and create SQL that consistently performs as desired? It's not magic but simply a matter of understanding how to best write (or rewrite) your SQL to help the Optimizer produce the best executions possible. It's also a matter of supporting our SQL with an effective set of indexes. Part of the reason producing SQL that "just works" seems so hard is that we, as developers, often hold onto our coding styles long after they have become outdated or unwieldy. Particularly when maintaining SQL that was written by someone else, we often continue to use/reuse code that is no longer maintainable because it still works in some way and we are afraid to modify it. But is that really effective? Obviously, the answer is "no." What we need to do is to remove redundancy, eliminate unused functionality, and rejuvenate obsolete designs and constructs in our SQL through refactoring. Refactoring shouldn't happen just once but instead should happen every time the code is reviewed or modified in order to eliminate inefficiencies and increase quality. The original formulation can be a good guide post, but may now be obsolete or simply proven to be inefficient when measured against the requirements of your production environment. It may also be necessary to evaluate indexing strategy in order to achieve the best performance footprint. Just like your SQL, index effectiveness needs to be evaluated again and again over time. Indexes that worked well for one set of SQL may need to be adjusted to provide the best performance as SQL is modified and added. How do you know which indexes are "best"? How do you determine when to use single-column indexes or multi-column indexes? In this session you will learn: * Common ways to rewrite SQL that make it perform better and more consistently * How to make your SQL easy to identify and test * How and when to add or modify indexes * How to determine the best choice of columns to include in an index and what order to place them * How to determine the trade-offs of creating the "best" index

Back to Top
Understanding Optimizer Statistics for Developers: May the Odds Be Ever in Your Favor
Karen Morton , Enkitec
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: The Database - Subtopic: SQL

It's the Hunger Games and you've got a 1 in 24 chance to come out alive. What can you do to make sure the odds you survive are in your favor? Making sure your SQL performs well and remains stable over time may not be a life or death situation, but you can stack the odds in your favor by understanding how the optimizer utilizes statistics to formulate execution plans. The calculations the optimizer uses to make plan operation choices are rooted in some very simple statistical formulas. These formulas, if understood, can help you make better choices when writing SQL as well as improve how you performance test your code so that you are confident in how well it will perform over the long haul in production. In this session, you will learn: * Statistics fundamentals for computing cardinality/selectivity for single and multi-column predicates. * How statistics can help the optimizer understand data distribution patterns (skew). * Reasons why certain ways of writing SQL limit the optimizer's ability to determine the best plan and how the optimizer uses query transformations to improve the odds. * How to use extended statistics to help the optimizer create more accurate cardinality estimates. * How the optimizer learns and self-corrects plan choices using cardinality feedback as well as a look at Oracle 12c enhancements such as adaptive execution plans and enhanced statistics.

Back to Top
ASH and AWR Performance Data
Kellyn Pot'Vin , Enkitec
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: The Database - Subtopic: Tuning

ASH and AWR performance data can be accessed in numerous ways. With the appropriate licensing, the DBA or developer has the opportunity to run various reports, both HTML and text, along with querying the data directly to gather important information about the database environment. This session will take the attendee through architecture, design, reports, and querying of the ASH and AWR data directly, that will provide invaluable data to troubleshoot issues and report on performance, ensuring a solid understanding of Oracle's Automatic Workload Repository.

Back to Top
The Enterprise Manager Command Line
Kellyn Pot'Vin , Enkitec
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: The Database - Subtopic: No Subtopic

For the database specialist working in an EM12c environment, having knowledge of EM CLI commands are essential, but how much do you know about this valuable feature? This session will go over the architecture, design, and installation of the Enterprise Manager Command Line Interface, along with commands, scripting, and how to automate deployment in large database environments.

Back to Top
WIT Session: "The Imposter Syndrome- When Successful Women Feel Like Frauds"
Kellyn Pot'Vin , Enkitec
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: The Database - Subtopic: No Subtopic

What is Imposter, (aka Fraud) Syndrome and why do so many people feel this way? Georgia University psychologists, Pauline Rose Clance and Sue Imes penned the term "Imposter Syndrome" back in 1978 when referring to those that were susceptible to feeling that they were frauds or imposters, no matter how skilled or successful they were. Both experts recognized that only about 20% of the cases involved men and started to investigate how much was due to nature vs. nurture and culture.

Back to Top
Storing Billions of Images in a Hybrid Relational and NoSQL Database Using Active Data Guard and Ora
Aris Prassinos , Morpho, SAFRAN Group
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: The Database - Subtopic: DBA

This sesssion is a case study of a real-world system storing billions of images in a hybrid Oracle relational and NoSQL configuration. Images are stored in a highly available high-performance distributed database built with Enterprise Oracle NoSQL. Metadata for these images is stored in an Oracle relational database using Oracle Active Data Guard to provide high availability and read performance. This presentation will emphasize practical considerations and lessons learned when such a hybrid configuration is used to store high-value data, where data integrity is very important. Topics discussed will include performance, scalability, high availability, disaster recovery, security, and manageability of the system.

Back to Top
Find us on Facebook
Follow Us