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

 

NoCOUG's May 15, 2003 Conference

Our May 15, 2003 meeting was held at Lockheed Martin in Sunnyvale. Some of the presentations from the meeting are available for download.

Conference Description

The Spring Conference had parallel sessions on database administration, application development, and one track with a mix of different topics. The conference agenda is as follows:

08:00 - - Registration opens. Continental Breakfast.
09:00 - 09:30 - General Session.
09:30 - 09:45 - Break
09:45 - 10:45 - Parallel Session #1:
DBA Application Development Other Topics

"Implementing Oracle9i Data Guard for Higher Availability" by Daniel Liu, Senior Oracle DBA, First American Real Estate Solutions.

 

"How to Figure Out What's Wrong, Part 1" by Thomas Kyte, Vice President, Core
Technologies, Oracle Corporation



 

"Managing What Matters Most - A Holistic Approach to Monitoring Oracle Applications" by Steve Coleman, Senior Engineer, Candle Corporation, Consulting & Services

 

10:45 - 11:30 - Break
11:30 - 12:30 - Parallel Session #2:
DBA Application Development Other Topics

"Moving to LDAP: A Step-by-Step Setup of Directory Naming Using OID" by Daniel Liu, Senior Oracle DBA, First American Real Estate Solutions.

"How to Figure Out What's Wrong, Part 2" by Thomas Kyte, Vice President, Core
Technologies, Oracle Corporation



"Managing OLAP Catalog Metadata in Oracle9i R2 Database" by Shinji Matsumoto, Vice President of Marketing, IAF Software, Inc.

 

12:30 - 01:30 - Lunch
01:30 - 01:55 - Roundtable Discussions
02:00 - 03:00 - Parallel Session #3:
DBA Application Development Other Topics

"Oracle Enterprise Manager (EM V4)" by Dave LeRoy and Martin Pena, Product Director, Oracle Corporation

 

"National Language Support" by Brian Hitchcock, DBA, Sun Microsystems


 

"Materialized Views" by Willie Albino, Senior DBA, Lockheed Martin



 

03:00 - 03:30  - Afternoon Break and Raffle
03:30 - 04:30  - Parallel Session #4:
DBA Application Development Other Topics
"Implications of Setting Oracle9i's Statistics Collection Level" by James
Koopmann, Co-Founder and Chief Architect, dbDoctor

 

"Eliminating Performance Bottlenecks in J2EE Applications" by Rajesh Radhakrishnan, Director of Product Management, Mercury Interactive

"Achieving Your Project's ROI: Managing the Human Aspects of Project
Implementation
"
by Dr. Frances Bruce, Independent Consultant, Bruce Partners
Consulting

04:45 - ...  - NoCOUG Networking and Happy Hour at Faz Restaurant and Bar,
1108 N. Mathilda Avenue in Sunnyvale

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

"Implementing Oracle9i Data Guard for Higher Availability" This presentation provides an overview of Oracle9i Data Guard technology. The session offers an introduction to the basic concepts and architectures of Data Guard. It discusses the following implementation steps: planning for high availability, creating the standby database environment, setting up the log transport services, managing the log apply services, and administrating the Data Guard environment by using Oracle9i Data Guard Manager and command-line interface. This session covers new features in Oracle9i Data Guard Release 1 and 2. This session also compares Data Guard technology with other disaster recovery methods.

"Oracle Enterprise Manager (EM V4)" Enterprise Manager (EM) is Oracle's single, integrated solution for administering and monitoring applications and systems that are based on the Oracle technology stack. EM V4 is the latest generation of the Enterprise Manager that includes significant enhancements in the areas of
holistic system monitoring, centralized application server management, web application performance management, extensive host monitoring, and
enterprise configuration management.

"Implications of Setting Oracle9i's Statistics Collection Level" Statistical analysis is at the root of all performance efforts. Oracle has introduced a new method of turning on statistical collection and expanded our ability to look deeper into areas not available before. This presentation will take a look at the implications of setting up this new method of statistical collection and its' impact on the system.

"How to Figure Out What's Wrong" Thomas Kyte frequently gets asked "My program is slow, what parameter do I need to set to make it go faster". Many people are in search of the fast=true init.ora parameter -- there is no such parameter. This presentation will describe how the author sets about diagnosing application performance related issues, the tools used and the techniques you should employ during development to avoid having to triage your system after the fact.

"National Language Support" Of all the dba joints in all the corporate world, she walked into mine. Christine said little. "Brian, the Kanji data are missing". I knew I was in trouble. Up to that point, no one had mentioned the minor detail that there
was multi-byte Japanese Kanji in this innocent looking single-byte database. The 'expert' DBAs at corporate analyzed the situation in the predictable way. "Brian, a single-byte database can't support multi-byte Kanji". And that was that. I was stuck, in the middle of nowhere, between Christine's need for her Kanji, and the experts' declaration that the Kanji had never existed. This left only one small detail. How to get the Kanji back?

"Eliminating Performance Bottlenecks in J2EE Applications" Our surveys have shown that over 75% of J2EE applications face performance problems. With today's complex multi-tier systems and integration projects, finding these performance bottlenecks can be like finding a needle in a haystack. Customers need a systematic approach to identifying, isolating and resolving performance bottlenecks prior to going live. This presentation will address methodology and technology available today to solve performance problems for multi-tier systems in a deployment or production setting.

"Managing What Matters Most - A Holistic Approach To Monitoring Oracle Applications" Problem isolation and resolution are hard enough in the simplistic client / server environments. We need to take a "holistic" approach to managing the Oracle applications infrastructure by bringing in event, performance, and availability data from clients, networks, web servers, middles tiers, and databases and anything else that can be considered part of the infrastructure and present it a clear, concise fashion so that critical business applications based on Oracle, remain up and responsive.

"Managing OLAP Catalog Metadata in Oracle9i R2 Database" The OLAP option of the Oracle9i Release 2 Database uses metadata in the database's OLAP catalog to describe multi-dimensional models and mappings to data sources. This presentation discusses the OLAP option's multi-dimensional data model, data sources (relational and multi-dimensional data types), run-time uses of the OLAP catalog (e.g., the OLAP API and administrative processes), the OLAP Catalog API and BI Beans applications that can be used to manage the OLAP Catalog metadata.

"Materialized Views" This entry level presentation on Materialized Views (Oracle8i version), will cover what materialized views are, how they created and used, and what set-up steps must be performed so they can be used effectively. In addition, to relevant examples, some of the "behind-the-curtain" mechanics relating to materialized views will also be covered.

"Moving to LDAP: A Step-by-Step Setup of Directory Naming Using OID" Oracle Internet Directory (OID) provides a new mechanism of resolving net service names by storing database-connecting information in a LDAP (Lightweight Directory Access Protocol) Server. LDAP-based name resolution is considered an industrial standard as compare to the more proprietary Oracle Names Server. The OID also replaces the need for storing connecting information on each individual client machine. This presentation discusses the required steps to install, configure, and setup an Oracle Internet Directory Server for name resolution. It offers an introduction to the basic concepts of OID and Oracle Net. It shows how to use Oracle Directory Manager, Net Assistant, and "oidctl" utilities to configure ldap.ora, names.ora, and sqlnet.ora.

"Archieving Your Project's ROI": Managing the Human Aspects of Project Implementation" Organizations today face even more challenges than before, particularly how to obtain collaboration, how to achieve ROI and how to get projects implemented faster with full take-up of what the project delivers. This session provides the latest figures on project 'wastage', based on current research into Fortune 500 companies. Analysis of the data indicates the root causes of implementation problems, backed up by case studies of how the symptoms of these causes played out in several organizations. A solution is outlined which addresses these causes though implementing projects as value delivery systems.

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

 

Copyright 2003 NoCOUG. All rights reserved.