The Delaware Valley Oracle Users Group Inc.

Agenda

Looking for the registration form?  Click here for the PDF version.

Detailed abstracts are available at the bottom of the page.  To get to a related abstract, please click on the topic in the agenda grid and it will take you there.

We have added the e-mail address of our speakers here so you can easily contact them with follow up questions, copies of the handouts, etc.  Please note: Their e-mail address has a space before and after the @ as an attempt to minimize spambot e-mail.  Please remove the spaces prior to sending your e-mail.

Abstracts

These abstracts detail the presentations that are scheduled above.  Click on the time and you will jump to that time in the schedule.

Welcome, Matthew Reagan, Centocor, Inc., 9:00 AM

 

Oracle Collaboration Suite, Rob Lehman, Oracle Corporation, 9:15 AM

Oracle Collaboration Suite enables you to locate people and communicate to them in a variety of mediums, at times convenient for all parties, while managing all the information you need to make your communication more efficient. Oracle Collaboration Suite eases user administration of email, voicemail and fax by providing one integrated message store with one centralized inbox. It provides voice access to your calendar allowing you to review your schedule and receive alerts when new meetings are created or existing meetings changed. Users access all the information they need to communicate effectively with a single user id and password. In addition, Oracle allows users to easily search across all enterprise information repositories regardless of where the information is located. And, Oracle Collaboration Suite integrates with familiar desktop clients and interfaces like Microsoft Outlook and Explorer so no end user training is needed.

Data Dictionary Views Reviewed, Marlene Theriault, MT Consulting, 10:45 AM

Oracle has provided a set of dictionary views for you to use to look up information about various area of interest in your database. The views help you to see the composition of your database, what files and objects comprise your system and where they are located, who has access to your database and the privileges each user holds, as well as other vitally important information that you can use to protect and tune your system.  This presentation will examine several of the Oracle data dictionary views with emphasis on what they mean and how to use them. The composition of Oracle9i views will be featured.

Object Oriented Programming in Oracle 8 Using Oracle Types, Barry Dancis, Barry Dancis Consulting, Inc., 10:45 AM

Object Oriented methods provide improved reliability, robustness, reusability and maintainability compared to standard procedural programming. This presentation will discuss some of the features and limitations of Oracle 8 Object Oriented objects and show how some of the limitations can be overcome with procedural code. It will also show some time-tested simple types that help create dynamic SQL statements more quickly and reliably and which are easier to debug. A consequence of using these types is increased lateral thinking and the incremental development of more sophisticated and powerful types over time.

Oracle RAC Presentation and Live Demo!, Bob Gannon, Oracle Corporation & Joe Yancone, HP 12:45 PM

Bob will be giving a presentation on the Oracle RAC solution, while Joe will be demoing the Oracle RAC solution on a two node cluster.  You wanted to see RAC?  Well, you're gonna!

Oracle9i Change Data Capture, Dan White, Innovative Consulting, Inc. 12:45 PM

Extracting Delta changes is typically the most challenging technical issue in data extraction. If it were possible to efficiently identify and extract only the most recently-changed or newly inserted data, the extraction process, as well as all downstream operations in the ETL process, could be much more efficient. Unfortunately, in previous versions of Oracle this operation was cumbersome at best. Oracle9i's Change Data Capture (CDC) utility provides a vast array of functionality to extract changed data and stage it directly into relational tables. CDC provides and easy to use "publish and subscribe" method of extracting data, thus making CDC the tool of choice for extracting change data from your Oracle source systems. This presentation will highlight the problems with traditional harvest methods and describe how Oracle9i's CDC can be leveraged to combat these shortcomings.

Oracle9i JDeveloper presentation/demo, Rob Lehman, Oracle Corporation, 1:45 PM

Abstract not available yet.

So you wanted to be a Fireman?, Jason Prigge, TargetRx, Inc., 2:45 PM

As corporate database environments grow in size and in numbers, putting out fires has become a major part of a DBA's day. This presentation covers the process of defining and enforcing corporate database standards to help decrease implementation time, increase DBA efficiency, and decrease unscheduled downtime.

 

Ask Oracle Tools/DBA Expert Panel, moderated by Matt Reagan, Centocor, Inc., 3:45 PM

Bring your questions, concerns, thoughts and stories.  This is your opportunity to ask the questions you don't dare ask at the office, and come away with answers, directions, and approaches you can take to the database administration and Oracle product issues that you need to handle.  Novices and experts are all welcome.

• Return to the DEVOUG Meeting Page

• Return to the DEVOUG Home Page

• Return to the Oracle User Group common home page

Comments? Please e-mail them to the OUG WebMaster.

Last changed: September 04, 2002