The Delaware Valley Oracle Users Group Inc.

Agenda

Its too early in the process to have an agenda together yet. Is there anything you want to see? Are you interested in presenting? If so, please let sandilea@fast.net know.

Due to snow damage, the Blair Mill Inn has requested that we change the date of our meeting from March 7, 2003 to March 21, 2003.  We apologize if this causes any inconvenience.

Here are the abstracts that we have collected.  As soon as we have the schedule together, we will post and e-mail the agenda.

Abstracts

These abstracts detail the presentations that we have to date.

Welcome, Sandi Moore
 
Upgrading to Oracle 11i E-Business Suite, Mike Janesch, Innovative Consulting, Inc.
A technical discussion on the challenges and approaches of upgrading to Oracle 11i. E-Business Suite customers on version 10.7 are being forced to upgrade by June 2003 with limited extended support through June 2004. This presentation discusses Desupported Versions and Clarification of Extended Assistance Support for 10.7, Fresh Install vs. Upgrade Options, Database Upgrade Requirements, Single vs. Multi-tier Server Deployment , Hardware Resources (Database Server, Application Servers, Desktops), and Realistic Project Approaches. Many E-Business Suite customers had a bad experience with their initial installs and previous upgrades. This presentation discusses the reality that technical project team members will encounter during this type of initiative.
 
 
Java Stored Procedures, An Alternative to External Procedures?, Robert F. Edwards, Dulcian, Inc.
This presentation will explore the use of Java Stored Procedures as an alternative to External Procedures, for performing operations on the operating system, the file system and providing functionality not available with existing database utilities. Java stored procedures are available on Oracle8i, and provide an additional way of developing applications that does not require a separate development platform, such as C/C++. An example explores executing commands to the operating system, using an external procedure and a Java stored procedure.
"Fire and Forget":  When to Use Autonomous Transactions, Michael Rosenblum, Dulcian, Inc.
Autonomous transaction control is a very powerful tool that can solve a number of difficult problems. At Dulcian, we have used autonomous transactions for tracking data manipulation activities (Select/Insert /Update/Delete), and dynamic changes of database structures. Autonomous transactions can even be used to avoid mutating tables. Most of those problems cannot be solved in any other way with the same level of efficiency.

Autonomous transactions enable a PL/SQL routine to spawn a new independent transaction and execute code within it using an independent Commit. Initially, this had been an internal Oracle tool which was introduced in Oracle 8i and extended in Oracle 9i to a distributed environment.

To take advantage of this function requires a thorough understanding of how it works. Without this knowledge, developers may experience totally unpredictable results.

Database Growth and Its Impact, Fred Booker, Princeton Softech 
Storing videos, images and other large objects in your Oracle database? How fast is your database growing? Is the database growth affecting your application performance and availability? Are you spending more time coping with the data growth issue rather than focusing on the future of your databases? What else can you do? Have you ever considered archiving this data, knowing that you must retain access to the data?

How do other companies resolve these problems? Come and see how others have addressed their pains associated with fast growing relational databases and develop a long-term strategy to handle this problem across all databases and applications.

 
SQLiBase – A dynamic web-based DBA Tool, Isaac Oribioye, SQL-Integrator 
Limitations of current DBA tools.
SQLiBase solutions
Linux/Oracle platform
Multi-database monitoring
Administer while you monitor
Cool extras.
The Sky is the limit...

 

Comments? Please e-mail them to the OUG WebMaster.

Last changed: March 09, 2003