Click on a link below to go to session category or presenter.
________________________________________________________________________________________________________________________
SESSION CATEGORIES:
Administrator
Analyst
Developer
Professional
Other
OTHER CATEGORIES:
Presenters by Name
Vendor Presentations
Bradley Brown, TUSC
Session: 9 - 11:15am to 12:15pm
Administrator - Intermediate
Oracle Application Express is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include: pop-up windows, complex searches, document management, indexing and searching, "tool tip" or hints, email links, page 0, help text, background jobs, "add to my calendar" feature, saving contacts (VCF), sending mass emails, and more.
Mike Swing, TruTek
Session 4: 2:15pm - 3:15pm
Administrator - Intermediate
In order to administer 11i, an understanding of 11i Evolution and 11i Architecture is necessary, including the Filey System structure, DB Objects and OA Framework. Reviewing an install of 11i with RapidWiz illustrates the normal directory structure. Patching, Cloning, 11i Upgrades, 11i System Administration and Workflow Administration are typical tasks for an 11i Apps DBA. The basics of patching discussed include how to: apply a patch, fix workers, check logs, why to merge patches, how to user admrgpch and applying HR Global. Cloning topics include single node and multiple node clones with RapidClone, AutoConfig, customizing AutoConfig templates, and SysAdmin steps. 11i upgrades can be a daunting task; the pain can be lessened by minimizing your downtime and performing adequate testing. Best Practices of 11i upgrades including downtime and testing will be discussed. 11i System Administration topics cover: diagnostics, security, personalizations, and managing ICMs. The Workflow Administration section will examine notifications, diagnostics, purging, gathering statistics and directory services. By equipping you with the necessary knowledge, methods, techniques, and tools you will learn how to consistently diagnose Oracle Applications issues and solve them. This presentation prepares you with a detailed explanation of the concepts, and a hands-on approach to the administration.
Arup Nanda, Starwood Hotels
University Session - 1:00pm to 5:00pm
Administrator - All
Automatic Storage Management (ASM), introduced in Oracle 10g, redefined the way storage is used in the Oracle database. It has been designed to keep in mind the Oracle database access, so the performance is considerably better compared to other storage techniques. It is a myth that ASM is only for the RAC database; it is good for any Oracle database. In this session, you will learn everything about ASM, from setting it up to use in backup and recovery. Everything will be demonstrated live.
Michael Mesaros, Oracle Corporation
Session: 5 - 3:45 to 4:45
Administrator - Intermediate
Advances in credential technologies promise to make the access of physical and IT resources more convenient and secure for employees and staff. Indeed, initiatives such as HSPD-12 in the United States are mandating the use of personal identity verification cards as a single source of identity for securing access to federal facilities and IT systems. While the technology exists to meet these requirements, management of the associated identities, credentials and access privileges remains a challenge for many organizations. This presentation describes how Oracle Identity Management has been integrated with physical access control systems to manage common identities and access privileges across the physical and logical security domains. Some of the usage cases for such integration we will discuss include: automating the user on-boarding and off-boarding processes; leveraging events and user status changes across the physical and logical domains; introducing delegated administration for controlling access to physical resources; and improving accountability of access to all resources with reports and attestation. We will also describe technologies developed by Oracle and others for integrating Oracle Identity Management with physical access control systems, and provide some customer case studies. This presentation is appropriate for security administrators and planners as well as anyone responsible for physical and/or logical security. No specialized product knowledge is required.
Steve Lemme, Computer Associates
Session: 7 - 8:30am to 9:30am
Administrator - Intermediate
Size and complexity of managing databases has increased significantly, further challenging the duties of database administrators. Business transformation and project initiatives like ITIL and Cobit further increase the pressure on DBAs as ways are sought to reduce costs and still effectively manage the myriad of databases supporting business. New manageability technologies in databases like Oracle are available to help yet DBAs need the time to learn about them and apply them to resolve real business problems. This presentation focuses on the new challenges, technologies and methods to managing relational databases on the way or for Oracle Fusion. This session will provide practices and technologies a DBA can use to move past database finger-pointing and firefighting 101.
Carel-Jan Engel, DBA!ert
University Session - 1:00pm to 5:00pm
Administrator - All
Running Data Guard out of the box is a piece of cake. GUI driven, a couple of mouse clicks, and voila! But what's going on behind the scenes? How do you determine the right settings of the LOG_ARCHIVE_DEST_n parameters? SYNC/ASYNC, LGWR/ARCH - there are some 50 pages of documentation to explain one parameter. What is important, what isn't? What is a robust setup of init.ora, listener.ora, tnsnames.ora, to enable easy switchovers and failovers? How do you tune the redo transport between primary and standby? How do you split the network traffic of redo and application? How do you deal with a setup with two standbys? There are many more questions to be answered when setting up Data Guard. Having set up more than 50 Data Guard configurations at more than 30 sites, Carel-Jan has developed a robust approach that can deal with complex environments, but can also be scaled down for straightforward primary/standby setups. During this University Session he will share his insight with you, illustrated with demonstrations of setups, failovers and switchovers.
Randy Arseneau, BEZ Systems
Session: 4 - 2:15pm to 3:15pm
Administration - All
Within Enterprise Manager 10g Grid Control R2, Oracle now maintains a central repository of performance data available for access by end users. This data is fed into the central repository from OEM collection agents deployed on each monitored server. The collection agents are programmed with a set of instructions on which "target type" data are to be collected and at which periodic collection interval. There are a series of native target types provided "out of the box" with the OEM product during installation. Additional 3rd party target type plug-ins can be downloaded from Oracle's website. OEM also provides a powerful facility called the Management Plug-In - an extensibility framework within which users are able to define and deploy their own custom target types within the product. In this presentation we will focus on two key areas of interest within the OEM framework: The standard "Oracle Instance" target type The use of Management Plug-Ins to extend OEM data collection capabilities Attendees will learn which Oracle Instance data are persisted within the OEM central repository and which data are retrieved and displayed dynamically. Scheduling and purging considerations for this data will also be reviewed.
Robert Baxter, Denver Newspaper Agency
Session: 5 - 3:45 to 4:45
Administrator - All
Applications that run on dedicated servers frequently do not require all the computer power of their associated servers. The applications have the advantage being isolated from each other, but dedicated systems frequently are not the most efficient way to use computing resources. Server virtualization may be a solution to this predicament. Virtualization allows multiple applications to be consolidated across fewer servers, while keeping each application isolated in its own operating environment. This presentation will discuss using virtualization as a tool to aid in server consolidation and disaster recovery, different virtualization software products, and virtualization caveats.
Robert Freeman, Independent Consultant
Session: 6 - 5:00pm to 6:00pm
Administrator - All
More and more Oracle sites are using RMAN as their prefered backup and recovery solution. In this four-hour University Session, the author of Oracle Database 10g RMAN Backup and Recovery will walk you through the setup and use of RMAN. You will leave the session having learned how to setup and configure RMAN, what a recovery catalog is and when to use it, and how to backup your database with RMAN. Most important, you will learn how to recover your database from all those nasty, late night failures that never come at a convenient time.
Arup Nanda, Starwood Hotels
Session: 5 - 3:45pm to 4:45pm
Administrator - Intermediate
Using concrete scripts and examples, this session will explore, with concrete scripts and examples, different methods to identify intrusion detection in an Oracle database to satisfy most security and privacy regulations and mandates. Attendees will learn the different types of intrusion and the sources of information to detect them. Topics will include: hacking attacks against the listener, denial of service, buffer overflow, etc.; attacks against the database, malicious entry, unauthorized access and denial of service attacks; mining information from listener log to know about listener attacks; simple and advanced Oracle auditing; and many more. All topics will be shown with live working demonstrations.
Joze Senegacnik - Private Researcher
Session: 4 - 2:15pm to 3:15pm
Administrator - Intermediate
The performance of an application solution depends upon efficient access paths to our data. CBO considers all available access paths during the optimization phase and chooses an access path with the lowest cost. Therefore, an optimal physical organization of data is crucial for effective application solution and desired performance. The presentation will point out the benefits and drawbacks of different physical database structures that are available in Oracle database and are often overlooked in the process of transformation of logical model to a physical data layout. The possibilities of available infrastructure in the Oracle database are seldom considered what introduces unnecessary overhead in logical I/O. During the presentation several live demos will be presented for heap-organized tables, index-organized tables, clusters, hash clusters and single table hash clusters. The results of different data layouts w ill be compared and discussed.
Brad Blake, Pharmion Corporation
Session: 5 - 3:45pm to 4:45pm
Administrator - All
This presentation will demonstrate how to install and implement a central management server, running Oracle Enterprise Manager 10g Grid Control. It will discuss how to migrate from Database Control to Grid Control, allowing the organization to have one interface to manage all Oracle systems, with the capability to monitor much more as well.
Murali Vallath, Summersky Enterprise
Session: 5 - 3:45pm to 4:45pm
Administrator - Intermediate
While single instance tuning practices also apply to RAC, one would have to effectively size the buffer cache and shared pool, tune the shared disk subsystems with a clustered configuration in mind and ensure that the cluster interconnect is performing at the maximum efficiency. By looking at the underlying data dictionary views, the global cache management and Oracle's wait interface, this presentation will look into the various aspects of performance tuning a RAC environment. With the introduction of services and workload management, new variables to tuning have been introduced in Oracle 10g. For example, tuning components at the service level identification of performance bottlenecks, etc. Tuning the system by recording and analyzing statistics using various methods including the OEM, ADDM, AWR, etc under a clustered configuration will be discussed.
Randy Cunningham, SageLogix, Inc.
Session: 6 - 5:00pm to 6:00pm
Administrator - All
This presentation provides practical, useful information focused on the productive use of Oracle diagnostic events. In addition to gaining an overview of what diagnostic events are, participants will gain practical, immediately usable information on how to enable and disable events for the current session, another session and for a database instance. Syntax of the event string is explained in detail, including differences between session and instance event strings. Useful methods for quickly and easily locating event trace files are provided. Use of events to troubleshoot database errors originating for third-party software will be demonstrated. Participants will learn how to find out what the various event codes do and will learn some of the more valuable events available to the Oracle practitioner. Some of the more useful tools for analyzing and formatting trace output will be provided, along with samples of their output. Best practices for using events are described, including situations where events should never be used. Properly used, Oracle diagnostic events can help to increase productivity, system availability and service levels.
Kirtikumar Deshpande, Idearc Media
Session: 6 - 5:00pm to 6:00pm
Administrator - All
In this presentation I will discuss the following topics: 1. What is Oracle Streams? Information Sharing Solution 2. What Can Streams do? Data Replication; Data Transformation; Data Warehouse Loading; Message Queuing; Event Management and Notification 3. Elements of Oracle Streams: Capture ; Staging (Propagation); Apply (Consumption); LCR (Logical Change Record) 4. Capture Process: How it works 5. Propagate Process: How it works 6. Apply Process: How it works 7. Logical Change Record: What it is; How Streams uses it 8. Streams Prerequisites: Initialization Parameters; Archivelog Mode; Supplemental Logging 9. Configuring Streams: Administrator Account; Privileges and Grants; Database Links 10. Monitoring Streams: DBA Views; Streams Health Check Script; Steams Monitoring utility; Custom scripts 10. Tips: Configuration; Rules; Operational; Known issues from our experience 11. Troubleshooting Streams: Capture; Apply; Propagation 12. Demo and Scripts review 13. Q and A
John Beresniewicz, Oracle Corporation
Session: 5 - 5:00pm to 6:00pm
Administrato - All
The Oracle 10g RDBMS exposes a conceptual, architectural and user-interface framework for identifying and diagnosing performance problems that uses database time as the core measure of performance impact. The wait-model performance analysis approach now in wide use by experienced DBAs has been formally embedded into Oracle 10g. One key new concept introduced is that of the time-normalized DB time, referred to formally as Average Active Sessions. This presentation will discuss the origin and meaning of Average Active Sessions and its visibility and usage in Oracle 10g, including ASH, AWR, V$ tables, sysmetrics and server alerts, and Enterprise Manager. We will focus on both theoretical and practical aspects of this important number.
Carel-Jan Engel, DBA!ert
Session: 7 - 8:30pm to 9:30pm
Administrator - Intermediate
Data Guard could have a dramatic impact on your database depending on the configuration choices you make. Physical and logical standby use fairly different transport techniques between primary and standby sites and each comes with a distinct footprint. Performance and scalability may vary widely. Ideally, however, your high availability deployment will not impact frontline applications. To ensure that, you need the facts. This presentation will discuss the various Data Guard options and their influence on the performance and scalability of your database environment, to help you decide for the optimal configuration that meets your busnisess' needs.
David Jenne, InfoNow Corporation
Session: 7 - 8:30am to 9:30am
Administrato - All
Poor query performance can sometimes indicate problems with the logic of the SQL statement itself. Tuning SQL queries should be an iterative process involving database administrators, developers and users. Poorly-performing queries can come to light through testing, monitoring database performance and user input. Common techniques for measuring and improving SQL query performance can include explaining plans, tracing sessions, indexing elected columns, and gathering statistics. Using these techniques, query performance can often be dramatically improved. However, when trying to tune a query, it may be important to ask "Does this query make sense?" xamples of queries where changing the statement improved performance include inadvertently retrieving too many rows where only one is needed. In another case, selecting the wrong column returned an incorrect result set which would have consumed far more tablespace than was available. In another case, using the wrong data type in a table negated the use of an index. In each instance, adding an index or optimizing statistics might have helped improve performance. However, in each case, changing the SQL statement to return the expected results helped improve performance to a greater extent.
Arup Nanda Starwood Hotels
Session: 7 - 8:30am to 9:30am
Administrator - Intermediate
Oracle Data Pump Export and Import, introduced in Oracle 10g Release 1, has been touted as tool for data movement across databases; but it s so much more than that. It has vast potentials to be used a backup and archival tool, moving stored code such as procedures and packages, and a remote data access enabler. In this session, attendees will learn the basic and advanced operations of the DP tool. Topics include: setting up DP; running in two modes, Interactive and Batch; performance monitoring; using external tables in DP; enable metadata movement; creating user objects using DP; and creating backup of user source code to satisfy compliance.
Murali Vallath, Summersky Enterprises
Session: 7 - 8:30am to 9:30am
Administrator - Intermediate
All versions prior to Oracle 10g Release 2, load balancing was more of a reactive nature, meaning that unless the session established a connection to the server, the session was not aware of the load. In Oracle 10g R2, this is gone. It is all proactive now. Before the session attaches to the database, the database will inform the client of its current state. Isn't this interesting? This presentation will discuss this concept, its architecture, its implementation and monitoring.
Joze Senegacnik, Private Researcher
Session: 8 - 9:45am to 10:45am
Administrator - Advanced
Oracle 9i introduced the automatic management of working areas. As it is usual for all new features to suffer from teething problems, the automatic work area memory management was no exception as well. The weaknesses in memory allocation for huge sort and join operations in DSS environment were partly solved in the latest release Oracle 10gR2. Only with a solid knowledge of how automatic memory management mechanism works the users are able to efficiently solve the memory allocation problems encountered in their environment and utilize the available memory to the maximum extent. The presentation will point out the Query Execution SQL Memory Manager (QESMM) mechanism details based on observations found in SMM trace files. Armed with the knowledge of automatic working area memory management the users will be able to define optimal memory management strategy suitable for their environment.
John Garmany, Burleson Consulting
Session: 8 - 9:45am to 10:45am
Administrator - Intermediate
Indexes are the easiest way to get great performance gains. However, indexing pitfalls are many. This presentation will cover indexes in the Oracle database, focusing on when and how to add indexes, the different types of indexes and when to use each type. It will also cover common Indexing Errors found in many database configurations. It includes a discuss of tools that will allow you to determine if your index is used correctly by the SQL that needs it. Lastly it will demonstrate using the Oracle 10g Automatic Workload repository to monitor and diagnose indexing problems.
Christo Kutrovsky, The Pythian Group
Session: 5 - 3:45 to 4:45
Administrator - Intermediate
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 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 optimally use it with Oracle in mind. Multiple examples throughout 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 gain visibility into a system's allocation and use of memory. The attendees will leave with good understanding of how memory is used by an Oracle database server and should be able to apply this knowledge to optimally configure their servers regardless of the underlying operating system.
Kyaw Than, Jefferson County Government
Session: 8 - 9:45am to 10:45am
Administrator - Intermediate
In order to learn Oracle RAC, the hardware requirements for an installation can be expensive. The minimum hardware required includes two PCs with multiple network cards and FireWire interfaces. Shared disks are also needed; this requirement can be met through the use of an external disk drive with FireWire ports. This presentation illustrates in detail, how to install Oracle RAC, VMware, and Red Hat Linux on a single PC with the aid of VMware virtualization software. Learning RAC in isolation without looking at other available clustering and High Availability solutions limits your ability to define an architecture for your Oracle installation. In the interests of learning about different kinds of clustering, we also take a brief look at a few other clustering solutions and architectures that provide differing levels of High Availablilty and performance scaling.
Bill Thater, Cyberian Consulate
Session: 9 - 11:15am to 12:15pm
Administrator - Novice
When the database goes away how do you get it back? Well, if you've planned for recovery and backup properly, with ease and stlye. The presentation will look at how you go about planning for recovery and backup from the begining DBA's point of view. It will show some examples of various backup schemes and how they make recovery easier.
Steve Karam, Burleson Consulting
Session: 12 - 4:00pm to 5:00pm
Administrator - Intermediate
Oracle Application Express is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include: pop-up windows, complex searches, document management, indexing and searching, "tool tip" or hints, email links, page 0, help text, background jobs, "add to my calendar" feature, saving contacts (VCF), sending mass emails, and more.
Dean Richards, Confio Software
Session: 9 - 11:15am to 12:15pm
Administrator - All
There are many ways to use Oracle wait events for performance tuning of an Oracle database, but often there is confusion on exactly what the data means. The issue typically centers around the fact the wait event data is analyzed at the wrong level or the collected wait event data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using wait event data to solve the most difficult performance related issues.
Roger Schrag, Database Specialists, Inc.
Session: 9 - 11:15am to 12:15pm
Administrator - Intermediate
Moving an existing Oracle database to a new server that uses a different operating system or processor architecture is more complicated than just copying data files from the old server to the new one. Prior to Oracle 10g, the only supported way to move a database across platforms was to export the data from the existing database and import it into a new database on the new server. This works pretty well if your database is small, but can require an unreasonable amount of down time if your database is large. In Oracle 10g, the transportable tablespace facility has been enhanced in a way that makes it possible to move large databases across platforms quicker and more simply than the export/import method. So if you've got a few terabytes of data in a database on a Solaris server and you want to move it to a Linux server, for example, there is now a much faster way to do it. In this presentation, we will begin by briefly discussing Oracle 10g's cross-platform support for transportable tablespaces. Then we will walk through a real-life example of moving an Oracle database from a Sun E450 to a Dell server running Red Hat Enterprise Linux. We will discuss the steps involved, pitfalls, limitations, and things to keep in mind when planning a database server platform change.
Daniel Likarish, Regis University
Session: 10 - 1:30pm to 2:30pm
Administrator - Intermediate
Regis University has an established Storage Array Networking curriculum that provides database and system engineering students with an opportunity to obtain hands-on virtual storage labs. The talk will review the architectural design process that was used to install, configure, support and manage the Hitachi Data Systems V9585 Thunder.
Kevin Closson, PolyServe, Inc.
Session: 10 - 1:30pm to 2:30pm
Administrator - Advanced
Oracle Real Application Clusters has shipped with Oracle-provided "clusterware" on Linux and Windows since the initial release of 9i RAC. While the name has changed from OCMS to CRS, and then Clusterware, few people actually know what it does or how it is implemented. RAC has been available for more than five years and it is as easy as ever to become confused where clusterware is concerned. All legacy RISC platforms support integrated Vendor clusterware packages along with Oracle Clusterware, and now Oracle has a Third Party Clusterware Validation Program for Linux. Why? This session introduces the new third party clusterware validation program, why you should care, and such important RAC-related concepts as fencing, node-membership services and high-speed interconnects.
Raj Pal, EchoStar Satellite, LLC
Session: 10 - 1:30pm to 2:30pm
Administrator - Novice
RMAN is an integral part of today's Oracle database integrity. There are many options that will restore and recover the Oracle Database to a consistent state for you. However, they do not offer proactive corruption checking and ease of recovery from it and other failures that a database may experience. This presentation centers around some of the different uses of RMAN that may be used, considering various constraints, helping the DBA be more effective.
Jay Caviness, McKesson Provider Technologies
Session: 10 - 1:30pm to 2:30pm
Administrator - Intermediate
Oracle's Automated Storage Manager (ASM) is new with Oracle 10g. ASM has enabled simplified storage management for both RAC and standalone databases. It has advantages over a file system or raw devices for storage, but it does have "quirks". This presentation is geared to the DBA who already uses ASM or may be considering its use. Best practices for implementation and tips and techniques to streamline the use of ASM for their organization will be reviewed.
Joze Senegacnik, Private Researcher
Session: 11 - 2:45pm to 3:45pm
Administrator - Intermediate
The CBO calculates the cardinality of a row source (i.e. table, result of previous operations) from the base cardinality of the row source and the estimated selectivity of predicates. The cardinality is then used for subsequent calculation of the cost of the execution plan which is used as an internal measure to select the optimal execution plan. CBO cannot determine the selectivity of predicates containing user-defined functions implemented usually in PL/SQL without the additional information. The process of defining their selectivity and cost is usually overlooked, although the extensible optimizer contains such mechanisms. When CBO is armed with these important details it can define the proper order of execution of different row source operations. The second part of the presentation will cover creation of statistic types for more complex functions where one can define his own selectivity and cost calculation functions which are called by CBO while the SQL statement is parsed.
Gaja Vaoduamatja, DBPerfMan LLC
Session: 11 - 2:45pm to 3:45pm
Administrator - Intermediate
The world of Oracle Performance Management has a reputation of being part science, part art, and mostly wizardry. This talk shares with you the core principles of performance management (including the methodology) utilized to determine, investigate, and implement "meaningful solutions" to real performance problems. The case studies discussed in this talk are real-world performance problems that were solved using a repeatable and reliable method. Bottom line - Oracle Performance Management is a mathematical science and it is about backing every "opinion or claim" with numbers.
David Fuston, Linium
Session: 11 - 2:45pm to 3:45pm
Administrator - All
We will look at the flexibility of five possible packaged data warehousing solutions to integrate with Oracle Applications, PeopleSoft Enterprise, and EnterpriseOne (formerly known as J.D. Edwards 5). This will entail a discussion of Oracle EDW, Jaros, DecisionPoint, Noetix, and Cognos applications. Based on implementations and project analysis of several DW/OLAP/BI systems, I will offer some very practical guidelines on assessing your BI/DW readiness and chance for project success. This will entail a discussion of the underlying architecture that has been used in Oracle EDW 4.1 (Oracle Applications 11.5.8 and below), Jaros Analytics (Oracle Applications 10.7, 11.0.3 and 11i), DecisionPoint Software (Oracle Applications, PeopleSoft, SAP), Noetix NETS (Oracle Applications, Siebel PeopleSoft), and Cognos Performance Applications (Oracle Applications11 and 11i, PeopleSoft EnterpriseOne 8, and PeopleSoft World 7). In addition, we will look at the flexibility of each solution to integrate with multiple ERP systems, and what reporting tools can be utilized to query and report the data once it is accumulated in the data warehouse. The analysis and information sources include Gartner Group, AMR Research, Ralph Kimball, Bill Inmon, as well as and the personal implementation experiences of several current and former team members. During this discussion, we will contrast and compare these DW approaches to the use of Discoverer 9i and Drake 10g, BIS (11.5.8 and below), DBI (11.5.9 and above), Profitability Manager (11.5.10 and above), and the other Oracle intelligence modules.
Marshall Presser, Oracle Corporation
Session: 11 - 2:45pm to 3:45pm
Administrator - All
Those familiar with Oracle 10g Real Application Clusters are aware of the role the Oracle Clusterware plays. But Oracle Clusterware can be used to provide High Availability for more than just RAC. In this session, we'll discuss the basics of Oracle Clusterware and see how it works with some real world examples, such as the Oracle Application Server and perhaps even an Oracle 10g Single Instance database. No knowledge of clustering or RAC is required. This session would be of interest to DBAs, SAs, and Data Center managers.
Kyle Hailey, Independent Consultant
Session: 12 - 4:00pm to 5:00pm
Administrator - Advanced
The wait interface method for tuning Oracle databases has become well known. Unfortunately the exact meaning of the wait events themselves is still shrouded in mystery. Now for the first time, each of the top 30 wait events will be explained in detail and examples of typical causes and solutions given. The top 30 wait events represent 99.9 percent of the wait time reported in Oracle customer databases. Note: the lecture is aimed at version seven through nine, though some version 10 wait events will be discussed. Note: Lecture excludes RAC and OPS wait events.
David Kurtz, Go-Faster Consultancy Ltd.
Session: 12 - 4:00pm to 5:00pm
Administrator - Advanced
If you are trying to resolve performance problems, then you need to work out how your application is spending its time, and why. If your problem is SQL-related then you need to know how Oracle is executing that SQL and why. Sometimes you need to be able to show that the problem is not in the database. This session will introduce you to Oracle's SQL Trace facility, it will include: how to enable SQL trace; what is in the SQL trace file; how to process it with TKPROF; how to read an execution plan; techniques to make sense of execution plans; limitations of TKPROF; and avoiding TKPROF traps
Graham Wood, Oracle Corporation
Session: 12 - 4:00pm to 5:00pm
Administrator - Intermediate
The data sampled in the Oracle 10g Active Session History can be used in many ways. This session will look at how ASH data can be used to get the equivalent of TKPROF, but without all the issues of having to enable SQL*Trace and then find the trace. It might not get you everything available in TKPROF but it is available, cheap and easy to use.
Terry Sutton, Database Specialists, Inc.
Session: 1 - 9:00am to 10:00am
Administrator - Intermediate
The SQL trace facility helps the DBA diagnose performance problems and make applications run faster. Tracing works well in client/server environments or two-tier architectures where there is a one-to-one correspondence between a database session and an end user session. In such systems, you can activate SQL trace for one user's Oracle server process and get a detailed accounting of all statements executed in that user's session. Unfortunately, the SQL trace facility never worked well in connection-pooled environments or architectures that use an application server to multiplex many end user sessions into a smaller number of database sessions. Beginning with Oracle 10g we have the ability to trace an end-user's session, even though connection pooling may cause each request by that user to be served by a different Oracle server process. In this presentation we will walk through a real-life example of tracing an individual end-user's actions as they use a web-based application. Although each request by the end user might be handled by a different Oracle server process, and each Oracle server process will also handle requests from other end-users, all requests by our target end-user get traced and reported cohesively in one TKPROF report. The technique is not hard to use, once you understand it. By the time we walk through the entire process and look at real output in this presentation, you will know how to trace individual end users in your connection-pooled environments.
Michael Ault, Quest Software
Session: 2 - 10:30am to 12:00pm
Administrator - Intermediate
In this presentation, I will cover methods to test your Oracle system to determine capacity and performance limitations. Using real-world examples, I will show how various testing tools can be utilized to determine just what to expect from your Oracle system under load.
Stephan Haisley, Oracle Corporation
Session: 2 - 10:30am to 12:00pm
Administrator - Intermediate
In nearly all production environments there comes a time when something unexpected happens. The biggest problem comes when the database crashes for an unknown reason, doesn't come up straight and gives way to a slew of error codes. Other problems crop up when jobs or reports fail or perform slowly for no reason. This presentation aims to provide a list of common problem scenarios that can occur along with a list of diagnostic data to gather. Once this data has been gathered I will provide a methodology to using it to help determine causes and provide solutions. All this can be done quickly before raising a Service Request (SR) with Oracle Support Services. In the case when an SR is raised, the data gathered will go a long way to helping the support engineer identify a cause and provide a solution.
Jared Still, Radisys
Session: 2 - 10:30am to 12:00pm
Administrator - Intermediate
The purpose of this presentation is to counteract the reaction that sometimes occurs when databases are designed, specifically the need to denormalize for performance. It is often assumed that a normalized schema will be slow. This presentation will give the listeners some things to consider: How fast is fast enough? Am I using the appropriate database features to enhance performance? Have I really considered all the pitfalls encountered when denormalizing for performance (update and delete anomalies, complex and convoluted SQL, future business requirements)? A brief review of normalization will be included.
Cary Millsap, Hotsos Enterprises, Ltd.
Session: 2 - 10:30am to 12:00pm
Administrator - Intermediate
In the years since the publication of Optimizing Oracle Performance in 2003, we've learned a little bit about performance problem diagnosis and quite a bit about how many ways it's possible to misunderstand what Jeff Holt and I tried to write in our book. This session describes topics including the following: "Method R is reactive" ...What about a method for "preventing" performance problems? Can you use Method R if you can't prioritize your business tasks? Do you have to use Oracle extended SQL trace data to use Method R? Do you have to own Hotsos products to use Method R? Does Method R work in complicated multi-tier environments? Is it practical to use detailed profile data as a primary diagnostic data source? Does Method R work with prepackaged applications? Does Method R ignore session interdependencies? Can Method R help diagnose performance problems that are outside the Oracle tier? How is Method R different from other educators' writings and teachings about the so-called Oracle Wait Interface? How does Method R compare to Anjo Kolk's YAPP Method? And is Method R consistent with principles of bottleneck analysis?
David Aldridge, Independent Consultant
Session: 3 - 1:30pm to 2:00pm
Administrator - Intermediate
The Linux 2.6 kernel allows the choice of four different i/o schedulers, which give priority to reads and writes in different ways. Conventional wisdom is that the CFQ scheduler represents the best compromise choice for many application types, but the anticipatory scheduler is in fact superior for systems characterized by multiple large sequential read requests of contiguous data-in other words, Oracle data warehouses. This presentation explains the scheduler types available, demonstrates how they react to a parallel query environment, and how the read bandwidth of devices varies with increasing degree of parallelism.
Chip Briggs, Independent Consultant
Session: 3 - 1:30pm to 2:00pm
Administrator - All
Recovery Manager (RMAN) concepts will be described and demonstrated along with audience participation questions: configuration; hot and cold backup; and various recovery scenarios, including media failure, corruption, and accidental problems (e.g. drop user, rm *, truncate table, and utl_file).
Roger Schrag, Database Specialists, Inc.
Session: 3 - 1:30pm to 2:00pm
Administrator - Intermediate
When a sort operation is too large to fit in memory, Oracle allocates space in a temporary tablespace in order to write data off to disk. Temporary space is a resource shared by all sessions on the database, and quotas cannot be set to limit how much temporary space can be used by any individual user or session. If a user submits a query with an incomplete WHERE clause, an enormous Cartesian product may result. That is all it takes to fill the temporary tablespace and possibly impact many other users on the system. When the temporary tablespace fills, any statement that requires additional temporary space will fail with an "ORA-1652: unable to extend temp segment" error. In this short session we will discuss how the DBA can determine if any statements on the database have failed because the temporary tablespace was full. We will also present two techniques the DBA can use to understand how space in the temporary tablespace is being used and how users are being impacted by a full temporary tablespace. First we will look at how to direct Oracle to log every statement that fails for a lack of temporary space. Next, we will look at queries the DBA can run at any time to capture in real time how temporary space is currently being used-on a per session or per-statement basis. These techniques can help DBAs address chronic or intermittent shortages of temporary space.
David Kurtz, Go-Faster Consultancy Ltd.
Session: 6 - 5:00pm to 6:00pm
Analyst - Intermediate
Just because you have bought a packaged application from a large company don't assume that its authors have made sensible design decisions. They probably haven't, in which case your problems are even worse, because even if you can fix the problem, will the vendor support your change? Probably not. This presentation will discuss some of the things that PeopleSoft did that were really not a good idea. Some of them you can do something about, some you have to live with, some not.
Dan Hotka, Training Specialist
Session: 1 - 9:00am to 10:00am
Analyst - Intermediate
This is a live-demo presentation of new functions in the latest release of the Oracle Discoverer product. Dan is an experienced trainer and will demonstrate a variety of new and neat features of this reporting/drilldown tool. The attendee will gain valuable insights as to the many features of the latest version of Oracle Discoverer 10g.
David Hay, Essential Strategies, Inc.
Session: 1 - 9:00am to 10:00am
Analyst - Intermediate
Data modeling, business rule modeling, and ultimately, database design to filter bad information. These approaches use logical constructs and an enterprise's semantics to make assertions about what is true, and therefore what data should be accepted into a database. The new world of ontology has produced languages (RDF and OWL) that are intended to analyze large bodies of information, also in terms of logical constructs and an enterprise's semantics, but this time in order to make inferences. The two approaches are profoundly different, but closely related as well. This presentation will take a sample data model, convert it to RDF and OWL, and use this exercise to demonstrate what is new and what is not new in this wonderful new world of ontology and semantics.
David Kurtz, Go-Faster Consultancy Ltd.
Session: 5 - 3:45 to 4:45
Analyst - Intermediate
Most Oracle professionals now realise that timed based metrics rather than ratios are THE reliable way to diagnose performance problems. It is ironic that as this change has come about, the effectiveness of the Oracle timed-event instrumentation has been degraded because more time is spent in the ever-increasing layers of middleware. Database idle time may actually be application busy time. We know what to do when the problem is in the database, but what about when most of the response time is "SQL Net message from client?" This presentation will look at how PeopleSoft (before it was acquired by Oracle) sought to address the problems of measuring application performance with its Performance Monitor utility, and whether it was successful.
Paul Dorsey, The Dulcian, Inc.
Session: 6 - 5:00pm to 6:00am
Analyst - All
For anyone working with databases and the applications that interact with them, Oracle Fusion Middleware is likely to be a significant part of your development environment. What does this mean technically for your organization? Must you use the Oracle DBMS and/or the Oracle Application Server (OAS)? Can you integrate with any existing .Net applications? What products/technologies do you need to learn to use? This presentation will clarify the different parts of the Oracle Fusion technology stack, discuss what this stack means to your organization, and provide a strategy for retraining and retooling in order to take advantage of Oracle Fusion Middleware capabilities.
Jean-Pierre Dijcks, Oracle Corporation
Session: 7 - 8:30am to 9:30am
Analyst - Novice
Let's face it, we need to involve our business users in the data quality process to make data quality projects a true success. That is why Oracle has integrated the Data Quality Inspector and Oracle Warehouse Builder into a single comprehensive offering. The combination of the products deliver robust Data Quality functionality for both the IT staff and for the business users. Business users directly influence the actions that will be taken on their data by reviewing the findings and suggesting fixes. The session will demonstrate the key benefits to the business and to the IT staff of this integrated offering. You will learn how you can implement a total quality process within your organization, and see all the software live in action. After this session you will understand where and how business users should (and can) be involved in data quality. You will see a concrete solution, not just a dream of what should have been.
Leslie Tierstein, NewScale, Inc.
Session: 5 - 3:45 to 4:45
Analyst - Intermediate
This paper presents a real-life exercise in constructing a datamart to meet many challenges recognized in data mart design and implementtion methodologies. Foremost among these is the need to load dynamically defined data (like Oracle Applications' flex fields) into the data mart, and build the reporting tool's metadata so it correctly reflects the source system's metadata. Then there is the issue of handling a very large number of dimensions (in the 100's!) in a design that performs adequately, but also provides an intuitive end user query interface. And last, but not least, the challenge of building an incremental refresh process that will also accommodate updates to the data mart contents. The presentation concentrates on design and methodology but includes some consideration of the tools used (the Cognos ETL and reporting suite).
Peter Haastrup, PA Consulting Group
Session: 11 - 2:45pm to 3:45pm
Analyst - Intermediate
Energinet.dk, which is responsible for the regulation of the energy sector in Denmark, has implemented a Data Warehouse (DW) using Oracle Warehouse Builder (OWB) as the tool used when constructing the DW, and Oracle Discoverer as the presentation layer to the users. The DW is being used extensively to provide reporting to all areas of the business, including marketing, operations and the financial department. The technical charter of the project catered for a 100% implementation of the DW in OWB, making the various parts of the Data Warehouse as uniform as possible with respect to the individual developer's choice when implementing a specific part of the DW, and additionally making further development and maintenance as seamless as possible. This presentation will illustrate in detail how this DW was constructed using Oracle Warehouse Builder illustrating the strengths of, and challenges in following this approach.
Jean-Pierre Dijcks, Oracle Corporation
Session: 12 - 4:00pm to 5:00pm
Analyst - Intermediate
We've seen and heard it before, but can you really do enterprise class ETL driven by business rules? With Warehouse Builder 10gR2 the answer is a definite yes. In this paper and demonstration you will see how you can create business rules in Warehouse Builder and then apply them to real world ETL problems. You will see how changing a business rule will change the ETL logic with a few simple clicks. You will see how you can create error handlers completely driven by business rules. As an extension of the rules in ETL we will show you how to validate your rules on your actual source data, to ensure that the rules are in fact correct and supported by your data. After this session you will understand that business rules can have a real impact on a developers life. Maintenance of ETL logic becomes simpler, error routines can be modified in minutes. After this session you will probably see many new applications for business rules in your environment when using Warehouse Builder.
Kris Rice, Oracle Corporation
University Session - 1:00pm to 5:00pm
Developer - Intermediate
There are many tools available in the market today that allow you to interact with an Oracle database. SQL Developer, Oracle's graphical alternative to SQL*Plus, allows the database developer a convenient way to perform basic tasks. Using a combination of presentation and hands on, this workshop walks you through various aspects, including editing and debugging PL/SQL, creating user defined master-detail reports and more. Adding extensions to SQL Developer and demonstrating how to build a small extension will be discussed. We will be using the latest release of SQL Developer, pointing out the latest new features.
Peter Koletzke, Quovera
University Session- 1:00pm to 5:00pm
Developer - Novice
It is often difficult to select among the myriad of technologies available for Web applications deployed in the J2EE environment. In addition, development work for this environment is very different from the "traditional" paths Forms and PL/SQL developers are accustomed to. This university session offers a solid introduction to a recommended set of technologies that provide a development experience as close to Forms as possible-ADF Business Components, JSF, and ADF Faces. It briefly explains where these technologies fit in the J2EE world and how to create code using Oracle Application Development Framework (ADF) in JDeveloper 10g. Students then obtain an introduction in how to use ADF Business Components to create a code layer to access the database for queries and updates. The presentation focuses on how to create a Web user interface using JavaServer Faces (JSF) and ADF Faces that connects to the data access layer. Concepts discussed include J2EE architectures, Web languages, converting forms applications to J2EE, ADF architecture, the ADF Model layer, entity objects, view objects, database-centric development, bindings, and data controls.
John King, King Training Resources
Session: 1 - 9:00am to 10:00am
Developer - Intermediate
Attendees are introduced to new and improved features of Oracle 10g that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or improve deployment. Attendees will be better equipped to create applications that take full advantage of Oracle 10g.
Peter Koletzke, Quovera
Session: 1 - 9:00am to 10:00am
Developer - Novice
This presentation explains the JAZN feature of the OC4J server and discusses how it provides solid security services for J2EE web applications. The presentation explores different ways to store user credentials in JAZN and how to tap into existing Lightweight Directory Access Protocol (LDAP) providers such as Windows' Active Directory. It also describes the JAZN ability to access user credentials stored in XML files and how to switch back and forth between these two styles when moving from development to production credential stores. Then this presentation describes and demonstrates how to set up and code security hooks into your application using JDeveloper 10g so you can restrict and permit user access and operations to your valuable enterprise data.
Cosmin Ioan, bridge-tech.com, inc.
Session: 5 - 3:45pm to 4:45pm
Developer - Intermediate
1. Thou shalt comment all thy code. 2. Thou shalt use proper indexes. 3. Thou shalt maximize SQL and minimize PL/SQL. 4. Thou shalt instrument thy code. 5. Thou shalt benchmark thy code. 6. Thou shalt debug code efficiently. 7. Thou shalt stress test with significant data. 8. Thou shalt make use of bulk processing. 9. Thou shalt minimize client code and maximize server code. 10. Thou shalt review code with peers. (Plus other things to watch for when developing a scalable and maintainable system.) Three to six case studies of everyday poor implementations of both OLTP and OLAP systems. Bonus: links to resources on some of the above topics.
Paul Dorsey, Dulcian Inc.
Session: 4 - 2:15pm to 3:15pm
Developer - Intermediate
ADF Faces delivers the capability of building applications that have near client/server look-and-feel. This presentation will demonstrate some of the sophisticated features of Faces, such as tree controls, pages with dynamically changing content elements and complex page flow.
Tom Brown, ESRI
Session: 9 - 11:15am to 12:15
Developer - Intermediate
ESRI has utilized Oracle's Object Type and Extensible Indexing to develop and release a commercial ISO compliant spatial type. This presentation delves into the new object type and domain index, discussing what was involved to implement the storage behavior, the domain index strategy and developing the necessary constructors and spatial/relational operators.
Bradley Brown, TUSC
Session: 4 - 2:15pm to 3:15pm
Developer - Intermediate
Web Services are the next logical step in application development. They provide a major step forward in the Internet computing model. There are so many components and continual research going on in this area. 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.
Kris Rice, Oracle Corporation
Session: 1 - 9:00am to 10:00am
Developer - Novice
Oracle SQL Developer provides the database developer with a convenient way to perform basic database tasks. Connected to an Oracle database, users can browse, create, edit, and delete database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; and create reports. This session positions the tool, demonstrates functionality and looks to future capabilities planned.
Peter Moskovits,
Session: 5 - 3:45 to 4:45
Developer - Intermediate
JavaServer Faces provide a rich, component-based framework for portal development. By attending this session, portal and JavaServer Faces technology developers will gain the knowledge to effectively build a portal presence using JavaServer Faces. Specifically, this session explores in detail how you can make your Faces applications customizable and how to add portal capabilities, such as JSR 168/WSRP portlets and site management. You will learn how to declaratively secure your components using Java Enterprise Edition 5 (Java EE 5) and JAAS security. You will also see how using JavaServer Faces can enhance the end-user experience beyond traditional portals with rich components and built-in services.
William Wimsatt, 1783 Productions, LLC
Session: 1 - 9:00am to 10:00am
Developer - Advanced
MDX is a query language designed for efficient processing of star schemas. MDX is not offered as a standard query language for Oracle. However, there are many tools and solutions that are now incorporating MDX. MDX allows easy navigation in the multi dimensional space. It understands the Multi-Dimensional concepts of cube, dimension, level, member and cell. It is used for queries, full statements SELECT FROM), business modeling, defining calculated members using MDX Expressions. This presentation will explore the MDX language and its use with Oracle databases. Attendees will be provided with an overview of MDX as a description for multi-dimensional structures and querying star schemas with MDX. It will include Declaritive MDX Structures and MDX Queries vs. MDX Expressions.
Donald Burleson, Burleson Consulting
Session: 2 - 10:30am to 12:00pm
Developer - All
This dynamic and in-depth presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle 10g features. The topics will include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, rewriting SQL queries in more efficient forms and the use of advanced techniques such as Materialized Views, replacing SQL with PL/SQL, the new automated CBO statistics collection, and using the new Oracle 10g CPU costing approach. 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.
Dustin Marx, Ratheon company
and Scott Carlson, Paragon Dynamics, Inc.
Session: 2 - 10:30am to 12:00pm
Developer - Novice
One of the hottest trends in web development in recent years has been the naming and widespread use of the collection of technologies commonly known as Ajax. While all of the technologies underlying Ajax have been around for some time, the naming of this collection of technologies combined with the high profile use of these technologies has led to its widespread adoption in the web development world. Ajax combines technologies such as Cascading Style Sheets (CSS), JavaScript, DOM (Document Object Model), and XMLHttpRequest to allow for more dynamic and responsive web sites. The growing use of Ajax has reduced the gap in performance and feature richness that has always existed between " rich" client technologies and web-based clients. This presentation will briefly cover the limitations of the web environment and the traditional web solutions. Brief descriptions of the technologies that make up "Ajax" will also be discussed. Attention will be paid to how the technologies of Ajax have become the modern day hero of web development by bringing greater richness and performance to web applications. Brief comparisons of Ajax to competing "rich web" techniques and approaches will be made to better accentuate the positive features of Ajax. This is an introductory presentation and is aimed at developers, administrators, technical managers, and others who wish to learn more about Ajax and why Ajax is so popular today. Ajax is more than just a fad and this presentation will point out some reasons why it is more than a fad.
Dustin Marx, Ratheon company
and Scott Carlson, Paragon Dynamics, Inc.
Session: 2 - 10:30am to 12:00pm
Developer - Novice
One of the hottest trends in web development in recent years has been the naming and widespread use of the collection of technologies commonly known as Ajax. While all of the technologies underlying Ajax have been around for some time, the naming of this collection of technologies combined with the high profile use of these technologies has led to its widespread adoption in the web development world. Ajax combines technologies such as Cascading Style Sheets (CSS), JavaScript, DOM (Document Object Model), and XMLHttpRequest to allow for more dynamic and responsive web sites. The growing use of Ajax has reduced the gap in performance and feature richness that has always existed between " rich" client technologies and web-based clients. This presentation will briefly cover the limitations of the web environment and the traditional web solutions. Brief descriptions of the technologies that make up "Ajax" will also be discussed. Attention will be paid to how the technologies of Ajax have become the modern day hero of web development by bringing greater richness and performance to web applications. Brief comparisons of Ajax to competing "rich web" techniques and approaches will be made to better accentuate the positive features of Ajax. This is an introductory presentation and is aimed at developers, administrators, technical managers, and others who wish to learn more about Ajax and why Ajax is so popular today. Ajax is more than just a fad and this presentation will point out some reasons why it is more than a fad.
Peter Koletzke, Quovera
Session: 2 - 10:30am to 12:00pm
Developer - Intermediate
Oracle has long offered tools that assist with designing, developing, and deploying applications; its current focus is with the Java IDE, JDeveloper. JDeveloper 10g (release 10.1.3) offers a new set of features, libraries, and methods-ADF Faces-which greatly simplify Java development tasks and take advantage of the popular J2EE (Java EE 5.0) technology JavaServer Faces. The tools that JDeveloper provides to work with ADF Faces allow development of J2EE web applications in an environment that is closer to Oracle Forms than anything previously released. This presentation describes Application Development Framework (ADF), ADF Faces and how they can assist with development of a Java-based application. It also shows the various tools in JDeveloper that support the "ADF development method" and how they ease the task of connecting Java front-end code to the database. In addition, the presentation provides an overview of the JHeadstart plugin and shows how its declarative environment might rival that of Oracle Forms Builder. Finally, the presentation offers insight about what type of development shop will benefit the most from ADF, ADF Faces, and JHeadstart and whether it really is possible to achieve the productivity of an Oracle Forms environment by using ADF Faces with JHeadstart.
John Garmany, Burleson Consulting
Session: 3 - 1:30pm to 2:00pm
Developer - Intermediate
This presentation will explain the why and how of using regular expression with Oracle. Unix SAs know the power of matching with regular expression and now the Oracle DBA and Developer can put that power to use. But regular expressions are not the only of even the best answer in all situations. We will cover your regular expression options in the SQL, PL/SQL and Java. While most DBAs do not use Java, it does provide a rich and powerful regular expressions capabilities that SQL and PL/SQL do not have. Similarly, improper use of regular expression can have a large negative impact on database performance. The presentation will explain the pros and cons of each method and when they can best be utilized to provide you with high performance matching capability.
Janet Burleson, Burleson Consulting
Session: 3 - 1:30pm to 2:00pm
Developer - All
Most Oracle professionals understand the technical mechanisms of Oracle tools such as SQL*Forms, HTML-DB and JDeveloper to write applications, but many are not aware of the rules of ergonomics. When online screens are used by thousands of people everyday, the Oracle application must optimize the interaction and allow the end-user to complete their task with a minimum amount of work. This presentation will show real-world examples of Oracle ergonomic design and illustrate techniques for improving end-user satisfaction and improving productivity for any Oracle online system. We will show time-saving techniques such as auto-fill vs. drop-down fill, examine best practices for screen design and show how to minimize typing and maximize throughput. This session is ideal for system development managers and Oracle developers who want to understand how to deliver robust, easy-to-use applications.
John King, King Training Resources
Session: 3 - 1:30pm to 2:00pm
Developer - Intermediate
Today the ability to project future data plays a large part in management planning. Oracle 10g added the SQL Model clause making complex "projection" calculations easier to create and use. Model is an extension to the SQL Select statement defining a multidimensional array by mapping query columns into three groups: partition, dimension, and measure columns. This presentation demonstrates the creation and use of "future" values via SQL using the Model clause.
Kris Rice, Oracle Corporation
Session: 5 - 3:45pm to 4:45pm
Developer - Intermediate
SQL Developer provides a convenient way to perform basic database tasks. Here we look at some of the activities you might perform, running complex scripts, normalizing data, and remote debugging. Advanced reporting capabilities include graphical displays and master-detail reports. We demonstrate a few existing extensions to SQL Developer and show you how to build and include your own extensions.
Michael Fons, Graebel Companies, Inc.
Session: 6 - 5:00pm to 6:00pm
Developer - All
Our company, perhaps like others, is currently being forced to leave Oracle Forms/Reports and work with JDeveloper, ADF, JSF, and other technologies-all in an SOA framework. Despite the many good publications and demos for Oracle Java-based technologies, this transition is troublesome. This presentation aims to give an overview of such transitions and to give advice on how to overcome the obstacles that come with them. This perspective is that of a developer and team leader.
John King, King Training Resources
Session: 5 - 3:45pm to 4:45pm
Developer - Novice
Service-oriented Architecture (SOA) is a standards-based framework that represents business functions as a set of shared, reusable services. Services can in turn be combined and orchestrated to produce composite services and business processes. The Enterprise Service Bus (ESB) provides the backbone of SOA. The ESB is a standards-based integration platform that combines middleware and services on the network. This presentation introduces the basic concepts and terminology of a SOA and its importance to IT. The session will provide the basic information necessary to help you enthusiastically participate in the implementation of SOA at your organization. Upon completion of this session you should be able to: explain the concepts and principles of SOA; explain the benefits of the SOA approach; and describe the basic function of an ESB.
Liz Hall, Pinnacol Insurance
Session: 8 - 9:45am to 10:45am
Developer - Intermediate
Oracle Forms is widely used, yet widely misused. This session will discussed pointers to writing easy-to-maintain, easy-to-debug and not-so-easy-to-break Forms code. Learn how to configure and use the Forms Degugger tool; add DML code in the correct place; see triggers as they fire; and other Forms "gotchas".
Dan Hotka, Training Specialist
Session: 8 - 9:45am to 10:45am
Developer - Novice
There hasn't been a free integrated development environment for Oracle since the TOAD tool was freeware! Learn more about this exciting new environment from Oracle. This presentation will include a live demonstration on various tips and techniques in using this tool to work with SQL, scripts, data and database objects. This presentation will be packed full of practical examples from Dan's book, The Oracle SQL Developer Handbook and is a must see for anyone involved with Oracle development.
Chris Ostrowski, TUSC
Session: 10 - 1:30pm to 2:30pm
Developer - Intermediate
This presentation will detail how to integrate Oracle and non-Oracle-based systems into OracleAS Portal providing a single environment with a rich, visually-consistent end-user experience while keeping administration efforts to a minimum.
Dustin Marx, Raytheon Company
Session: 9 - 11:15am to 12:15pm
Developer - All
Ruby on Rails is a framework intended for rapid web application development. This presentation is based on the presentation "Riding Rails to Ruby and Riches" that was presented at RMOUG Training Days 2006, but adds significant code examples and demonstration of rapid development with Rails. "Ruby on Rails Revisited" will briefly cover the basics of the Ruby programming language, the basics of web development, and how Ruby on Rails takes advantage of conventions and assumptions to allow for rapid development of web applications. Simple demonstrations will show how to employ Rails' scaffolding to create a basic CRUD web application with no coding and then how to easily adapt this scaffolding to more sophisticated web applications. This presentation will cover areas where Ruby on Rails is strongest as well as situations in which its benefits may not be as fully realized. Topics discussed during the course of the presentation include using convention rather than configuration, overriding Rails' conventions for use with legacy database schemas, using and overriding Rails' scaffolding, Rails' support for easier use of XMLHttpRequest (often called Ajax or Asynchronous JavaScript and XML), and three approaches to accessing Oracle stored procedures from Rails.
Lynn Munsinger, Oracle Corporation
Session: 9 - 11:15am to 12:15pm
Developer - Novice
Security is an afterthought in many development projects. Few would argue that leaving the doors of your car unlocked and the keys in the ignition is a bad idea, but deploying J2EE applications to the Web without some level of security is no less careless. Security is a critical part of both your application design and development. It is important for developers and architects to understand that security is on the critical success path of Web application development. This session explains Web application security fundamentals and how to apply J2EE security to Web applications built with Oracle Application Development Framework (ADF) and JavaServer Faces (JSF).
Tuomas Pystynen, Independent Consultant
Session: 10 - 1:30pm to 2:30pm
Developer - All
Connection pooling enables web applications to scale to thousands of users. This presentation covers many aspects related to the topic. How to write applications that use connection pooling correctly and efficiently. How to configure, monitor, tune and troubleshoot OC4J connection pooling. What are the differences between OC4J 10g Release 2 and 3 Data Source implementations? Should I use JDBC Thin or OCI driver? How does connection pooling work in RAC environments?
Chris Ostrowski, TUSC
Session: 10 - 1:30pm - 2:30pm
Developer - Intermediate
This presentation will walk through the Portlet development wizards in Oracle JDeveloper to demonstrate the pros and cons of developing PDK and JSR 168-based portlets.
Steve Karam, Burleson Consulting and Training
Session: 11 - 2:45pm to 3:45pm
Developer - All
Apex (HTML-DB) has become a wildly popular system development platform and Oracle has always emphasized how HTML-DB can be used to quickly create working applications. However, Apex can be easily extended into a fully robust tool that can be used to deploy super sophisticated systems. This presentation will show little-known techniques for performing complex screen interfaces and leveraging Java, and special techniques for large scale systems development. Topics will include cascading menus, dynamic included content, updateable repeating display and much more.
Peter Koletzke, Quovera
Session: 12 - 4:00pm to 5:00pm
Developer - Intermediate
Normally, connecting database data to the user interface of a web application requires some work. Oracle Application Development Framework (ADF) provides a feature called ADF Bindings that you can use to accomplish this task. ADF Bindings is part of the ADF Model layer, which is recognized as the most innovative and remarkable technology in the ADF stack. This presentation briefly reviews where ADF Model (ADFm) fits and how one of its components, ADF Bindings, allows you to quickly connect components from any user interface library such as ADF Faces and JSF Reference Implementation to business services such as ADF Business Components. The presentation provides details and shows examples of how ADF bindings work; how to automatically bind data elements to visual elements; what types of bindings are available; and where binding code appears. It also explains the basics of the expression language used to bind Model layer components to View layer components.
Steve Karam, Burleson Consulting and Training
Session: 11 - 2:45pm to 3:45pm
Developer - Advanced
When Oracle changed the name of HTML DB to Oracle Application Express (ApEx), many people wondered just where the "express" came from. Sure, it's easy to make quick and dirty applications that handle large amounts of data, but it's just so bulky for the end user! This presentation will show how to use emerging Asynchronous Javascript and XML (Ajax) technology to make your ApEx applications lightning fast for your users. We will examine the use of Ajax in submitting forms and retrieving data, both as single fields and even in complex reports. By pairing Ajax with DHTML, we can build advanced screens that retrieve data on the fly without a single page refresh.
Andreas Katsaris, Arisant, LLC
Session: 9 - 11:15am to 12:15pm
Administrator - Intermediate
The presentation is geared towards Intermediate-level DBAs who support Data Warehouse projects. The presentation will focus on three major topics: Oracle-centric techniques that may be used to move large amounts of data from source systems to a warehouse, design tips for optimal performance of such loads, and SQL tips for querying large warehouse tables. The above three topics are discussed below in more detail. Move large amounts of data from source systems and load them in the warehouse: this topic will discuss the different tools available to the DBA, such as SQL*Loader, external tables, Data Pump, PL/SQL code, materialized views/replication, streams and CDC (Change Data Capture). The discussion will focus on the pros and cons for each of these options and offer tips on how to determine the best option. Design tips for optimal performance of these loads: this topic will cover design techniques and a simple methodology for optimizing data load times. The discussion will focus on the following topics: partitioning, parallelization, index strategies used to avoid data load interference, and managing foreign keys in a warehouse. Determining when to gather statistics SQL tips for querying large warehouse tables: this section of the presentation will cover available techniques used to optimize warehouse querying, indexing techniques, materialized views, star schemas and star transformations, SQL hints (specific for warehouse queries), and Init.ora parameter settings.
John Weaver, General Dynamics
Session: 6 - 5:00pm to 6:00pm
Administrator - Intermediate
With the increased usage of large high volume files, such as digital imaging, large Storage Area Networks are becoming more of a necessity in many of today's high tech businesses. There are multiple ways to implement and configure Storage Networks and the decision on how to do so will have a large impact on how well these networks work. This presentation will go into the configuration and design of Storage Networks and how to optimize them with regard to application, speed, portability, security and redundancy.
John Reading, Graebel Companies, Inc.
Session: 3 - 1:30pm to 2:00pm
Professional - Novice
Oracle Collaboration Suite is filled with lots of goodies. This presentation will introduce you to the various components available and then focus on Real Time Collaboration with the emphasis on the web conferenceing capabilities of OCS.
Steve Karam, Burleson Consulting and Training
Session: 5 - 3:45 to 4:45
Professional - Technical Management - Intermediate
To a DBA, RAC is very tempting; you will get scalability, high availability, and performance load balancing, not to mention a great mark on your resume, all in one fell swoop. However, going to RAC can be costly. In order to attain the money, man-hours, and training necessary to implement RAC in your environment, you will most likely need manager approval. This presentation targets the manager of a database shop where RAC may be under consideration. We will discuss costs, pros and cons, and the full impact it will have on your staff, training, data center, and company.
Leslie Tierstein, newScale, Inc.
Session: 6 - 5:00pm to 6:00pm
Professional - All
Corporate politics comprises a set of non-technical "people" skills needed to develop and maintain software and the software development and production environment. This skill set will help you, as an IT developer, DBA, or manager, better understand the corporate environment in which software is used, developed, and deployed - including interactions between project teams; among team members; between managers and subordinates; and between developers, DBAs, and their software's prospective users. You will also learn how to guide or influence policy so that it promotes the delivery of robust, usable software to the user community in a timely, cost-effective fashion.
Dennis Phillips, Gold Systems, Inc.
Session: 7 - 8:30am to 9:30am
Professional - All
This presentation is a case study of Gold System's implementation of Agile methodologies. Gold Systems, a Salt Lake City based application development shop, had been using traditional waterfall processes to deliver to its clients. In order to reduce risk of failure and increase value to clients, they implemented new software development methodologies. This presentation will illustrate the path they took to improve process and results with Agile methods.
Carol Jeunette, Prairie Systems Group, Limited
Session: 7 - 8:30am to 9:30am
Professional - All
This presentation is a case study of Gold System's implementation of Agile methodologies. Gold Systems, a Salt Lake City based application development shop, had been using traditional waterfall processes to deliver to its clients. In order to reduce risk of failure and increase value to clients, they implemented new software development methodologies. This presentation will illustrate the path they took to improve process and results with Agile methods.
Jim Peters, Symantec
Session: 8 - 9:45am to 10:45am
Professional - All
Oracle is promoting RAC as the way to achieve minimal downtime for database applications. This session will examine the causes of downtime, and how RAC, related software, and best practices can reduce and/or even eliminate planned and unplanned downtime.
Kevin Closson, PolyServe, Inc.
Session: 8 - 9:45am to 10:45am
Administrator - Intermediate
The datacenter trend towards server consolidation is occurring at a rapid pace. The motivating factors behind server consolidation include agility, availability, security and regulatory compliance. But risk avoidance is important since applications don't always coexist. Choosing an architecture for consolidation that offers manageability, flexibility, and application isolation is essential. Modern commodity Linux-based clustered systems can be a powerful and effective architecture for consolidation. This presentation covers a Proof of Concept by consolidating 60 Oracle10g databases into a manageable 14-node Linux-based cluster. Focusing on architecture, deployment techniques, monitoring, SLAs, and low-impact server repurposing makes this presentation a must-see for any IT organization planning a server consolidation effort.
Erik Moore, CYBEReTOWER, LLC
Session: 9 - 11:15am to 12:15pm
Professional - Intermediate
This report presents research on the use of iSCSI SAN technology to create ad hoc networks for development environments, emergency provisioning, and training scenarios. Included in the topics analyzed are VMware environments, low bandwidth trials, and the use of TOE devices to support scalability. While the primary experience of the author is in software targets, hardware targets and multi-purpose devices will also be discussed.