Orange County ORACLE User Group

Quarterly Meeting Announcement

Wednesday January 26, 2000

8:30 AM

Registration and Continental Breakfast (Networking Opportunity)

***** FREE BOOKS from ORACLE PRESS to Early Arrivals *****

9:00 AM

Official Call to Order and OCOUG Business

9:15 AM

***** CHANGE IN AGENDA *****

ORACLE DBA

– Managing Database Change

QUEST Software – Mark De Pledge

Inadequate change management is the #1 cause of application failure and the biggest risk to your ERP or homegrown investment.

Elimination of risks and errors during development, coupled with increases in productivity, makes for accurate, on-time releases.

SQL APPLICATION TUNING

- Find the Needle in a Haystack

Embarcadero – Bert Scalzo

Learn successful advanced techniques for identifying and correcting resource consumptive SQL.

Issues covered include pro-active vs. reactive tuning, database tuning scripts, SQL tuning tools.

Attendees receive a free copy of XPlan (an Oracle explain plan utility)

10:20 AM

Break Time (Refill on Coffee and Network with Your Fellow ORACLE Professionals)

10:35 AM

ORACLE APPLICATIONS

– Release 11i: A Technical Perspective

Oracle – Steve Mills

11i uses the latest versions of Oracle tools and systems products. This presentation discusses the technical foundation for 11i, focusing on how the APPs leverage the underlying Oracle technologies.

Presented at the OOW ’99 convention

DATA WAREHOUSING

- Successful Dimensional Modeling

Embarcadero – Bert Scalzo

Learn successful techniques for dimension modeling of large Data Warehouses using traditional ERD.

Issues covered include Star Schemas, fact and dimension tables, plus aggregate table design and population.

11:40 AM

Close of Business (Announcements and Door Prizes) -

Door Prizes: The latest O’Reilly and McGraw Hill Publications