The NoCOUG Winter Conference was
held on Thursday, February 20, at the Hotel Sofitel at Redwood
Shores. Some of the presentations from the meeting are available
for download.
Conference
Description:
The Winter Conference had
parallel sessions on the topics of database administration,
application development, and a special "Oracle by Oracle"
track. Here is the agenda, followed by session descriptions:
08:00 - |
- Registration opens.
Continental Breakfast. |
09:00 - 09:30 |
- General Session. |
09:30 - 10:15 |
- Keynote: "How
Oracle's Complexity Breeds Simplicity"
Craig Shallahamer, President, OraPub, Inc. |
10:15 - 10:30 |
- Break |
10:30 - 11:15 |
- Oracle Keynote: Dennis
Leung Vice President of Development for 9iAS and J2EE
Technologies |
11:15 - 11:45 |
- Break |
11:45 - 12:45 |
- Parallel Session
#1:
DBA |
Application Development |
Oracle by Oracle |
"All About Oracle's
Touch-Count Data Block Buffer Algorithm"
Craig Shallahamer, President, OraPub, Inc.
Level: Advanced
|
"Java Basics for PL/SQL Programmers"
by Peter Koletzke, Technical Director, Quovera
Level: Intermediate
|
"Oracle Collaboration
Suite" by Steven Levine Vice President,
Oracle Corporation |
|
12:45 - 01:45 |
- Lunch |
01:45 - 02:25 |
- Roundtable Discussions |
02:30 - 03:30 |
- Parallel Session
#2:
DBA |
Application Development |
Oracle by Oracle |
"Managing Production
Databases - Best Practices" Noel
Yuhanna, Senior Industry Analyst, Giga Information
Group
Level: All
|
"Top Tips for Oracle Designer" by
Peter Koletzke, Technical Director, Quovera
Level: Intermediate
|
"Oracle 9iAS
Integration Overview", by Milton Wan,
Director of Product Management, Oracle Corporation
|
|
03:30 - 04:00 |
- Afternoon Break
and Raffle |
04:00 - 05:00 |
- Parallel Session
#3:
DBA |
Application Development |
Oracle by Oracle |
"Navigating
the Oracle Backup Maze" by Robert
Spurzem, Senior Product Manager, Legato Systems,
Inc.
Level: All
|
Much Ado About Nothing (NULL)
by Walter Schenk, Principal Consultant, Solutech
Level: Intermediate
|
"Choosing an
Integration Product: Comparing Replication, Messaging
and Oracle 9iAS Integration", by Prashant
Nema, Principle Product Manager, Oracle Corporation
|
|
05:15-??? |
-
NoCOUG Networking and Happy Hour at the bar in the Hotel Sofitel lobby
|
If you have suggestions for future
conferences or would like to offer feedback on previous
conferences, then please send us an email.
"How
Oracle's Complexity Breeds Simplicity" I'm going to
lead you through a journey. A kind of story. It's the story
about how throughout the ages we have tried to understand
our surroundings and make use of them. We began by understanding
our world with simple shapes, then numbers and equations,
and finally through recognizing the patterns all around
us. These patterns can be better understood through the
sciences and mathematics of complexity and self-organizing
systems. We have learned that simple components operating
under simple rules can exhibit very complex behavior. Oracle
has throughout the years incorporated aspects of complexity
and self-organizing behavior into its core database server.
This is allowing Oracle based systems to solve incredibly
massive and complex problems that where literally impossible
just a few years ago
"All About Oracle's
Touch-Count Data Block Buffer Algorithm" Oracle introduced
a touch-count based data buffer management algorithm to
address the growing size, performance requirements, and
complexities of current day systems. Data block buffers
are no longer managed using a modified least recently used
(LRU) algorithm. The touch-based algorithm introduced in
Oracle 8i significantly reduces latch contention, forces
buffers to earn their way higher up the main list, and allows
for increased granular buffer performance optimization opportunities.
This paper details Oracle's touch-count algorithm, how to
monitor its performance, and how to manage for optimal performance.
"Managing Production
Databases - Best Practices" With the increased number
of databases and their ever-growing size, manageability
has become a challenge for most customers. In this presentation
we look at some of the "best practices in the industry"
to manage production databases. We also look at where DBAs
put more effort and how they can become more efficient.
We then proceed on ways to monitor databases including writing
your own custom scripts. We also review some of the 3rd
party vendors offering monitoring products and also validate
if the remote DBA solutions should be considered. Finally
we wrap up with some of the guidelines on improving database
availability.
"Navigating the
Oracle Backup Maze" Backing up an Oracle database has
always been a challenge even for an experienced DBA and
now with the introduction of new Oracle9i RMAN features,
new backup to disk, snapshots and the like, it is getting
even more confusing. This presentation will present and
discuss ten common issue surrounding Oracle backup and present
some clear recommendations on how to best tailor Oracle
backup to your environment.
Much Ado About
Nothing (NULL) Unlike a great deal of programming languages
relational databases work with the concept of null values.
This presentation first provides an overview of the concept
of NULL and discusses the functions and operators available
in ORACLE to work with NULL values. It then shows how various
programming languages interface with NULL values and finally
good code practices as they relate to NULL are presented.
Directions
to the Hotel Sofitel at Redwood Shores
Address: 223 Twin Dolphins
Drive, Redwood Shores, California. Phone: (650)
598-9000.
Southbound- Take Highway
101 South (toward San Jose) to the Ralston
Ave./Marine World Parkway exit. Take Marine World Parkway
east which will
loop you back over the freeway. Make a right at the second
light onto Twin
Dolphins Drive. The hotel will be on the left.
Northbound- Take Highway
101 North (toward San Francisco) to the Holly
Street exit toward San Carlos. Merge onto Redwood Shores
Parkway and make a
left at the second light onto Twin Dolphins Drive. The hotel
will be on the
right.
|