TD2010Presentations

Click on a name below that will link to the paper summaries. Then to download a presentation; click on the paper title to which will prompt you to save the .pdf file. Please note that not all presentations may be available for download.

What is Master Data? What drives organizations to consider deploying a Master Data strategy? When is a Master Data management solution viable? We explore Master Data maturity models (consolidation, co-existence, transaction, and reference). We discuss the key business and architectural considerations. We do a quick review of the major PIM and CRM vendors. And we’ll discuss efforts being applied at GHX (Global Healthcare Exchange).

Michael Anderson, PlanetAnderson.biz Inc
Professional Development

Data Warehouse, Data Marts, OLAP, Master Data, and ODS --- Some Tips on When to Use What and Where

After twenty years as an OLAP Express DBA, Informatica developer, C programmer, and Enterprise architect, I’ve implemented many Business Intelligence solutions. There’s dizziness for the business and IT professionals on when to use what Data Warehouse components. Do we provide Enterprise integration with a Master Data solution or a Data Mart? Do we need a Data Warehouse or not? This presentation will focus on some core terms, common sense, and key components in helping you better understand the technology and business drivers in your architecture.

Back to the top
--------------------------------------------------------------------------------

Mike Ault, Texas Memory Systems
Database Administration

Going Solid: Use of Tier Zero Storage in Oracle Databases

In this presentation the attendee will learn techniques to determine what database objects should be placed on the high speed, low latency, tier zero, solid state device storage. Common system reports, such as statspack and AWR, will be used to show methods to determine what database assets would most benefit from SSD usage.

--------------------------------------------------------------------------------

Mike Ault, Texas Memory Systems
Management Infrastructure

The Ultimate Oracle Architecture – OPERA

This presentation shows a multi-tier system architecture using COTS hardware. The architecture uses SAS or SATA disk assets, SSD, and commodity servers along with Oracle technology to provide for high performance, high reliability, and local as well as global resiliency. The architecture provides for ease of expansion as well as providing OS and database (if needed) independence.

--------------------------------------------------------------------------------

Sridhar Avantsa, Rolta-TUSC
Database Administration

Index Organized Tables - To IOT or Not to IOT

Index Organized Tables (IOT's) have been around for a while, since 9i but not often used by DBA's, database designers, and application architects. This presentation will, for all intensive purposes, re-introduce IOT's to the Oracle user community at large. The goal of the presentation is to equip the database designer / DBA with enough information to be able to spot opportunities where implementing IOT's would help or hurt the application. The presentation will, broadly speaking, cover the following topics in relation to IOT's: what is an IOT, syntax, and an explanation of the various elements / components of an IOT; DML / DDL performance comparisons of IOT's and regular heap organized tables; IOT management issues; IOT specific scaling issues; how are they different from regular tables; guidelines and best practices; examples / use cases.

Back to the top
--------------------------------------------------------------------------------

Rich Baca & Arthur Nelson, U.S. Department of Agriculture
Applications

Thinking about SOA, Don’t Forget the Canonical Message Structures!

The information technology roadmap for the U.S. Department of Agriculture (USDA) Veterinary Service (VS) clearly presents a “commitment to ensuring that information relevant to animal disease management and surveillance is gathered, protected, and shared appropriately.” Proving this commitment, the VS Office of the Chief Information Officer has established a strategy for the implementation of a Service Oriented Architecture. In the early part of this strategy, the need for data integration with animal health system providers, in both the private and public sectors, was noted as one of the most significant needs. The technologist involved determined that aligning data messaging strategy to core business areas was a great place to start. A Canonical Message Model (CMM) was used within a business area as a means to reduce complexity when passing messages, and to increase the standardization of the data. This presentation will discuss how we have initiated our Service Oriented Architecture Strategy; describe a method used to combine multiple data models based on the same business area into a canonical message model for our first business area using standardized data; and demonstrate some of the challenges in converting data encoded in diverse standards into a single global standard to make the canonical message more robust.

Back to the top
--------------------------------------------------------------------------------

Rama Balaji, Rolta-TUSC
Database Administration

Oracle Automatic Storage Management Benefits With the Real World Examples

This presentation is for anyone interested in learning about Oracle Automatic Storage Management; how to configure ASM; what are ASM disks and disk groups; ASM mirroring and striping; rebalancing activity; command line tools; how to migrate databases from non-ASM to ASM using RMAN; and best practices and new features in 11g with simple to understand diagrams and charts.

Back to the top
--------------------------------------------------------------------------------

John Beresniewicz & Graham Wood, Oracle Corporation
Database Administration

DB Time-Based Oracle Performance Tuning: Theory and Practice

This session introduces the abstract theory of DB Time and Average Active Sessions. The process of performance tuning using DB Time will be discussed and compared with other current methodologies. The session will discuss the Active Session History (ASH) technology and its critical importance in identifying and quantifying sources of DB Time accumulation in an active system across many dimensions of interest to performance analysts. EM will be used to illustrate how to put the concepts and methods to use.

Back to the top
--------------------------------------------------------------------------------

Edward Bowers, ISS
Applications

Databases for Developers

This is an explanation of how Codd's Relational Model Tasmania is being applied in the real world to gain a significant information advantage. In recent papers on semantic data modeling, there is a strong emphasis on structural aspects, sometimes to the detriment of manipulative aspects. Structure without corresponding operators or inference techniques is rather like anatomy without physiology. Domain knowledge models are worthless without reasoning operators and AI inference engine frameworks. WebTAS is a powerful, robust, operationally proven, practical AI inference engine framework able to process domain knowledge models across a broad scope of domains, including static and empirical domains. This lecture tells you how it is done.

Back to the top
--------------------------------------------------------------------------------

Jordan Braunstein, Rolta-TUSC
Middleware

SOA Today

Service Oriented Architecture (SOA) is complex, lengthy, and riddled with challenges. Many organizations have had frustrating experiences in the path they chose, and some have even given up on their SOA initiatives. This session will present a refreshing and effective approach to achieving rapid and incremental results in SOA, all the while educating participants on how to keep their projects aligned with the “big-picture” SOA Roadmap. Approaches include how to leverage an Agile methodology with SOA, when to use top-down vs. bottom-up vs. middle-out, and how to ensure business success through the use of SOA pilots. The session will also cover fundamental principles of Service Oriented Architecture by explaining definitions, concepts, and practices. This will help participants gain a common understanding of what SOA is, what constitutes SOA, and why it is so important to businesses.

--------------------------------------------------------------------------------

Jordan Braunstein, Rolta-TUSC
Professional Development

Using Agile Approaches and Techniques for Rapid SOA Implementations

An overview of applying Agile and SCRUM methodologies to SOA projects. Covers introductory aspects of Agile and how Agile methodology can be more effective than traditional software or SOA approaches.

Back to the top
--------------------------------------------------------------------------------

Bradley Brown, Rolta-TUSC
Applications

Building a Mashup with Application Express (APEX)

In this presentation, Brad Brown will cover how you can consume the services using APEX. This is a technical presentation covering the specifics within APEX to accomplish service consumption.

--------------------------------------------------------------------------------

Bradley Brown, Rolta-TUSC
Applications

Scalable Oracle Application Express - Case Study on a True n-tier Architecture

This presentation will demonstrate a solution to this architectural dilemma! A reference architecture is provided along with a case study that this presentation is based around. You'll see exactly how to scale APEX (inexpensively) within your environment.

--------------------------------------------------------------------------------

Michael Butler, Rolta-TUSC
Applications

The ABCs of AIA

Oracle’s Application Integration Architecture (AIA) is a revolutionary new approach to systems integration. Or is it? This presentation will explore how AIA fits into the continuum of system integration methods and will explain, as non-technically as possible, how it really may be the groundbreaking approach to integration for which organizations have been waiting. By detailing the basic concepts, components, and functions of this architecture, we will demonstrate how it can provide the foundation necessary to support an evolution to an efficient, flexible, scalable, and highly reliable integration platform for your Oracle applications.

Back to the top
--------------------------------------------------------------------------------

Karen Cannell, Integra Technology Consulting
Applications

APEX Debug Strategy

APEX development is a breeze, until something goes wrong and there’s no obvious clue of what happened, how to fix it, and there's no “undo” or is there? This session presents overall strategy and specific tactics to address common APEX problems such as the pesky MRU internal error, browser errors, SQL and PL/SQL issues, HTML, and JavaScript problems. We cover general strategy, triage, debug tool options, and debug tactics, then demonstrate applying those strategies to tackle common APEX problems.

--------------------------------------------------------------------------------

Karen Cannell, Integra Technology Consulting
Applications

Migration BI Tool to APEX Interactive Reports: What Works and What Doesn't, and Lessons Learned Along the Way

APEX Interactive Reports offer a wealth of end-user functionality for filtering, organizing, massaging, and charting data—but is this enough to replace your Business Intelligence tool? From our experience, migrating from Business Intelligence to APEX IR, learn what works and what doesn't, and under what conditions and resources such a migration succeeds. Track our progress from analysis and planning, to report conversion, to testing and implementation. We will present our path—the leaps, the creeps and the stumbles—through identifying candidate reports, parameter selection, crosstab queries, drills, and downloads, to timing, tuning, testing, resources gained/lost, and training.

Back to the top
--------------------------------------------------------------------------------

Patty Charlebois, Green Shield Canada
Database Administration

CSI Oracle – Investigate Past Performance Problems Using ASH, AWR, ADDM, and Optimizer Statistics

We’ve all been there. You leave to enjoy a nice relaxing week away from the office, only to come back to an inbox full of e-mails about database problems that occurred while you were away. Management is pressuring you to explain what happened, and the fact that you were not at work is not an acceptable response. This presentation will show you how to use the Oracle automated toolset to go back in time and figure out what happened while you were away, based on my own real-life experience.

--------------------------------------------------------------------------------

Patty Charlebois, Green Shield Canada
Database Administration

Successful Upgrades Start with a Good (Execution) Plan

Upgrading an Oracle database can be a large and stressful undertaking for a beginner or even an advanced DBA. The biggest unknown during the upgrade process these days is what will happen to your SQL statement performance, once a new version of the Oracle optimizer gets a hold of it? This presentation will outline a method we have successfully used to upgrade an Oracle database without causing SQL statement performance issues, using Oracle’s SQL Performance Analyzer (SPA) product.

Back to the top
--------------------------------------------------------------------------------

Qingchen Chen, Tri-State Generation and Transmission Association
Applications

10 Things I Did Not Learn from SQL Class

This presentation is intended to share tips, tricks, and traps of Oracle SQL with an entry level Oracle developer. The Presentation will include: 1. Trap of null value 2. How to achieve first day of the month 3. How to use decode to compare values 4. How to get top three value of column using rownum 5. How to select any Friday within a month 6. How to randomly select ten rows in a table 7. How to delete duplicate records in one table when values are equal in two or more columns 8. Common mistakes using outer join; cascading issue 9. 9. How to determine a varchar2 type column contains only number 10. How and where to use analytic functions.

Back to the top
--------------------------------------------------------------------------------

Maria Colgan, Oracle Corporation
Database Administration

Explaining the Explain Plan

The execution plan for a SQL statement can often seem complicated and hard to understand. Determining if the execution plan you are looking at is the best plan you could get, or attempting to improve a poorly performing execution plan, can be a daunting task even for the most experience DBA or developer. This session—presented by Oracle Development — examines the different aspects of an execution plan, from selectivity to Parallel Execution, and explains what information you should be gleaming from the plan and how it affects the execution. It offers insight into what caused the optimizer to make the decision it did, as well as a set of corrective measures that can be used to improve each aspect of the plan.

--------------------------------------------------------------------------------

Randy Cunningham, SageLogix
Database Administration

Networking and Oracle: What You Need to Know

This fast-paced session will organize and fill in the gaps of your understanding of network architecture, protocols, and practical network application in an Oracle-centric architecture. As a result, you will gain an improved capacity for communication, with their system and network administrators, on the topic of connectivity between systems. Starting with an overview of the OSI model, protocols and technologies most pertinent to the Oracle practitioner will be described, including TCP, LDAP, HTTP, TLS, NTP, and others. In addition, the fundamentals of routing and subnets will be presented, including network address translation (NAT). Learn about cross-platform tools that facilitate diagnosis of network problems and measure network performance. No-cost tools for measuring bandwidth and latency across wide-area networks will be described. Find out more about network security, including encryption of data in transit, the function of Oracle Wallet Manager, and how firewalls affect Oracle implementations. Need to learn more about a specific network topic? A knowledge roadmap, to learn more about specific networking subject matter, will be shared.
--------------------------------------------------------------------------------

Randy Cunningham, SageLogix
Database Administration

DBFS in a Nutshell

Introduced in Oracle Database 11g Release 2 (11.2), the DataBase File System (DBFS) is a new solution that is part of Oracle SecureFiles. It enables a database to be mounted as a POSIX-compatible file system on Linux, using the FUSE library infrastructure. As a result, ordinary file system data can benefit from Oracle database features including security, backup, high availability, performance and scalability. In addition, APIs facilitate access to the underlying files in DBFS by database applications. DBFS Hierarchical Store enables convenient archiving and de-archiving of DBFS data to secondary storage tiers, such as tapes, optical libraries, or storage clouds. Learn about the benefits of DBFS, how to set it up, and some of its current limitations. A brief demonstration of DBFS will be provided.

Back to the top
--------------------------------------------------------------------------------

Piet de Visser, Logica
Database Administration

Good Indexing: Show CBO Where to Go

Common joke: The best way to fix inefficient queries is to not have them. The next best way is to present them with the most efficient path into the data, which is why I first want to cover some indexing basics and a few lesser used techniques like IOT and clusters. The presentation involves some demos of things we already know, and possibly a few neat, but simple, tricks to get more out of your indexes. Then, once we have really efficient access-paths, we must still tell the CBO workhorse where to go, but that is a different presentation.

Back to the top
--------------------------------------------------------------------------------

Jean-Pierre Dijcks, Oracle Corporation
Database Administration

Extreme Performance with Oracle Database 11g and In-Memory Parallel Execution

Introduced over a decade ago, Parallel Execution is one of the fundamental technologies that enable organizations to manage and access tens and hundreds of terabytes of data by taking full advantage of the IO capacity on a system. Oracle Database 11g Release 2 delivers a milestone for Parallel Execution with new groundbreaking in-memory capabilities, along with a new automated technique for determining the most optimal degree of parallelism for every operation. This session will discuss Oracle's Parallel Execution architecture, its new ground-breaking in-memory technology, and other enhancements in Oracle Database 11g Release 2.

Back to the top
--------------------------------------------------------------------------------

Chuck Edwards, Blue Gecko, Inc.
Management Infrastructure

E-Business Suite in the Amazon Cloud

With Oracle’s announcement of support for Amazon Web Services (AWS), it is now possible to run Oracle databases and Oracle E-Business Suite in the AWS EC2 (Elastic Cloud Compute) cloud. In this session, we will create a working release 12 Vision Demo environment on EC2, based entirely on audience specifications. Through the deployment process, we will explain the basics of EC2, and show how anyone can instantly deploy Oracle E-Business Suite for less than $20/day.

Back to the top
--------------------------------------------------------------------------------

Iggy Fernandez, Database Specialists
Applications

SQL 101: Recursive Common Table Expressions in Oracle Database 11gR2

New in Oracle Database 11gR2, the "recursive Common Table Expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members," followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list his parents, followed by recursive members that identify his male ancestors and female ancestors. Recursive CTEs can also be used to generate rows; for example, we can easily list the members of the Fibonacci sequence. In this session, we study recursive CTEs and compare them with queries written using the traditional "CONNECT BY" proprietary Oracle syntax.

--------------------------------------------------------------------------------

Iggy Fernandez, Database Specialists
Applications

DBA 101: In Defense of Statspack

Beginning with Oracle Database 10g, Statspack is no longer documented in the Oracle manuals. The manuals simply say that this feature has been replaced by Automatic Workload Repository (AWR). In reality, Oracle made enhancements to Statspack in both Oracle Database 10g as well as Oracle Database 11g. Further, AWR is only available with Oracle Database Enterprise Edition as part of the separately licensed Diagnostics Pack. Very few organizations have licensed both Enterprise Edition and Diagnostics Pack and, therefore, Statspack is the only performance tuning tool available to most Oracle database administrators. This presentation focuses on the new features of Statspack in Oracle Database 10g and Oracle Database 11g. You will also learn how to go beyond the simple Statspack report and analyze the wealth of information in the Statspack tables. For example, you will learn how to identify queries whose execution plans have changed, and how to systematically compare current performance with a baseline period.

Back to the top
--------------------------------------------------------------------------------

Steven Feuerstein, Quest Software
Applications

Why You Should Care About Oracle11g PL/SQL Now!

So Oracle has come out with another version. You probably won't be using it for years, so why should you bother learning about what's new in Oracle11g PL/SQL now? A very reasonable question, and the answer is: because once you understand what will be possible in Oracle11g, it will change the way you write your code now! This session will offer an overview of the most exciting new features for PL/SQL in Oracle11g and prove to you, beyond the shadow of a doubt, that you should be designing your code at this moment to get ready for that version.

--------------------------------------------------------------------------------

Steven Feuerstein, Quest Software
Applications

Automated Testing Options for Oracle PL/SQL

We all know we should test our code more thoroughly, but who has the time and patience, and isn't our code "good enough" anyway? Did you know that it is widely accepted that if you have a program of five hundred lines, you should expect to write five thousand lines of test code? Ah, so that's why we don't test our code! If you are not satisfied with the number of bugs in your code or if you sometimes find yourself embarrassed demonstrating your software to users, then attend this session. You will: learn how you can automate the testing process, reduce bugs in your code, and increase confidence in your applications. This session reviews the tools, from open source to commercial, that offer varying levels of testing automation.

Back to the top
--------------------------------------------------------------------------------

Daniel Fink, Independent Consultant
Database Administration

A Command Line DBA's Guide to SQL Developer

SQL Developer Version 2 includes extensions and reports that are beneficial to the DBA. Attendees will learn how to use SQL Developer for typical DBA tasks, including scripting, monitoring, managing objects, and optimizing queries. This presentation covers the basics of installing and configuring SQL Developer, connecting to a database, writing, saving and running a script, and exploring the DBA extensions. When installing and configuring SQL Developer, several pre and post-install tasks should be performed to assist in the transition and use of SQL Developer. Creating database connections can be achieved using several methods, and using folders will help keep multiple connections organized. Querying and scripting are two key tasks for a DBA and the process for writing a query, saving the query in a script, and running a script are important to being efficient. Query and script output and data can be saved in external files, including formats for reporting, like html, and formats for transfer, such as comma separated value. Finally, the presentation covers some day-to-day DBA tasks that are now part of SQL Developer, including viewing object details, generating ddl, running ASH/AWR reports, checking sessions, top SQL and memory and using explain plan and reading trace files to optimize queries.

Back to the top
--------------------------------------------------------------------------------

Robert G. Freeman, LDS Church
Database Administration

Advanced RMAN Backup and Recovery

RMAN is Oracle’s premiere backup and recovery product. This session is for those who are familiar with basic RMAN usage and who would like to dive deeper into some of RMAN’s more advanced features. In this session, you will learn about RMAN point-in-time recovery of a database; flashback database features; RMAN database duplication; ways to tune RMAN backup operations; and how to monitor RMAN database operations.

Back to the top
--------------------------------------------------------------------------------

John Garmany, Burleson Consulting
Database Administration

Oracle Streams: Drinking from the Fire Hose

Oracle Streams is the Oracle Replication solution. This presentation will not discuss setup and monitoring Oracle Streams, instead it will focus on value-added capabilities. Data transformation using rules and user-defined apply handlers will demonstrate the advanced capabilities that Streams provides. Handling data collisions with built-in and custom conflict resolution methods will also be covered. This presentation assumes basic knowledge of the stream setup and configuration.

Back to the top
--------------------------------------------------------------------------------

Gary Garrison, Raytheon Company
Database Administration

From Here to Eternity: Using Oracle’s 11g Flashback Data Archive to Persist Data Modifications

This presentation will use lecture and examples to demonstrate the ability of Oracle’s Flashback Data Archive to track changes made to data over a chosen period of time. This presentation is technical in nature and primarily geared towards DBAs and security administrators. However, managers will also derive some benefit from the presentation’s coverage of regulatory compliance.

--------------------------------------------------------------------------------

Gary Garrison, Raytheon Company
Database Administration

The Worst Case Scenario: Emergency Performance Tuning for the Novice DBA

This presentation will help the nascent DBA overcome the fear and loathing of stepping into the often opaque world of tuning an Oracle Database. Luckily, each successive version of Oracle has helped level the field between junior and senior DBAs when it comes to performance tuning. Tools such as Automatic Database Diagnostic Monitor and Autotrace will be demonstrated and discussed. Using a real world example, we will explore emergency performance tuning for the new novice Oracle DBA.

Back to the top
--------------------------------------------------------------------------------

Doug Gault, Sumner Technologies
Applications

Replicating NetFlix Queue Drag-and-Drop Functionality with Oracle Application Express/jQuery

Although Oracle Application Express enables you to create very robust Web-based applications in a very short timeframe, there are some areas in the UI that are lacking the pizazz of Web 2.0. jQuery, one of the most popular open source JavaScript libraries, can be used to add sophisticated user interface functionality to Web-based applications. To demonstrate this functionality, this session shows, step-by-step, how Oracle Application Express and jQuery can be used to fairly easily duplicate the functionality of the NetFlix movie queue. You'll gain an understanding of the basic structure of the jQuery library, and how it can be integrated into Oracle Application Express, and how it can be used to implement some very impressive interface techniques.

--------------------------------------------------------------------------------

Doug Gault, Sumner Technologies
Applications

Performance-Tuning Oracle Application Express Applications

Oracle Application Express is a highly-flexible and highly-scalable rapid application development environment for Oracle-platform-based Web applications. But what do you do when your application's success starts to become its downfall? This presentation covers strategies and tactical advice for monitoring and addressing performance issues in Oracle Application Express-based applications, using built-in as well as free third-party (open source) tools. The session also presents some of the best practices for making Oracle Application Express performance problems easy to diagnose.

Back to the top
--------------------------------------------------------------------------------

Anthony Golden & Kenneth Lee, Douglas County Schools
Middleware

And We are Live...What You Need to Know About BPEL After Go-Live

You have worked your way through a successful implementation of a BPEL project deployment. Now that you are live, what do you need to know? The session will discuss issues found at Douglas County Schools with implementing a set of Web services, through BPEL, that process credit card transactions using another vendor’s Web services and services integrated with SQL Server. The topics include Web server load balancing and tools in BPEL to monitor and audit transactions.

Back to the top
--------------------------------------------------------------------------------

Glenn Goodrum, Collect America
Database Administration

Change Tracking Techniques for Databases

Any DBA who has worked in a development environment knows the challenges of getting the right versions of all database objects into all of the various database environments at the right time. Many of us are familiar with issues arising after a deployment, such as columns having the wrong data type, missing indexes, missing synonyms, or missing privileges. We may also have faced the question of just which version of an object in a given database, why a particular table or other object differs in one database from another, or why a privilege is granted in one database and not another. This paper discusses some basic techniques for keeping track of what has changed in a database, when it was changed, who changed it, and why. These techniques allow the DBA to know exactly what version of objects are in the database; furthermore, they form the foundation for a process, covered in a companion paper, that can maximize the chances of deploying the correct versions of database objects on the first try, including tables, indexes, views, stored procedures, triggers, synonyms, privileges, and reference data.

Back to the top
--------------------------------------------------------------------------------

Alex Gorbachev, The Pythian Group
Database Administration

Oracle ASM 11g Release 2 - The Evolution

Oracle Automatic Storage Management has proven to be one of the most widely adopted new features in Oracle Database 10g and it has been dramatically improved in the later 11g releases. This presentation will explain what changes are solved by ASM, how these challenges are solved, what barriers there are to ASM adoptions, and how 11g Release 2 addresses these barriers.

Back to the top
--------------------------------------------------------------------------------

Kent Graziano, BCS, Inc.
Database Administration

Agile Methods and Data Warehousing: How to Deliver Faster

Most people will agree that data warehousing and business intelligence projects take too long to deliver tangible results. Often by the time a solution is in place, the business needs have changed. With all the talk about Agile development methods and Extreme Programming, the question arises as to how these approaches can be used to deliver data warehouse and business intelligence projects faster. This paper will look at the principles behind the Agile Manifesto, and see how they might be applied in the context of a data warehouse project. The goal is to determine a method or methods to get a more rapid (two to four weeks) delivery of portions of an enterprise data warehouse architecture. Real world examples with metrics will be discussed.

--------------------------------------------------------------------------------

Kent Graziano, BCS, Inc.
Applications

Data Design Reviews: Using Extreme Humiliation to Insure Quality Data Models

Tired of crappy data models and whiney data modelers? Need to deliver a high quality design in a short period of time? Need a better way to enforce standards? In order to be more agile in developing data models, this presentation has adopted a concept from the agile world (and others): peer reviews. Before any data model moves from analysis (logical model) into development (physical model), this presentation gathers to review what the modeler has done. If the model passes the review (almost never on the first round), the physical model is constructed. The physical model is then subjected to a rigorous review as well (including metadata). Only then can DDL be produced and deployed. This presentation will discuss the actual modeling and design process followed and give you a check list of questions to ask in any model review session. This is a “take no prisoners” approach that has left many a would-be data modeler in a withering heap, but in the end, this presentation has solid models and designs that deliver value.

Back to the top
--------------------------------------------------------------------------------

Stephan Haisley, Oracle Corporation
Database Administration

Oracle Streams Replication Made Easy

This session covers the Oracle Streams replication feature, showing how the new Oracle Streams management abilities, in Oracle Enterprise Manager 10g Release 5, greatly simplify Oracle Streams administration and monitoring. Learn about workflows in Oracle Enterprise Manager 10g Grid Control, for easily creating Oracle Streams configurations. Learn how to use the new end-to-end Oracle Streams path-level views in Oracle Enterprise Manager 10g Grid Control, to quickly identify potential bottlenecks and improve overall throughput. Learn how to create transformation rules, Oracle Enterprise Manager 10g Grid Control alerts based on Oracle Streams metrics, and more. The session also addresses Oracle Database 10g/Oracle Database 11g management abilities.

Back to the top
--------------------------------------------------------------------------------

Sue Harper, Oracle Corporation
Database Administration

Database Modeling and Design with Oracle SQL Developer Data Modeler

Oracle SQL Developer Data Modeler supports logical, relational, and physical data modeling for Oracle, Microsoft SQL Server, and IBM DB2. The Data Modeler provides forward and reverse engineering of database structures from the ERD to relational models and the reverse, thus allowing users to keep models synchronized where required. The tool supports the import of metadata from a variety of sources, including Oracle Designer and CA Erwin, and DDL generation, for the supported databases. In this session, we discuss the features supported in a logical entity relationship diagram, such as the choice of notations, the displays, and formatting supported. We’ll build logical, relational, and physical models and generate the DDL. Through the demonstration, we point out the supporting features, such as domain creation, naming standards, and the design rules.

Back to the top
--------------------------------------------------------------------------------

Guy Harrison, Quest Software
Database Administration

Next Generation Databases

For the first time in more than twenty years, credible alternatives to SQL-based relational databases are emerging. Modern Web 2.0 applications have size, performance, and reliability requirements that cannot currently be met even by the most sophisticated and expensive relational offerings. Consequently, non-relational “NoSQL” datastores are emerging and may change the very nature of database management. In this presentation, we’ll review the evolution of the modern RDBMS in general and Oracle in particular, and outline where emerging application architectures find the RDBMS lacking. We’ll then review the major architectural models for non-relational data stores such as Google’s BigTable, Amazon’s SimpleDB, CouchDB, H-Store, and others. We’ll also look at ways in which Oracle and the other RDBMS vendors may respond to this challenge.

--------------------------------------------------------------------------------

Guy Harrison, Quest Software
Applications

High Performance PL/SQL

Each release of the Oracle RDBMS is associated with dramatic improvements in PL/SQL performance. However, the ultimate performance of any PL/SQL program is still in the hands of the PL/SQL programmer. In this presentation, we’ll examine trends in PL/SQL performance, look at tools to identify and tune problematic PL/SQL, and examine PL/SQL performance best practices. Topics will include opportunities for improving SQL performance by using PL/SQL code, measuring and diagnosing PL/SQL performance issues, best practices for writing high performance PL/SQL, and the use of new 11g optimizations to further turbo-charge application code.

--------------------------------------------------------------------------------

Guy Harrison , Quest Software
Database Administration

Optimizing Oracle on VMware

Virtualization is a red hot trend—but what about for databases? The answer is YES, with the proper care and configuration, Oracle on VMware is a reality. The author will present some of the best practices from his new book: “Oracle on VMware - Expert tips for Database Virtualization.” Topics and concepts apply to any virtualized database environment, including Hyper Visor and Oracle VM.

--------------------------------------------------------------------------------

Guy Harrison, Quest Software
Applications

Oracle Performance by Design

It’s a sad fact that we spend more time dealing with performance after development than during design. Yet it’s usually the architecture and design of an application that limits its ultimate performance potential. This presentation looks at the principles of designing a high-performance Oracle application. It starts by considering the general principles of logical and physical database design, indexing, and transaction structure. It then looks at Oracle-specific considerations such as partitioning and clustering, SQL statement parsing, data fetching and caching, and the use of PL/SQL.

Back to the top
--------------------------------------------------------------------------------

Robert Holland, Roxytone LLC
Professional Development

PMI Project Management for IT Professionals or How to Avoid Becoming IT Roadkill

How often have you been brought a task involving several weeks or even several month’s work and just handed a ‘body of work’ to do by your supervisor on a new group of servers and given some fuzzy instructions like “. . . migrate the old bookkeeping application to this new server!”? Or, your management will come to you complaining about the ‘old, slow server’ or say, “I just want it fixed!” What do you say when you know the operating system no longer supports upgrades, or is not compatible with the new application? Is there a shouting match in your future? When will the ‘blame storm’ start? Who is best at ‘passing the buck’? So, forgetting all these points above, you have now taken on a body of work without any idea how long it will take, what the steps are you’ll need to use, what is your authority in getting the job done, what your take on it is, or how you will go about getting it done in addition to all of your ordinary day-to-day duties. Now jump ahead in time—you have been working for fifty-five hours a week forever, your regular duties have slipped to the point you’re worried that something major might crash, and you still don’t have the migration finished. Then, along comes your boss and says, “What the heck have you been doing?” and suddenly, your first impulse is to strangle him or her with your mouse cord.

Back to the top
--------------------------------------------------------------------------------

Dan Hotka, Training Specialist
Applications

Oracle11g New Features for Developers

This presentation is a must-see for anyone migrating to the new Oracle11g Database. The focus of this presentation is new features that would be of interest to developers.

--------------------------------------------------------------------------------

Dan Hotka, Training Specialist
DBA

Tools of the Trade: All the Free Tools from Oracle Corp

Dan Hotka has used a variety of SQL tuning tools through the years. This presentation will include a live demonstration on various available tools from Oracle Corporation including SQL Developer, TKProf, the race Analyzer, and undocumented explain plan tools. This presentation is packed full of tips and techniques, including scripts that help find offending SQL statements.

Back to the top
--------------------------------------------------------------------------------

Bill Jackson & Dustin Marx, Raytheon Systems Company
Applications

10 Easy Ways to Build a Better Graphic User Interface

In the world of graphic user interfaces, form nearly always follows function. From Dilbert jokes about GUIs designed by engineers, to MySpace’s reputation for ugly pages, it’s clear that designing attractive, useful, and well thought-out GUIs is much easier said than done. However, positive examples in the commercial world, such as Apple’s well-earned reputation for stylish products, show just how much impact a well-designed user interface can have. This presentation will cover ten basic steps for building more intuitive, attractive, and useful user interfaces. The discussion will include issues such as usability, data presentation, form layout, color selection, icon acquisition, and a host of other issues that will help attendees to understand the basic steps to making programs that users actually like. The benefits of these skills go beyond the aesthetic issues to help raise user productivity and product longevity. The presentation will not require any specific programming knowledge, and will apply to desktop applications and Web pages alike.

--------------------------------------------------------------------------------

Stephen Jackson, Raytheon Company
Database Administration

Using SQL to Generate SQL

In this presentation, beginning DBAs will learn to use the power of the SQL programming language to write SQL programs. When you need to manipulate several user accounts, add a new column to a table, or put the same trigger on fifty tables, SQL generating SQL is the only way to go. In this presentation, you will see several useful real world examples, including the source code, which you will be able to take back to your job.

Back to the top
--------------------------------------------------------------------------------

Steve Jun
Security

A Discussion of Encryption and Oracle Databases

A discussion of encryption techniques and algorithms, especially pertaining to Oracle Databases. A review of encrypted tablespaces, DBMS_CRYPTO, advanced security, and key management.

Back to the top
--------------------------------------------------------------------------------

Mike Killough, Rolta-TUSC
Middleware

SOA High Availability

Overview of the architecture and installation steps required for a highly available SOA installation, which includes an RAC database, Oracle Application Server 10g cluster, and a clustered configuration of ESB and BPEL.

--------------------------------------------------------------------------------

John King, King Training Resources
Applications

Oracle 11g for Developers: What You Need to Know

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. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, regular expression improvements, new analytic functions, virtual columns, result caching, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL result cache, and materialized view improvements. Attendees will be better equipped to create new applications, or modify existing applications, to take full advantage of Oracle 11g Release 1 and Oracle 11g Release 2.

--------------------------------------------------------------------------------

John King, King Training Resources
Applications

Java 6 and Java 5 New Features

Java has become the dominant development language for Web-based systems. Since its release to the public in 1995 (Java 1.0), Java has matured-improving functionality and performance with each new release. In Java SE 6 and J2SE 5 (1.5), Sun added several useful features in addition to making improvements in the JVM and other infrastructure. This session discusses and demonstrates what's new in Java syntax as well as some internal improvements that make this the best release of Java ever. Specific topics include: generics, enhanced for loop iteration, autoboxing/unboxing, typesafe enumerations, static imports, annotations, formatted (ala print) output, variable argument lists, input scanner, and other features.

Back to the top
--------------------------------------------------------------------------------

Bruce Kissinger, Rolta-TUSC
Applications

Implementing Search Using Open-Source Tools

This presentation describes how to implement search functionality using the Apache Lucene and Apache Solr open-source toolkits. The architecture of these toolkits are briefly described, and examples of retrieving content from documents and Oracle Databases are provided. Additional examples show how to integrate this capability in PL/SQL, Oracle Application Express, and Java.

Back to the top
--------------------------------------------------------------------------------

Peter Koletzke, Quovera
Applications

Hello Worldwide Web: Your First JSF

JavaServer Faces (JSF) is a Java-based user interface technology used primarily to develop Web applications. It is currently the most popular UI technology in the Java world, and it is a key technology in the Oracle Application Development Framework (ADF). Oracle's Fusion Applications (formerly E-Business Suite) use JSF as the main user interface technology. This presentation provides an in-depth overview of JSF technology, as it is used with ADF, to build applications in JDeveloper 11g. It discusses the basic communication paths used when running a JSF application. The presentation also explores development details for creating and testing JSF files. It describes the contents of runtime files such as backing beans and managed beans, message bundles, faces-config.xml, and web.xml. The presentation also briefly explores how to link data from the database into the JSF page so it can be saved or retrieved from the database. Throughout this presentation, sample code and demonstrations show how these concepts manifest in a sample application.

Back to the top
--------------------------------------------------------------------------------

John Krahulec, TURBO Enterprises
Applications

Rich Web Applications for the Enterprise... Creating RWA from Your Oracle Database

Leverage the power of your existing Oracle Database and PL/SQL development skills to create the Rich Web Applications your customers desire, using the skills you already have. Skip the table-driven tools and use your PL/SQL skills to create powerful, easy to develop and maintain packages that serve up Rich Web Applications from your Oracle Database.

Back to the top
--------------------------------------------------------------------------------

Christo Kutrovsky, The Pythian Group
Database Administration

RAC+ASM: Three Years in Production. Stories to Share

This presentation will cover Migration via LUN re-assignment; migrating online migration from EMC to 3par; removing ASMLIB and using EMC multipathing; gotchas when building ASMLIB devices with multipathing; corrupting your production database beyond repair with duplicate database on ASM; overwriting your data with ASM due to incorrect naming convention; corrupting your production database with NETAPP/NFS due to Oracle bug; two nodes RAC is not HA; performing network maintenance; and RAC + SAME = LAME.

Back to the top
--------------------------------------------------------------------------------

Kenneth Lee, Douglas County Schools
Tony Golden, ITS
Applications

APEX Moves from the Garage to the Basement

In year's past, many businesses started in the garage of an entrepreneur's house. Today, many developers are able to accomplish the same thing with a spare PC and an Internet connection. This presentation will go over how to integrate different components to create a working environment. Although technical in terminology, the goal is to present a quick guide to setting up a working environment that can be used whenever a consistent Internet connection is available. The setup described above will allow both development and access to the applications you create from external locations, enabling the applications you create to be available to the entire world!

Back to the top
--------------------------------------------------------------------------------

Debra Lilley, UKOUG/Fujitsu
Applications

Thinking of Supporting or Extending Fusion Applications - An Update

Last year Debra Lilley presented this for the first time anywhere at RMOUG: As Oracle gets ready with its first suite of Fusion applications She is proud to have had a sneak preview. Debra liked what she saw and at a high level, can talk about the concepts. What blew her away was the vision, all of the technology is here today and she could identify with it all, so if it is available today, could she build it? If you had the resources, the investment, and above all the vision could you? Oracle has moved on a lot in the last twelve months, so Debra’s presentation will be a recap and an update of new information.

Back to the top
--------------------------------------------------------------------------------

Sherry Litasi, Dynamic Directions in Bodywork
Professional Development

Ergonomics 101: Learn How to Work Pain Free

There is no need to suffer with carpal tunnel pain, low back pain, thoracic outlet syndrome pain, and neck pain while working at your computer. Learn how muscles work, why they get tired, and why and where pain occurs. Learn how to set up your desk, chair, monitor, and keyboard regardless of your size. Learn how to perform simple exercises, that you can do at your desk, that will mitigate the chronic pain.

Back to the top
--------------------------------------------------------------------------------

Daniel Liu, Oracle Corporation
Database Administration

Oracle Database Security in a Nutshell

In this session, the attendees will learn how they can use Oracle Database features to meet the security and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data Protection Act, and others requires better security at the database level. The session provides suggested architectures for common problems. It covers four major areas of database security: 1) authentication 2) authorization 3) auditing 4) eEncryption. It covers the following security features/options of the database: audit vault, database vault, data masking, secure backup, transparent encryption, secure configuration scanning, label security, virtual private database, ASO, and more.

--------------------------------------------------------------------------------

Brent Lowe, STR Software Company
Applications

Report Bursting & Email/Fax Delivery with BI Publisher Enterprise at Starbucks Coffee Company

Oracle’s Business Intelligence Publisher Enterprise is a stand-alone reporting and document output management solution that allows companies to lower the cost of ownership for reporting solutions. Leveraging open standards, BI Publisher Enterprise can run on any J2EE application server, access data from any database, and deliver finished documents via a number of standard protocols. Join us as we dig into the mechanics of report generation and the bursting and delivery engines of BI Publisher Enterprise, and learn how Starbucks Coffee Company is leveraging Oracle and STR Software to create reports and burst them to fax and e-mail delivery channels.

Back to the top
--------------------------------------------------------------------------------

Slavik Markovich, Sentrigo
Security

Attack Your Database Before Hackers Do

In this presentation, we will show typical security flaws found in PL/SQL and Java code due to programmer mistakes. We will demonstrate how to use existing open-source scanning and fuzzing tools to automatically find and flag such flaws, and also demonstrate how creating your own tools in PL/SQL can help you keep your code secure.

Back to the top
--------------------------------------------------------------------------------

Dustin Marx & Bill Jackson, Raytheon Company
Applications

Applied Groovy: Scripting for Java Development

As a dynamic language that runs on the JVM and can be used anywhere the Java programming language is used, Groovy is a great choice for building, testing, and maintaining Java SE and EE applications. This presentation briefly summarizes some basics of Groovy, advantages of using Groovy, and demonstrates how to use Groovy to improve the ability to build and test standard and Enterprise Java applications. Although the basics will be covered initially in the presentation for those who have not used Groovy previously, most of the syntax and other features covered in this presentation will be presented in conjunction with the use of Groovy in the building and testing of applications for the Java platform.

--------------------------------------------------------------------------------

Dustin Marx, Raytheon Company
Middleware

RESTful Java

The Java platform provides many types of support for building REST-based Web services and REST-compliant clients. This presentation will briefly summarize the main principles of the Representational State Transfer style of Web services before covering several of the most popular Java-based approaches for working with REST. The presentation will focus on JSR 311 (“JAX-RS: The Java API for RESTful Web Services”), Jersey (the JSR 311 reference implementation), Restlet, and Enunciate while also covering other useful tools related to REST-oriented development with Java.

Back to the top
--------------------------------------------------------------------------------

Jennifer McNeill, CipherSoft, A Subsidiary of Unify Corporation
Applications

Converting Oracle Reports to BI Publisher

The ability to easily access, manage, and report information is critical in today’s competitive environment. Users require timely, accurate, and actionable reports that provide highly usable business information (without the deployment) management, and usage complexities inherent in traditional reporting solutions. Oracle Business Intelligence (BI) Publisher provides the flexibility and functionality needed to meet the increasing demands by users for functional reports. BI Publisher is an Enterprise reporting solution to author, manage, and deliver all types of highly formatted documents. As a Java application, BI Publisher can be deployed in any J2EE container. This presentation will discuss the key advantages of converting Oracle Reports to BI Publisher and the cost-savings associated with developing and maintaining reports with BI Publisher.

Back to the top
--------------------------------------------------------------------------------

Michael Messina, Rolta-TUSC
Database Administration

Partitioning, More Cost Savings, Better Performance, and Better Management in Oracle Database 11g

Using new features of Oracle Database 11g in partitioning and advanced compression, we can maximize cost savings and performance, without sacrificing ease of management. New partitioning features can help us improve performance, combining with Oracle Advanced Compression, to reduce disk storage costs and eke out some further performance improvements. This session shows examples and demonstrates cost savings, performance gains, and management ease.

--------------------------------------------------------------------------------

Michael Messina, Rolta-TUSC
Database Administration

Centralize Your Automatic Workload Repository Data for Better Analysis

The Automatic Workload Repository is a powerful feature that was introduced in Oracle 10g and improved in Oracle 11g. Learn how you can utilize that power at an Enterprise level by bringing your Automatic Workload Repository data together into a central repository to compare reports across databases in your Enterprise; keeping snapshot data for longer periods without taking space in your live databases; thus adding to the flexibility and power of the Automatic Workload Repository. This session will give you some ideas of how you might leverage this feature in your Enterprise.

Back to the top
--------------------------------------------------------------------------------

Duncan Mills, Oracle Corporation
Applications

Oracle Fusion Design Fundamentals

Oracle JDeveloper 11g and the Oracle Application Development Framework (Oracle ADF) open up a whole world of possibility for custom development of database applications. You now have a lot of tools and capabilities to play with, so exactly how should you start? This session looks at some of the core design patterns and golden rules that have emerged out of Oracle's own Fusion development project to create the next generation of business applications. Although the scale may be very different from the work you are undertaking, many of the principles are identical and the core aim of maximizing developer productivity is key.

Back to the top
--------------------------------------------------------------------------------

Cary Millsap, Method R Corporation
Database Administration

Thinking Clearly About Performance

Cary Millsap describes the fundamentals of performance in a session designed to put DBAs and developers alike onto the right path of thinking clearly about the speed of software and how to manage it.

Back to the top
--------------------------------------------------------------------------------

Daniel Morgan, University of Washington
Database Administration

New Features in Oracle Database 11gR2

Oracle Database 11gR2 contains new functionality, as well as substantive enhancements to existing functionality, such as Advanced Compression, PL/SQL Warnings, and even new ways to create tables and indexes. This presentation, by Oracle ACE Director Daniel Morgan, will be live in SQL*Plus and will demonstrate the use of the most valuable of these new features.

Back to the top
--------------------------------------------------------------------------------

James Morle, Scale Abilities Ltd.
Applications

The Oracle Wait Interface Is Useless

For years, the Oracle Wait Interface has allowed DBAs to quickly get to the root of their performance problems. However, technological progression means that it is becoming increasingly likely that real performance problems will show no waits at all. This presentation highlights such scenarios and some techniques to get to the truth.

Back to the top
--------------------------------------------------------------------------------

Matthew Morris, Rolta-TUSC
Management Infrastructure

When a Good Cluster Goes Bad

Cluster Solutions, RAC, VERITAS, and SERVICE Guard each have their place in the data center. However, the implications of a cluster is that services will be available nearly all the time. This presentation discusses some of the key areas to look for and how to be vigilant when ensuring cluster success. Additionally, we will look at when VERITAS or HP ServiceGuard add value and what the new capabilities of 11gR2 RAC will mean for your data center.

Back to the top
--------------------------------------------------------------------------------

Peter Mullineaux, Level(3) Communications, LLC
Applications

SQL Outer Limits - Exploring New Worlds of Oracle Join Functionality

Outer joins add important query functionality to Oracle SQL, but they can become a source of confusion or unexpected results when complex relationships and multiple tables are involved. Join us to explore Oracle joins and discover how Oracle's traditional (+) outer join syntax translates to the new world of ANSI standard joins. We'll delve into the distinction between join conditions and filter predicates to understand how ANSI join structure can more clearly depict the business logic behind complex multiple table joins. These insights will be applied to practical query problems common in commercial off-the-shelf software packages and Oracle metadata queries.

--------------------------------------------------------------------------------

Lynn Munsinger, Oracle Corporation
Applications

Developing Cutting Edge Web UIs for Your Applications – the Easy Way

The Web 2.0 generation of applications has brought a new user experience to Web-based applications. Rich Internet Applications (RIA) are providing responsive and dynamic interfaces therefore, delivering better usability. Learn how to add rich UIs to new and existing applications with the new Oracle ADF rich-client components. See how this new technology drastically simplifies the development of advanced UIs. Learn about the new components, how they work, and how they can influence the design of your next user interface. In this session, we’ll demo building attractive and functional Web 2.0 user interfaces for Enterprise applications.

--------------------------------------------------------------------------------

Lynn Munsinger, Oracle Corporation
Applications

Rapid User Interface Prototyping for Rich Enterprise Applications

User interface mockups and prototypes are an essential part of the communication process needed for application design. But how do you create realistic mockups that explain your vision yet still reflect the real capabilities of the platform you have chosen? Using drawing tools can lead to designs that are difficult or even impossible to implement, and that concentrate on the basics such as colors, fonts, and layout, but neglect the crucial aspect of prototyping: user interactions with the UI. Fortunately, Oracle Application Development Framework comes complete with mockup capabilities that can be used to show how to build effective prototypes. Interested? Come to this session, and learn how it's done.

--------------------------------------------------------------------------------

Lynn Munsinger, Oracle Corporation
Applications

The Oracle Fusion Development Platform – an Overview

This session provides an overview of the components involved in developing Oracle Fusion Applications. The session covers Oracle JDeveloper, Oracle ADF, Oracle WebCenter and the Oracle SOA Suite and explains how they are integrated to create the Fusion architecture. A specific focus is placed on the development experience with demos illustrating the declarative and visual approach to enterprise application developmern. Learn how to leverage Oracle Application Development Framework (Oracle ADF) - A framework that simplifies the development of Java-based applications with built-in solutions to simplify the creation of both business services and user interfaces. See how you can leverage the technology today as well as getting your organization ready for the upcoming Fusion Applications.

--------------------------------------------------------------------------------

Shyam Varan Nath, IBM
Middleware

De-Mystifying OBIEE / Oracle Business Intelligence Applications

Shyam Varan Nath will simplify OBIEE and Oracle BI Applications such that attendees can evaluate the product suite in context of their own specific needs. The session will show a live demo of how to install, configure, and troubleshoot the BI Apps. Additionally, real world strategies will be discussed for successful roll-out of the related projects such that risks are minimized. Shyam will share several tips and tricks learned during several OBI Apps projects and will showcase how to obtain continuous peer support.

--------------------------------------------------------------------------------

Shyam Varan Nath, IBM
Applications

Honey, I Simplified the Master Data Management (MDM)!

Attendees will understand the role of Master Data Management (MDM) and the applicability to their environments. Using Oracle Customer/Product Data Hub, we look at the different components of MDM and their implementation details. Next, we will look at the impact of MDM to the existing ERP/application systems (data sources) and Operational and Strategic BI Reporting as targets.

--------------------------------------------------------------------------------

Shyam Varan Nath, IBM
Professional Development

Oracle Business Intelligence in the Cloud

The goal is to showcase the impact of futuristic technologies, such as Amazon Cloud, on Oracle Business Intelligence/OBIEE. Attendees will also learn about the impact of other Web 2.0 technologies, and how to stay current to make the best use of these in context of Oracle related professional development.

Back to the top
--------------------------------------------------------------------------------

David Peake, Oracle Corporation
Applications

Oracle Application Express 4.0

This session will cover all the exciting new features that are expected in APEX 4.0. Don’t miss the demonstration of Websheets, the premier new feature for business users, or the demonstrations on features such as dynamic actions, plug-ins, charts, improved application builder, tabular forms, error handling, and REST Web services. APEX 4.0 promises to include enhancements that will benefit every developer, from novice to expert, to be able to build, enhance, and maintain database-centric Web applications faster and easier.

Back to the top
--------------------------------------------------------------------------------

Kellyn Pedersen, I-Behavior
Database Administration

The Power of Parallel

As database sizes increase, DBAs are utilizing Oracle’s more advanced features to offer their businesses better performance. Oracle recommends as objects reach a certain size, to partition, and with partitioning, many DBAs and developers are venturing into the realm of parallel processing. Unlike other features in Oracle, there are different requirements for aspects of parallel processing, such as parallel DML vs. a parallel query or parallel DDL. Due to this, many are left with questions of what to look for when parallel processing does not occur, why performance degraded, or why performance is inconsistent. This presentation will cover the types of parallel processing, when to decide to utilize parallelism, and how to ensure the best performance when parallelism is invoked. Also covered: requirements to set up parallel processing in an Oracle Database; requirements and performance tuning of parallel DML (along with performance views to assist with managing and trouble-shooting); and Oracle Databases that utilize this feature.

Back to the top
--------------------------------------------------------------------------------

Marshall Presser, Oracle Corporation
Management Infrastructure

ASM Cluster File System—Cluster Storage for Non Database Files

With the increasing movement towards clustered databases, cluster aware storage plays an increasing role in the environment. In release 10g of the database, Oracle introduced Automatic Storage Management (ASM), a cluster aware storage paradigm for database files. In 11g R2, Oracle introduces the ASM Cluster File System (ACFS), a general purpose cluster file system for the storage of non-database files. ACFS is a POSIX compliant file system, built atop ASM, that can be used for shared Oracle Homes, BFILE contents, UTL_FILE directories, trace files, log files, user written script files, and so forth. ACFS is highly performant, easily managed, highly available, and provides a useful snapshot capability. In this presentation, we'll explore how such file systems are created, managed, and integrated with the Oracle Clusterware.

Back to the top
--------------------------------------------------------------------------------

Kenneth Ramey, SageLogix
Applications

Oracle APEX/BI Publisher Rapid Application Development Quick Start

Oracle Application Express (APEX) may be the answer for smaller shops looking to develop robust applications quickly and easily. Utilizing Oracle BI Publisher to augment the reporting capabilities of APEX will put a professional touch to a variety of APEX applications. BI Publisher requires an application server to serve up the reports generated. A low (no) cost option for this is Apache Tomcat. This is a tested configuration that will allow shops to leverage BI Publisher and APEX integration without the added cost of Oracle Application Server. This presentation will walk through the installation and configuration of BI Publisher, Apache Tomcat, and the steps to integrate BI Publisher with Oracle APEX. Finally, a sample application will be shown demonstrating the ease of creating and maintaining application forms and report templates.

Back to the top
--------------------------------------------------------------------------------

Ron Reidy, Reidy Database Consulting
Security

Oracle Security: Guidelines for an Effective Audit

Oracle security is more than applying CPU patches and marking items off a checklist. Bad configurations, installation issues, object permissions, and the PUBLIC issue all contribute to insecurity in applications and data exposure. In this session, attendees will receive an introduction to the need for securing Oracle Database instances, why security by following a checklist does not provide security, and the proper way to secure your data. This session will examine a fictitious application, and examine common vulnerabilities and the implications of those vulnerabilities.

Back to the top
--------------------------------------------------------------------------------

Kris Rice, Oracle Corporation
Applications

Manage and Version Your SQL and PL/SQL Files

SQL Developer provides tight integration with files on your file system and popular version control tools, such as Subversion, CVS, and Serena Dimensions. Whether you are writing SQL or PL/SQL and whether the detail is stored in the database or you have copies in the file system, the bigger the project you work on, the more likely you are to need some form of file management. The more people working on the same project, the larger the project, or if you are working on multiple projects, the more important it is that the files you work with are well managed, secure, and, if possible, placed under version control. In this session we look at file management, specifically at SQL and PL/SQL files, and how to place them under source code control. We’ll look at best practice and offer advice based on experience gathered from within an internationally situated development team. We look at the impact other team members have on checking in code and offer advice on how to share files with colleagues. The presentation is supported by demonstrations throughout, using Oracle SQL Developer as the client to access the files in the file system, and Subversion, an open source version control tool, for managing the files

--------------------------------------------------------------------------------

Kris Rice, Oracle Corporation
Applications

Oracle SQL Developer Unit Testing: Testing Your PL/SQL Code

Oracle SQL Developer supports the development of SQL and PL/SQL code. You can create, edit, compile, and run your code using the editors provided. Creating and compiling code is only one aspect of developing code. Code that has been successfully compiled is not necessarily good or even accurate code, so debugging, tuning, and testing are as important as the initial phase of writing. Prior to SQL Developer 2.1, the rich debugging capabilities allowed you to step into your code to debug and trap errors; a process you need to repeat for each case or whenever you update the code. SQL Developer 2.1 introduces Unit Testing, a powerful feature that provides a framework or test harness for you to develop a suite of tests that can be run and rerun. Testing code using a framework means that you can create a wide variety of tests and rerun them whenever needed, for example, when you change or update the code. It means you can test for regressions and unusual or edge cases. In this session, we show you how to use SQL Developer Unit Testing and how to create and run unit tests.

Back to the top
--------------------------------------------------------------------------------

Mark Rittman & Stewart Bryson, Rittman Mead America
Applications

A DBA and Developers' Guide to Oracle Warehouse Builder 11gR2

This presentation, aimed at database administrators and developers, takes delegates through key new features in Oracle Warehouse Builder 11gR2 including support for heterogeneous data sources and mappings, changed data capture, in-database OLAP, interfaces with Oracle Master Data Management and BI tools, and Web services. This is a technical, demonstration-led session that explains how traditional Oracle developers can use these capabilities and boost their productivity, when working on data integration and data warehousing projects.

Back to the top
--------------------------------------------------------------------------------

Edward Roske, interRel Consulting
Applications

Achieving a Common Goal: Creating an Oracle EPM Center of Excellence

At most companies, there are Hyperion products spread throughout various departments. Finance may control Hyperion Financial Management, the budgeting department owns Hyperion Planning, and IT controls Essbase. In many cases, several different departments all have expertise in the same product (Essbase, commonly). Wouldn’t it be better to bring all of these groups together under one common umbrella that can share best practices, dimensions, data, and most importantly, experience?

An Oracle EPM (or Hyperion) Center of Excellence is within your reach, and in this one hour presentation, you will learn the steps to begin creating one. What areas should come together first? Do I hire new people or bring my existing ones under one common group? How do I span excellencies around the globe? Can I take different Hyperion applications and cubes and give them common hierarchies? Are there recommended ways to share data between all of my products? Who should lead this group?

Once you’ve implemented an Oracle EPM, BI, or Hyperion center, you’ll find that your administrative costs go down, maintenance is simplified, your users are happier, your consulting costs decrease, and your time to roll out new Hyperion projects is dramatically reduced. Don’t miss this important session to truly achieve excellence in performance management for your organization.

--------------------------------------------------------------------------------

Edward Roske , interRel Consulting
Applications

Implementing HFM in 6 months or Less?

The consulting companies of the world don't want you to know this, but it shouldn't take twenty-four, twelve, or even six months to implement HFM. There are some companies who implement HFM in six months or less (this session even knows of one who did it less than ninety days). So what are they doing right and how can you follow the same steps to getting HFM up and running with happy users? This session will show you how to save money, chop your implementation time in half using project management and application design best practices, and in today's economic climate, probably save a few jobs at your company too.

--------------------------------------------------------------------------------

Edward Roske, interRel Consulting
Applications

Integrating Essbase and OBIEE+ with Your Data Warehouse Strategy

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution. Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. This presentation will show how the OBIEE+ Reporting and Analysis components provide a single interface into any type of data source, combining data from your data warehouse and data marts into nicely formatted reports, user-friendly dashboards, and easy-to-use analytic screens. Check out this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

Back to the top
--------------------------------------------------------------------------------

Robyn Sands, Cisco Systems
Applications

Measuring for Robust Performance

The first step in any performance improvement project is benchmarking the existing performance level. What you measure, how you measure it, how you analyze the results, and how you define your goals will have a significant impact on your project's success. Do you measure an individual process or the overall throughput? Do you use the 10046 trace, Stats Pack, ASH, or AWR? And how do you identify the critical information within your performance data and provide proof of the improvements to the business? The answers to these questions usually depend on your experience, the available tools, and the opinions within your workgroup. The answers should be based on the profile of the system under evaluation and the business needs. This session will present multiple measurement methods and how they can be used most effectively to achieve robust performance.

Back to the top
--------------------------------------------------------------------------------

Joze Senegacnik, Private Researcher
Database Administration

RMAN Tips

This presentation will cover some of the not very frequently used commands which can help DBA to prepare more efficient backup/recovery procedures. In the second part, we will discuss how one can build an imitation of a standby database which can be used in case of failure on a primary database without a significant downtime and therefore, saving a lot of money for licenses.

--------------------------------------------------------------------------------

Joze Senegacnik, Private Researcher
Database Administration

Services – Why Should One Use Them?

Services are most frequently used in conjunction with RAC. However, one can and should use services also in single-instance environments especially for managing and monitoring database workload and performance monitoring. This presentation will discuss all the required steps to create and manage services and utilize them for database monitoring and workload management.

Back to the top
--------------------------------------------------------------------------------

Sumit Sengupta, Hewlett-Packard
Management Infrastructure

RAC Storage Case Study - Fiber Channel Versus NFS

Prior to 10g, Raw Device or third party cluster file systems were the only options for Oracle RAC or OPS. Starting with 10g, even with the popularity of ASM using Raw LUNS over FC storage network, NFS is often a much cheaper and viable option. In the case study, the same storage system was assigned as SAN and NAS to two RAC clusters. The architecture, setup, maintenance, backup, and performance were compared between these two with both 10g and 11g RAC installations. 11g Direct NFS capabilities and future directions for both Fiber Channel and NFS storage connections are discussed.

--------------------------------------------------------------------------------

Marc Sewtz, Oracle Corporation
Applications

Advanced Reporting and Charting With Oracle Application Express 4.0

Oracle Application Express (Oracle APEX) is the native Web application development framework for the Oracle Database. Since its inception in February 2004 as a feature of Oracle Database 10g, one of its core strengths has been to enable programmers and non-programmers alike to easily build sophisticated Web-based reports and charts on any kind of data stored in the Oracle Database. With Oracle APEX 4.0, Oracle is taking these features to the next level, introducing support for AnyChart 5, including Flash-based Map and Gantt charts and significantly enhanced presentation and printing features of interactive reports. This sessions introduces Oracle APEX 4.0 enhancements to charts, interactive reports, and classic reports, including an in-depth review of advanced report printing using Oracle BI Publisher and Apache FOP. We’ll look at the new and improved AnyChart 5 based charts types, built Gantt and as Map charts, and upgrade chart regions from previous versions of Oracle APEX. We’ll also go through the creation of custom print layouts using XSL-FO and Apache FOP and cover how to build an Oracle APEX application that allows for asynchronous scheduling and e-mailing of reports in PDF format.

--------------------------------------------------------------------------------

Marc Sewtz, Oracle Corporation
Applications

Multi-Row Data Editing with Oracle Application Express 4.0 Tabular Forms

Oracle Application Express (Oracle APEX) allows to declaratively create tabular forms performing multi-row update and insert operations on data in the Oracle Database. Tabular forms can be used to stand-alone or as part of master-detail forms. Tabular forms have been an integral part of Oracle APEX since its introduction with the Oracle Database 10g. Oracle APEX 4.0 introduces several enhancements and new features to tabular forms including: declarative validations; new form item types such as popup-key LOVs; radio groups and checkboxes; declarative multi-row operations and support for ROWID as an alternative to using primary keys for update; and insert and delete operations. In this presentation, we’ll review these new features, see how they can be utilized in new and existing Oracle APEX applications, and take a look at what has changed in the underlying reporting engine and associated public PL/SQL APIs.

Back to the top
--------------------------------------------------------------------------------

Craig Shallahamer, OraPub
Database Administration

Quantifying Oracle System Performance

Quantitatively representing database server performance allows Oracle performance metrics and performance mathematics integration resulting in a number of analysis benefits such as problem highlighting, graphical representation, and anticipating proposed performance solutions. This presentation demonstrates step-by-step how to quantify database performance, how to blend the metrics and performance mathematics, and how to represent the situation both numerically and graphically. You will also learn how to comfortably and confidently communicate using response time terms, numerics, and graphics.

--------------------------------------------------------------------------------

Craig Shallahamer, OraPub
Database Administration

Resolving the Free Buffer Waits Event

If you enjoy solving a difficult technical puzzle, then working on a system plagued by free buffer waits should get your adrenaline pumping! The free buffer waits event is intriguing because it takes a combination of database writer, IO subsystem, SQL, buffer cache configuration, and server process activity to manifest. Understanding this wait event is fascinating because it touches the very deepest parts of the Oracle architecture—the least recently used lists, the dirty lists, how blocks are brought into the buffer cache, and buffer "movement." Fortunately, with so many causes to this problem there are also many solutions. This presentation focuses squarely on resolving free buffer waits by concentrating on Oracle buffer cache internals, diagnosis using Oracle's wait interface, and solution development focusing on tweaking Oracle, the application (including the SQL), and the IO subsystem. This is a very practical yet deep internal presentation, filled with amazing discoveries about how Oracle works.

Back to the top
--------------------------------------------------------------------------------

This presentation is to explore various SQL performance issues encountered in the real world and to discuss the root cause for those SQL performance issues. 1. Review of cardinality, selectivity, and histograms. A must for every performance tuner to completely understand these concepts. 2. What to look for in a 10053 trace. How to effectively use 10053 trace files to identify the root cause of a SQL performance issue. 3. Bind peeking issues. 4. Effective use of system statistics to combat optimizer discrepancies. 5. Index efficiency and indices on non-selective columns. 6. Nulls and indices. 7. Issues with few hints such as ORDERED, INDEX, etc. Use of profiles and outlines to resolve these issues. 8. Subquery transformation and few optimizer features related to sub query transformation. 9. Predicate based first_k_rows mode. 10. Correlation issues.

--------------------------------------------------------------------------------

Riyaj Shamsudeen, OraInternals
Database Administration

Advanced RAC Troubleshooting

This presentation is to explore and troubleshoot various customer performance issues encountered in RAC environment. A few discussion points: 1. Review and understanding of AWR reports/statspack reports to troubleshoot global cache performance issues. Trend analysis for global cache traffic and performance using AWR/statspack tables. Also review of simple techniques to probe interconnect performance. 2. Understanding wait events in SQL trace files related to RAC such as gc cr grant 2-way, gc cr grant 3-way, gc multi block reads, etc. 3. Global cache object re-mastering: object re-mastering, various parameters influencing object re-mastering, and how to use it to tune performance. Wait events associated with object re-mastering. 4. Global cache waits and LGWR performance. LGWR performance is important in single instance databases and LGWR performance is even more critical in RAC instances. Discussion about GC performance issues due to LGWR performance issues. 5. Interconnect issues, lost packets, and AWR statistics. Identifying interconnect issues with database and OS statistics. 6. Troubleshooting performance issues with MTU/jumbo frames and jumbo frames mis-configuration issues. 7. Troubleshooting RAC background processes such as LMS/LMD etc. 8. Troubleshooting parallel query, interconnect, and PQ setup related performance issues. 9. Concurrency-induced global cache issues and few time-tested simple work-arounds. 10. Troubleshooting locking issues in RAC environments. 11. Bind peeking issues and RAC instances.

--------------------------------------------------------------------------------

Chen Shapira, Hewlett-Packard
Database Administration

Analyzing Oracle Performance Using Time Series Models

Time series is a sequence of measurements, collected at successive times. Time series analysis comprises powerful methods that describe the measurements and attempt to predict future data. Those methods reflect the fact that current values are derived from past values and are related more closely to more recent measurements. Since Oracle Databases are typically monitored at regular intervals for vital performance statistics, time series analysis can be easily applied to the collected data. The analysis can be used to find performance trends, to recognize regularly occurring peak loads, and to predict how often unacceptable performance will occur. This session will present the basic time series models. The audience will learn how to apply time series analysis to data already collected by Oracle and Linux using open source statistical analysis tool - R, and how to use the results of the analysis to plan capacity and define SLAs.

--------------------------------------------------------------------------------

Chen Shapira, Hewlett-Packard
Database Administration

What Every DBA Should Know About TCP/IP Networks

Databases do not run in a vacuum. Clients and application servers connect to the database, databases connect to storage systems and to each other. All those systems are communicating through (mostly) TCP/IP networks. It should be obvious that quirks on the network level will have a profound effect on the availability and performance of your database. Can you diagnose those problems? Do you know for sure when the problem is in the network? What do you do when your network admin will not listen? Armed with knowledge on how TCP networks really work and how database responds to changes on the network layers, a DBA can diagnose performance problems faster and communicate with the network admin in a more effective way. Oracle ACE, Chen Shapira, will share her stories of network-related mysteries. She will explain the underlying principles of network performance, explain how to use network diagnostics tools to approach database problems, and dive into the fine details of the SQLNET protocol.

Back to the top
--------------------------------------------------------------------------------

Laura Sprowls, Rolta-TUSC
Professional Development

Problems and Solutions Facing SOA Implementations

As the SOA world continues to evolve, new challenges come to light, while others fall by the wayside. For example, a year ago, many IT managers either didn't understand SOA, or more likely, didn't understand why it was important. Today, almost all IT managers understand that moving towards SOA is important—what is less clear is how to actually go about the implementation. This discussion will cover obstacles and their possible solutions as applied to today's environment.

--------------------------------------------------------------------------------

Laura Sprowls, Rolta-TUSC
Applications

Agile SOA: Is it Possible?

Based on the economy, it appears that many companies are avoiding large projects, which historically eliminates SOA projects. However, it is possible to take an Agile approach to an SOA implementation. This transfers into delivery of a number of smaller scope, smaller budget, shorter delivery time projects. An Agile approach allows us to show a much faster ROI on budget dollars spent on these projects. This presentation will also include a case study on how an SOA project was accomplished using Oracle tools and an Agile methodology.

Back to the top
--------------------------------------------------------------------------------

Mike Swing, TruTek
Database Administration

SQL*Net Dead Connection Detection

In a recent load test of the Oracle Application Release 11.5.10.2, Oracle Time and Labor module, we simulated time card entries and approvals for four hundred simultaneous users. The generated wait events and subsequent wait times indicated the top three performance improvements consisted of the following: 1. run statistics 2. purge workflow 3. resolve blocking locks. The blocking locks are primarily caused by abnormally terminated processes that refuse to release database locks when the process terminates. The first two performance techniques are fairly well known. However, the typical process to remove blocking locks is performed manually by the DBA at the command line by querying the session and serial number of the process and then killing the specific database session. This manual approach takes time for the user to recognize there is a problem, and more time for the DBA to find the session information and kill the session. The use of Dead Connection Detection will automatically remove any dead database connections for any application that can recognize a dead process. The problem is, the database considers the SQL*Net connection to be active and by default, the Transparent Network Substrate can’t determine the status of the database connection. By setting parameters in the sqlnet.ora and tnsnames.ora files, dead connection detection can easily be enabled.

--------------------------------------------------------------------------------

Mike Swing, TruTek
Database Administration

The Release 12.1 Upgrade is EASY

This presentation is primarily a technical discussion about the R12 upgrade. We will discuss the pre-upgrade functional tasks, post-upgrade functional verification tasks, pre-upgrade technical tasks, post-upgrade technical tasks, downtime reducing methods, and cover the pitfalls encountered during the upgrade. Changes to the architecture will be presented and the implications investigated. Typical upgrade steps: functional staff understand the new functionality of Release 12 determine gap/fit; design custom processes; develop detailed test scripts; verify detailed testing has been performed; perform pre-upgrade downtime reduction steps; complete the post-upgrade verification steps; determine functional training requirements approval management R12.1 functional new features technical staff plan for the R12.1 upgrade; develop a plan to migrate/replace customizations; plan for new hardware/rehosting to new operating system; Perform the Upgrade Implement customizations Develop new custom process as designed by the functional staff; and determine technical training requirements XML Publisher BPEL OA Framework.

Back to the top
--------------------------------------------------------------------------------

Todd Trichler, Oracle Technology Network (OTN)
Database Administration

Oracle on Linux Installfest

Join OTN as we show how to install Enterprise Linux and configure it for installing Oracle 11gR2 Database, SQL Developer, APEX, Fusion Middleware, and Oracle VM. Watch as we demo the latest techniques for using JeOS and the new template builder to build streamlined secure templates. With just enough OS, a secure minimized OS, developer and ISVs can now easily build a full stack virtual machine or Oracle VM Template on top of a small footprint, Enterprise operating system, that's freely redistributed and backed by Enterprise-class support. Come join us. Watch the demos. Pick up the Installfest software kits, including tips, interviews with Oracle's engineers, and more.

Back to the top
--------------------------------------------------------------------------------

Russ Tuttle, Quest Software
Database Administration

Oracle Utilities as Vital as Ever

Why are books like the recent, "Advanced Oracle Utilities: The Definitive Reference," imperative for today’s DBAs and senior developers? The answer: Oracle has become so robust and complex, where many new features are implemented, not as SQL commands, but as either PL/SQL packages and/or stand alone utilities. Thus, to best leverage all that Oracle has to offer, one must know all those non-SQL command interfaces for those new features. This presentation will demonstrate a few critical examples of such features and their usage. The goal will be to inspire attendees to realize that SQL alone is no longer sufficient; there are many other commands and/or PL/SQL packages to master.

--------------------------------------------------------------------------------

Steven Wille, Great-West Life
Professional Development

Work Harder, Smarter, and Faster: Survive and Thrive in a Challenging Economy

Get more done on a lower budget, with fewer people, in less time, and deliver higher quality. Like it or not, this is what we are asked to do today, and we are expected to do it with a smile, keeping the customer happy. Tired old time management techniques won't get us there. We need fundamentally new perspectives where the 80/20 rule works with us rather than against us. To make the critical decision on where to spend precious time, we will apply the 3-Filters discipline from the book, “Colorful Leadership,” looking at each situation from three perspectives: quality, innovation, and people. With this, we will appear to be working harder and faster without burning the team out. The key to success is to get the right things done rather than spinning our wheels on tasks that don’t matter all that much.

Back to the top
--------------------------------------------------------------------------------

Jeremiah Wilton, Blue Gecko, Inc.
Management Infrastructure

High Performance Oracle 11g in the Amazon Cloud

What is Cloud Computing, and how does it relate to Oracle technology? With so many companies claiming that their technology is part of the cloud, it can be difficult for DBAs, developers, and architects to separate the marketing-speak from the actual technical details. After reviewing the various types of architectures that are commonly called Cloud Computing, we focus on the Amazon Elastic Computing Cloud (EC2). Using live examples and demonstrations, we show the various ways to manage and deploy computing resources for Oracle. Cloud Computing is a new architecture with unique deployment, performance and management challenges. We focus on how those deploying Oracle on the Amazon Cloud can overcome those challenges and create a high-performance, Oracle service using Amazon’s dynamic, scalable, professionally-managed architecture. Get ready for a world free of capital hardware expenditures and high, new project deployment costs. Get ready for a world where running Enterprise-class Oracle services costs pennies a day.

Back to the top
--------------------------------------------------------------------------------

William Wimsatt, Wells Landers Group
Database Administration

Revisiting the Practice Data Modeling

Relational data modeling has been around since the 1970's, generally recognized as starting with Peter Chen's notation. Since then, RDBMS technology has proliferated into almost every facet of the Enterprise information infrastructure. How have we progressed in the last thirty plus years? We have 3NF, dimensional models, and data vaults. How has conceptual, logical, and physical modeling changed? Have we gotten jaded and lazy from our everyday use of the technology? This presentation will present the practice of data modeling, and describe its use and purpose in the modern corporation.

Back to the top
--------------------------------------------------------------------------------

Graham Wood & John Beresniewicz, Oracle Corporation
Database Administration

The ASHes of Time?

Active Session History (ASH) was introduced in Oracle Database 10g as part of the instrumentation to support the Automatic Database Diagnostic Monitor (ADDM) and has been enhanced in each subsequent release. The sampled data in ASH allows us to do highly-detailed performance analysis in many different dimensions (session, SQL, application, etc.). Examples will be presented of using ASH to identify the source of performance problems with emphasis on using the newer capabilities.

Back to the top
--------------------------------------------------------------------------------

Tom Wright & Babu Rallapalli, Oracle Corporation
Middleware

Best Practices for Your Application Server Migration to Oracle Fusion 11g MiddleWare

What is Fusion? What is Fusion Middleware? What does it mean to migrate to 11g MiddleWare and why would you move to 11g? This session will cover the Application Server to WebLogic migration, changes to the WebLogic server, bundled product updates, J-Rockit, and more. This is a “Best Practices” session that will guide you through the migration and ensure that you can find the relevant information, documentation, and tips necessary to make the transition to Fusion MiddleWare 11g a success.

Back to the top
--------------------------------------------------------------------------------

Training Days 2010 Presentation Summaries and Papers

Training Days 2010 Presentation
Summaries and Papers