Spring 2004 presentation handouts by the following topics:

Database Administration and Tuning, JDeveloper and Java, PL/SQL, and Management!

Keynote Presentation by Tim Hoechst, senior vice president of technology for Oracle Government, Education, and Healthcare
Information Centric Architecture
Over the past decade in governments in developed countries worldwide, we have seen unprecedented growth in computer interconnectivity. The benefits of network-centric systems are enormous in terms of facilitating communications, simplifying business processes, and providing information access at lower cost. To reach these benefits of network-centric systems, organizations must properly build out the technology infrastructure and identify the necessary business processes to properly gather, share, and secure information. Major hurdles in attaining successful network-centric systems include: information assurance, availability, authentication, and Non-repudiation. While few organizations have mastered these challenges, Oracle, from its position of thought leadership in the realm of information management, has recently introduced the next step Information Centric Systems.

Database Administration and Tuning

Oracle Real Application Clusters (RAC) Best Practices
Lorenzo Diez
Since the release of Oracle9i Real Application Cluster (RAC), Oracle has advertised the full availability of “cache fusion” technology. Cache fusion allows direct sharing of Oracle data blocks, thereby eliminating the last obstacle to using the Oracle Parallel Server. This presentation will give a brief introduction to the concepts and general features of RAC including RAC, server and disk technology. The introduction will serve as the groundwork to the best practices used when installing/configuring, administering, and performance monitoring/tuning of Real Application Clusters.

Oracle8i and Oracle9i Database Backup and Recovery: Tips, Tricks, and Best Practices
Chuck Wolfe
This presentation will provide an overview of the database backup and recovery capabilities available in Oracle8i and Oracle9i. Advantages and disadvantages of the various alternatives will be discussed along with tips and tricks which will help attendees develop a robust and repeatable database backup and recovery plan. The presentation will include live demonstrations and a question-and-answer period.

Best Practices for Getting Secure and Staying Secure
Dan Ackerman
Securing your Oracle database and applications has always been important but has gained considerable attention in recent years. In this presentation, learn what steps you should be taking to secure your Oracle solutions and how to keep them secure. The focus will be on how to apply a methodical approach to security as well as a review of things you can do today to better secure your Oracle environment.

Oracle Enterprise Manager Best Practices
James Hanson
Learn how to get the most out of Enterprise Manager 9i in this best practices presentation. Oracle white papers, case studies, and personal experience are distilled into recommendations for monitoring and alerts, job scheduling, data collection, and tuning wizards. Information on using EM with Unix and Windows plus mixed database version sites is included.

Performance Tuning Practices
Ed Schaeffer
This presentation discusses Oracle and system performance analysis based on wait events within extended SQL trace data. We will look at trace file elements, walk through a detailed trace, cover steps for collecting trace data, and locate trace files. We’ll also look at some kernel timings and some fixed view data.

Back to top

JDeveloper, Java

The Object-Oriented SDLC and JDeveloper
Dr. Paul Dorsey
Merging OO and relational theory means that we are now building a new kind of system. Database design should be consistent with OO development but is more than just a persistent copy of the classes. Normalization and other good design principles are still important but we also need to design databases that minimize the cost of overall application development. This presentation will discuss how JDeveloper fits into the overall Object-Oriented SDLC and attempt to provide guidance for developers trying to use JDeveloper to build object-oriented systems.

Demystifying J2EE: Developing J2EE Applications with Oracle JDeveloper 10g and Oracle ADF
Dr. Avrom Faderman
Java 2 Enterprise Edition (J2EE) is the Java standard for developing complex, enterprise-level applications. J2EE provides a plethora of new concepts, technologies, and choices that can be overwhelming to the new developer. This presentation will cover the basics of J2EE and explain the Model/View/Controller design pattern that provides the structure of J2EE applications. It will then look at Oracle JDeveloper 10g and the Oracle Application Development Framework (ADF). JDeveloper and ADF address what has historically been one of the greatest problems for J2EE: the limited productivity of third-generation languages such as Java and the lack of RAD tools. JDeveloper provides a powerful visual and declarative design environment that lets you harness the power of J2EE to solve your business problems without writing 3GL code.

Struts in JDeveloper
Roger Dorsey
This presentation will provide an overview of Struts for the purpose of building J2EE-compliant web-deployed applications using Oracle9i JDeveloper. The technology used to build a real system within the J2EE framework will be discussed. The goal—to determine the optimal way to build applications—turned out to be a much more difficult task than was initially envisioned. This presentation will provide attendees with an overview of the architecture necessary to build J2EE web-deployed applications as well as tips on how to get started.

Management

"Geek Speak" vs. "Management Speak": How to Teach Your Techies to Communicate to You!
David Wendelken
Do your techies spout techno-babble to you? Frustrated by your techies' inability to speak coherently in terms that make sense to you? Feel like you are guessing when it comes to making technology choices because you don't have the information you need? Here is a simple way to teach them what they need to tell you when they ask you to make a decision.

Top Ten Ways to Know—UP FRONT—Whether Your Project Manager Is Going to Fail
Dr. Dale Lowery
How can you know-before you've sunk lots of time and money into a project - that it is in serious danger of failing? What are the signs that can give you an early heads-up before the problems cause a catastrophic project failure?

Application Performance Management—A Necessity
Carolyn Heeley
When an application consists of an Oracle database and there is a performance problem it's always a problem with the database, right? This presentation will illustrate how to determine whether an application performance problem resides at the database level or in another tier of the application—the web server or the J2EE application server, plus is the end user's response time. Let Veritas i3 show you.

Back to top

PL/SQL

What's SQL Got to Do With It? A Best Practices-Based Argument Against Writing SQL
Steven Feuerstein
It's very easy—perhaps too easy—to write SQL into your PL/SQL applications. SQL is something most of us take entirely for granted with the unfortunate result that we end up with redundant SQL statements that are very difficult to maintain and enhance. This lead session on PL/SQL best practices will make clear the problems with unconstrained coding of SQL and show you how to fix things, mostly by following a simple recommendation: STOP WRITING SQL!

It's a Matter of Self Respect: How to Unit Test Your Code Practically and Efficiently
Steven Feuerstein
A unit test is a test that a developer creates to ensure that his or her "unit," usually a single program, works properly. A unit test is very different from a system or functional test; these latter types of tests are oriented to application features or overall testing of the system. You cannot properly or effectively perform a system test until you know that the individual programs behave as expected. So, you would expect that programmers do lots of unit testing and have a correspondingly high level of confidence in their programs. Ah, if only that were the case! This seminar shows you how to improve dramatically the quantity and quality of unit testing—and do it with a lightweight methodology and prebuilt PL/SQL framework: utPLSQL and Ounit.

Keeping an Application's Cool: Best Practices for Exception Handling in PL/SQL
Steven Feuerstein
Trapping and handling errors is a crucial, but often neglected, aspect of any PL/SQL application. This session includes a quick review of PL/SQL exception handling via class quizzes, identifies common problems with coding for exceptions, and offers an architecture and and reusable code that will result in consistent error handling throughout your application.

Back to top