![]() |
The New York Oracle Users Group, Inc. |
| June 2004 General Meeting Presentations | |
| Michael S. Abbey The Pythian Group |
KEYNOTE: Wouldn’t It
Be Nice if Things Worked That Way? - This presentation pokes a bit
of fun at ourselves and Oracle. In the midst of our hectic day-to-day
world, Michael always finds a way to lighten up the perspective and offer
new ways of looking at ourselves and this wonderful software we call
Oracle. |
| Michael S. Abbey The Pythian Group |
Michael Abbey Jeopardy |
| Michael S. Abbey The Pythian Group |
Neat Things to Help Manage Partitioned Objects - When we embark on a course involving management of partitioned objects, we are all so keen and eager to implement all of the theory we have in our heads. Once we get started, we find a plethora of syntactical limits that interfere with the way in which we planned to implement our approach. This presentation will examine some tricks used during partition maintenance operations that, for example, do not invalidate global indexes. In addition, this presentation will offer assistance in building locally partitioned indexes and naming the containers with the same convention adopted for your tables. It will cover the author’s approach to naming conventions, and show attendees why partition object management is fraught with many obstacles, most of which are not difficult to circumvent. |
| Peter Koletzke Quovera |
I Love the Java
Jive: J2EE Overview for Oracle Technologists - Lately, Oracle has been spending a large amount of
time and resources implementing concepts published in the Sun Microsystems
Java 2 Platform, Enterprise Edition (J2EE) specifications. Oracle
customers must have a handle on the technology and options available in
this relatively new world if we are to take advantage of current and
future technologies. J2EE offers a myriad of possibilities and dizzying
number of new acronyms. This presentation is aimed at explaining these to
the Oracle technologist who well understands the "traditional" world of
relational database design, development, and administration but who needs
a quick tour of the Java J2EE landscape and a simple explanation of its
terms and features. The presentation puts J2EE in perspective with
Microsoft's offering .NET and discusses web deployment alternatives such
as servlet and JSP pages as well as Java client alternatives. Finally,
Oracle's product offerings in the Java space are outlined. |
| Data Warehousing SIG | |
| David Friedland, CoSort/IRI | Speeding High-Volume ETL for Oracle Data by Combining Optimized Flat-File Tools |
| John McKenna, Counterpoint Technologies, Inc. | Aggregate Navigation - Using Materialized Views And Query Rewrite |
| Jennifer Leung, Oracle | Oracle Data Warehousing - A Guided Tour - 1400K |
| DBA SIG | |
| Simay Alpoge | Bulk Collections and Inserts in Oracle 9i & 10g |
| Larry Carpenter, Oracle Corporation | Oracle DataGuard New Features in 9i and 10g |
| Jeff Holt and Gary Goodman, Hotsos Enterprises, Ltd. | Using 10046
trace data to resolve Oracle performance issues - A review of three case
studies Paper 50k Presentation 250k - This is a very interactive presentation where we will review 3 actual case studies from the last year. We will examine our client's performance problems and how the Hotsos method was utilized to rapidly determine and repair the root cause issues. We will use these case studies to show the effectiveness of using 10046 level 8 trace data as the basis for Oracle optimization. We will close with a brief discussion of Hotsos and a short demo of the Hotsos Profiler. |
|
FairWest SIG | |
| Dave Anderson SkillBuilders |
What's New For SQL Tuning? Are you working on Oracle9i but have yet to learn the new SQL tuning-related features? Are you interested in what 10g delivers in this area? If so, this presentation is for you. Dave will bring you up to speed on the latest SQL statement performance and tuning features available with Oracle9i and Oracle10g. Some of the new SQL language features available with Oracle10g will also be presented. |
| Long IslandSIG | |
| Backup Scripts (ZIP FILE) Restore Scripts (ZIP FILE) | |
| Raj Sakthi Senior Oracle DBA NMHCrx |
GO LOCAL..! ALL ABOUT LOCALLY MANAGED TABLESPACES - The audience will learn all about LMT's. What makes them tick, Why it is a better choice, what are the advantages, and more. |
| Yomi Odedeyi, Euro RSCG Circle |
Migrating From Unix To Linux - An Oracle's Journey - Yomi discusses his trials and tribulations migrating his Oracle Databases from Solaris to Linux. He discusses topics such as cost justifications for doing it, resources necessary, critical success factors, installation process, lessons learned. |
| Rob Edwards, Dulcian | Oracle 9i Data Warehouse Review - Oracle9i Server presents the latest move by Oracle in establishing a data warehouse platform for supporting e-business intelligence applications. This new version release of Oracle Server lays the foundation for a "Data Warehouse Platform" that adds integrated OLAP services, data mining, an ETL infrastructure, and additional analytical SQL functions to the relational database. The new Oracle Warehouse Builder 3i, with its new mapping architecture and enhancements, will also be reviewed. |
| Howard Horowitz | Oracle Certification
Preparation (OCP) - Attendees are introduced to
general Oracle Certification Professional (OCP) exam info, what's needed
to pass the exams and an overview of each exam. This 45 minutes to one
hour session is divided into two parts. First part focuses on what OCP is
and how it can help you in today's market/economy. It examines the
resources used to prepare for the exam and discusses the structure of the
exams and strategies used to pass them. The second part of the presentation discusses each section of the exam and focuses on various topics from each of the six sections. Exams discussed: (1Z0-001-Intro to SQL and PL/SQL, 1Z0-023- Oracle 8i Architecture and Administration, 1Z0-025- Oracle 8i Backup and Recovery, 1Z0-024-Oracle 8iPerformance and Tuning, 1Z0-026- Oracle 8i Network Administration, 1Z0-030-Oracle 9I New Features). |