About NoCOUG
Join NoCOUG
Sponsorship
Vendors
Online Survey
NoCOUG Board
Site Map

 

NoCOUG's August 15, Conference

The NoCOUG Summer Conference was held at the ChevronTexaco campus in San Ramon. Some of the presentations from the meeting are available for download.

Meeting Description

The Summer Conference had parallel sessions on the topics of database administration, N-Tier Architecture, and Server Features for Developers.

Here is the agenda, followed by session descriptions:

 
08:00 - Registration opens
09:00 - 09:30  - General Session
09:30 - 10:30  - Keynote:"Oracle9iAS Technical Overview" with Thomas Kurian, Senior Vice President, Oracle 9iAS, Oracle Corporation
10:30 - 11:00  - Morning Break
11:00 - 12:00  - Parallel Session #1:
DBA N-Tier Architecture Server Features for Developers
"Oracle Backup and Recovery Essentials Every DBA Should Know" by Rob O'Brien, Product Marketing Manager,
VERITAS Software


Level: Intermediate

"Oracle 9iAS Release 2 Update" by Margaret Mei, Senior Product Manager, Oracle Corporation

Level: Intermediate

"PL/SQL Native Compilation, an Implementation Story" by Roger Schrag, Senior Consultant, Database Specialists, Inc.


Level: Intermediate
12:00 - 01:00  - Lunch Break
01:00 - 01:40  - DBA and Developer Roundtable Discussions
01:45 - 02:45  - Parallel Session #2:
DBA N-Tier Architecture Server Features for Developers

"Information Integration Using Oracle Streams" by Bob Thome,Group Product Manager, Distributed Databases, Oracle Corporation

Level: Intermediate

"Top Tips for Web-Deployed Forms" by
Peter Koletzke, Technical Director, Quovera


Level: Intermediate

"Oracle Text" by Ron Hardman, Senior DBA, CommerceOne.com

 

Level: Intermediate

02:45 - 3:15  - Afternoon Break and Raffle
3:15 - 04:15  - Parallel Session #3:
DBA N-Tier Architecture Server Features for Developers

"Making the move from ANALYZE to DBMS_STATS" by
Hamid Minoui & Rajesh Khanna, UPS Freight Services


Level: Intermediate

"Implementing Object-Oriented Inheritance in a Relational Database" by Howard Hyde, President of RADical Information Design Corporation

Level: Intermediate

"Oracle XML Support" by Jinyu Wang, Product Manager, XML Group, Oracle Corporation

Level: Intermediate

     
04:30-???  NoCOUG networking and happy hour at O'Kane's Irish Pub - 200 Montgomery St., San Ramon

"Oracle9iAS Technical Overview" This presentation provides an in-depth overview of the technical features of Oracle9iAS. It covers areas including:
· J2EE and Transactional Web Applications
· Web Services
· Integration
· Portal
· Wireless
· Business Intelligence
· Performance
· Salability and High Availability
· Management and Security
The paper discusses industry standards and Oracle enhancements in each solution area. In addition, it describes some sample customer cases of customers using Oracle9iAS.

"Oracle Backup and Recovery Essentials Every DBA Should Know" As the amount of Oracle data increases exponentially and backup windows are disappearing, there is a distinct need to have a sound database backup and recovery strategy so that your Oracle data is protected and readily available in the present and in the future. This presentation will discuss in detail the technical fundamentals and essentials that every Oracle DBA should know and follow when creating their Oracle RMAN backup, restore, and recovery strategy. Alternative Oracle backup methods such as Block Level Incremental Backup, split mirror backup, and ServerFree backup will also be discussed. The Oracle RMAN backup and recovery strategy that will be discussed will be useful to all Oracle DBAs, whether they are responsible for managing a small one-gigabyte database or a large multi-terabyte database.

"Making the move from ANALYZE to DBMS_STATS"
Since the new statistics manipulating and gathering package became available in Oracle 8.1.6, we took the direction of moving away from using ANALYZE and use this facility for collecting CBO statistics. Our motivation to implement this strategy for all our database and the experience obtained with implementing with be discussed.

"Information Integration Using Oracle Streams"
Oracle Streams is a new information integration feature and infrastructure introduced in Oracle9i Database Release 2. Information integration is critical for identifying and capturing information from applications and databases, and passing that information to applications, databases, and end users who value it. Streams is a feature that can be used to build sophisticated database replication and event notification solutions. As the foundation for Oracle Advanced Queuing and Oracle Data Guard in SQL Apply mode, Streams is a common infrastructure for all information integration solutions in the database. This allows users to easily migrate from one solution to another, and to build hybrid solutions that leverage the strengths of replication and message queuing. This presentation will present an overview of Streams, describe the underlying technology, and introduce some of the solutions you can build using Streams. It will also present how some early adopters are using (or planning to use) Streams to solve their information integration requirements.

"Oracle 9iAS Release 2 Update" This presentation introduces the theme and key messages Release 2 of Oracle9iAS. It discusses key new features in all major areas of the application server including:
· Transactional Web Applications
· Web Services
· Integration
· Portal
· Wireless
· Business Intelligence
· Performance
· Salability and High Availability
· Management and Security

"Top Tips for Web-Deployed Forms" Web-deploying your Forms applications is straightforward, but you must be aware of the things that work differently from client/server and the things that just don't work. This presentation provides the top tips and techniques you need to focus on when deploying forms on the Web. It supplies details on what to think about when designing an application as well as how to optimize code and objects to run efficiently within a browser. Details such as startup HTML file parameters, reducing the initial startup time and the "Oracle look and feel" are demonstrated and discussed.
The presentation also supplies tips on things you need to avoid or modify when moving forms from client/server to the Web -- some of which are documented, some derived only from experience. The presentation also provides an overview of the architecture as well as a discussion of resources that are available for information on the subject.

"PL/SQL Native Compilation, an Implementation Story" Starting in Oracle9i it is possible to compile your PL/SQL stored procedures into native machine code on your database server. Oracle documentation claims that natively compiled procedures can run up to ten times faster than interpreted PL/SQL code. We will begin this session with a brief overview of the native compilation feature, and continue on to discuss my experiences on a project where a production application including over 35,000 lines of complex PL/SQL code was natively compiled. We'll talk about the actual performance improvements observed, system stability, and the inevitable unexpected issues that popped up along the way.

"Oracle Text" is an integrated solution for advanced searches of standard text and many document formats. This presentation introduces Oracle Text and its features, compares functionality with interMedia, and demonstrates how Oracle Text can be used to enhance your application We will review the 3 types of indexes available, discuss multilingual features, and explore many of the functions and operators available to enhance your searches.

"Oracle XML Support" This presentation provides an in-depth overview of the technical features of Oracle9i XML Support. It covers areas including:
· Oracle XML Developer's Kits
· Oracle9i XDB
· iDAP and SOAP XML Messaging Support
. 9iAS XML Support
· Oracle9i JDeveloper XML Support
We will discuss the XML enterprise strategies, demonstrate Oracle9i XML Features and explore how the Oracle XML Solutions can be used to enhance your enterprise application
.


If you have suggestions for future meetings or would like to offer feedback on previous conferences, then please complete our online survey or send us an email.

Directions to ChevronTexaco Park in San Ramon

Address: 6101 Bollinger Canyon Road San Ramon, CA 94583
Please note that the conference building is next door to the ChevronTexaco Campus.

From Highway 680 South: Take Highway 680 south to the Bollinger Canyon Road exit. Turn left onto Bollinger Canyon Road, heading east (back over the freeway). Take a right on Bishop Ranch 1. This is the next street east of
ChevronTexaco Park Circle West. Address 6101 is the first building after entering the parking lot. Park anywhere not restricted.

From Highway 680 North: Take Highway 680 north to the Bollinger Canyon Road exit. Turn right onto Bollinger Canyon Road, heading east.Take a right on Bishop Ranch 1. This is the next street east of ChevronTexaco Park Circle West. Address 6101 is the first building after entering the parking lot. Park anywhere not restricted.

Map

 

Copyright 2002 NoCOUG. All rights reserved.