SPRING CONFERENCE

Sponsored by Lockheed Martin

May 13, 2004

Lockheed Martin, Building 157, Sunnyvale, CA

 



Refer a Friend




Some of the presentation are available for download.


 

8:00 - 9:00

Registration and Continental Breakfast – Refreshments Served

9:00 - 9:30

General Session and Welcome – Roger Schrag, NoCOUG President

9:30-9:45

Break

 

Auditorium

Executive Conf. Room

X7 Conference Room

Session 1

9:45 – 10:45

Choosing the Right Mass Deployment Strategy for Oracle Database 10g Software by Sudip Datta, Principal Product Manager, Oracle Corporation

Increase Java Application Performance with PL/SQL by Joel Thompson, Rhino Systems

Oracle's Workspace Manager by Daniel A. Morgan, Instructor, University of Washington

10:45 – 11:30

Break

Session 2

11:30 – 12:30

10G - ASM (Automated Storage Management) and New Manageability Features by Bert Scalzo, Product Architect, and Lenka Vanek, Product Manager, Quest Software

Oracle RDBMS patching -- how a fast, simple process can become very slow and complicated. by Brian Hitchcock, Sun Microsystems

Beginning SQL: Differences Between Oracle and Microsoft by Les Kopari, Independent Consultant

12:30 - 1:30

Lunch

1:30 - 1:55

Round Table Discussions in Auditorium

Session 3

2:00 – 3:00

 

A DBA’s Perspective on J2EE by Debu Panda, Oracle Corporation

The Persistence of Memory (Issues) -- The Shared Pool, Sorting and Other Nightmares by Brian Hitchcock, Sun Microsystems

Oracle Backup and Recovery Essentials Every DBA Should Know by Rob O’Brien, Senior Product Marketing Manager, Veritas Software

3:00 - 3:30

Break & Raffle

Session 4

3:30 – 4:30

 

Develop, Deploy, and Manage Web Services with Oracle Application Server 10g by Olivier Le Diouris, Oracle Corporation

Reducing Costs of Environment Copies Using Oracle Recovery Manager by Rich Bernat, ChevronTexaco

The Rap on RUP: An Introduction to the Rational Unified Process by Jeffrey Jacobs, SDLC Methodology and Project Management, Jeffrey Jacobs & Associates

4:45 - ?

Join us for Networking/Happy Hour at Faz, 1108 North Mathilda Avenue, Sunnyvale

 

 

Our next quarterly conference is August 19, 2004 at ChevronTexaco in San Ramon!!!

 


 

Speaker Abstracts for Spring Conference

 

 

Auditorium

“Choosing the Right Mass Deployment Strategy for Oracle Database 10g Software” - Sudip Datta, Principal Product Manager System Management Products, Server Technologies, Oracle Corporation

Today as Grid Computing evolves, data centers need to deploy the Oracle database software to multiple nodes. The challenges that center around deployment are various and often specific to the IT environment of the enterprise. This document seeks to explore the solutions to the challenges around deploying Oracle database software taking into consideration the various factors that influence the method of deployment. The document does not cover specific tools or commands in detail, though it is broadly prescriptive in terms of practices and processes. In terms of technical scope, it assumes and is restricted to, the Oracle 10g database software.

“10G - ASM (Automated Storage Management) and New Manageability Features” - Bert Scalzo, Product Architect and Lenka Vanek, Product Manager, Quest Software

A brief introduction and explanation of Oracle 10G's new Automated Storage Management (ASM) feature. With today's explosive database size requirements and the proliferation of SAN (Storage Area Network) and NAS (Network Attached Storage) disk technologies, both the system administrator and the DBA must manage hundreds to thousands of disks - sometimes just for one database! Thus the task of planning, initializing, allocating, managing and tuning of so many disks becomes unwieldy. Oracle 10g's new Automated Storage Management directly addresses these real world scenarios by providing an effective and simple solution. Now instead of spending inordinate amounts of time managing disk complexities or treating space like a "black box" and hoping that all is well, we can simply permit Oracle 10g's

ASM to manage it all. We can now merely allocate entire disks to Oracle with preferences for striping and mirroring stated via templates, and let ASM manage the space - thus eliminating the need for traditional tools used to manage lots of disk space: Logical Volume Managers (LVM), file systems and the numerous commands necessary to manage both. Oracle 10g database is introducing features to make your databases more manageable. One database administrator is asked to manage tens of databases. This portion of presentation contains brief overview of the common manageability infrastructure in 10g. The main components of this infrastructures are the Automatic Workload Repository, server generated alerts, the advisory framework and the Automatic Database Diagnostic Monitor.

 “A DBA’s Perspective on J2EE” – Debu Panda, Oracle Corporation

In most J2EE applications, managing the persistence of information to a database is critical. Understanding how this persistence takes place and what the effects of a J2EE server are on databases is critical to the success of any J2EE application. This session provides an introduction to J2EE for DBAs. In addition, it gives DBAs the necessary information to effectively communicate with Java developers to enable the DBA to design and manage databases in a J2EE environment, such as Oracle Application Server Containers for J2EE. Specifically, the presentation examines how Enterprise JavaBeans (EJBs) interact with the database, what relational structures are created to represent entity EJBs and EJB relationships, what default SQL is generated for persistence access, and how the SQL statements associated with this access can be tuned. Additionally, it provides information on how existing relational schemes can be mapped to EJBs, how DBAs can work with application developers to tune EJBs and their application, and what other aspects of database administration are affected by J2EE applications. Oracle Application Server J2EE and Web Services Architecture

 “Develop, Deploy, and Manage Web Services with Oracle Application Server 10g” – Olivier Le Diouris, Oracle Corporation

Oracle Application Server 10g provides a highly scalable runtime infrastructure for developing, deploying, and managing Web services. This session covers various aspects of developing Web services, starting from Java, PL/SQL, and Enterprise JavaBeans and deploying and managing them on Oracle Application Server, using Oracle Enterprise Manager. Learn how to register developed Web services into the Oracle Application Server UDDI registry and discover them dynamically through the registry. The presentation also covers the latest J2EE 1.4 APIs for Web services and best practices for Web services interoperability. In most J2EE applications, managing the persistence of information to a database is critical. Understanding how this persistence takes place and what the effects of a J2EE

 

Executive Conference Room

“Increase Java Application Performance with PLSQL” – Joel Thompson

 

Learn how to optimize your database I/O from a Java application using JDBC, PL/SQL, and Oracle's stored procedures. Review sample code with in depth explanation of "best practice" techniques. Learn how to return results sets from a stored procedures; efficient usage of Oracle's sequences to generate primary and foreign keys; and JDBC and PL/SQL batch processing techniques.

 

Target Audience: Developers, Architects

“Oracle RDBMS patching -- how a fast, simple process can become very slow and complicated.” - Brian Hitchcock


The technical process of applying a single patch to the Oracle database software is very simple. What isn't simple is knowing which patch to apply in what order, when, and with what prerequisites. This presentation will cover the patching process needed to comply with the Oracle security patches for the Oracle 8.1.7 database. In addition, the issues that come up that turn a 10 minute patch into a 5 hour upgrade will be reviewed.

“The Persistence of Memory (Issues) -- The Shared Pool, Sorting and Other Nightmares” – Brian Hitchcock

 

A detailed look at how Oracle assigns memory in the shared pool and when sorting is presented along with specific ways to see what is happening and why. This will explain why sizing the shared pool and sort area can be so complicated. Detailed steps to see who is using these resources, how much they are using and what can cause user connections to be refused will be covered. The wisdom of adding more memory in different situations will be debated.

 

Target Audience: Intermediate

“Reducing Costs of Environment Copies Using Oracle Recovery Manager” – Rich Bernat

The presentation highlights a 'before and after state'  in backup strategy used by CVX by the SAP support team.   Using the RMAN backup process and the DUPLICATE feature, CVX was able to lower support costs by providing QA refreshes and project environments in less time and maximizing hardware utilization. Also covered are the components of a RMAN backup and how to use the duplicate command.   You will also learn some RMAN tuning practices for performance and avoid some problem areas.

 

Target Audience:  Intermediate

 

X7 Conference Room

“Oracle’s Workspace Manager” – Daniel A. Morgan, Instructor, University of Washington

With Oracle you can version control your data as well as your application code. Daniel Morgan of the University of Washington Oracle program will present a live SQL*Plus demonstration of how to use Oracle's Workspace Manager to automate maintenance and reconciliation of multiple versions of your production data for simulations and to avoid lost updates.

“Beginning SQL: Differences Between Oracle and Microsoft” – Les Kopari, Database Admin and Dev

If you're new to Oracle or just SQL, you may find this presentation useful in orienting yourself to these two different versions of the SQL standard. We'll just touch on the basics needed to get a sound beginning in becoming conversational in each dialect, and move into more advanced topics as time allows.  DBA or developer, you may occasionally need to cook up a quick custom query.

“Oracle Backup and Recovery Essentials Every DBA Should Know” – Rob O’Brien, Senior Product Marketing Manager, Veritas Software

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.  In this session, we will examine newly developed technology for protecting large Oracle environments with fewer backups and speedier recovery times. Specific attention will be given to disk-based Instant Recovery, Block Level Incremental Backup and Recovery and other advanced backup methods. The Oracle RMAN backup and recovery strategies 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 or petabyte database.

“The Rap on RUP: An Introduction to the Rational Unified Process” – Jeffrey Jacobs, SDLC Methodology and Project Management, Jeffrey Jacobs & Associates

The Rational Unified Process (RUP) is the latest and "hottest" in a long line of software development methodologies and frameworks. This presentation will provide an overview of the key phases, concepts, and deliverables contained in RUP.

 


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 Lockheed Martin in Sunnyvale

Address: Building 157 is located at the intersection of Third Avenue and J Street in Sunnyvale.

From Highway 101: Go on Highway 101 toward Highway 237. Go east on 237 and exit at Mathilda Avenue. Travel north on Mathilda and turn left onto Third Avenue. Take Third Avenue to J Street. Building 157 is on the left, and the parking lot is on the right.

From Highway 880: Go on Highway 880 toward Highway 237. Go west on 237 and exit at Mathilda Avenue. Travel north on Mathilda and turn left onto Third Avenue. Take Third Avenue to J Street. Building 157 is on the left, and the parking lot is on the right. 

Map

 

 

Copyright 2004 NoCOUG. All rights reserved.