|
|
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
|
