Click on a link below to go to session category or presenter.
________________________________________________________________________________________________________________________
SESSION CATEGORIES:
Application Design
Application Development
Business Intelligence / Data Warehousing
Database Administration
Middleware
Package Software Support
Professional Development
Web, Intranet/Internet
Ann Horton, Oracle Corporation
Session: 12 - 4:00 pm to 5:00 pm
Application Design - All
Oracle Data Integrator (ODI) is a high-performance, flexible data integration platform that addresses today's pervasive data integration requirements. ODI provides the capability to quickly integrate data from disparate systems, and is being used to meet the full spectrum of today's data integration challenges. ODI, a key component of Oracle's Fusion Middleware, is being teamed with SOA, Oracle Fusion Applications, Oracle BIEE, Oracle Essbase and Hyperion products, and other Oracle products. This presentation will present the capabilities of ODI and walkthrough the use of ODI to design and develop an ODI transformation scenario.
Debra Lilley, UKOUG/Fujitsu
Session: 2 - 10:30 am to 12:00 noon
Application Design - All
As Oracle gets ready with Fusion Applications I am proud to have had a preview. What blew me away was the vision; all of the technology is here today and we will look at the skillsets required and how they are brought together. A joint presentation from both the application and technology perspective.
Chris Ostrowski, TUSC--A Rolta Company
Session: 6 - 5:00 pm to 6:00 pm
Application Design - Intermediate
Web Services are the foundation of service-oriented architecture (SOA). Being able to create Web services from your existing applications can be a steep technical challenge, however. Web Services make use of numerous technologies (such as Java, XML, SOAP, et al) that many Oracle developers are not familiar with. This presentation will explain what Web services are, how to create them easily using both Oracle and commercial tools, and how to begin constructing your SOA environment.
Bradley Brown, TUSC-A Rolta Company
Session: 10 - 1:30 pm to 2:30 pm
Application Development - All
This presentation will focus on the things you really need to know and care about with Web Services. This presentation will focus on a practical example of a Web Service application of the future.
Bradley Brown, TUSC-A Rolta Company
Session: U1 - 1:00 pm to 5:00 pm
Application Development - All
In this full-day hands on session, you'll learn to use APEX from concept to delivery to support. We'll start with an existing "database" (i.e. an Excel spreadsheet) and build a real world application from the ground up. We'll also look at how APEX was used to solve specific business problems such as performing online property validations, keeping track of insured pilots, bug tracking, Agile development tracking, getting people to RSVP to monthly events without having to call them, and others. This session will discuss and demonstrate the functional requirements, how these applications were extended over time, the net results, and cost savings. APEX is a declarative web-based application development and deployment environment. It's a powerful and easy way to quickly develop a database-centric Web application. You can install APEX on your own machines or run it in a hosted environment on Oracle's apex.oracle.com site. All development (construction of pages) is done through the browser interface. You can use the SQL Workshop and the Data Workshop to run SQL and add data to your environment. This easy-to-use tool will impress you in no time at all! PL/SQL developers and DBAs love Application Express! This presentation gives the participants a good introduction and great hands on experience with the APEX development environment, as well as a good idea of the power that it contains to create quick, powerful Web application in a very short time. Brad will bring a server that has APEX installed along with a wireless network router that everyone will connect to for the class. You'll need to bring your own laptop that has a wireless card that can connect to his network. You can share with someone else in the class if you would like, but the best experience is for you to do the typing. SQL and PL/SQL knowledge will be beneficial, but not absolutely necessary. This class is going to be limited in size, so sign up quickly!
Steve Callan, LodgeNet
Session: 3 - 1:30 pm to 2:00 pm
Application Development - All
No abstract
Bill Coulam, Church of Jesus Christ of Latter-day Saints
Session: 7 - 9:00 am to 10:00 am
Application Development - All
Come learn about Oracle Text and take some readily useable code examples home with you! Many Oracle practitioners have never had a need for Oracle Text, or so they thought. In reality most shops have or would have users clamoring for the advanced search capabilities provided by Oracle Text if they only knew they existed. We will briefly cover the major types of applications that can be built upon or enhanced by Oracle Text. But we will spend the majority of the hour diving deep into live demos and the code behind them. We'll spend some time being impressed by Text's search goodies like stemming, fuzzy, prefix, substring, multi-column, and multi-table (user datastore). CONTEXT grammar and CONTAINS queries will be covered as well. CTXCAT and CTXRULE systems will not be covered.
Paul Dorsey, Dulcian, Inc.
Session: 6 - 5:00 pm to 6:00 pm
Application Development - Intermediate
The Oracle Fusion Technology stack is large and complex encompassing many components. Some parts are free or nearly so such as JDeveloper, whereas other portions carry large licensing fees (WebCenter). What portions of the Fusion Middleware stack are organizations really using? How have their projects fared so far? This presentation will discuss the results of a number of projects from organizations that are using one or more parts of the Fusion Middleware technology stack.
Tony Golden, Douglas County Schools
Session: 1 - 9:00 am to 10:00 am
Application Development - Intermediate
Developing a Web service using BPEL to call an Oracle stored procedure will be demonstrated. The presentation will then address further integration possibilities using BPEL, SQL Server, and Java Stored Procedures to accomplish the same goal.
Sue Harper, Oracle Corporation
Session: 8 - 10:15 am to 11:15 am
Application Development - Novice
SQL Developer provides database developers with a powerful tool for database tasks. Users can browse, create, edit, and delete Oracle database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; run reports and place files under version control. Time does not allow for every feature to be discussed, so the primary focus of the session is the demonstration which walks through a series of tasks users may encounter when working with the database. Supported throughout by source code control, the demo includes code editing support in the SQL Worksheet, how to create and edit database objects, and run reports. We look at migrating from a non-Oracle source and review existing Data Models.
Sue Harper, Oracle Corporation
Session: U1 - 1:00 pm to 5:00 pm
Application Development - All
SQL Developer provides database developers with a powerful tool for database development tasks. Users can browse, create, edit, and delete Oracle database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; run reports and place files under version control. Using a combination of presentation and hands on, this session walks users through various aspects of the tool. We'll start with an overview and look at the general features of the product, with a focus on new features. This is followed by a drill down into features such as PL/SQL editing and debugging, building User Extensions, using Version Control, and interacting with Application Express. We'll close with an overview of SQL Developer Data Modeling and an opportunity to try out the product. In each of the sections, attendees will have a choice of hands on sessions to work with. Throughout, we will be using the latest release of SQL Developer, pointing out the latest new features introduced.
Dan Hotka, Training Specialist
Session: 3 - 1:30 pm to 2:00 pm
Application Development - All
This presentation will be packed full of practical examples from Dan's book, The TOAD Handbook, and is a 'must see' for anyone involved with Oracle development.
Dan Hotka, Training Specialist
Session: U1 - 1:00 pm to 5:00 pm
Application Development - Novice
Understanding how Oracle arrives at the Explain Plan is a definite prerequisite to doing any furthur SQL statement tuning. Attend this presentation to understand exactly how Oracle arrives at execution plans and gain a better understanding of how Oracle works.
Kurt Kellner, ECS
Session: 4 - 2:15 pm to 3:15 pm
Application Development - All
There are a lot of frameworks available to build Web-enabled java applications. When you consider all the parts of a front-end application, the choices that need to be made can become overwhelming. Everything from choosing a persistence framework, a Web-service library, a screen-flow, field validation and format framework, and for a modern application, an Ajax library must be selected. Does your project have time to research which of the many frameworks should be used? And what about integrating all these components together? Are the frameworks compatible and working seamlessly together? What is needed is a solution that can be installed and immediately provide a developer the tools to build an application where all the underlying frameworks and libraries work seamlessly together. Welcome to Oracle Fusion Middleware 11g, specifically the Application Developer Framework (ADF). If you've looked at 10g ADF, it's time for another look at what the newly released 11g has added to the toolbox. ADF provides a rich framework to build a front-end application. Although the framework includes many needed components for an application, for the purposes of this presentation we will concentrate on the robust Ajax enabled UI components that have been added to 11g. If you think its complex to create an Ajax enabled UI, think again.
John King, King Training Resources
Session: 11 - 2:45 pm to 3:45 pm
Application Development - Intermediate
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 Oracle11g/10g 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, virtual columns, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL Result Cache, case/accent-insensitive query, regular expressions, expanded LOBs, new data types (BINARY_FLOAT, BINARY_DOUBLE, etc.), new statistical functions, model clause, and the recycle bin. Attendees will be better equipped to create new applications or modify existing applications to take full advantage of Oracle11g/10g.
Peter Koletzke, Quovera
Session: 2 - 10:30 am to 12:00 noon
Application Development - Novice
Oracle's current focus on implementing database and development features based on the Java language may have you thinking that you need to learn Java. However, if you are mainly familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. Also, you may wonder about where Java fits in the industry and how much Java you really need to know to create Web applications. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures-classes and methods-as well as control statements, exception handling, datatypes, and variables. This explanation will act as a springboard for further study. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures-classes and methods-as well as control statements, exception handling, datatypes, and variables. This explanation will act as a springboard for further study.
Peter Koletzke, Quovera
Session: U1 - 1:00 pm to 5:00 pm
Application Development - All
These days, development shops have been mandated to develop new applications using Java Platform, Enterprise Edition (Java EE) Web technologies. This proves to be a challenge for traditional application developers because the main Java EE languages and the style of development are very different. Oracle Corporation is developing the next wave of Oracle Applications (E-Business Suite, now Oracle Fusion Applications) using JDeveloper 11g and Application Development Framework (ADF) technologies such as ADF Business Components and ADF Faces Rich Client. JDeveloper 11g helps Web developers from every discipline transition more easily than ever to Java EE Web development. Its declarative and visual development environment rivals that of traditional tools, yet it creates standard Java EE code that can be deployed on any Java EE server such as Oracle Application Server and WebLogic Server. This training session, presented by the co-authors of the Oracle Press book Oracle JDeveloper 10g for Forms and PL/SQL Developers, explains how to use JDeveloper and ADF with the technologies Oracle is using for fusion applications. It provides an introduction to and best practices for the use of JDeveloper's visual and declarative tools. It demonstrates how you can use JDeveloper's visual and declarative environment to create the Model layer, using ADF Business Components, which allow you to easily query, insert, update, and delete data; as well as the View and Controller layers, using ADF Faces Rich Client and JSF, which supplies the AJAX-enabled, Web 2.0 user interface and the ability to interact with user events such as button clicks.
Darl Kuhn, Sun Microsystems
Session: 11 - 2:45 pm to 3:45 pm
Application Development - All
Many companies use multiple database vendors to address varying requirements in an increasingly tough business environment. This presentation shows how to implement and use MySQL from an Oracle DBA's perspective. Details will be given on DBA tasks such as installation, secure setup, user management, monitoring, performance, and troubleshooting a MySQL database.
Thomas Kyte, Oracle Corporation
Session: 1 - 9:00 am to 10:00 am
Application Development - All
From the dbms_obfuscation_toolkit, to dbms_crypto to transparent data encryption at the column level to tablespace encrypt and data pump encryption, we'll cover them all. We'll investigate which techniques should be used and under what circumstances they should be used. We'll see how the keys are managed by the Oracle Database-or not in the case of the DBMS_ packages. We'll discuss "why" you encrypt and when encryption just does not apply.
Dustin Marx, Raytheon Company
Session: 12 - 4:00 pm to 5:00 pm
Application Development - Novice
Adobe Integrated Runtime (AIR) is a platform that allows developers with Web development experience to easily bring their skills to desktop application development. AIR combines technologies commonly associated with the Web (such as HTML, CSS, JavaScript, Flex, and ActionScript) with advantages associated with the desktop (such as local storage and local file system interactivity). Applications written for AIR can take advantage of the ability of AIR to run on several different operating systems and provide a consistent user experience across those different environments. AIR also allows developers to easily migrate applications already written for the Web to the desktop. This presentation will provide an overview of Adobe Integrated Runtime and outline some of the main reasons a developer may choose to use AIR. The presentation will include some simple examples of AIR, including the adaptation of a Flex-based application into an AIR application and the adaptation of an Ajax/DHTML application into an AIR application.
Duncan Mills, Oracle Corporation
Session: 9 - 11:45 am to 12:45 pm
Application Development - Novice
This session provides an overview of the new Oracle Application Development Framework (Oracle ADF) 11g release. 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, Oracle ADF, with Oracle JDeveloper, provides a visual and declarative development approach that provides unparalleled productivity for building enterprise applications. Oracle ADF is the framework at the base of Oracle's upcoming Fusion Applications and has been used by multiple organizations to increase their development productivity.
Cary Millsap, Method R Corporation
Session: 8 - 10:15 am to 11:15 am
Application Development - Intermediate
To many application developers, a database is just a "data store" with an API that they call when they need to persist an object. It's an abstraction that makes sense from one perspective: in a world where you're expected to write dozens of new features every day in Java, PHP, or C#, who has the time or the inclination to dive into what's going on deep inside the Oracle Database? As a result of this abstraction, though, developers sometimes inflict unintended performance horrors upon their customers. The good news is that you can avoid most of these horrors simply by better understanding a bit more about what's going on inside the Oracle kernel. The trick is knowing which details you need to study, and which you can safely learn later. This presentation describes, from a developer's perspective, the most important code paths inside the Oracle kernel that can make the difference between an application that breaks down under load and one that can scale to thousands of users.
Lynn Munsinger, Oracle Corporation
Session: 1 - 9:00 am to 10:00 am
Application Development - Novice
The new version of Oracle JDeveloper 11g along with Oracle ADF 11g takes productive development to a new level. Come and learn how you can build standard based SOA applications faster than ever before. This session reviews various new capabilities added to JDeveloper and uses demos to illustrate the development experience.
Chris Ostrowski, TUSC--A Rolta Company
Session: 12 - 4:00 pm to 5:00 pm
Application Development - Intermediate
Oracle JDeveloper has become Oracle's flagship development tool. It covers so many Web-based technologies that it can be overwhelming to learn and understand. Oracle has, however, made it relatively easy to get started using the product by incorporating sophisticated "under-the-covers" technologies. These technologies make it easy for developers to create relational data-driven applications in Oracle JDeveloper while writing a minimum of code. The presentation will outline those technologies along with the EVA paradigm that will allow organizations to start building Oracle JDeveloper applications immediately.
Ernst Renner, Vgo Software
Session: 4 - 2:15 pm to 3:15 pm
Application Development - All
This presentation is on how to realize the value of SOA and Web technologies when you are living in the world of Forms. We will outline the options ahead of people when considering upgrading their Forms or converting them to ADF, and insight on what makes sense now and down the road. The intent is to convey the landscape of Forms, where it is going, and how someone can thoughtfully embrace the promise that Fusion, through ADF, can bring to an organization. This session is applicable to developers, architects, or managers of any level.
Kris Rice, Oracle Corporation
Session: 1 - 9:00 am to 10:00 am
Application Development - Intermediate
This session focuses on SQL Developer's PL/SQL support, initially reviewing editing PL/SQL, code templates, and snippets, and is followed by PL/SQL debugging, with particular reference to debugging remote applications. SQL Developer includes a variety of code formatting features that enhance working on the SQL Worksheet editor or the PL/SQL code editor. The session also reviews a variety of PL/SQL focused features, such as code refactoring and the PL/SQL hierarchical profiler, introduced in Oracle Database 11g. Finally we'll review a number of the reports available for reviewing and searching code.
Kris Rice, Oracle Corporation
Session: 9 - 11:45 am to 12:45 pm
Application Development - Intermediate
Oracle SQL Developer provides database developers a convenient way to perform various database tasks and to manage database objects. This session focuses on a few aspects of the tool that users are either unaware of or use less frequently. These include Reporting, user defined extensions, migrations, Oracle Application Express integration, and version control. By focusing on a few features, we can pay more attention to some of the detail, such as reviewing the advanced reporting capabilities by allowing users to introduce graphical displays and master-detail reports. We will demonstrate building more complex master-detail reports, passing parameters, and drill down capabilities. We'll also show how you can tune SQL and the database using some of the latest reports introduced. We show you how to add new features to the product using SQL Developer's extensibility and delve into our own migrations extension. For Application Express users, we show a number of useful integration points between the two products.
Michael Rosenblum, Dulcian, Inc.
Session: 10 - 1:30 pm to 2:30 pm
Application Development - Advanced
The concept of using connection pools involves keeping a limited number of persistent sessions that serve incoming requests on "first-in/first out" basis. This strategy can be applied to some of the most critical issues (both client/server and N-tier) currently faced by existing database system technologies: However, despite handling old problems effectively, the use of connection pools introduces some new ones: This presentation discusses some core use cases implementing connection pools and including the topics of resource utilization, effective session management, read/write consistency, etc. Real-life examples will be included to pinpoint common hidden traps.
Skip Sauls and Manish Devgan, Oracle Corporation
Session: 3 - 1:30 pm to 2:00 pm
Application Development - Novice
Web 2.0-enabled collaborative applications are penetrating the enterprise as they provide today's knowledge worker the means to effectively collaborate with other employees to get their work done. A major challenge that today's enterprises face is how to select the right framework for building such applications. Come to this session and learn how WebCenter can give you a head start in building collaborative applications that leverage its standard-based framework and rich set of Web 2.0 services.
Bert Scalzo, Quest Software
Session: 2 - 10:30 am to 12:00 noon
Application Development - Intermediate
TOAD users, come and see how to maximize both developer and DBA productivity using powerful shortcuts, overlooked features and advanced capabilities. This session will have you saying "wow-I didn't know TOAD could do that (and so easily!)" You'll learn easy yet extraordinary ways to make both new and veteran TOAD users more productive, and thus increase the value of TOAD usage within your company. Our goal will be to show you how to get the most out of your TOAD experience. And this session is being brought to you by people who know TOAD best-the product manager and product architect. There might even be time for some product future roadmap discussion and upcoming feature previews!
Sumit Sengupta, Hewlett-Packard
Session: 10 - 1:30 pm to 2:30 pm
Application Development - All
Not sure which process is holding onto the listener port or preventing a filesystem from being unmounted? What is the PID of the offending session on the application server outside the database server? How to find system and hardware configuration information on various flavors of Unix ? How to set up SSH keys or port forwarding to use Toad through a firewall or setup Unix Desktop on your laptop even though the server has no monitor or video card? Want to clean up the IPC resources of an Oracle instance that crashed without killing a running instance? Can't delete a file even as root on Linux? You'll learn many such tips and tricks in this session.
Marc Sewtz, Oracle Corporation
Session: 10 - 1:30 pm to 2:30 pm
Application Development - Novice
Oracle Forms was and still is a very popular development tool, but many organizations are looking to modernize to a purely Web-based solution. This session demonstrates the latest Oracle Forms conversion tool being built directly into Oracle Application Express. Starting with the Forms XML conversion file, the presentation demonstrates how you can generate HTML pages within Oracle Application Express. Oracle Forms developers will feel right at home with Oracle Application Express, given its similar declarative nature and use of PL/SQL.
Marc Sewtz, Oracle Corporation
Session: 7 - 9:00 am to 10:00 am
Application Development - Novice
This session will demonstrate advanced techniques in outputting your information to both the screen and printable reports. First will be a demonstration on expanding the basic functionality available with Interactive Reports. This will be followed by utilizing Flash charts with multiple data sets and some of the lesser used capabilities. Then to round it off developing complex reports with BI Publisher will be demonstrated.
Jason Straub, Oracle Corporation
Session: 8 - 10:15 am to 11:15 am
Application Development - Advanced
Many organizations have begun either implementing or evaluating SOA strategies to tie together heterogeneous systems. It is important that these organizations use development tools that support that strategy. Application Express has supported consuming Web services since version 1.5. Starting with version 3.0 the feature Manual Web References was introduced to allow for maximum flexibility in interacting with Web services. This session will cover interactions with Web services based on consuming a WSDL as well as manual Web references. The demonstrations in this session will utilize a variety of Oracle products such as BPEL, JDEV, XML DB Native Web Services, and Stellent. The session will also cover cases where neither WSDL-based nor Manual Web references are appropriate and what you can do to still interact with Web services in Application Express. Finally, there will be a preview of Web service support planned in the next major Release of Application Express.
Hermann Baer, Oracle Corporation
Session: 9 - 11:45 am to 12:45 pm
Business Intelligence / Data Warehousing - Intermediate
This session will outline the best practices for deploying a data warehouse on Oracle Database 11g in a clear "how-to" fashion, including detailed examples of schema design, partitioning strategies, and parallel query.
Hermann Baer, Oracle Corporation
Session: 11 - 2:45 pm to 3:45 pm
Business Intelligence / Data Warehousing - Intermediate
Partitioning is a key technology for addressing the requirements of large data volumes, for data warehouse as well as OLTP environments. Benefits are not only for performance, but also increasingly for manageability and Information Lifecycle Management. This session will reveal best practices and designs used by successful customers. Furthermore, it will provide an insight into less known details of how to get the best leverage out of Oracle Partitioning.
Matthew Braunschweig, Wells Landers Group
Session: 4 - 2:15 pm to 3:15 pm
Business Intelligence / Data Warehousing - Intermediate
This session will help you understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization. Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads. Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query. The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool. This presentation will present data quality, and formation of a data quality program. The presentation will cover the following topics: data quality misconceptions, levels of data quality, data profiling and data dictionaries, and creating data stewardship/governance.
Bradley Brown, TUSC-A Rolta Company
Session: 7 - 9:00 am to 10:00 am
Business Intelligence / Data Warehousing - All
Imagine building a virtual ESB based on SOA! This presentation demonstrates a virtual ODS/data warehouse and virtual ESB, which will provide you with the best of both worlds.
Ben Bruno, STR Software
Session: 6 - 5:00 pm to 6:00 pm
Business Intelligence / Data Warehousing - All
TLearn how to expand native Oracle EBS functionality (workflow, forms, and database technology) to automate e-mail/fax/print delivery of any document/volume of documents. Presentation includes: Pros/cons of the native e-mail/fax functionality of Oracle EBS and XML Publisher; advanced features such as the following: secured, confirmed e-mail delivery printing of Oracle database attachments; case studies presented by the customers themselves.
Steve Callan, LodgeNet
Session: 7 - 9:00 am to 10:00 am
Business Intelligence / Data Warehousing - All
No abstract
Kevin Closson, Oracle Corporation
Session: 2 - 10:30 am to 12:00 noon
Business Intelligence / Data Warehousing - Advanced
Kevin Closson will present an overview of the Oracle Exadata Storage Server and HP Oracle Database Machine architecture and internals including performance analysis of typical workloads the Exadata Storage Server is solely capable of accelerating. The presentation will include comparisons to the typical storage architectures supporting Oracle Database workloads today. Attendees will leave with a good understanding of why, and how Exadata is what it is. Kevin will leave ample time for a fruitful question and answer session.
Jean-Pierre Dijcks, Oracle Corporation
Session: 11 - 2:45 pm to 3:45 pm
Business Intelligence / Data Warehousing - Novice
The HP Oracle Database Machine is built for extreme performance for large-scale data warehouses. Anyone who is thinking about a data warehouse with Oracle should come to this session. Announced by Larry Ellison at Oracle OpenWorld, this is Oracle's answer (and much more) to the data warehouse appliance hype. In this session you will learn the details of what this product delivers for you. You will see how pre-optimized and pre-configured software, servers, and storage make your life simpler. Learn how HP Exadata Storage speeds up your queries and other I/O intensive jobs, and how you can benefit from it without changing your data warehouse models.
Jean-Pierre Dijcks, Oracle Corporation
Session: 8 - 10:15 am to 11:15 am
Business Intelligence / Data Warehousing - Intermediate
The beauty of OWB is that you run your ELT in the database and have a distinct advantage on performance because of that architecture. But that does not mean you can completely ignore performance!! Industry trends show double-digit growth percentages on data volumes, so sooner or later you will be looking at tuning your ELT. We will discuss tips and tricks in Warehouse Builder to tune and deliver better ELT, but also look at some of the biggest bottlenecks in typical systems (read I/O). We will show some new features that help you in 11g and go into detail as to how to implement some basic best practices for better ELT. We will also go into detail on the benefits of using the new HP Exadata Storage coming with Oracle Database Machine. Note, if you have currently developed your ETL in PL/SQL, this may be just as useful for you.
Tim Gorman, Evergreen Database Technologies
Session: 2 - 10:30 am to 12:00 noon
Business Intelligence / Data Warehousing - Intermediate
There are several errors present in many data warehouse implementations in Oracle. Central to these is the lack of use of partitioning, or (more prevalent) ineffective use of partitioning. Partitioning is crucial to data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully-gained understandings of data warehousing. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often die painfully.
David Hay, Capgemini Financial Services
Session: 10 - 1:30 pm to 2:30 pm
Business Intelligence / Data Warehousing - Intermediate
This presentation will show you how to produce a high-quality conceptual entity/relationship model using UML. The result can be used in conversations with the business community ensuring that it correctly reflects the structures and requirements of the business.
Ralph Hughes, Ceregenics
Session: 2 - 10:30 am to 12:00 noon
Business Intelligence / Data Warehousing - Intermediate
Business intelligence applications are wonderfully powerful tools, but they are often so expensive that they actually deliver little or negative net value to our customers. In the last ten years, development teams for transaction applications have dramatically streamlined their delivery process by using agile methods, which revolve around the philosophy of maximizing the work "not" done. What would happen if we were to apply such an agile approach to BI projects? In this presentation, we explore accelerating data warehousing implementations via three means: (1) applying the agile manifesto to the way BI teams work, yielding an agile method for BI, (2) working smarter as we build BI modules by employing data warehousing patterns and frameworks, (3) minimizing the overall labor required by choosing unconventional data architectures and commercial, off-the-shelf data management products. When braided together, these three threads yield an Agile Data Warehousing approach, enabling BI professionals to deliver business intelligence applications through a process that is dramatically "cheaper, faster, and better." Such acceleration not only benefits the current tier of major BI consumers, the Fortune 500, but also makes data warehousing affordable to far smaller organizations, the Fortune 500, and greatly expands the market for data management tools and services.
Andreas Katsaris, Arisant
Session: 9 - 11:45 am to 12:45 pm
Business Intelligence / Data Warehousing - Intermediate
Information is arguably the most important commodity in an organization. Thus, it stands to reason that if the information is important, we need to make sure that the right people have access to the right information at the right time. If not, mission critical data can be compromised or may not be accessible to the right people. This presentation will cover the different authentication methods supported in Oracle Business Intelligence Enterprise Edition (OBIEE) and demo how the Oracle Identity and Access Management Suite can be used to authenticate users and manage access to OBIEE dashboards and reports.
Thomas Kyte, Oracle Corporation
Session: 5 - 3:45 pm to 4:45 pm
Business Intelligence / Data Warehousing - All
Join Tom Kyte and learn how Oracle Exadata and Oracle Database 11g provide a comprehensive platform for addressing today's data warehousing and business intelligence requirements. Oracle Exadata combines industry standard hardware from HP with smart software from Oracle that overcome the limitations of conventional storage and can improve data warehouse query performance by a factor of times ten or more. In addition to industry-leading performance and scalability, Oracle Database 11g offers integrated analytics and embedded data quality on a reliable, low-cost grid infrastructure. This encompasses a broad set of database features and options that allow you to: o Manage integration and loading of quality data with Oracle Warehouse Builder o Improve performance, availability, and manageability by partitioning large tables o Consolidate enterprise-wide reporting, analytics, and data mining.
William Wimsatt, Wells Landers Group
Session: U1 - 1:00 pm to 5:00 pm
Business Intelligence / Data Warehousing - Intermediate
Understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization. Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads. Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query. The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool. This presentation will present data quality, and formation of a data quality program through hands-on demonstrations and exercises with Oracle Warehouse Builder Data Profiler and an open source data profiler. The presentation will cover the following topics: Debunking Data Quality Preconceptions Discover Levels of Data Quality Learn Data Profiling and Data Dictionary Create Data Stewardship/Governance Attendees will learn the following: Defining data quality and what it means to your corporation How to start a data quality program How to conduct data profiling to measure data quality How to maintain data quality through creating data quality programs.
Mike Ault, Texas Memory Systems
Session: 10 - 1:30 pm to 2:30 pm
Database Administration - Intermediate
In this presentation I will cover the new Oracle technologies that appear to make tuning of Oracle databases an obsolete skill. The pros and cons of each technology will be discussed and an overall rating given fo each. I will cover automation of the temporary tablespace, undo segments, memory management, SQL tuning and statistics, and profile management.
Brad Baker, Hewlett-Packard
Session: 9 - 11:45 am to 12:45 pm
Database Administration - Advanced
Disk-array-based remote copy infrastructures have been available and in use for over a decade. When properly configured and deployed, they are capable of providing a very timely recovery from a variety of failures, including the loss of an entire data center site. Relying on a combination of well-understood technical issues, plus information from recent customer briefings and a commissioned study with IDC, HP has determined the key requirement: the remote copy of databases must be done in concert with the native RDBMS technology in order for the solution to be practical. This presentation provides a comprehensive set of test-proven best practices for properly configuring, deploying, and operating an Oracle 11g database with Oracle's Automatic Storage Manager (ASM) on an HP Enterprise Virtual Array, using Continuous Access as the remote copy infrastructure.
Brad Baker, Hewlett-Packard
Session: 10 - 1:30 pm to 2:30 pm
Database Administration - Advanced
This presentation extends the previous presentation to include the best practices for failover and failback in an Oracle 11g on EVA replicated environment. Specifically, this project addresses our findings upon investigating the following: Failover Scenario, Failback Scenario, and Link Failure Scenario. The methods and best practices described in this presentation are intended to be used to facilitate both the productive planning for and the timely deployment of a fully operational remote copy infrastructure-one that will have predictable performance characteristics, ease of operation, and satisfactory recoverability capabilities.
Rama Balaji, TUSC-A Rolta Company
Session: 11 - 2:45 pm to 3:45 pm
Database Administration - Intermediate
Businesses today cannot tolerate downtime. Downtime means loss of business, and ultimately loss of revenue to the company. The real challenge of achieving 24/7 availability comes from productively utilizing all the available resources, software, and hardware. This presentation is a case study of one such customer, whose storage array failed during the heavy transaction processing time. We quickly brought the database back up and subsequently got their entire system restored, all the while maintaining at least two copies of production databases. This presentation is a perfect example of how a mission critical production shop can utilize all Oracle HA features such as RAC, ASM, RMAN, and Data Guard to acheive maximum availability.
Frank Bommarito, DBA Knowledge
Session: 10 - 1:30 pm to 2:30 pm
Database Administration - Intermediate
Explore Oracle stored outlines and SQL Profiles like never before. Learn of practical usage cases. This paper will demonstrate and show specific, repeatable examples for your environment. Learn what to do, when to do it, and why it is done. Learn the difference between SQL Profiles and stored outlines. Experience the power of tools that allow for changing application performance without crazy init.ora parameters. Increase productivity; decrease exposure.
Bradley Brown, TUSC-A Rolta Company
Session: 12 - 4:00 pm to 5:00 pm
Database Administration - All
TUSC will present the current culture in service-oriented architecture (SOA) for the DBA and demonstrate a tool to help automate much of this process for you. What are the others doing? What are the first steps in this process? How do administrators "service-enable" existing services, using existing technology, and with your existing skills set. You can do this one service at a time with tools like Eclipse and JDeveloper (free integrated development environments-IDEs). For example, JDeveloper allows you to wrap an existing piece of PL/SQL (for the Oracle world) or Java code and expose it as a service. You'll need to learn about the IDE, about Java, about app servers, and plenty more to get going. That's enough of a dip into the ocean to get you going down the SOA path. Once you have services, you'll find countless ways of consuming those services. From data conversion to loosely coupled integration to mashups and portals to so much more-SOA will help you!
Donald Burleson, Burleson Consulting
Session: 3 - 1:30 pm to 2:00 pm
Database Administration - All
The declarative nature of the SQL syntax has always made it difficult to perform SQL tuning. The basic tenet of cost-based SQL optimization is that the person who writes a SQL query simply "declares" what columns they want to see (the SELECT clause), the tables where the columns reside (the FROM clause), and the filtering conditions (the WHERE clause). It's up to the SQL optimizer to always determine the optimal execution plan. This is a formidable challenge, especially in a dynamic environment. Once you create a workload (called a SQL Tuning Set, or STS), Oracle will repeatedly execute the workload, using sophisticated predictive models (using a regression testing approach) to accurately identify the salient changes to execution plans, based on your environmental changes. Using SPA, we can predict the impact of system changes on a workload, and we can forecast changes in response times for SQL after making any change, like parameter changes, schema changes, hardware changes, OS changes, or Oracle upgrades; any change that influences SQL plans is a good candidate for SPA.
Donald Burleson, Burleson Consulting
Session: 12 - 4:00 pm to 5:00 pm
Database Administration - All
This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the "result cache" hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach. Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.
Charlie Callaway, DaVita
Session: 7 - 9:00 am to 10:00 am
Database Administration - Intermediate
Ever had a wonderfully behaving production system start performing poorly, only to find after hours of troubleshooting that a key query has inexplicably switched to a bad execution plan? With a little work you can have your own execution plan monitor up and running that will alert you when such a switch takes place. This can reduce the amount of time spent on diagnosing the problem when performance suddenly degrades. In this session, attendees will learn: essential concepts such as how SQL statements and execution plans are uniquely identified by sql_ids and plan_hash_values respectively; how to actively mine Active Workload Repository (AWR) data for changes in execution plans of queries, and raise an alert if such a change takes place; how to fine-tune which queries you monitor; how to accommodate multiple "acceptable" execution plans for the same query; how to use StatsPack data to accomplish the same goal if you are not licensed for AWR; and how to avoid certain Gotchas with execution plan monitoring (such as multiple child cursors w/different plans).
Jay Caviness, McKesson Provider Technologies
Session: 1 - 9:00 am to 10:00 am
Database Administration - Intermediate
Oracle RAC is not quite the panacea for load balancing that most of us expected. Client side load balancing is random (not round-robin) and the server side can be confusing in its path. It takes a little work to find the right setup for client and server side load balancing. This session will present the basics of load balancing and then push into the uses of services and the load balance advisor for optimal use of RAC.
Patty Charlebois, Green Shield Canada
Session: 1 - 9:00 am to 10:00 am
Database Administration - Novice
Change is one of the few "constants" of database administration. Arguably the most important-but often under recognized-issue facing Oracle database administrators today is that to maintain database stability they must manage the changes that occur throughout their systems. It is self-evident that change-to hardware, software, applications etc. -is continually occurring throughout an IT organization; and being able to effectively manage these changes will both dramatically improve efficiency, as well as significantly reduce costs for the organization. This presentation will explore the methods we use to manage change within our databases at Green Shield and provide real-life examples of lessons we learned and pitfalls to avoid.
Randy Cunningham, SageLogix
Session: 8 - 10:15 am to 11:15 am
Database Administration - Advanced
Experiencing extremely poor or inconsistent performance from your Oracle database server or mid-tier? Oracle Wait Events and AWR reports aren't really telling you why? If so, the problem often results from hardware and OS memory management issues, including swapping, even on systems with very large real memory. Learn how to identify these issues on various platforms and what to do about it. Learn from real field cases how various memory problems were diagnosed (or eliminated from consideration) and how they were resolved. The perils of memory management on virtual machine environments will also be explored in this presentation. While the emphasis is on database host systems, the information provided is applicable across a variety of platforms.
John Darrah, DBA Knowledge
Session: 7 - 9:00 am to 10:00 am
Database Administration - Intermediate
This presentation will demonstrate how OEM Grid Control helps to quickly spot high level performance anomalies, drill down, and discover root causes of performance problems. This presentation will demonstrate how to use groups and dashboards as well as AWR and ASM through OEM Grid Control.
Iggy Fernandez, Database Specialists
Session: 4 - 2:15 pm to 3:15 pm
Database Administration - All
What are the deliverables of the database administration role? How likely is it that the deliverables will be met if we cannot articulate them? In The Tao of Pooh, the clever little bear Winnie the Pooh, says, "If you don't know which to do, off all the things in front of you, then what you'll have when you are through, is just a mess without a clue." "Deliverables" are not the same as "current priorities" or "assigned tasks" because priorities and assigned tasks change from day to day. In this session, we discuss ten specific deliverables that do not change from day to day; the first is "databases that meet the needs of the business." One of the ten deliverables is a maintenance schedule and therefore we give special attention to the subject of database maintenance including backups, statistics, archiving, log file management, rebuilding, auditing, user management, capacity management, and patching.
Daniel Fink, Independent Consultant
Session: 11 - 2:45 pm to 3:45 pm
Database Administration - All
Performance is poor, user sessions are 'hanging', management wants a diagnosis NOW! What do you do? Use the G2 method? Gather everyone in a conference room for a brainstorming session? Flush the shared pool, analyze everything and change a couple of database parameters? If it works (or fails), do you know why? More importantly, when performance is poor next week, can you repeat your actions with the same result? If a diagnosis process is not explainable and repeatable, it is undisciplined and unreliable. Diagnostic routines bring discipline to the troubleshooting and optimization process. This presentation covers some of the common undisciplined approaches, the foundations of and techniques for developing disciplined processes, and finishes with basic diagnostic routines and root cause analysis for Oracle sessions. The topics and methods are designed to enable the attendee to develop methods that are specific to their system, application, and situation.
Robert Freeman, Church of Jesus Christ of Latter-day Saints
Session: 2 - 10:30 am to 12:00 noon
Database Administration - Intermediate
Oracle Database 11g is the newest version of Oracle's flagship database product. In this presentation Robert Freeman, author of Oracle Database 11g New Features will introduce you to Oracle Database 11g and several of the more impressive new features of the product. Robert will start with a discussion on upgrading to Oracle Database 11g. He will then discuss many of the new features available in Oracle Database 11g including: new diagnostic related features, new RMAN features, new memory related features, Oracle Flashback related features, database Replay, SQL performance analyzer, and many others!
Robert Freeman, Church of Jesus Christ of Latter-day Saints
Session: U1 - 1:00 pm to 5:00 pm
Database Administration - Intermediate
So, you have RMAN up and running. You are backing up your database, and you are pretty sure you know how to recover it. Maybe. Beyond that, what else exists out in the RMAN world that can help you? In this presentation Robert Freeman, author of Oracle Database 10g RMAN Backup and Recovery will touch on a number of advanced RMAN topics. Topics include point-in-time recoveries, performance tuning, and database duplication. Several new Oracle Database 11g features will also be highlighted. Come join us for this exciting exploration of advanced RMAN backup and recovery topics!
John Garmany, Burleson Consulting
Session: 12 - 4:00 pm to 5:00 pm
Database Administration - Intermediate
This presentation focuses on monitoring and managing a standby database. Many times a standby database is not ready when it is needed. Failure to monitor your standby database can leave you without a recovery capability when you need it. We will focus on monitoring, care, and recovering a standby database. The presentation will include real world techniques and scripts.
John Garmany, Burleson Consulting
Session: 8 - 10:15 am to 11:15 am
Database Administration - Intermediate
Oracle Streams is the premier replication method for Oracle databases. The Oracle Physical Standby is the fastest method to protect your data. Together they pose a set of unique issues and are sometimes difficult to manage. This presentation covers methods to implement and manage Oracle Streams Replication and Standby databases. We will cover failover and switchover requirements and methodologies.
Gary Garrison, Raytheon Company
Session: 3 - 1:30 pm to 2:00 pm
Database Administration - All
Oracle's data compression helps solve an obvious problem of helping to conserve disk space. In addition, it can also improve performance for some operations. This presentation will give a fairly high-level overview of compression, along with tips on its use, and new compression features in Oracle 11g.
Tim Gorman, Evergreen Database Technologies
Session: 7 - 9:00 am to 10:00 am
Database Administration - Intermediate
The Automatic Workload Repository is a significant part of Oracle's tuning advisories introduced in Oracle10g and further enhanced in Oracle11g. Enterprise Manager makes extensive use of AWR to enable performance tuning, but like STATSPACK before it, there is a lot more important information within AWR which can be obtained. The presenter will briefly explain the structure of the workload repository and how it is populated, but will mostly show attendees how to extract more information from this rich source of tuning information using SQL*Plus. This type of knowledge makes the difference between a DBA who is out of ideas once Enterprise Manager fails to yield a solution, and a DBA who knows how to tease out important evidence to resolve practically any problem that arises.
Stephan Haisley, Oracle Corporation
Session: 6 - 5:00 pm to 6:00 pm
Database Administration - Intermediate
With the release of 11g, Oracle has added more features to help reduce the time it takes to back up, restore, and recover a database after a failure. Such features include multisection backups, faster backup compression, and undo optimization. Oracle has also introduced a couple of flashback features to decrease the amount of time to recover after a logical failure affecting certain tables. These features will all be presented, along with how they work and some example test figures demonstrating their benefit to the ever increasing number of 24x7 shops.
Stephan Haisley, Oracle Corporation
Session: U1 - 1:00 pm to 5:00 pm
Database Administration - All
Oracle Maximum Availability Architecture (MAA) is Oracle Corporation's HA best practices blueprint based on Oracle high availability technologies such as Real Application Cluster, ASM, Data Guard, Exadata, Flashback technologies, etc. The goal of MAA is to design the best high availability architecture with the greatest return on investment and quality of service Downtime is something every mission critical business wants to avoid or minimize, whether it is due to planned or unplanned outages. Oracle offers a number of features and proven operational and configuration practices to minimize downtime. This session aims to demystify the HA features offered by Oracle and outline a clear set of best practices to avoid and minimize downtime for all outages. I will provide real world examples of how MAA best practices have prevented prolonged downtime when faulty HBAs corrupted the primary database, how a leading telecom reduced downtime exposure from two hours to its minutes for outages resulting in site failover, and how legal and insurance firms reduced downtime to minutes using Data Guard switchover for upgrades and major system changes. I will also describe how to configure for zero downtime for most unplanned and some planned outages.
Dan Hotka, Training Specialist
Session: 11 - 2:45 pm to 3:45 pm
Database Administration - Intermediate
Have you migrated your business applications to Oracle10g from prior versions to have them suffer from unexplained performance issues? Dan will discuss a little-known index statistic and the impact this has on new tablespace features now available in Oracle10g. Dan will even provide a script that will help identify if your database environment is suffering from this issue.
Niklas Iveslatt, Arisant
Session: 3 - 1:30 pm to 2:00 pm
Database Administration - All
Oracle licensing can be very confusing. This overview will highlight the various Oracle Database licensing options and provide the audience with the ability to fine-tune their Oracle licensing options for their specific business needs. Much like SQL plan-management can be used to improve and control database performance and save cost, having a well tuned licensing scheme can save an organization a lot of money as well as position the database for future growth.
Christo Kutrovsky, The Pythian Group
Session: 6 - 5:00 pm to 6:00 pm
Database Administration - Novice
Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources being used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in detail the different types of memory, how to monitor memory, and how to use it optimally with Oracle. Multiple examples in the presentation demonstrate how certain actions on the database side cause different memory areas to be allocated and used on the OS side. Key underlying differences in operating systems approaches to managing memory will be highlighted, with special attention given to Linux, Solaris, and Windows. Using Linux as an example throughout, this presentation explains how to effectively use tools such as "top", "vmstat", and "/proc/meminfo" to look into a system's allocation and use of memory.
Thomas Kyte, Oracle Corporation
Session: 4 - 2:15 pm to 3:15 pm
Database Administration - All
A hotly debated topic is, "Do I need to reorganize/rebuild indexes and tables?" We will discuss the times when a reorganization or rebuild is relevant, how to measure what you've done (to verify that the work performed did something useful!), and the best techniques for performing a reorganization of data.
David Lipowitz, Tuning Knife Consulting
Session: 10 - 1:30 pm to 2:30 pm
Database Administration - Intermediate
The 10053 event produces a tracefile detailing the statistics and calculations used by the Cost Based Optimizer (CBO) in the development of execution plans. The CBO takes a variety of inputs including optimizer statistics (e.g. NUM_ROWS) and initialization parameters (e.g. OPTIMIZER_INDEX_COST_ADJ). By varying initialization parameters and optimizer statistics, we can then trace queries with the 10053 event and see how these changes affect the CBO's decision to use or ignore indexes.
Daniel Liu, Oracle Corporation
Session: 2 - 10:30 am to 12:00 noon
Database Administration - Intermediate
In this session, the students 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) encryption.
Russ Lowenthal, Oracle Corporation
Session: 7 - 9:00 am to 10:00 am
Database Administration - All
Tired of resetting passwords? Granting additional privileges? Filling out those endless periodic audits of user accounts? Make someone else do the work! Delegate database user management to your Active Directory administration group. This presentation will discuss new features in Oracle Identity Management 10.1.4.2 for managing Oracle Database users in Microsoft Active directory WITHOUT HAVING TO SYNCHRONIZE USERS TO OID! This new capability lets you go from project start to managing your database users in less than an hour. In this presentation we'll take a step-by-step approach to the integration including discussing your options along the way and the impact of the different choices you can make in architecting your solution.
Timothy Mishek, ITT
Session: 8 - 10:15 am to 11:15 am
Database Administration - All
The presentation will start by going over what ASM is and how it can benefit an organization. Progressing forward, the basics of ASM will be covered including the requirements for an initial install which might include a full database upgrade. Concepts concerning what type of redundancy is available. The definition of Course and Fine in addition to High, Normal, and External redundancy will be looked at in detail. Questions such as "What can be put on an ASM volume?" "How is the structure created for the storage of spfiles, datafiles, undo, temp, archive redo logs, redo logs, and rman backups?" "What is a disk group?" will be answered. Backup and recovery solutions and architectures may have to be changed in an ASM environment. Several scenarios will be discussed in detail. Tools for using ASM effectively such as "ASMCMD" and "OEM" will be covered with live examples. What are the advantages of going to ASM. Comparing the advantages against technologies such as OCFS2 and raw devices for RAC and single instance environments will be covered.
Karen Morton, Method R Corporation
Session: 9 - 11:45 am to 12:45 pm
Database Administration - All
Oracle continues to add more and more automated features and advisors to assist with diagnosing and fixing problems. Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is "dumbing us down" or "smartening us up." Too often more automation can lead to using these features as a crutch and bypassing the acquisition of key skills and knowledge. Ideally, these features should be tools to help us do our jobs better instead of simply letting Oracle do them for us. The key is to know what help the advisors' can provide and know how to use them properly and effectively. The risk is becoming trained to only follow the advisors output, but when a situation arises where our skills and knowledge are needed, it's not there. This presentation will review several cases where the Oracle SQL Tuning Advisor (in particular) isn't able to provide any help with identifying and correcting poorly performing SQL. We'll then review the knowledge and critical thinking skills needed by the DBA or developer to understand how to make the needed improvements to the code to provide enhanced performance.
Jim Osborn, SageLogix
Session: 3 - 1:30 pm to 2:00 pm
Database Administration - All
The quick tip session will briefly describe the conceptual framework which allows third-party tools to be incorporated into Oracle's Grid Control framework for monitoring and alerts. It will use Dell's OpenManage Server Administration tool to demonstrate incorporation of data collected by Dell's tool into Grid Control.
Tanel Poder, PoderC
Session: 2 - 10:30 am to 12:00 noon
Database Administration - Advanced
This presentation gives you the knowledge of how to dig deeper from usual performance troubleshooting approaches like tracing and Oracle Wait Interface sampling. These classic techniques are often not adequate for diagnosing special cases involving bugs, Oracle instrumentation deficiencies, and operating system issues. We will look into techniques, scripts, and tools for sampling relevant execution statistics from inside and outside Oracle. We also use a simple non-intrusive stack profiling method for pinpointing where exactly in Oracle kernel the response time is spent. This all is wrapped into a practical troubleshooting method which has so far helped the author to accurately troubleshoot many issues related to hangs, bugs, and unexplained bad performance.
Tanel Poder, PoderC
Session: 9 - 11:45 am to 12:45 pm
Database Administration - Advanced
Even though SQL statements and their compiled execution plans are just declarations of what work needs to be done, when Oracle gets to execution of a SQL statement, all processing is done procedurally. Every rowsource, join method, and access path is internally just a loop, continuing as long as there is data flowing from its child rowsources. This session gives you an in-depth understanding of how Oracle SQL plan execution physically works, a step beyond just interpreting the logical view of execution plan trees. This should give you a good foundation for troubleshooting complex SQL performance issues, understanding in which cases one join method is better than another, and making more suitable physical design decisions.
Bert Scalzo, Quest Software
Session: 8 - 10:15 am to 11:15 am
Database Administration - Intermediate
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.
Joze Senegacnik, Private Researcher
Session: 4 - 2:15 pm to 3:15 pm
Database Administration - All
SQL Plan Management was introduced in Oracle11g to guarantee execution plan stability and allow controlled execution plan changing. The presentation will discuss this new feature in conjunction with new mechanisms for gathering extended statistics and managing pending optimizer statistics.
Sumit Sengupta, Hewlett-Packard
Session: 12 - 4:00 pm to 5:00 pm
Database Administration - All
How would you backup your 1 TB database in minutes before a major application upgrade? How would you recover the database in minutes if the upgrade goes wrong? Two options are discussed in this presentation: FLASHBACK DATABASE technology in Oracle 10g and above and snapshot technology from storage vendors such as Network Appliance. The architecture and workings of each of these technologies is discussed. Both technologies are expensive, you have to decide what works best for you.
Craig Shallahamer, OraPub
Session: 1 - 9:00 am to 10:00 am
Database Administration - All
Surveys indicate that most database servers operate at far less than their capacity allows, which means businesses are wasting money and IT is doing additional work. To counter this wastefullness, organizations are increasingly turning to server consolidation as one means of cutting redundant costs such as backups, monitoring, maintenance, various license fees, and technology standardization. But it's not that simple. Due to different CPU speeds, CPU core numbers, workload peaks, software releases, and application dependance and security issues, what seems like a simple consolidation exercise can turn into a daunting challenge. The danger is if too many applications are consolidated onto too few or underpowered servers, the result is upset users and interrupted business processes. This paper is aimed at introducing server consolidation by enabling IT to understand the potential, the dangers, the complexities, as well as how to perform basic server consolidation.
Craig Shallahamer, OraPub
Session: 4 - 2:15 pm to 3:15 pm
Database Administration - Intermediate
The Oracle database is extremely complex software. Part of the solution to performance optimization is Oracle Corporation itself optimizing the core database kernel code. One such optimization is the introduction of Oracle's patented in-memory undo (IMU). Essentially, instead of maintaining undo in Oracle segments, the undo is managed, as much as possible, in memory using structures optimized for in-memory operations. But as you will read, how Oracle does this is fascinating and foreshadows even greater things to come. But with any piece of code, there is always the possibility of a bottleneck, so this paper covers how to detect IMU performance issues and multiple ways to potentially solve the problem (in addition to just turning it off).
Riyaj Shamsudeen, OraInternals
Session: 6 - 5:00 pm to 6:00 pm
Database Administration - All
This paper focuses on a few new features introduced in Oracle version 11g. Features include but are not limited to, virtual columns, virtual indexes, CBO features, extended stats, sub-query transformation, faster lob, faster column addition, trigger enhancements, etc. Various test cases will be provided comparing performance improvements. Further, scalability improvements and issues with these new features will be discussed.
Riyaj Shamsudeen, OraInternals
Session: 7 - 9:00 am to 10:00 am
Database Administration - Advanced
This presentation is to explore various RAC performance myths and show how battle among the nodes can cause worse performance issues. Some of myths covered, but not limited to : (1) Global cache performance issue? It must be an interconnect performance issue. (2) CPU hogging process? Throw that in report node; we are not worried about high CPU usage in there.(3) We've got many CPUs across many nodes and so use Inter instance parallelism to improve performance of parallel executions. (4) Use inter instance parallelism to create tables and indices efficiently. (5) Set sequence to nocache value in RAC environments to avoid gaps in sequence. (6) Our application is designed to generate much dynamic DDL. We are upgrading to RAC this weekend and we might need to call you if there are any issues! Quick, where is that off button? (7) We will cache the whole table in buffer cache and cache fusion should take care of moving blocks across nodes, too. So, small tables should not be indexed in RAC. (8) Bitmap index performance is worse compared to single instance. (9) If there are performance issues, convert from single instance to RAC.
Jeff Smith, Quest Software
Session: 5 - 3:45 pm to 4:45 pm
Database Administration - All
No abstract
Gaja Krishna Vaidyanatha, DBPerfMan
Session: 9 - 11:45 am to 12:45 pm
Database Administration - Intermediate
Oracle Performance Management has a reputation of being part science, part art, and mostly wizardry. A system plagued with the fundamental problem of poorly configured SAN, is guaranteed to exacerbate any application-level problems with inconsistent I/O service times. Application response times, as a result, dip to sub-optimal levels. Diagnosing storage sub-system performance issues takes time, organization, discipline and a methodical approach. The configuration and performance of the various layers of storage sub-system needs to be understood and unraveled. This talk shares with you the core principles of performance management (including the methodology) utilized to determine, investigate, and implement "meaningful solutions" to real-world storage sub-system performance problems. This presentation will not only discuss the relevant concepts but also provide case studies that go into the required technical details.
Gaja Krishna Vaidyanatha, DBPerfMan
Session: 10 - 1:30 pm to 2:30 pm
Database Administration - Intermediate
Oracle Performance Management has a reputation of being part science, part art, and mostly wizardry. A system plagued with the fundamental problem of poorly configured SAN, is guaranteed to exacerbate any application-level problems with inconsistent I/O service times. Application response times, as a result, dip to sub-optimal levels. Diagnosing storage sub-system performance issues takes time, organization, discipline and a methodical approach. The configuration and performance of the various layers of storage sub-system needs to be understood and unraveled. This talk shares with you the core principles of performance management (including the methodology) utilized to determine, investigate, and implement "meaningful solutions" to real-world storage sub-system performance problems. This presentation will not only discuss the relevant concepts but also provide case studies that go into the required technical details.
Jeremiah Wilton, ORA-600 Consulting
Session: 8 - 10:15 am to 11:15 am
Database Administration - Intermediate
To become skilled in the area of troubleshooting and failure resolution, most Oracle professionals endure a wide variety of trials by fire in production environments, over many years. By learning to create realistic load levels and failure scenarios in test systems, Oracle professionals with little experience in troubleshooting and fault resolution can hone their skills without the customary stressful ordeals and business impact. In this session we will induce realistic problems, including hangs, spins, crashes and corruptions on a running Oracle 11g instance, then apply effective techniques for diagnosing and resolving those faults.
Jeremiah Wilton, ORA-600 Consulting
Session: 4 - 2:15 pm to 3:15 pm
Database Administration - Intermediate
Most unplanned Oracle downtime and service reductions are caused not by the initial occurrence of a fault, but by the many subsequent occurrences of the same problem that take place before DBAs or support find a solution or workaround. Diagnosing a problem the first time it happens in a mission-critical environment is difficult even for the most experienced Oracle professionals. To address such circumstances, several new Oracle 11g features have been introduced under the umbrella of the diagnosability infrastructure. In addition, there are a variety of novel methods that make it possible to automatically detect and diagnose faults upon the first occurrence. Instead of suffering through dozens of failures from the same problem, mission-critical sites will benefit from implementing first-failure fault detection and diagnostics strategies as described in this session.
Graham Wood, Oracle Corporation
Session: 1 - 9:00 am to 10:00 am
Database Administration - Intermediate
Performance events requiring DBA attention have been historically difficult to detect. Often, user complaints are the first indication of a problem. Traditional solutions set alert thresholds against system-level metrics. Problems with this technique arise on a number of fronts: shortage of quality performance indicators, thresholds are static while workloads may vary predictably, indicator metrics may be application or system dependent, appropriate thresholds may be workload dependent, and adjusting threshold settings over many databases is labor-intensive. The Oracle 11g Adaptive Thresholds feature addresses these issues by enabling databases to automatically determine and adjust meaningful alert thresholds for key performance metrics.
Thomas Green, Single Sign on Data
Session: 9 - 11:45 am to 12:45 pm
Middleware - All
Many organizations are missing out on the full power of Oracle middleware or fusion ware. This presentation is designed to help Oracle users understand the functional advantages of Identity Management (IM). In very simplistic terms, IM lets the organizational decision makers decide who gets access to what data, applications or any other system part and how data is used. IM contains five very useful functions: (1) increases security-inside and out, (2) cost effective regulatory compliance, (3) improves system responsiveness, (4) streamlines operations and administrative tasks, (5) reduces costs. Examples will be reviewed which demonstrate how IM accomplishes the five functions. References will be made to Oracle Flexible Architecture and the built-in connectors in Oracle Application Software which facilitate the set up of IM.
John King, King Training Resources
Session: 1 - 9:00 am to 10:00 am
Middleware - Novice
Among the most promoted benefits of a service-oriented architecture (SOA) is the reuse of services and Web services. To achieve reuse developers must know: that a service is available, how to call it, what to expect in return, and they must trust it to work as advertised. The larger and more geographically dispersed a team of developers is, the more important it becomes to have centralized control of Web services. Oracle's Service Registry provides a UDDI V3 compliant mechanism for publishing, categorizing, and discovering Web services. This session discusses the need for a registry and explores the setup and use of the Oracle Service Registry. Participants will learn how to publish and categorize Web services. In addition, attendees will learn how the Oracle Service Registry's search mechanism may be used to discover Web services. By learning to properly use the Oracle Service Registry, teams of developers can achieve the reusability promised by SOA.
Khanh Lai, Arisant
Session: 12 - 4:00 pm to 5:00 pm
Middleware - All
Today many companies face the challenge of not being able to quickly and accurately answer the question "Who has what resource and why?" This issue becomes even more critical when the termination of resources is required in an urgent fashion. Oracle Identity Management (OIM) offers the capability to enterprises to manage user's lifecycle in all available resources such as Microsoft Active Directory, Microsoft Exchange, and ERP systems. This presentation will give an overview of OIM, discuss its architecture, and show how it can help enterprises with identity management. Then, it will focus on how OIM allows users to self register to become new users or request additional resources. Users, with approving authority role, see these requests in their pending approval tasks queue. Upon approvals, resources are provisioned to users accordingly. OIM also allows requests for resources to be de-provisioned following the same model of approval.
Lynn Munsinger, Oracle Corporation
Session: 5 - 3:45 pm to 4:45 pm
Middleware - All
Bring your laptop and your questions to the Fusion Development hands-on session. You'll learn how to develop a Fusion application, using the Oracle Fusion Middleware stack- including Oracle JDeveloper, Oracle Application Development Framework (Oracle ADF), and the highly interactive ADF Faces user interface components. Make sure you have downloaded and installed the Oracle XE Database and Oracle JDeveloper 11g before you arrive to maximize the time you'll have to complete the tutorial.
John Vansant, Oracle Corporation
Session: 6 - 5:00 pm to 6:00 pm
Middleware - Intermediate
Oracle has made a decision to use WebLogic Server as it's strategic application server going forward. For those that are familiar with OiAS and want to understand what's "in the box" of WebLogic, this is the talk for you. This talk will give an overview of what capabilities WebLogic has along with demos of some of the key features of the application server. At the end of this talk, attendees should understand the components of WebLogic Server, how it works, how it is managed, and how applications are developed on it.
Charlie Freeman, Oracle, USA
Session: 11 - 2:45 pm to 3:45 pm
Package Software Support - All
During this session you will learn how to prevent problems before they occur! Optimize your systems based on the latest Oracle knowledge and best practices! Resolve your service requests faster! This session will concentrate on the preventive and proactive capabilities available to you via the My Oracle Support: configuration manager. Learn how these industry-leading enhancements can provide a desired proactive support experience and save your company money.
Jeff Needham, RedHat
Session: 9 - 11:45 am to 12:45 pm
Package Software Support - Intermediate
Oracle on RHEL certification Jeff will give a brief update for customers running Oracle on RHEL. Oracle has recently been focusing much of their Linux work on their version of RHEL (OEL), so this session provides an update from the RHEL engineering perspective. This session will provide an overview of ongoing certifications for which Red Hat is now responsible, including RAC certifications for the Red Hat Global File System (GFS) running on the Advanced Platform/Clustersuite infrastructure. The intent is to be as interactive as possible, so considerable time will be dedicated to open Q and A.
Mike Swing, TruTek
Session: 1 - 9:00 am to 10:00 am
Package Software Support - All
Parallel concurrent processing failover uses two mechanisms to detect a failure, dead connection detection and detecting a failure of the process monitor for the concurrent managers, otherwise known as PMON (not the pmon from the database); introduced with patch 6495206. Load balancing of the concurrent managers is critical if you expect parallel concurrent processing to function after the failover to the remaining node(s). A review of concurrent manager basics is covered before we discuss the topics of failover and load balancing. One of the key components used by concurrent processing is generic service management. The use of GSM with multiple nodes and seeded GSM services are discussed. Administering concurrent managers, control across nodes, starting and stopping the concurrent managers, and concurrent log files are skills needed to understand the configuration of PCP failover and load balancing. The primary tables that contain the concurrent processing data are investigated with a review of the phase and status types for concurrent requests. Each manager type is discussed: service manager, internal manager, standard manager, transaction manager,conflict resolution manager, and internal scheduler/prerelease manager. The failover and load balancing of these managers is central to the theme of this paper. Configuration of parallel concurrent processing and some configuration examples are followed by a practical approach to troubleshooting concurrent managers.
Famara Aires, Verizon Business
Session: 3 - 1:30 pm to 2:00 pm
Professional Development - All
What does it take to be a good Oracle systems analyst? Is being detail-oriented the key? How much background systems knowledge do you really need? What is the real duty of a systems analyst? We will explore these questions and much more. Being a good Oracle systems analyst isn't as clear cut as some might think. This session will explore from a manager's perspective, and from a lead developer's perspective, what is expected of a systems analyst and what set of skills is required to do the job well. We will discuss where the line is drawn between being a programmer and being an analyst, and why a company would specifically hire true analysts, versus programmer/analysts. We will also discuss the types of documents a systems analyst may be required to produce, as well as the role they play in the testing process.
David Cook, Oracle Consulting
Session: 6 - 5:00 pm to 6:00 pm
Professional Development - Intermediate
Performance Management from Crisis to Confidence; Utilizing Oracle's Unified Method, Performance Management Track When implementing any IT system, performance is a concern on every manager's mind. But how to ensure performance will be there at go-live? We will examine the implementation of a typical Oracle system and blend the phases of the Oracle Unified Method (OUM); Performance Management Track (PT) into the overall implementation project plan. We will discuss the critical tasks of each the track's phases as well as the gotcha's. Load testing tools and their proper application will be introduced. From the proper execution of the Workload Characterization task, through Performance Testing; this paper covers the OUM PT sub-project end-to-end.
Robert Freeman, Church of Jesus Christ of Latter-day Saints
Session: 4 - 2:15 pm to 3:15 pm
Professional Development - Novice
Have you ever wanted to take a crack at writing your own Oracle book? In this presentation Oracle Press author Robert Freeman will discuss getting published in the Oracle world. In this presentation he will discuss how the publishing process works, how to get started with an idea, things to do, and some things not to do in your effort to get published. Finally the session will end with a Q and A session where you can ask any questions you like!
Steve Lemme, CA
Session: 11 - 2:45 pm to 3:45 pm
Professional Development - All
In this session understand how Fusion can apply to your current job role or possibly a future one. This is a growth area where IT professionals are being sought and could lead to your career enhancement. Learn where and how to be connected and grow your skills and expand your knowledge on your Fusion journey as well as supporting after upgrade or deployment.
Mogens Norgaard, Miracle A/S
Session: 12 - 4:00 pm to 5:00 pm
Professional Development - All
When there are dramatic changes in the business environment there is a new sense of urgency for businesses and individuals to focus on value. Inefficiencies cost money and the lack of a current skill set may be the difference between maintaining employment and an undesired career change. In this presentation Oak Table Network co-founder and Ace Director Mogens Norgaard and Ace Director Daniel Morgan will discuss the current state of technical education as it applies to real-world environments and offer concrete recommendations with respect to how organizations can evaluate and upgrade their current talent and individuals can make sure that they have the skills they need for their career.
Laura Sprowls, TUSC-A Rolta Company
Session: 11 - 2:45 pm to 3:45 pm
Professional Development - All
As experienced SOA companies will attest, the scope of SOA is massive, and as companies start researching SOA, the concepts get deeper by the minute. Between all of the acronyms, terms, and technologies such as buses (ESBs), Message queues (JMS, MQueue), compliance, governance,and so many more, database administrator's and others get overwhelmed quickly. Each topic is its own Pandora's Box! The bottom line is, SOA is HUGE! But...it doesn't have to be. You don't have to boil the whole ocean to venture into SOA, you just need to dip your toe in to see how it feels first. This presentation will present the current culture in Service Oriented Architecture and demonstrate a tool to help automate much of this process for you.
Paul Dorsey, Dulcian, Inc.
Session: 4 - 2:15 pm to 3:15 pm
Web, Intranet/Internet - Intermediate
Well designed Web applications can provide performance that is just as fast as their older client/server counterparts, but this requires a rethinking of application tuning strategies. Poorly performing Web applications are rarely or only marginally improved by tweaking the database and tuning the SQL statements. This presentation will discuss techniques that can be used to identify and resolve many common performance issues that arise when developing Web applications.
Julie Johnson, Firebox Training
Session: 2 - 10:30 am to 12:00 noon
Web, Intranet/Internet - Intermediate
There has been a lot of buzz recently surrounding Ajax, commonly referred to as "Asynchronous Javascript". With Ajax you can retrieve data from a Web server without refreshing the whole page, making your application run much faster. In this session, we'll cover dynamic HTML and Ajax concepts and see it in action, pulling information from an Oracle database for display in a Web page. We will also explore the DoJo toolkit, an Ajax client side library. With DoJo, we'll read data stores using JSON (JavaScript Object Notation), implement dynamic drag and drop, and use special effects such as fade in and out and other neat animations.
Peter Laird, Oracle Corporation
Session: 6 - 5:00 pm to 6:00 pm
Web, Intranet/Internet - Novice
In this session, we will take a tour of Cloud Computing. The tour begins with an explanation of what Cloud Computing is, followed by an exploration of the major categories of solutions. We then will survey the vendors that offer solutions in this space. Finally, we will look at case studies in which enterprises have used the Cloud with success. Attendees will walk away with an understanding of what Cloud Computing can do for their company.
Peter Laird, Oracle Corporation
Session: 3 - 1:30 pm to 2:00 pm
Web, Intranet/Internet - Intermediate
Google Gadgets have become a popular widget technology that have been rapidly adopted by consumers. A gadget is a small Web page that encapsulates a feature like a stock ticker or flight status lookup. This session will discuss why it is beneficial to provide official corporate Google Gadgets, and an introduction to how to build them.
Dustin Marx, Raytheon Company
Session: 7 - 9:00 am to 10:00 am
Web, Intranet/Internet - Novice
While REST was originally coined as an acronym for Representation State Transfer, it is also very easy to think of it as a method for "resting" from the complexity and frustration commonly associated with the WS- specifications. The WS-* specifications can be useful for ensuring services are implemented in a standard and widely supported way, but unfortunately they also have several disadvantages such as high level of complexity, inconsistent implementation, and even competing and contradictory concepts among different specifications. The REST approach to Web services promises and delivers an easier path for developing basic Web services. This presentation will provide an overview of the REST concept and contrast REST with the more formalized WS- specifications. Support for REST principles and REST-based Web services in the Java-based Jersey project will also be discussed. The presentation will also offer some ideas regarding when REST is the more appropriate alternative and when REST is the less appropriate alternative for implementing Web services.
Skip Sauls and Manish Devgan, Oracle Corporation
Session: 8 - 10:15 am to 11:15 am
Web, Intranet/Internet - All
Social networking applications like Facebook and LinkedIn using Web 2.0 technologies are sprouting up all over the consumer Web. Such applications present a set of rich interactions between users and content. Applications that leverage aspects of social networking are beginning to show up the enterprise. These applications help improve employee productivity by helping users connect with subject matter experts and relevant content. This session includes a demonstration of an application that features social networking features for the enterprise.