Guerilla J2EE-Walking the Talk, Part II
William Jackson
This presentation will discuss the core technologies used when developing with Java 2 Enterprise Edition.   It is intended to help programmers and managers understand what is involved with J2EE development and how best to transition to this new technology.

Object-Oriented (Oracle8.0-Oracle9i Release 2) Database Features with Demos
Chip Briggs
This presentation will describe object-oriented features (including inheritance, polymorphism, and constructors) in several Oracle database versions, demonstrate these features, and answer attendees questions.

Oracle9i and Oracle9i Release 2 New SQL Features
Chip Briggs
This session will describe new Oracle9i and Oracle9i Release 2 SQL features.   The presenter will demonstrate the various features and answer attendee questions.

Implementing JSP in Oracle Portal
Bradley Brown
This presentation will first cover a brief overview of JavaServer Pages, (JSPs) and why you would use JSPs in Oracle Portal, followed by the requirements for using JSPs in Oracle Portal.   Next, downloading, installing, and configuring the Java Portal Development Kit will be covered.   Finally, the presenter will develop a JSP and deploy it in a portal application.

Oracle9iAS Installation, Configuration, and Tuning
Bradley Brown
This presentation will cover how to successfully install Oracle9iAS and migrate OAS applications.   Attendees will learn how to configure Oracle9iAS by creating Database Access Descriptors (DADs), remapping virtual paths, and configuring the virtual root and other virtual directories.   Other configuration topics to be covered include setting up virtual hosts, restricting access, configuring directory indexing and, time permitting, how to best tune Oracle9iAS.

Tools Directions: Browser-Based Team Development
David Brown
This presentation will introduce the next release of Oracle Software Configuration Manager, demonstrating browser-based team development support for code control, issue tracking, release building, and bug fixing.   The objective is to show that configuration management is not difficult to implement and, in all but the smallest software development projects, should be mandatory.

Advanced PL/SQL and Oracle9i ETL
Doug Cosman
This presentation will describe some of the more advanced PL/SQL capabilities that can be exploited to add new functionality to the database.   Topics covered will include advantages of nested tables over index_by tables, using table functions to return rows from a function, bulk binding, native compilation, passing and returning cursors, and using the PIPE ROWS function to stream output.   It will then illustrate how all these concepts come together in the new Oracle9i extract, transform, and load (ETL) functionality, which uses PL/SQL and external tables to transform data without the use of third-party ETL tools.

Using Oracle8i and Oracle9i PL/SQL Collections and Records
Bill Coulam
This presentation is for those who have only scratched the surface of PL/SQL, meaning you have yet to explore the rich benefits of PL/SQL index-by tables, nested tables, records, and now Oracle9i Release 2 associative arrays.   It will cover performing SQL against PL/SQL collections at length.

Cats, Dogs, and ORA-01555
Tim Gorman
Cats and dogs . . . seemingly destined for indefinite conflict.   The ORA-01555 ("snapshot too old") error message . . . it plagues every Oracle developer and end user, as well as every database administrator to whom they complain.   This presentation will give a thorough explanation of how the Oracle relational database management system implements transactional atomicity, consistency, and isolation and why the ORA-01555 error occurs and what should be done about it.   It will also describe how Oracle9i improves that situation, but covers all versions from Oracle6.0 to Oracle9i.

DAD Gum It! Configuring Designer 9i and Oracle9iAS for Web PL/SQL
Kent Graziano
That's right, you too can build dynamic, lightweight, interactive web-based applications using Oracle Designer 9i without having to know any Java.   Of course, there are a thousand other things you have to know to make the application actually work-like how to configure a Database Access Descriptor (DAD) and where to install the Web PL/SQL Toolkit.   This presentation will explain not only what these things are, but how and where to install them.    In addition, the steps to actually build a simple web PL/SQL module will also be discussed.

XML Types and Oracle Performance
Walter Guerrero
Now that XML objects have become a part of the Oracle Database Server, how will the interaction between the XML types and web services (XML, Simple Object Access Protocol, Web Services Description Language, and UPPI) be affected by SQL performance?   This presentation will discuss how to take advantage of the new XML types with web services.    It will discuss the benefits of using either a LOB or an object-relational format for the XML type, and type of services available to a XML type.   The presenter will finalize this discussion with the type of performance bottlenecks that can (and will) be encountered in the creation of the SQL statements that will work in conjunction with the XML types.

Oracle Text and Ultra Search
Ron Hardman
Oracle Text and Ultra Search provide an in-depth look at Oracle9i's most powerful data storage/retrieval mechanism: Oracle Text.   The presenter will build a sample application to demonstrate the powerful features included in 9i Oracle Text and provide attendees with a jumpstart on using the advanced features that are available.   Performance numbers for various index creation scenarios are also reviewed so users can determine which Oracle Text index is the best choice for their applications.

Generating Business Components for Java Applications with Oracle9i Designer
Sue Harper
Oracle Designer users moving to a Java-based environment can preserve all the intellectual investment they made over the years in Designer and automatically generate Business Components for Java (BC4J) from Designer.   This presentation will walk you through generating BC4J from module and schema definitions stored in the Designer repository. It will detail how to review the generated components and create first cut-class models based on the generated detail.   Furthermore, it will explain how to quickly create a variety of default user interfaces and add detail to further refine the generated application before its deployment.

Oracle9i Designer in the 21st Century
Sue Harper
This presentation will consider Oracle Designer's role in application development today and introduce new functionality significant to Designer users.   These are the Repository Object Browser, the web-based user interface to the Designer Repository, and the Business Components for Java (BC4J) generator.

UML Modeling for J2EE Applications and Web Services
Sue Harper
Oracle9i JDeveloper introduces Unified Modeling Language (UML) to Java and XML developers to optimize development productivity based on visual modeling, automatic generation, three-way synchronization, and reverse engineering.   This presentation will explain how to use the Class Modeler for business object modeling and detail how to automatically generate Java classes, EJB 2.0 (of Session EJBs, Entity EJBs, and Message-Driven Beans), and web services.   It will also present the Activity Modeler for business process modeling and explain how to define business processes and generate messaging infrastructures.    It will conclude with a look into the future of UML in Oracle9i JDeveloper.

Building Robust Applications with Java and JDeveloper
Ann Horton
Java and Oracle JDeveloper offer powerful capabilities for building thin-client applications for the internet or intranet.   This presentation will walk you through the key steps in architecting and developing a robust, thin-client Java application using Java and JDeveloper, with emphasis on architecture decisions and best practices.

Introduction to PSP, JSP, and XML
Dan Hotka
This session will illustrate how easy it is to adapt PL/SQL and Java to existing web pages (PL/SQL Server Pages and JavaServer Pages).   The presenter will enforce this topic with practical examples from his new book, Oracle9i Development by Example.   There will also be practical examples using XML to format information for a variety of devices, including hand-held devices. The presentation will be packed full of practical examples and is a "must see" for anyone involved with web development.

TOAD Development Tips and Techniques
Dan Hotka
This presentation will illustrate the latest features of TOAD in the development process of Oracle.   It will show how easy it is create SQL, SQL*Plus scripts, and PL/SQL using TOAD.   Shortcuts, code templates, and hotkeys in the PL/SQL development are highlighted.

Inner, Outer, Full? Oracle9i Join Syntax
John King
In this presentation, attendees will learn the standard ISO/ANSI Join syntax incorporated by Oracle9i.   ISO/ANSI standard Join allows more functional relationships than previously possible in Oracle.   The "new" Join syntax will be explained and demonstrated.

Making Oracle and SQLJ Work for You
John King
Java's ability to use Oracle's database is provided by means of either JDBC or SQLJ. SQLJ provides a familiar looking "embedded SQL" appearance.   In addition, SQLJ frequently outperforms comparable JDBC code. Like JDBC, SQLJ provides a mostly vendor-neutral ability to query database tables, update database tables, and execute stored procedures.    In this presentation, attendees will learn the Java and SQLJ syntax necessary to query and update Oracle table data as well as to execute Oracle stored procedures and functions.

Application Efficiency
Anjo Kolk
Tuning databases are the norm even when the applications are responsible for the problems.    Obvious problems are SQL statements that need to be optimized, but scalability of an application is also limited by the implementation.   This presentation will show four programs that solve the same problem with a difference in efficiency (almost by a factor of 50).   It will explain how to implement scalable and efficient programs.

Deploying J2EE Applications to Oracle9iAS
Bill Lyons
Attend this presentation and develop your knowledge of the Java 2 Enterprise Edition Architecture.   Learn how Oracle9iAS Web Application Server and Oracle Components for Java support J2EE deployment.   Participants will also learn how to deploy prebuilt J2EE applications.

Beyond the Buzzwords-Walking the Talk, Part III
Dustin Marx
This presentation will deal with actual code, configuration files, and output related to implementation of a simple J2EE application that utilizes J2EE technologies such as JavaServer Pages (JSPs), Java servlets, and Enterprise JavaBeans (EJBs).   The implementation presented relies heavily on Oracle products such as Oracle9iAS/OC4J, Oracle9i database, and Oracle9iAS MVC Framework for J2EE.   Some uses of XML technologies in conjunction with Oracle9i and J2EE will also be covered.

Real-Life Development of a J2EE Application Using Oracle iAS, Walking the Talk, Part I
Gregory Mudge
This presentation will highlight lessons learned in the actual planning and development of a J2EE application using Oracle iAS.   The presenter will give an introduction to Enterprise Java and the application server, relate his experiences during development, and advise on a few do's and don'ts.

Oracle Schmoracle: Methods and Tricks for Forms/Reports
Tito Suarez
Attend this presentation and become the magician on your team-dramatically reduce trips to the database for repeated data, have a form "wake-up" at preestablished intervals (to run a function or procedure repeatedly), create multiline label buttons, create reports with different report layouts using the same query, and test an "After Report" trigger (from within Report Builder).

Blending Oracle9i ETL Options with Proven ETL Tools and Techniques
Brad Cowdrey and Hasan Hicsasmaz
This presentation will be an overview of the available Oracle9i extract, transform, and load (ETL) options and their use in combination with proven ETL tools and techniques.   The presenters will merge real-world strategies with the ETL options while looking to specific examples of design techniques, code, and performance, with data volume as a variable.    The presentation will provide tangible strategies and tools to complement your existing software and infrastructure.

Compression Obsession . . . Diving in Without Getting the Bends!
Gary Dodge
The ability to compress data stored in Oracle tables was introduced in Oracle9i, Release 2.    Combined with existing techniques (using indexes and clusters), table compression makes it possible to dramatically reduce the amount of storage needed for your data.   This presentation will demonstrate these techniques and explore best practices for their use.

Populating Data Marts with Oracle9i SQL
Ralph Hughes
There is often a large gap between the way data is stored in an enterprise warehouse and how it must be structured to enable the reporting and online analysis that end users demand. Fortunately, Oracle9i has introduced several SQL extensions that make such data transformation relatively easy.   This presentation will demonstrate Oracle's components for multi-dimensional data transforms and the near-online analytical processing (OLAP) capabilities.

Transient Modeling for Hybrid Data Systems
Brahmaiah Jarugumilli
The demand for hybrid data systems between a data warehouse and an online transaction processing (OLTP) system are a reality.   Since separated systems are expensive and time consuming to build, there is a need to create transient systems that simultaneously address both needs.   This presentation deals with what such approaches would look like.

Stranger in a Strange Land: An Initiation into Data Warehousing
Sean Kern
As an IT professional new to data warehouses, what are the basic concepts and terminology that you would like to know?   This presentation will introduce novice warehouse developers to some of the ideas and techniques for managing data at a corporate level, as well as compare warehouse modeling to traditional relational modeling.

The Big Green Thingy: A Case Study in Data Warehousing
Allison Lobato and Kent Graziano
As with any large LEGO project, a data warehouse must be built on an architected infrastructure (a.k.a. the big green thingy).   This presentation will explore one organization's approach to building the Oracle infrastructure to support a data warehouse environment.   The various repositories that are needed, the specific Oracle tools used in developing and managing each process and step, what activities are managed by specific tool processes, software version compatibility issues, and interoperability issues will all be covered.

Parallel Execution Facility Configuration and Use
Jeff Maresh Attendees of this presentation will learn the parallel execution architecture and how to configure, tune, and use it in the data warehouse from a practical standpoint.   The first part will cover process and memory architecture, setup, and troubleshooting.    The second part will cover the various parallel operations applicable to the data warehouse.

Data Warehousing for the Little Guy
Paul Mihaly
This presentation will provide a real-life example of an Order and Customer analysis system for direct marketing.   Building a good data warehouse in a time crunch without major extract, transform, and load (ETL) tool expense is possible because Oracle gives you so much to work with.   It will explain how a mid-size, flexible data warehouse can be done with a small team.

The Operational Data Store
Joyce Norris-Montanari
The Corporate Information Factory (CIF) is a conceptual architecture that describes and categorizes the information stores that are used to operate and manage a successful and robust decision support infrastructure.   One component of the CIF is the Operational Data Store (ODS) which is used for tactical decision-making.   This session will introduce the four classes of OD, and identify the types of data, access, and reporting that makes the ODS unique.

Introducing Oracle's New Performance Tuning Assistant (PTA)!
Christine Arthur
Reactive tuning is one of the most difficult problems to tackle in a database environment if you have had minimal or no training in performance and tuning.   Oracle's new tool, the Performance Tuning Assistant (PTA), was designed to assist anyone faced with a performance and tuning problem in an Oracle database environment.   The tool is designed to be of assistance for both proactive and reactive tuning issues.   This presentation will introduce and demonstrate how the new Performance Tuning Assistant can assist you to identify and tackle a tuning issue and learn the proper methodology for approaching any tuning problem you may be faced with in the future!

Optimal Usage of Oracle's Partitioning Option
Frank Bommarito
Attendees will learn when it is appropriate to implement partitioning and what database-specific issues need to be addressed when implementing partitioning.   Instructions will be given to design an application with partitioning in mind.

RMAN (Oracle8.0-Oracle9i and Oracle9i Release 2) Potential Pitfalls
Chip Briggs
In this presentation, attendees will be made aware of potential pitfalls common to all RMAN versions.   The presenter will describe RMAN advantages for HOT backups and discuss version-specific compatibility and pitfall issues.

HA 101
Rachel Carmichael
As local companies turn into global corporations and applications run 24-7-365, high availability has become the newest catch phrase.   The dictionary defines availability as "the quality of being at hand when needed."   This presentation will review the basics of high availability from the viewpoint of the database administrator.    Attendees will learn about the new Oracle9i Release 2 features that assist them in maintaining their database's availability.

How NOT to Be a DBA: Top 20 Critical Mistakes
Rachel Carmichael
Have you ever wondered where the "best practices" come from and how accurate they really are?    As Oracle releases new versions, rules that applied to an older version are sometimes no longer accurate.   This presentation will take an in-depth, but lighthearted, look at some of the "worst practices" a DBA can follow.   Attendees will learn just why each of these practices is a problem and how to turn a "worst practice" into a "best practice."

Nested Materialized Views Case Study
Jon Cyphers and Ben Tarver
This session will present a real-life success story in the implementation of materialized views.    It will highlight how FedEx Services IT redesigned a web-based reporting system to use materialized views and exceeded their customer's service level requirements with sub-second report response time.

Eureka! I've Got It!
Carol Dacko
In this presentation, attendees will gain knowledge on some internal Oracle locking issues. It will cover the importance of MetaLink in troubleshooting adventures.   In addition, there will be a demonstration of some of the V$ views and X$ tables that are relevant to these issues.

Oracle8i/Oracle9i Shared Pool Tuning-Beyond the Usual Suspects
Carol Dacko
Following traditional shared pool tuning methodology can lead to less than satisfactory results.    This presentation will guide attendees through a "tried and true" way of tuning the shared pool for Oracle8i through Oracle9i, version 2.   The current and new V$ views and X$ tables will be used to explain and contrast what works, what does not, and why.    Participants will leave with a step-by-step procedure on how to effectively tune the shared pool.

Oracle/W2K: Sensible Security Tips Implemented
Paul Drake
Most people do not think of security when they think of W2K systems.   However, it is just as important to monitor and secure databases on W2K operating systems as it is on Unix/Linux ones.   Attendees will see screenshots, learn the steps to locking down the operating system by applying readily available tools to audit the operating system, and get tips on how to monitor security with minimal impact on the system and on your time.    Links and information for attendees who wish to dive deeper will also be provided.    The only prerequisite for attendance is a familiarity with a Windows desktop and mouse and a desire to increase the security of the operating system.

Heroes and Zeroes - 35 Years of Database Disasters
Dave Ensor
The reality of project disasters is that there are a limited number of causes that keep repeating themselves over the decades.   The principal recurring theme is human frailty.    Drawing from experience that ranges from tape-based systems to Oracle-based applications with thousands of simultaneous users, the presenter will describe the most memorable and expensive lapses of judgment that he has encountered in more than 35 years of performance-related work in the IT industry.   This talk has the twin objectives of entertaining the audience and helping them to avoid the same problems on their next high visibility project.

sql_trace in the 21st Century
Dave Ensor
At its introduction more than 10 years ago, the sql_trace mechanism was the only published method of getting accurate, detailed information from the Oracle dataserver about session activity and the resources used by individual SQL statements.   Over the years, Oracle has added to the information written to trace files but has also made significant enhancements to the data available through the "fixed view" or V$ mechanism.   This presentation will review the comparative overheads and benefits of collecting data from fixed views versus trace files, and will conclude with a summary of how to choose the appropriate technique to help address a given performance problem.

Oracle Administration in Windows NT and UNIX Environments
Shari Feltner-Cary
Today, it is important for DBAs to have a clear understanding of the differences of Oracle Administration in both Windows and UNIX environments.   This presentation will cover Oracle installation, database creation, setting up the environment, operating system terminology, Oracle utilities, and automating and scheduling scripts.

Index Monitoring and Optimization in Oracle8i
John Garmany
Adding indexes is the first step most DBAs use in Oracle performance tuning.   But adding indexes can soon become a performance deterrent.   Overindexing is a common problem in Oracle8i.   Attend this presentation and find out how to identify unused indexes and create efficient indexes to gain optimal database performance.

Succeeding with STATSPACK
Tim Gorman
Oracle's STATSPACK utility is an excellent free tuning tool, but it provides only one report against the incredible performance history information it gathers.   This presentation will discuss some easy customizations to make STATSPACK more useful by optimizing its performance analysis.

Using Log Miner
Tim Gorman
Introduced in Oracle8i, Log Miner was positioned in a log analysis and debugging capacity only.    Now, in Oracle9i, Log Miner's analytic and debugging capacities are enhanced, but mostly the product has become a crucial component in Oracle's new database replication product, Logical Standby Databases, and its data replication product, Change Data Capture.   This presentation will discuss the "traditional" uses of Log Miner as well as the recent enhancements as primary components in replication products.

Oracle Backup and Recovery A-Z
Stephan Haisley
Backing up your Oracle database is one of the most important things you cannot afford to get wrong, especially in a 24/7 environment.   This session will present how Oracle handles the mechanisms of backup and recovery and quash several myths on how best to handle backup and recovery situations.

Swimming Along with Oracle Streams
Stephan Haisley
This presentation is an introduction to the Oracle Streams feature, making its debut in Oracle9i Release 2, to improve the ease of data replication.   Fundamental architecture and mechanisms will be introduced, along with an example configuration of replicating data using this new feature.

Transaction Management in Oracle9i
Stephan Haisley
This presentation will explore the fundamentals, architecture, and mechanisms involved in transaction management within an Oracle9i database.   Understanding what goes on behind the scenes is crucial to understanding many performance issues and possible locking problems.   The presenter will look at these activities, paying close attention to redo and undo generation, rolling back, commits, consistent reads, and the new Self-Managed Undo feature of Oracle9i.

Data Compression Options in Oracle9i
Hasan Hicsasmaz and Brad Cowdrey
This presentation will provide an overview of the available compression options and a detailed case study of compression ratios obtained from real-world and artificial data sets.    The case studies include not only the storage profiles before and after data compressio, but also performance metrics regarding the query and data manipulation language throughput.

Practical Tips to Load Modeling and Performance Planning
Brahmaiah Jarugumilli
Capacity planning, load modeling, workload characterization, and stress testing activities have a solid quantitative basis that makes it easier to validate and complement each other effectively.   This presentation will provide attendees with tips and techniques and the HOW TOs.

XML Survival Skills for DBAs
John King
XML has quickly become significant to the information industry.   This presentation will examine the concepts and facilities of XML and how they are being implemented in Oracle.    DBAs need to understand the basic nomenclature of XML, what XML is used for, how XML is supported by Oracle's database and other tools, and the DBA's role in supporting XML, using applications.

Stand By Your Data Guard
Darl Kuhn
Oracle Data Guard was vastly improved with the release of Oracle9i.   This presentation will cover Oracle9i Data Guard new features and present hands-on examples of how to implement and enable new levels of data protection.

Database Slow? Bet It's Fragmented! How Do You Fix It?
Steve Lemme
Database fragmentation not only slows the database down but also wastes storage.   Oracle7.x, Oracle8.x, and Oracle9i databases manage fragmentation in different ways.    This presentation will review the different types of fragmentation and discuss options that are available with the different versions of Oracle to reduce or reorganize fragmentation.    It will also review the new online functionality in Oracle9i.

While You Were Out . . .
Steve Lemme
Business over the internet is 24/7, yet a DBA is not.   Businesses can no longer wait until the next business day to put out fires that might have been prevented.   This presentation will cover what is necessary for Oracle DBAs to manage in an e-business world and how to apply this in practice so that Oracle DBAs can justify, automate, and obtain the proper education and resources needed to be successful in their jobs as well as in their careers.

Resolving and Tuning the Oracle Connection Process
George Loewenthal
This presentation will illustrate how to resolve Oracle connection issues and improve connection performance.   Do you ever have issues getting clients to connect or drop Oracle connections?   Learn to troubleshoot your connections with Oracle utilities.   You can use prespawned server processes or local bequeathed connections to improve Oracle connections performance.

Configuring and Tuning Oracle Parallel Recovery
John Middleton
In this presentation, the parallel features of Oracle instance and media recovery will be reviewed and related to the general problem of recovery tuning.   Also, techniques will be described for monitoring and tuning the recovery process to make effective use of the parallelism.

Measuring Response Time
Cary Millsap
The "wait interface" is a godsend, because it helps to account for response time consumed by resources other than user-mode CPU, however, in most circumstances, the "wait interface" accounts for only a small part of the total response time equation.   Ultimately, the only performance metric that your business cares about is response time.   So, then, why do most Oracle performance analysts measure event counts instead of response times?    The answer is that count statistics are better understood and easier to obtain than timing statistics.   This presentation will describe two aspects of Oracle's timing statistics: how to obtain them and exactly how much faith you can put into them.

Why You Should Focus on LIOs Instead of PIOs
Cary Millsap
Professionals analyzing Oracle system performance problems often miss performance improvement opportunities because they perceive systems through a network of incorrect assumptions about Oracle internals.   This presentation will explain the truth about some of the most important misapprehensions about Oracle performance.   The result is an ability to improve system performance beyond the levels at which many system owners are stuck today.

10 Steps to a Bullet-Proof Backup and Recovery Strategy
Chris Ostrowski
This presentation will discuss the top 10 steps every DBA MUST go through to ensure a backup and recovery strategy that is bulletproof, and, most importantly, it will give the "why" of each step in detail.   Suggestions from real-world examples will be given, allowing attendees to master each of the steps before moving on.

Deja View: Understanding Flashback Query
Chris Ostrowski
This presentation will include understanding and configuring automated undo management, procedures and functions available to the DBA in the DBMS_FLASHBACK package, embedding flashback queries in subqueries, steps required to recover an object, and alternatives for object recovery when DBMS_FLASHBACK cannot be used.

Implementing an Advanced Replication Solution
Bill Pass
This presentation will focus on implementing Oracle Advanced Replication.   Materialized views, updateable materialized views and multimaster replication will be covered.    Unique challenges that only occur in replication environments will be presented with solutions for conflict resolution, monitoring, and maintenance.

Implementing RMAN in the Enterprise
Bill Pass
This session will provide essential knowledge to architect, design, and implement Recovery Manager (RMAN) in a heterogeneous enterprise.   It will cover an architecture and implementation approach to automate the backup.   Also very important, the recovery process will be presented along with shortcomings of the RMAN product and workarounds highlighted.

Direct Contention Identification Using Oracle's Wait Interface
Craig Shallahamer
Oracle's wait interface has profoundly changed Oracle contention identification.   No longer is it necessary to gather volumes of data, calculate a seemingly ever-growing number of performance ratios, and finally perform analysis.   Through the session wait event views, the Oracle server tells performance specialists specifically where contention resides and what is causing the contention.   This dramatically reduces problem identification time, allowing more time for problem resolution analysis.   This presentation will explain how one can quickly begin performing "wait event" analysis by understanding the technology, effective use of the technology, and the use of publicly available tools.

Quickly Performing Low-Confidence Capacity Predictions Using Ratio Modeling
Craig Shallahamer
This presentation will define the ratio modeling technique as a set of steps that will allow you to quickly perform low-confidence capacity predictions, which are required when budgeting hardware, assessing technical risk, validating alternative technical architecture designs, sizing packaged applications, and predicting production system capacity requirements.    It will detail step-by-step how you can determine ratio categories, calculate the ratios, make capacity predictions using the ratios, and validate both the ratios and the resulting predictions on a production system.

New Memory Management Features for the Forgetful DBA
Edward Wiener
In this presentation, new memory management features will be discussed and demonstrated. Specifically, multiple buffer pools, multiple data block sizes residing in the same database, dynamic allocation of the SGA, automatic sizing of the PGA, and the buffer cache advisory will be explained.

Oracle Security and Performance
Ken Shelby
This presentation will give an environmental overview of "security and performance" that Oracle developers can use to better understand how their hard work is used in high-availability production deployments.   A number of developers have expressed interest in the data center and have found that a conceptual understanding helped them expand beyond the Oracle internals in which they specialize.

Feng Shui for Techies
Tamara Swilley
Find out how to adjust your office and desk area environments to support, nurture, and energize yourself at work.   Keep your morale up and your energy focused, enhance your creativity and productivity, and reduce your stress and help your physical health.

Leveraging Oracle Concurrent Manager for Large-Volume Jobs
Mushtaq Basheer
This presentation will give a brief overview of Oracle Concurrent Manager, a component of the Oracle E-Business Suite.   It will offer a design approach to decompose a large-volume batch job into a main program and several runner programs, show use of Oracle Concurrent Manager application-programming interfaces for spawning of parallel concurrent processes, give a step-by-step development approach to building and setting up main/runner concurrent jobs, and recommend building tools for monitoring these jobs.

Achieving 150 Times the Performance
Bradley Brown
The use of various caching methods is an essential part of developing responsive, web-based applications.   In this presentation, you will learn about the types of caching available and how to get the most out of caching while ensuring that pages returned to end users contain accurate information.   Find out how to gain performance, store dynamic pages, and even personalize the cached content before serving the cached object to the browser.   A live demonstration will benchmark the difference between 100 users concurrently hitting a web server for dynamic content, with and without the Oracle9iAS Web Cache in place.

New Product from Oracle-Collaboration Suite
Joshua Hou
Information is moving at a faster pace and there are increasingly more communication channels to manage.   Much of the information is generated by communications between individuals and collaborative teams.   This presentation and product demo will highlight Oracle Collaboration Suite's capabilities and features: integrated e-mail, voicemail, phone, fax, scheduling, calendaring, meeting management, file management, and more in a single product.

Wireless Enabling Your Oracle Portal
Erika Leetmae
Oracle9iAS Portal pages can be viewed from a wide variety of devices including, but not limited to, desktop browsers, cell phones, and PDAs.   This presentation will provide details on the main components and concepts for building useful and relevant portals for such multidevice environments.   It will explain what is involved with rolling out components of Oracle Portal to users that are not always tied to a desktop browser to access the portal, regardless of how they connect.

Best Practices for Managing Java Development Projects">
Ann Horton
Java and object-oriented technologies offer powerful capabilities for implementing application systems, but also present new risks for missed deadlines, cost overruns, and project failures.    This presentation will examine best practices for managing Java development projects to ensure that business goals are effectively met.

Oracle9i-Death of the DBA?
Steve Lemme
Oracle9i may be complete, but there are new challenges, and the job responsibilities of the DBA have definitely changed.   Because of the increased business reliance on data, Oracle database infrastructure is one of the most important components to be managed.    Those who learn what it takes and how to manage the "Bigger Picture" will be setting themselves apart from the pack, enabling them to further achieve advancement while improving customer service and satisfaction.   This presentation will examine the "Big Picture" and empower attendees to utilize Oracle technology.

IT Project Management: How to Build a Project That Will Succeed
Wayne McGurk and Eric Linneman
This session will focus on the tools that every IT project manager should have available in their project toolbelt to successfully define, manage, and complete an IT project on time and on budget.   Using real-world experiences, the presenters will provide a blueprint for IT professionals that illustrates the steps and techniques necessary to ensure a successful project.

The True Cost of Poor Planning
Jeffrey Meyer
A database failure can have disastrous effects with client relations and revenue.   This presentation will cover what factors should be considered (downtime, equipment costs, idle employees, goodwill?) when deciding the recovery method to implement.   It will provide clear definitions to determine and calculate "The Real Cost of Poor Planning."

The Leap from PL/SQL to Java: More Than Just Syntax
Greg Matus
Often, an experienced PL/SQL programmer, having heard so much about Java and its role in Oracle and web development, decides to tackle the subject only to give up in frustration.    Unlike the transition from one procedural language to another, the transition to Java is much more than just learning a new syntax.   It is about learning object-oriented programming, a completely different approach to program design.   While difficult to grasp at first, this approach greatly simplifies the design of complex programs and yields significant practical benefits to those with a proper understanding of the concepts.    This presentation will demystify OO concepts and prove that this approach actually makes things easier.

Platform Architecture and Features for Thin-Client Delivery of Oracle Interface and Tools
Samuel Conn
If you are interested in accessing Oracle technologies over the internet using thin-client technology, this presentation will give you a platform architecture for delivery of Oracle administration and development tools.   The specific focus will be on the use of the technology in corporate training and academic delivery environments.

Accessing an Oracle Database from Active Server Pages
Debra Elliott
This presentation will explain how to access an Oracle database from active Server Pages using both VBScript and JavaScript.   A basic set of examples will be presented that will allow attendees to create functional, dynamic HTML pages.   In addition, a list of online example code resources and reference pages will be discussed.

CSS Reporting: Reliable Page Breaks?
Michael Fons
Have you ever tried to create a web report where the size of the page was unsure and you wanted to make it printable with page breaks that are reasonable?   Cascading Style Sheets (CSS) gives web programmers a variety of ways to control how such reports print.   Attend this presentation and learn how to produce documents that are as changeable as the data in your database and still have a good looking printable document.

SOAP: What Is It and How Can It Work for You?
Michael Fons
SOAP: You've heard of it, but what is it and what can it do with Oracle9iAS?   This presentation will illustrate how SOAP and Oracle9iAS can enhance the web projects that your company is considering or even starting.   As an experienced Oracle web professional, you will come away with enhanced knowledge and the ability to apply this new knowledge to your particular situation.

Configuring and Maintaining Development and Production Portal Environments
Chris Ostrowski
This presentation will discuss the steps needed to create a second (production) portal environment, how to populate the production environment, and subtle, yet very important differences, between versions 3.0.9.8.0, 3.0.9.8.2 and 9.0.2 of Oracle Portal.

RMAN: Your New Best Friend for Backup and Recovery
Ruth Gramolini

Quantitative Modeling and Capacity Planning with Oracle Statistics as Load-Factors
Brahmaiah Jarugumilli & Shankar Jayaganapathy

Workload Characterization and Quantitative Modeling
contacts: Jbsastry@mavericksystems.net and shankar.jayaganapathy@oracle.com

High Availability for Oracle 9i and 9i RAC - Architecting High Availability for Oracle Databases
Kevin Loney and Paul Massiglia

BC4J What's It All About? (The Top Ten FAQs)
Greg Matus

Data Integration in Heterogeneous Environments
Bradley Brown
TUSC
A free CD version of the Oracle Press book Oracle9i Web Development by Bradley D. Brown will be given to the first 50 people who attend!   This presentation will discuss how to easily read data (as if it exists natively within an Oracle table) from any source.    For example, data can be read using any JDBC source; web services using SOAP or XML/RPC; web sites using HTTP or HTTPS; and e-mail servers using SMTP or application APIs such as Seibel, Peoplesoft, and Bahn.   This method of access simplifies development by allowing your developers to write standard select, insert, update, and delete statements to access non-Oracle data transparently.   The net effect is that you will save money, time, and effort using the methods that will be discussed.

Searching the World for the Perfect Oracle9i Storage Solution?
Doug Felsenthal
XIOtech Corporation
XIOtech's networked storage solutions, together with Oracle9i Real Application Clusters (RAC), provide unbreakable availability for your critical Oracle data.   With XIOtech's proven adaptive solution, you can share Oracle data across the enterprise and not worry about a component failure comprising access.   Come and hear all about their RAC Pack solution.

24/7 Resiliency for the Oracle Environment
Mark Ketchie
DataMirror
With costs of downtime in the thousands of dollars per minute range,data access and availability are business imperatives.   This presentation will explore the need for high availability within the Oracle environment and will discuss the benefits of implementing a data resiliency solution, including protection against the effects of planned or unplanned downtime and the ability to do business 24/7.

Ensuring Oracle Performance
Greg LeNeveu
Precise Software Solutions
Learn how to guarantee the performance of your Oracle-based applications using Precise i3 for Oracle.   Precise i3 cuts through organizational and technological barriers to detect and correct the root cause of application slowdowns.   This solution overview will review best practices of finding the definitive root causes of performance degradation in minutes (e.g., application, user, network, module, JavaBean), as well as using automated analysis to resolve the problem.

Database Availability for Oracle9i and Oracle9i RAC
Paul Massiglia and Rich Niemiec
VERITAS Software and TUSC
Relational databases have become crucial to enterprise operations, and that means no time for downtime.   We are all familiar with the RAID and mirroring technologies that preserve Oracle's data in case of storage failure, but what about keeping database applications and Oracle itself running?   This session will review the basics of clustering technology that can be applied to Oracle9i and Oracle9i RAC environments.   It will then relate the technologies to Oracle and its data storage facilities and show how Oracle can be combined with clustering technology to enhance the availability of critical enterprise applications.   TUSC president, Rich Niemiec, will join VERITAS to share his hands-on experiences implementing clustering solutions and address the importance of developing a solid, high-availability strategy for your Oracle environment.

From Monitoring to Automation
Matt McAdams
Senware
AutoDBA is an Oracle management tool that goes beyond the monitoring capabilities of other tools by automatically generating repair scripts for a variety of database problems.   This presentation will focus on AutoDBA's features and script-generation technology, and show how it can be used to turn monitoring into automated database maintenance.

A Successful Performance Tuning Methodology Using the Database Health Check
Azeem Mohamed
Quest Software
This discussion will cover a successful performance tuning methodology and uncover the steps needed to detect, diagnose, and resolve issues on Oracle databases.   A "health check" of a database will yield information needed to take the guesswork out of tuning, and the presenter will define and outline what a database health check is as well as how to employ this practice as the core of a successful performance tuning methodology.

9iRAC Live! Using Linux with Oracle and HP
Cliff Loeb
Hewlett Packard
In this presentation, you will learn from Oracle and Hewlett Packard about supportable implementations on Linux, low cost solutions for availability and scalability, and other advantages.   Experience how Oracle9i Real Application Clusters (RAC), combined with Hewlett Packard's 25 years of clustering expertise, delivers a high-performance clustered database to meet your business needs.   See firsthand transparent application failover, automatic load balancing, and exclusive management features.   There will be a short demonstration of Oracle9i RAC's features, and then plenty of time to experience it for yourself.

Best Practices: Implementing Manageable Real Application Clusters
Brian Schwarz
VERITAS Software
Today's businesses need high levels of availability, which has led them to implement technologies such as Real Application Clusters.   Many companies have implemented Oracle9i RAC on raw partitions, which creates management headaches.   Through the implementation of a cluster file system technology and intelligent cluster services, management can be simplified without reducing performance.   This presentation will compare RAC to other high-availability architectures and discuss best practices for implementing RAC with leading cluster file system and cluster service technologies.   The best practices will focus on increasing manageability without sacrificing the performance or availability delivered by RAC.

Navigating the Oracle Backup Maze
Robert Spurzem
Legato Systems
Backing up an Oracle database has always been a challenge even for an experienced DBA.    Now, with the introduction of new Oracle9i RMAN features, new backup to disk, snapshots, and the like, it is getting even more confusing.   This presentation will discuss 10 common issues surrounding Oracle backup and present some clear recommendations on how to best tailor Oracle backup to your environment.