• 2008
  • March General Meeting
• 2007
  • December General Meeting
  • October General Meeting - NYC Metro Area User Group Meeting
  • June General Meeting
  • March General Meeting
• 2006
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2005
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2004
  • December General Meeting
  • September General Meeting
  • June General Meeting
• 2003
  • December General Meeting
  • September General Meeting
  • March General Meeting
• 2002
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
  • January General Meeting
• 2001
  • June General Meeting
  • March Training Day
• 2000
  • December Training Day
• 1999
  • December General Meeting
  • September General Meeting
  • February General Meeting

March 2008 General Meeting

• Keynote

• DBA Track

• Development Track

KEYNOTE: PL/SQL Enhancements in Oracle Database 11g

• Transparent and “knob-controlled” performance improvements;
• New language features that you use in your programs to get better performance;
• New language features that bring functionality which you earlier couldn’t achieve, or could achieve only with
cumbersome workarounds;
• New language features that improve the usability of programming in PL/SQL.

Bryn has made an unashamedly personal selection of some of these features to describe in fair detail in this
presentation. He used two criteria: his instinct-based ranking according to their relative importance for customers;
and his judgment of whether attendees might appreciate some background that they’re unlikely to find in other
accounts. For completeness, Bryn will finish by just listing the other features and giving a skeletal account of each.

Bryn Llewellyn is the PL/SQL Product Manager, Server Technologies Division, at Oracle HQ. He has worked in
the software field for 30 years. He joined Oracle UK in 1990 at the European Development Center in the Oracle
Designer Team. He transferred to the Oracle Text Team and then into Consulting as the Text specialist for Europe.
He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the
Product Manager for PL/SQL since 2001. It’s hard for Bryn to remember his life before Oracle. He started off doing
image analysis and pattern recognition at Oxford University and then worked in Oslo, Norway, in the public sector
and in a startup. Bryn programmed in Simula (its inventors were his close colleagues). This language was the
inspiration for Smalltalk and C++.

Back to Top

DBA TRACK: The Secret to a Successful Upgrade: Using Database Replay to Guarantee Success

Extensive testing is usually performed to validate system changes such as database upgrades. However, unforeseen
problems such as performance regressions often occur when the production database is finally upgraded. This
presentation describes how you can significantly improve your chances of a successful upgrade by using Database
Replay, a new feature introduced in Oracle Database 11g. Mughees will describe, in detail, the internal architecture
of this feature, give practical examples of its usage, as well as discuss general best practices for using Database
Replay.

Mughees Minhas is responsible for the self-managing solutions of the Oracle Database with special interest in
areas such as performance diagnostics, SQL optimization and tuning, space management and load testing. He has
more than 12 years of experience working with Oracle databases and is currently director of product management
in Oracle’s Server Technologies division.

Back to Top

DBA TRACK: Overview of TimesTen

TimesTen is a very popular, fast-growing product in the Oracle suite. This presentation will walk through the
TimesTen feature set and discuss the path to implementation. Shig will cover the cover the product features,
function, and implementation required for TimesTen as well as discuss success stores and case studies.

Shig Hiura is a Senior Sales Consultant with Oracle in the Embedded Global Business unit, serving embedded and
ISV partners who want to leverage Oracle technologies in their solutions. He has over 15 years of experience in the
IT industry and has worked with the Oracle database since version 7. Much of his experience includes work in the
Financial Services sector and work with Fortune 500 companies.

DBA TRACK: DUDE, Where’s my Data?

It's a DBA's worst nightmare--the loss of data. Sure, your backup scripts were well-tested and had some real cool
exception handlers in them. But now the time has come to recover your data, and guess what? Those exception
handlers weren't so cool after all. Datafiles are missing, you're missing archives, and hey, where did that system
tablespace go anyway? This presentation describes several real life situations where Oracle database recoveries
went terribly wrong, resulting in a situation where using a data unloader was the only option left to extract data.
The second part of the presentation provides an overview of how data unloaders work. By briefly looking at the
block internals, it will show you how data can still be recovered, even when the system is gone or the database can't
be opened. The data unloader “DUDE” is used as a case study.

Having administered, developed against, and consulted on all versions of Oracle since version 7, Jonah Harris has
spent a considerable amount of time specializing in OCI, performance tuning, and researching Oracle Internals.
When time permits, he provides support to the Database, Call Interface, Instant Client, ODBC, PHP, Linux, SQL,
and PL/SQL community forums on OTN.

DBA TRACK: Protect Privacy with Data Masking

The Data Masking Pack for Databases helps organizations share production data in compliance with privacy and
confidentiality policies by replacing sensitive data with realistic but scrubbed data based on masking rules. This
presentation discusses the two primary use cases for the Data Masking Pack:
1. DBAs want to take a copy of production for testing purposes and use the Data Masking Pack to replace all
sensitive data with innocuous but realistic information and then make this database available to developers.
2. Organizations want to share production data with 3rd parties.
This presentation will include a demo to show how to Mask data and maintain referential integrity.

Nicholas J. Donatone is a Grid Sales Consultant for Oracle Corporation. Nick has been working with Oracle
software since version 4 (1986). Nick is one of the founders of the New Jersey Oracle Users Group (NJOUG) and
was president/co president of the NJOUG for more than 18 years. He is Vice President of the Philadelphia Area
Oracle User Group (PHLOUG). Nick has made presentations at NYOUG, NJOUG, IOUG, ODTUG, SEOUG and
Oracle OpenWorld.

DEVELOPER TRACK: Doing SQL from PL/SQL: Best and Worst Practices

The PL/SQL developer has many constructs for executing SQL statements, and the space of possibilities has
several dimensions: embedded SQL versus native dynamic SQL versus the DBMS_Sql API; bulk versus non-bulk;
implicit cursor versus parameterized explicit cursor versus ref cursor; and so on. Deciding which to use might seem
daunting. Moreover, as new variants have been introduced, older ones sometimes have ceased to be the optimal
choice. Oracle Database 11g has kept up the tradition by bringing some improvements in the area of dynamic
SQL.This presentation examines and categorizes the use cases for doing SQL from PL/SQL, takes the Oracle
Database 11g viewpoint, and explains the optimal approach for the task at hand.

Bryn Llewellyn is the PL/SQL Product Manager, Server Technologies Division, at Oracle HQ. (See full bio above)

DEVELOPER TRACK: Forms to Fusion

This presentation reviews the current Forms landscape and options Forms users have in regard to their existing
investment. Ernst will review when to upgrade or convert, what role ADF plays in Forms applications, and what
technologies will come into play in an SOA environment. This presentation will also discuss how to understand your
current state environment and map it to a practical, workable, future state. This session will provide insight into
making thoughtful decisions regarding the advancement of a Forms application.

Ernst Renner is CEO of Vgo Software, a leader in the modernization of client/server applications. In addition to
leading Vgo, Ernst is managing partner at NEOS, a services company he started in 2000, specializing in enterprise and
information architecture services. He brings over 15 years of high-technology experience to the table in database and application technologies.

DEVELOPER TRACK: Value of Embedding Oracle Technologies

95% of Oracle user do not know that they could potentially embed Oracle technologies saving them money and
implementation effort. Participants will learn the value of embedding, how to embed, and which Oracle products are
“embeddable.” Mel will cover the basics of embedding and the implementation required. The presentation will
include descriptions of case studies and success stories.

Shig Hiura is a Senior Sales Consultant with Oracle in the Embedded Global Business unit. (See full bio above)

DEVELOPER TRACK: Two 30-minute presentations

A. Oracle Instant Client for Windows
Oracle Instant Client allows you to run your applications without installing the standard Oracle client, while using
significantly less disk space than before. Even SQL*Plus and ODBC can be used with Instant Client. This
presentation demonstrates the easiest way to connect to a remote Oracle database, requiring light installation of small
libraries on Windows using Oracle Instant Client on Windows XP.
Eunhee Lee is a Senior Database Architect at ReturnPath Inc. in New York City with over 10 years of Oracle
Database and software development experience. She earned her Master's Degree in Computer Science and
Engineering at HongIk University, South Korea and New York University.

B. Consensus and the Collaboration Method
Accessing data is a core aspect of any n-tier software system. From a traditional software development lifecycle
point of view, there are three popular ways in which the application developer works with the emerging
schema/database:
1. The Developer may have carte blanche to dictate the type of tables/views to be built and/or accessed.
2. The database tables/views have already been fully implemented via the Data Architect and the DBA. Therefore,
the developer must do his or her best to work with what has been put into place.
3. Collaboration and consensus between the Application Developer(s), the DBA and the Data Architect, working
together towards a common goal.

This presentation discusses the risks and rewards of using the different methodologies. Ultimately, the findings
substantiate the claim that using the Collaboration/Consensus method produces the most benefits.

Joshua Feinstein-Plummer is a Data Systems Architect at Standard and Poor's. He has over 10 years of practical
experience in financial information systems and currently serves as a member of the S&P Technical Architecture
Group. He lives in Brooklyn with his wife, Eva-Maria C. Plummer.

December 2007 General Meeting

• Keynote

• DBA Track

• Development Track

• UCM Track

What with new-fangled this and new-fangled that, many of the issues that surfaced 20-25 years ago were supposed to "disappear" with the influx of new more powerful hardware and more database self-management techniques. The major players in the database arena are proud of the advancements they have made in the throughput of query processing. Whether companies go the "open source" MySQL route, or choose a more industrial strength vendor such as Oracle, so many problems that surface are reminiscent of the 80's and, in many cases, have little or nothing to do with the software.

IT management and the "human factor" are still the major dictators, influencing what works and what does not. Management decisions made 20 years ago still affect what's going on today. Once vendors get their claws into corporate IT infrastructures, companies are stuck with what they have in order to protect their investments and product knowledge gleaned from years of product use.

This presentation will discuss database management in the first decade of the 21st century, and offer some suggestions about what may be the "best" route to take. As the baby-boomers approach retirement, this may be the only chance we have to turn things around and not keep repeating the mistakes that we made in the 80's.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 14 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of events for and serves on the board of directors of the Independent Oracle Users Group (IOUG). He is a frequent speaker and keynoter at user group and vendor conferences and has appeared at such events as IOUG Live!, COLLABORATE, Oracle Open World, the European Oracle User Forum, and UK Oracle User Forum.

Back to Top

System Administrators have to manage a larger number of critical systems and deliver a higher quality of service. At the same time, decision-makers require more insight into business agility in order to meet service performance goals. This presentation will show how to automate your IT systems to improve quality of service and lower data center management costs. Learn how Oracle Enterprise Manager manages IT services and the system infrastructure in Grid computing and service-oriented environments, thereby reducing costs and risks, maximizing productivity, and aligning your IT objectives with your business.

Sandra Cheevers has been with Oracle for over 18 years, and has worked in Customer Support, Customer Education and Product Management. She handles product management in the development organization for the Oracle Enterprise Manager product, and is a frequent speaker at Oracle conferences.

Back to Top

Arup Nanda is the lead DBA at Starwood Hotels. He has been an Oracle DBA for more than 12 years. He writes for many Oracle related technological magazine, speaks at many Oracle conferences and has co-authored four books. He paints watercolors when is not doing all of these activities. He was Oracle Magazine's DBA of the Year in 2003 and is an OTN ACE Director.

Back to Top

Database archiving allows sites to streamline the application upgrade process, minimizing costly business disruption and improving performance. This presentation explores how managing enterprise application data can help:
1. Reduce time to upgrade and “go live” into production, while minimizing downtime during the conversion.
2. Control costs associated with application upgrade time, resources and maintenance
3. Increase your ability to satisfy data retention compliance requirements, ensuring that historical reference data remains accessible, even after applications have been upgraded.

Attendees will learn how some sites have cut downtime by over 50 percent while boosting the performance of key functional processes.

Steve Johnston is an experienced marketing and technology professional who has spent more than 10 years working in and around the technology industry. Steven has spoken at numerous conferences, user groups and associations on topics ranging from data privacy and compliance to the management of the effects of data growth in enterprise databases, the implementation of compliance-driven data management strategies, and the implementation of solutions to secure data in test and development environments. His background and experience includes successful work with EPCglobal US, GS1 (formerly the Uniform Code Council), Apptix, RealMedia, Penn Mutual and currently Princeton Softech.

Back to Top

There are probably close to as many ways to investigate a database slowdown as there are DBAs in attendance at most user group events. We all have a suite of methods and techniques in our toolkits to troubleshoot the performance hiccoughs that systems experience from time to time. When the call comes or the pager sounds off, this presentation will suggest one track to follow when trying to figure out what role the database is playing in these service interruptions (if any!). This presentation discusses my favorite places to go in the data dictionary and offers a handful of queries that may end up assisting the Oracle professional in getting to the bottom of application bottlenecks.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 14 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of events for and serves on the board of directors of the Independent Oracle Users Group (IOUG). He is a frequent speaker and keynoter at user group and vendor conferences and has appeared at such events as IOUG Live!, COLLABORATE, Oracle Open World, the European Oracle User Forum, and UK Oracle User Forum.  

Back to Top

Bob Wicklund is a Consulting Technical Senior Director at Oracle Corporation

Back to Top

Inderpal S. Johal has been working as a lead database administrator and architect for more than 10 years. He is currently working as principal consultant for Data Softech Inc., a New Jersey based company that specializes in providing complete database support solutions and training to various clients. He has written various Oracle technical articles for journals and magazines including Oracle Magazine and has spoken at Oracle Open World, IOUG, UKOUG, NYOUG, NJOUG and DBA Online. He has a Master's Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.

Back to Top

DEVELOPER TRACK: If you’re not using Analytics, shame on you!
In this presentation, will explain why you should be using analytics along with the minimum knowledge needed to get started. The presentation will also include some easy-to-understand, yet effective examples.

Travis Rogers is a Senior VP of Database Development for CDG Management LLC with over 15 years of software development including 10 years of Oracle development.

Back to Top

If your application users span time zones, dates should be relative to the user and transformable to different time zones. Oracle offers a complete set of options serving different requirements. Daylight savings time and the dynamic policies that determine it, must also be accounted for. What are the options and trade-offs? What are the relationships of the session, database, and server? This presentation will answer those questions and further discuss all the ancillary functions and their use. Detailed examples will explain the differences between SYSDATE, SYSTIMESTAMP, CURRENT_DATE, LOCALTIMESTAMP, etc. And finally the bugs.

Edward Kosciuszko started at Oracle Corporation in 1981 and since leaving in 1986 has been consulting, teaching SQL courses and designing Oracle tools. Ed created the first SQL optimization product, which was later sold to Platinum Technologies. 

Back to Top

This presentation discusses various scenarios to successfully approach Oracle testing based on the workload/workflow characterization, involving forms, reports, SQL, PL/SQL, and object-oriented programming languages among others. Independent from the methodology used, the presentation will also challenge opinion discrepancies among approaches such as CMM/CMMI and XP models, and traditional, object-oriented, and iterative software engineering methodologies. Best practices in testing Oracle front-end, back-end and middleware development at any stages will be covered. Finally, cases discussing strategies to both front-end, middleware, and back-end testing with an assessment as to whether a successful or failed outcome was related to the methodology utilized will be presented.

Anthony D. Noriega is an IT consultant and computer scientist who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms spending most of his time as a database architect, DBA, database analyst, and developer. Anthony holds an MS Computer Science from NJIT, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a Senior Consultant or Associate for Bowne & Co., IBM, Time Warner, AT&T, Reed-Elsevier, MCS Canon, Time, FMC, and Deutsche Bank.

Back to Top

October 2007 General Meeting
NYC Metro Area User Group Meeting

• Keynote

• DBA Track

• Development Track

• Fusion Track

Linux installs are still growing rapidly and many companies are deploying new systems with Linux as the preferred operating system. However even today, there is a lot of concern around Linux, its future and reliability/scalability in big datacenters. This presentation will discuss some of the new features coming up and see what companies like Oracle are doing to help ease the concerns. Linux is a very viable deployment platform and we want to make sure everyone feels comfortable with it.

Wim Coekaerts is vice president of Linux Engineering for Oracle, reporting to Chief Corporate Architect, Edward Screven. He is responsible for managing Oracle's Unbreakable Linux strategy with a dedicated focus on ensuring large enterprises can adopt Linux quickly. Mr. Coekaerts has spent more than 7 years building a large-scale development and support organization and has fostered comprehensive customer and partner relationships, which helps drive the company's evolution of Linux. Additionally, his group develops and makes on-going contributions to the Linux community, including the first Cluster File System to be accepted into the Linux mainline kernel in 2006.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

June 2007 General Meeting

KEYNOTE: Secure Your Data Transparently

Most applications developed in last decade were not designed to meet today's challenges around compliance (SOX, PCI), privacy, and insider threats. While security technologies such as encryption have existed for many years for protecting Personal Identifiable Information (PII), incorporating these technologies has proven to be a costly, risky, and time consuming exercise. This presentation will discuss how the transparency of security technologies is critical in making significant progress in securing today's data and applications. Mr. Samar will show how Oracle Database Vault, Oracle Audit Vault, Transparent Data Encryption (TDE), and Oracle Label Security can be applied to existing deployments to dramatically increase security, and lower the costs for compliance. In addition, the key security features of the next database release from Oracle will be discussed.

Vipin Samar is Vice President of the Database Security group at Oracle, and is responsible for all database-related security technologies as well as several Oracle security products including Database Vault, Audit Vault, Label Security and Advance Security. Starting his career in Sun's OS and networking group, he has been in the security space for 12+ years, and has worked in the areas of OS security, PAM, secure RPC, PKI, single-sign-on, and Identity Management. He is a local boy having completed his Master's Degree in Computer Science at SUNY Stony Brook many years ago.

Back to Top

Corporate databases contain the crown jewels of an organization, and data theft by hackers or insiders can cost millions in fines, lawsuits, and customer attrition. The good news is there are 10 commonly used methods to attack databases. Defend against these, and your databases will be virtually impenetrable. Using real-world examples, this presentation will describe each of the top 10 database security threats as well as demonstrate the probable attack mechanisms. The potential damage will be illustrated, along with detailed information regarding best practices in mitigation and defense techniques and tools.

Idan Soen is a Senior Security Engineer for Imperva. He has been in the IT security market for over 9 years. After spending two years at HP and five years at Check Point he joined Imperva three years ago as a senior security engineer covering Asia, EMEA and most recently the New York metropolitan region. Idan is well versed in web application and database security and has been involved in security implementations at many of the fortune 500 companies. Idan has a BA in business with a minor in IT and he is a CISSP.

Back to Top

Attendees will learn about the functionality that Oracle Application Express provides by exploring the three main working areas of Application Express. This brief presentation will serve to introduce Oracle professionals to the Application Express environment. It will show attendees how they can rapidly create intra and internet based applications that reference existing Oracle data. Attendees will also be shown how they can rapidly integrate spreadsheets, PDFs and various business related documents into their database and web application.

Karen Hackett is an IT professional with over 25 years experience. She has been working with Oracle for over 5 years at SkillBuilders. She is webmaster of www.skillbuilders.com which uses Oracle and Coldfusion. She also designed, developed and maintains www.RIOUG.org and www.RIRenewableEnergy.com

Back to Top

This presentation covers the high availability capabilities in Oracle Database 11g, which are designed to help organizations maintain a highly available, scalable infrastructure that meet users' quality of service expectations. Tim will detail many of the Maximum Availability Architecture (MAA) and availability capabilities in Oracle Database 11g such as:
• Utilizing standby databases for real time query purposes
• Enabling standby databases to be easily used for testing purposes
• Significantly reducing recovery downtime with Data Recovery Advisor to automate problem investigation and intelligently determine a recovery plan
• Applying patches to an Oracle database instance with zero downtime
• Further automating human error recovery using Flashback Transaction
 

Tim Chien is a senior product manager with Oracle's High Availability and Storage Management Group.
He is an 8 year Oracle veteran and has extensive product management and product marketing experience includes server systems, application server, and database products.

Back to Top

This will be a detailed presentation using an RMAN script where participants will learn step-by-step how to clone a new database and refresh an existing database’s data. The author has used the RMAN feature in production for several years. He will share his experience and script to show step by step to clone or to refresh databases in same or in different machines. Many production details will be talked such as refresh archived production database to no archive develop database. The script will enable the attendees to use just one command to do the entire job automatically. HP OMNI Performance tips will also be introduced.

Yongan Cui has been an Oracle certified DBA since version 7.3. He has presented at IOUG and authored a SELECT Journal article.

Back to Top

Participants will learn how to secure their Oracle databases and some of what Novartis has done globally to implement Oracle Database Security. Jonathan will discuss specific activities that DBAs and application teams should perform to secure their databases. In addition, some specifics of what Novartis has done to harden their database environment, including an "Oracle Database Security Roadshow" will be presented.

Jonathan Intner has been an Oracle DBA for more than 15 years. In addition to being a 9i OCP, he is a CISSP (Certified Information Systems Security Professional).

Back to Top

Oracle released Database Vault in August of 2006 to address rapidly emerging security requirements around the world for restricting access to sensitive data by privileged users, overcoming a long-standing security problem. Along with such first-of-its-kind access control capability, Database Vault also introduced custom access policies based upon environmental, execution, as well as user factors to control how existing databases, applications, and data are accessed. This presentation takes a look inside Oracle Database Vault, its architecture, security threat model, and how new controls were added to the Oracle Database kernel so that privileged users and DBAs are restricted from accessing sensitive data, but can still perform all of their authorized maintenance and tuning activities. Mr. Samar will discuss the operational model and how it offers separation-of-duty capabilities. In addition, a case study of how a financial services company plans to leverage Database Vault to address its compliance and security requirements for its world-wide operations will be presented.

Vipin Samar is Vice President of the Database Security group at Oracle, and is responsible for all database-related security technologies as well as several Oracle security products including Database Vault, Audit Vault, Label Security and Advance Security. Starting his career in Sun's OS and networking group, he has been in the security space for 12+ years, and has worked in the areas of OS security, PAM, secure RPC, PKI, single-sign-on, and Identity Management. He is a local boy having completed his Master's Degree in Computer Science at SUNY Stony Brook many years ago.

Back to Top

CLOBs/BLOBs/BFILEs (commonly called “large objects”) have been around for a long time, but only recently have they become critical tools for database systems. Handling large database objects requires in-depth understanding of their proper handling. This presentation will provide a starting point by explaining when, why, and how to use large objects in real-world situations.

Michael Rosenblum is a Development DBA at Dulcian, Inc. He is responsible for system tuning and application architecture. He supports Dulcian developers by writing complex PL/SQL routines and researching new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press, 2006). Michael is a frequent presenter at various regional and national Oracle user group conferences. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics.

Back to Top

March 2007 General Meeting

KEYNOTE: How Oracle Came to Rule the Database World

This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Richard J. Niemiec is chief executive officer and principal of TUSC. He is respected around the world as a master in database administration. In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master -- one of the first six so recognized around the world. In 2003, Rich authored Oracle9i Performance Tuning Tips & Techniques, one of more than two dozen books TUSC has written for various publishers and features a compilation of more than 20 years of hands-on experience and real-life issues. Some Fortune 500 accounts he has managed include M&M Mars, McDonald's Corp. and Pepsico. His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is a former president of the International Oracle Users Group and currently serves as vice president for its Real Application Clusters special interest group. In addition, Rich is the current president of the Midwest Oracle Users Group. He previously was the executive editor of Exploring Oracle DBMS magazine and editor of MOUG Newsletter. Rich has delivered hundreds of lectures on Oracle to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has conducted numerous expert class presentations at Oracle OpenWorld and other major conferences.

Back to Top

Database creation, because of better GUI tools, has become an increasingly overlooked area of Oracle. In this presentation, Sean pulls back the covers, revealing what Oracle is doing at each stage. Why do we have startup nomount, mount, restrict, and open? What OS resources is Oracle using at each step? How do we issue CREATE DATABASE? What is the simplest init.ora file? How many file descriptors does Oracle use and why?

Sean Hull is the founder of and senior consultant at Heavyweight Internet Group in New York. He has worked as a database consultant and expert for ten years, in the areas of Oracle and various Open Source technologies. He is the co-author of Oracle and Open Source (2001, O'Reilly & Associates) as well as various Open Source database tools, scripts, and applications. Sean has also written articles for various online and print publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

Attendees will learn how to build their own versions of Instant Client with tools not included in Oracle's Instant Client. Oracle Instant Client is a power tool that is easy to install and set up, but it only comes with SQL*Plus. This presentation shows how to include other Oracle tools like SQL*Loader and exp/imp to make your own instant client bundle.

Richard Ji is a Senior Principal DBA Manager at WiderThan Corp. He has been working with Oracle databases since 1996. Richard had architected high performance, large scale databases that perform in the range of several hundred million transact

Back to Top

What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are easy ways to solve many of your performance issues that plague your system. This presentation will show how to use Statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file I/O issues. Attendees will also learn how Statspack compares to AWR Report and some of the additions that AWR Report provides over Statspack, even though 80% of the information is the as that in Statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events.

Richard J. Niemiec is chief executive officer and principal of TUSC. He is respected around the world as a master in database administration. In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master -- one of the first six so recognized around the world. In 2003, Rich authored Oracle9i Performance Tuning Tips & Techniques, one of more than two dozen books TUSC has written for various publishers and features a compilation of more than 20 years of hands-on experience and real-life issues. Some Fortune 500 accounts he has managed include M&M Mars, McDonald's Corp. and Pepsico. His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is a former president of the International Oracle Users Group and currently serves as vice president for its Real Application Clusters special interest group. In addition, Rich is the current president of the Midwest Oracle Users Group. He previously was the executive editor of Exploring Oracle DBMS magazine and editor of MOUG Newsletter. Rich has delivered hundreds of lectures on Oracle to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has conducted numerous expert class presentations at Oracle OpenWorld and other major conferences.

Back to Top

Security_Practices.zip

Participants will learn how the JAZN service of the Oracle Application Server OC4J runtime provides solid security services for J2EE web applications. They will also learn about the JAZN ability to access user credentials stored in XML files and in LDAP repositories. They will hear about and see how to set up and code security hooks into an application using JDeveloper 10g so they can restrict and permit user access and operations to valuable enterprise data.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

The use of column histograms can have a very positive impact on the Cost-Based Optimizer's operation, but there is still much uncertainty about when and how to take advantage of this functionality. This presentation discusses how histograms are used, how to identify columns for which they are appropriate, how to create them, and how to confirm their use. Participants will learn how to determine if a column is a candidate for histogram generation, how to create the histograms, and how optimizer behavior changes in their presence.

Paul Baumgartel has been an Oracle DBA for many years, and currently works as an independent consultant in the New York City financial industry. He specializes in performance optimization, database server architecture, and training.

Back to Top

This paper and presentation with discuss important applications in finance, marketing, research and development and other important areas of management science, forecasting, and data mining. The key aspects of this presentation, unlike most business intelligence analytics, is that it is driven by Oracle10g SQL Model’s ability to achieve successful forecasting utilizing traditional and scientific business models based on the dimensions, measures, and rules implemented.

Anthony D. Noriega is an IT Consultant who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony has attained an MS in Computer Science from NJIT, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a consultant for IBM, AT&T, M&M Mars, Tosco, Allied-Signal, and an associate for Deutsche-Bank, Bowne & Co, Reed-Elsevier, MCS Canon, and FMC. Anthony is fluent in Spanish and French.

Back to Top

December 2006 General Meeting

KEYNOTE: Soft Skills….Can’t Live Without Them
I don't care if you played bass guitar for the Quarrymen before Paul McCartney or if you were a ghost writer for Dickens ... if your going to sit in your cubicle all day, pound away at your keyboard, and bark at colleagues who stray into your space ... you're not getting the job! Even though you have Oracle skills second to none, it's not all about the software.

• Are you a team player?
• Can you compromise?
• Hows your grammar and spellnig?
• Ever heard of a deadline?
• The phone ... yes we do still use them here.

Soft skills .. often as important, if not more important, than your technical skills. In this keynote, Michael will share some of his experience of his north of 20 years in the industry and highlight some experiences we have all gone through which, when happening, were painful, but in hindsight are nothing but comical. Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 12 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of conferences for and serves on the board of directors of the Independent Oracle Users Group (IOUG)

Back to Top

DBA TRACK (single session): 11gR1 PLSQL New Features

A 60 minute overview of some of the many new SQL/PLSQL features including much improved native compilation, result caches, more granular dependency management, new trigger types and more.

Back to Top

DBA TRACK:  Introduction to Automatic Storage Management

This presentation is and introduction to Oracle's new integrated file system and volume manager, ASM. Demonstrations will illustrate the basic use of ASM, including creating disk groups, migrating to and from ASM and using ASMCMD to manage ASM files.

Dave Anderson has more than 24 years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle - as a programmer and administrator.  Dave speaks regularly at Oracle conferences including IOUG, NYOUG, CTOUG, VOUG, NOUG and SEOUC (where he won “Best of Conference” for his RMAN presentation).  In 1992 Dave founded and is still employed by SkillBuilders, an Oracle Partner specializing in Oracle sales, training and consulting.

Back to Top

Oracle has long offered tools that assist with deploying applications; its current focus is with the Java IDE, JDeveloper. JDeveloper 10g (release 10.1.3) offers a new set of features, libraries, and methods -- ADF Faces -- which greatly simplifies Java development tasks and takes advantage of the popular J2EE (Java EE 5.0) technology JavaServer Faces. The tools that JDeveloper provides to work with ADF Faces allow development of J2EE web applications in an environment that is closer to Oracle Forms than anything previously released.
This presentation describes Application Development Framework (ADF) and ADF Faces and how they can assist with development of a Java-based application. It also shows the various tools in JDeveloper that support the "ADF development method" and how they ease the task of connecting Java front-end code to the database. In addition, the presentation provides an overview of the JHeadstart plugin and shows how its declarative environment might rival that of Oracle Forms Builder. Finally, the presentation offers insights about what type of development shop will benefit the most from ADF, ADF Faces, and JHeadstart and whether it really is possible to achieve the productivity of an Oracle Forms environment by using ADF Faces with JHeadstart.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

So many DBAs are postponing the move to Recovery Manager due to its seemingly time-consuming learning curve. In this presentation, attendees already fluent with backup and recovery strategies using Oracle's toolset will see how the transition is nowhere near as time consuming as anticipated. This presentation will cover the infrastructure setup to support catalog-based RMAN, and present some scripts to get started. Michael will discuss the three main backup scenarios and look at the recovery phase of an RMAN restore exercise as well as cover the pesky management of and backup of archived redo as well as a primer on catalog cleanup. With a kick-start through the lessons learned in this presentation, the move to RMAN is one of the least complicated hurdles DBAs will be asked to overcome.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 12 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of conferences for and serves on the board of directors of the Independent Oracle Users Group (IOUG)

Back to Top

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

Matthew Williams is a Senior Oracle Programmer at LexisNexis Corporation, and specializes in matching techniques to unite unrelated data sources. He has a cat.

Back to Top

September 2006 General Meeting

KEYNOTE: Fusion Middleware Technical Overview and Roadmap

Oracle Fusion Middleware is not only the fastest growing Oracle product.  It is also innovating rapidly.  The keynote will first address the major technologies and components of Fusion Middleware supporting SOA, Identity Management, Business Intelligence, and Workplace.  Vijay will also describe the release themes and some high-level features anticipated for Oracle Fusion Middleware 11.  Lastly, for customers who have PeopleSoft, JD Edwards, and Seibel Applications, he will highlight how they can leverage Fusion Middleware today.

Vijay Tella is the chief strategy officer for Oracle Corporation's middleware platform product, Oracle Application Server 10g. He is responsible for shaping the technical and strategic direction of the product, ensuring Oracle's continued leadership in the application platform suite (APS) market. Mr. Tella has more than 15 years of experience innovating and delivering market leading products in the middleware space. His expertise includes Enterprise Application Integration, Business Process Management, Business Activity Monitoring, B2B Integration, Web Services Infrastructure and Enterprise Portals. Prior to joining Oracle, Mr. Tella was senior vice-president of engineering at TIBCO Software Inc, delivering its business integration products: Active Enterprise, Active Exchange and Active Portal. Mr. Tella holds a B.Tech. degree in Computer Science from the Indian Institute of Technology and an M.S. degree in computer science from University of California, Los Angeles .

Back to Top

DBA TRACK: An Extensible Materialized View Architecture

This presentation describes an extensible architecture modeled after Oracle materialized views that has many of the features of Oracle materialized views without many of the limitations. Most notable among its features are its ability to support fast log-based refreshes of arbitrarily complex materialized views under circumstances where an equivalent Oracle materialized view would require a complete refresh. One such circumstance is the restoration of a materialized view after a media failure on either the master or materialized view database. The architecture allows us to resynchronize the materialized view with the master(s) without performing a full refresh.
 
Claudio Fratarcangeli has 20 years of experience using Oracle (since V4) in application development, software product development, and database administration. In recent years he has also been involved in Java J2EE architecture and development. He has presented at various regional and national conferences and has authored articles in various database trade magazines and academic journals.

Back to Top

DEVELOPER TRACK: Customizing a Packaged Application for a J2EE Environment: A Case Study

How does a Forms and Designer expert (relatively) adjust to life in a Java and J2EE world? The author is finding out while customizing a J2EE-compliant application to the requirements of several clients. This presentation details some of the issues to be faced in making this transition. Topics include the use of multiple technologies (including CSS, HTML, JavaScript, and ColdFusion) to customize the user interface; development and deployment using both proprietary and open source tools and servers; integrations with external systems using XML and XSLT; and the learning curve in mastering Java and JavaScript in a real-world environment.

Leslie Tierstein is a Principal Technical Architect for newScale, Inc, a Silicon Valley-based company which provides IT Portfolio Management and Service Catalog applications.  Her responsibilities have included customizing newScale’s J2EE-compliant RequestCenter product suite for client implementations and delivering and developing technical training materials on a wide range of topics, including application integration, JavaScript programming, data warehousing, and user interface customization.  Before joining newScale, Leslie had over 20 years of IT industry experience which has included leading the implementation of mission-critical applications built using Oracle database technology.  She is an award-winning speaker at conferences including NYOUG, Oracle Development Tools User Group (ODTUG), and IOUG.

Back to Top

DBA 101 TRACK: Do-It-Yourself Monitoring with OTop

The Oracle Wait Interface has become the one-stop shop for diagnosing bottlenecks in your database. However querying it directly remains somewhat laborious, and many a commercial tool just don't quite fit the bill. Enter OTop, a PERL-based monitoring and diagnostic tool based on the popular Unix top utility, and the MySQL mtop. In this presentation, attendees will learn about the OWI, how to identify some typical bottlenecks, what wait events to look out for, and how OTop can display that information for you.

Sean Hull is the founder of and senior consultant at Heavyweight Internet Group in New York. He has worked as a database consultant and expert for ten years, in the areas of Oracle and various Open Source technologies. He is the co-author of Oracle and Open Source (2001, O'Reilly & Associates) as well as various Open Source database tools, scripts, and applications. Sean has also written articles for various online and print publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

DEVELOPER 101 TRACK: Oracle 10g for Developers

Attendees will be introduced to new and improved features of Oracle10g that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or improve deployment. Attendees will be better-equipped to create applications that take full advantage of Oracle10g.

John King is a Partner in King Training Resources, a firm providing instructor-led training since 1988 across the United States and Internationally. John has worked with Oracle products and the database since Version 4. John develops and presents customized courses in a variety of topics including Oracle, DB2/UDB, SOA, Java, XML, .NET, and C++. John presents frequently at various industry conferences.

Back to Top

ORACLE FUSION TRACK: Securing Your Enterprise: Oracle Security &  Identity Management

This session will focus on how Oracle's comprehensive Identity and Access Management Suite helps organizations enhance enterprise-wide compliance, lower operational costs, and strengthen security. We’ll give a high level overview of the features and benefits of each of the components of the suite to show how both Fusion and non-Oracle applications benefit from using these best in class products.

DBA TRACK: Introduction to DBMS_METADATA

DBMS_METADATA, introduced in Oracle9i, was a breakthrough for DBAs and developers, eliminating the need to write tortuous SQL statements in an attempt to construct DDL from data dictionary contents.  This presentation reviews DBMS_METADATA's extensive capabilities, and presents a fully-developed example to illustrate how to use the package's API. Participants will learn how to use the powerful DBMS_METADATA package to extract and apply DDL programatically or save it for later use. 

Paul Baumgartel has been an Oracle DBA for over fifteen years.  He specializes in performance optimization, training, and utility development.  His consulting clients have included Oxford Health Plans, TIAA-CREF, BMG, United Parcel Service, and Credit Suisse.

Back to Top

DEVELOPER TRACK: Six Steps to Unit Testing Happiness

This presentation will discuss the overall state of software quality -- and the impact of low quality code. Steven will review high-level principles for unit testing, introduce the concept of "test-driven development", offer a simple methodology ("six simple steps") for integrating testing into development, and demonstrate that process with automated unit testing software.
 
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the most popular pages on the Oracle Technology Network, he writes regularly for Oracle Magazine, and was awarded both the Best Presentation Content/Topic and Editor's Choice Awards at the ODTUG (Oracle Development Tools User Group) 2004 conference. He can be reached at steven@stevenfeuerstein.com.

Back to Top

DBA 101 TRACK: You Probably DO Need RAC

Several years ago, Mogens Norgaard wrote a paper entitled, "You probably don't need RAC".  RAC is a powerful and exciting technology for database environments of all sizes.  In this session, Matthew will speak on the history of RAC, the challenges surrounding RAC in terms of application design and tuning, and why organizations should be moving to RAC.

Matthew Zito is an expert in large-scale infrastructures, with extensive experience in designing and deploying some of the world's largest system, network, and application architectures. Before joining GridApp, Mr. Zito worked at leading information storage company EMC and Register.com, where he designed and implemented a variety of storage infrastructures and pioneered the use of centralized management and automation to run large production application infrastructures.  Matthew Zito has worked with Linux for almost 10 years, testing, contributing, and advocating Linux as the future of the enterprise datacenter.

Back to Top

DEVELOPER 101 TRACK: An Introduction to BPEL

BPEL (Business Execution Language) is becoming the standard for connecting a set of disparate and discrete services into an end-to-end process flow. BPEL can reduce the cost and complexity of integration. The Oracle BPEL Process Manager is very easy-to-use. Oracle BPEL Process Manager is an infrastructure for creating, deploying and managing BPEL business processes. This presentation will give attendees an understanding of the Oracle BPEL tool, show how a developer might use BPEL (live demo), and what a DBA needs to be aware of.

Nicholas J. Donatone is the Vice President of Database Services for MFG Systems Corporation. He is one of the founders of the New Jersey Oracle Users Group (NJOUG) and has been president/co-president of the NJOUG for more than 16 years. He has made presentations at NJOUG, IOUG, ODTUG, VOUG and Oracle OpenWorld.

Back to Top

ORACLE FUSION TRACK: Betting Big on JavaServer Faces: Components,  Tools and Tricks

This presentation highlights all of the areas where Oracle has bet big on JSF, including illustrating the breadth and depth of the ADF Faces JSF component library, previewing our Web 2.0 AJAX components, showing support for Telnet devices and PDAs. Demos will highlight some of the additional JSF productivity features Oracle's own developer's leverage like declarative data binding, more sophisticated tables and tree controls, translatable prompts and format masks, declarative validation, declarative security, declarative method invocation and page lifecycle control, and centralized error reporting.

Steve Muench is is a consulting product manager for Oracle JDeveloper and an Oracle ACE. In his more than 16 years at Oracle, he has developed and supported Oracle tools and XML technologies and continues to evangelize them. Muench coauthored the Oracle ADF Developer’s Guide for Forms/4GL Developers (Oracle, 2006) and wrote Building Oracle XML Applications (O’Reilly Media, 2000).

Back to Top

DBA TRACK: Changing Servers with Little or No Downtime

Downtime ... a big bad word that creeps up when looking at moving an environment from one server to another. This presentation will present a tested routine to accomplish a server move with close-to-zero downtime, assuming the operating system is not changing. Using Oracle's physical standby database technology for the transfer of the database itself, this need not be a daunting task. This presentation will discuss issues such as file and crontab synchronization, backups on the new site, and the transfer of the recovery manager catalog database.

Michael S. Abbey is a regular presenter at user group and some vendor functions, having first cut his teeth with Oracle version 3 in the mid 80's. He is part owner of Ntirety LLC in Boston MA, vending Oracle and SQL Server support services to a hungry install base. He is the Events Director for the Independent Oracle Users Group, responsible for the delivery of COLLARORATE 07 in Las Vegas in April 2007.

Back to Top

DEVELOPER TRACK: "Thick Database" Approach for Web Development

The J2EE architecture is very robust and mature but is also very complex. There is a dizzying array of development alternatives which, in and of itself, can almost guarantee project failure. Even when a project succeeds, the resulting applications are often impossible to maintain by anyone other than the original architect. This presentation outlines a development methodology that results in applications that are functionally sophisticated but are architecturally very simple. They are easy to build and maintain by moderately skilled developers. The techniques demonstrated in this presentation go far beyond merely placing all of the logic into the database. Applications are architected using a standard/reusable set of APIs that call database routines.  Applications built using this methodology scale well and provide good performance.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development. He is the chief architect of Dulcian's BRIM^® tool. Paul is the co-author of seven Oracle Press books.  Paul is an Oracle Fusion Middleware Regional Director, President of NYOUG, an editor of IOUG’s SELECT Journal, founder and chairperson of the ODTUG Best Practices Symposium and the Fusion Java Development SIG. He has been IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. 

Back to Top

DBA 101 TRACK: Oracle 10g's A's: AWR, ADDM, ASM, ASH

This presentation will explain these features and their architecture as well as the benefit of these important terms for your environment and how it can be managed using SQL as well as thru EM. The presentation will provide technical details about AWR, ADDM, ASM, ASH, Advisories and other Oracle automatic features to help you learn how to utilize them in your 10g environment.

Inderpal S. Johal has been working as Database manager, Lead Database Administrator and architect for the last 10 years. He has written Oracle technical articles for Journals and magazines including Oracle Magazine. He has also spoken at Oracle OpenWorld, IOUG, UKOUG, NJOUG, NYOUG and DBA online. He has a Master's Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.

Back to Top

DEVELOPER 101 TRACK: SQL Tuning for Developers 101

This presentation will cover the techniques and generic tools available for developers to utilize when tuning SQL code during development efforts. Techniques such as proper use of bind variables, proper indexing and proper PL/SQL techniques will be discussed. Tools such as those available in SQLPLUS and from the command line will be covered as well as limited demonstrations of the techniques and tools presented.

Michael Ault has been working with Oracle for 16 years. Before Oracle, Mike worked with both Ingres and Informix databases for a total database experience level of 20 years. Mike has written over two dozen books related to Oracle monitoring and tuning and the use of Real Application Clusters. Mike is a frequent presenter at conferences and is the author of numerous white papers, articles and classes on Oracle related topics.

Back to Top

ORACLE FUSION TRACK: Intro to the Oracle Business Intelligence Platform

This presentation will focus on Oracle as an integrated Business Intelligence platform rather than a collection of tools for data warehousing, reporting, OLAP, data mining and other data exploration tools. The presentation will use a demo-like overview of the BI technology and also discuss how Siebel Analytics - Real Time Decisioning helps to extend this platform for real-t