• 2013
  • March General Meeting
• 2012
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2011
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2010
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2009
  • NYOUG 25th Anniversary/NYC Metro Area Meeting - December
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2008
  • December General Meeting
  • September General Meeting - NYC Metro Area User Group Meeting
  • June General Meeting
  • 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 2013 General Meeting

• Keynote

• DBA Track

• Development Track

Guesswork is enemy number one for any IT professional! This presentation explains why such a strong statement holds true. Can we afford guesswork while diagnosing an issue? What do we do when it seems like there is no path forward and no reasonable way to collect missing diagnostic information? In a crisis situation, how do you handle
the pressure of getting "something" done? Is it safe to take a shortcut, relying on experience rather than on scientific method? Can experience play nasty jokes on you? These are the sort of questions to be asked and hopefully answered during this presentation.

Alex Gorbachev is an Oracle ACE Director and a member of the OakTable Network. He is a sought after speaker at Oracle conferences around the world. Currently Alex is the CTO at Pythian. The search for the perfect fit between technology, engineering talents, and business is what keeps him up at night.

Back to Top

DBA TRACK:  Advanced Database Performance Analysis Using Metric Extensions and SPA

This session describes how to diagnose database performance problems using Metric Extensions (ME), a new feature of Enterprise Manager Cloud Control 12c, and SPA. ME support a rich feature set such as multiple key metrics, design and deploy lifecycle, and a robust user interface. This session will cover a real-world Oracle
internal use case where an ME querying GV$SQL_MONITOR was developed to identify problematic SQL. Once the problematic SQL has been identified, Mughees will discuss ways to tune the SQL and validate the fix using database features such as ADDM/AWR, SQL Tuning Advisor and SQL Performance Analyzer.

Mughees Minhas is responsible for all aspects of product management relating to database, systems and quality management solutions at Oracle Corporation. He has more than 17 years of experience working with Oracle products with special interests in the areas of application testing and quality, performance diagnostics and tuning,
and SQL optimization. Mughees is a frequent speaker at various Oracle forums and has authored several papers on the internal workings and usage best practices of a wide variety of Oracle technologies. Mughees holds an undergraduate degree in Electrical Engineering from Washington University and an MBA from Columbia Business
School. He is currently senior director of product management in Oracle’s Server Technologies division.

Back to Top

DBA TRACK:  Practical Hadoop by Example

This session describes several practical examples of using Hadoop in companies that have been traditional users of relational Oracle databases. Alex will discuss such areas as ETL, archival storage, and analytics.

Alex Gorbachev (see keynote presentation for bio).

Back to Top
 

DBA TRACK:  Schema Integration Techniques for Building the ODS

The goal of this presentation is to present a simple yet thorough process that solves the challenges of schema integration and provides solutions to data conflicts uncovered by the process. Angelo will demonstrate how the application of schema integration addresses these challenges. Schema integration is a theory and process pioneered by
experts in the field of data management. This presentation will explain the techniques used by two of these pioneers, M. Tamer Ozsu and Patrick Valduriez that can be applied in the design of an Operational Data Store (ODS).

Angelo R Bobak is a seasoned data architecture professional and published author with over 20 years experience in Business Intelligence, Data Architecture, Data Modeling, Master Data Management, and Data Quality. Angelo is currently working at Veyance as Foundation Manager and Senior Data Architect in the areas of Data Warehousing,
Global Master Data Management, Data Integration and Data Quality.

Back to Top
 

DEVELOPER TRACK:  Top 5 Issues that Cannot be Resolved by DBAs  (other than missed bind variables)

Common knowledge says that if there is something wrong with the database, blame DBAs. Fortunately for database administrators, about 95% of such cases have nothing to do with their job responsibility. Unfortunately, it takes a lot of time to explain this to any manager. And it takes even longer for an organization as a whole to look for real
solutions to its IT problems other than asking its DBAs to look for “run_faster=TRUE”. This presentation’s goal is to illustrate the most common “pseudo-DBA” issues and proper ways of resolving them.

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), contributing author of
Expert PL/SQL Practices (APress, 2011), and many database-related articles and conference papers. Michael is an Oracle ACE, and frequent presenter at conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG) and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received
the scholarship of the president of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev National University of Economics.

Back to Top

DEVELOPER TRACK:  Empowering Your Data Sharing Architecture for Continuous Availability

The amount of data captured and accessed by your organization is growing every day. Everyone needs the most current information from their servers for operational decision-making, billing, inventory control, purchasing, and more. This session, will demonstrate how database replication offers the most effective way to provide real-time
access to relevant data in production databases. Topics to be discussed include enabling customers to query data locally for faster access, preventing queries from affecting system performance, replicating to unlimited target systems, consolidating data to a centralized location, streamlining reporting, enabling disaster recovery, increasing
security and scalability.

Jeffrey Surretsky has been working at Dell/Quest Software for 13 years as a Database Systems Consultant where he focuses on database solutions including replication and performance monitoring/management. Before that, Jeff held various roles in the IT industry since attaining his Bachelor Degree in Computer Science in 1987. Jeffrey also
has an MBA in Information Systems.

Back to Top
 

DEVELOPER TRACK:  A Hitchhiker’s Guide to Integrating Oracle XML DB 11gR2 and SQL Developer

This session describes a project using XML with Oracle Database 11gR2 and discusses why XML DB was chosen, how XML DB was used, and the technical issues encountered. The presentation covers several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT, XMLFOREST, XQuery and dbms_xmldom. You will learn about methods, design considerations and issues using Oracle XML DB. We will provide working examples that you may use with your Oracle environment.

Coleman Leviter, OCP is employed as an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG's Collaborate and at Oracle Open World. His articles have appeared in Select Magazine, IOUG's Tips & Best Practices Booklet for Oracle professionals and ODTUG Journal. He is the NYOUG WEB SIG chairperson and was
the 2012 IOUG COLLABORATE Conference Chair. He has worked in the financial services industry and the aerospace industry where he developed Navigation, Flight Control and Reconnaissance software for the F-14D Tomcat. Coleman was recently elected to the IOUG Board of Directors. He may be contacted at cleviter@ieee.org

Back to Top
 

December 2012 General Meeting

• Keynote

• DBA Track

• DBA/Dev Track

• Development Track

• Implementation Track

Consolidating databases onto Private Clouds, utilizing Database Services in Public Clouds, deploying Engineered  instead of manually built systems and integrating Big Data into Business Intelligence applications and dashboards are top priorities for many IT organizations. Oracle Database is fundamental to the success of IT projects like these. But what can Oracle customers anticipate next? This keynote discusses the latest innovations from Oracle Database Server Technologies that can help accelerate IT projects, protect enterprise data, lower IT costs, and add value to the business.

Charles Garry has over 20 years of experience in Information Technology. He is a former Vice President and Director for META Group’s Technology Research Services. Mr. Garry’s focus has been on relational database and infrastructure design, support staffing, licensing/pricing and data management best practices. He has been a frequently requested speaker at noted database conferences such as Oracle World, IOUG, IDUG, Teradata Partners and the MySQL User Conference and was the author of a regular column for eWEEK.com. Mr. Garry was a founding member of Divine Interventures and VP of Infrastructure Strategies for Platinum Technology, and Director of Field Operations for Platinum’s data warehousing/BI division.

Back to Top

DBA TRACK:  “Exadata Demystified for Oracle DBAs”

Exadata is fast – even superfast. That is not a secret anymore. But what really makes it fast? This presentation explores the various building blocks of Exadata: Storage Indexes, Cell Offloading, Smart Scan, smart Flash and more - all the components that make the database machine faster. Attendees will learn what these concepts are, how they are used, and how they can jumpstart their transition from an Oracle DBA to a DMA.

Arup Nanda has been working as an Oracle DBA for the past 17 years. Arup trains and mentors DBAs, has coauthored 4 books, written some 300 published articles (including the most popular 11g and 10g New Features Series on the Oracle Technology Network) and given numerous presentations. He is an OCP DBA, an Oracle ACE Director and a member of the Oak Table Network. In 2003, he won the coveted Oracle DBA of the Year award. Arup blogs at arup.blogspot.com.

Back to Top

DBA TRACK:  “Edition Based Redefinition: Testing Live Application Upgrades (Without Actually Being Live)”

No matter how "agile" you believe your development environment to be, if you're using PL/SQL code and patching or upgrading frequently, you'll find that your patches and upgrades almost always incur necessary downtime. With Oracle11gR2's edition-based redefinition, re-creating a stored procedure, changing a trigger, adding or revoking a grant, and changing a view (to name a few actions) have been made easier with the ability to access more than one occurrence of such objects to stage changes in a schema in complete isolation. This helps you to see how your changes will behave in a
production environment without their being "live”. This presentation provides an introductory discussion of the editionbased redefinition feature, the edition object introduced in Oracle 11gR2, editionable and non-editionable object types, and includes example code for code patches and schema changes, as well as caveats.

Melanie Caffrey is a senior development manager for Oracle Corporation, providing front-end and back-end Oracle solutions for the business needs of various clients. She is co-author of several technical publications including Expert PL/SQL Practices for Oracle Developers and DBAs and Expert Oracle Practices: Oracle Database Administration from the Oak Table, (Apress), as well as Oracle Web Application Programming for PL/SQL Developers and The Oracle DBA Interactive Workbook, (Prentice Hall) and she writes the SQL 101 series of articles for Oracle Magazine. She instructed
students in Columbia University’s Computer Technology and Applications program in New York City, teaching advanced Oracle database administration and PL/SQL development, and she is a frequent Oracle conference speaker.

Back to Top
 

DBA TRACK:  "Hey Oracle Optimizer! Don’t Mess with MY Plans”

Unexpected execution plans due to system changes such as optimizer version and statistics, schema/metadata definitions, and system settings can have disastrous effects on database performance. Prior to 11g, you could not guarantee that a plan will change for the better. This has caused some DBAs to freeze execution plans and optimizer statistics. SQL Plan Management (SPM) is a new 11g feature that provides controlled plan evolution by not permitting the optimizer to select a plan that is slower than the one currently executing, thus ensuring stability and consistent SQL performance. This presentation will explain how to set up SQL plan baselines and use them effectively. Attendees will also learn the difference between SPM
compared to previous Oracle plan stability features such as Outlines and SQL Profiles.

Janis Griffin has over 25 years of Oracle DBA experience including design, development and implementation of many critical database applications. Before coming to Confio, Janis held DBA positions primarily in the Telecom/Network Industry, working with both real-time network routing databases and OLTP B2B applications. She was responsible for mentoring other DBAs on best practices in database performance tuning and managing all aspects of the Voice Network databases. Additionally, Janis has many years of experience implementing Oracle Applications (E-Business) as a consultant.
As a highly successful liaison between management and technical staff, Janis has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

Back to Top
 

DBA TRACK:  "Partitioning: What, When & How"

So you have heard about partitioning but don't know where to start, or you are familiar with it but want to double check your design. This session explains when to do partitioning for tables and indexes, which partitioning options to choose depending upon the problem you are trying to solve - purge, performance, archival, backup or whatever, potential issues to watch out for and so on. This presentation will *not* describe the syntax and commands for partitioning, but rather how to decide which partitioning scheme to choose. Includes Oracle 11g.

See above for Arup Nanda bio.

Back to Top
 

This presentation will cover JavaEE, Web Server, Application Server Models, as well as the core components of the Oracle WebLogic Application Server and explain its position in the Oracle Fusion Middleware Stack. Attendees will also learn how to install and configure WebLogic Server and deploy an application.

Lawrence Manickam is the President of Toyork Systems Inc, An Oracle Gold Partner. He has 12+ years of Architecture, Administration experience in all versions of WebLogic Application Server

Back to Top

DBA/DEV TRACK:  "Database Virtualization and Instant Cloning"

This presentation provides an overview of current technologies for virtualizing databases. With database virtualization and instant cloning, database copies can be made in seconds with almost no extra disk space usage. Database virtualization technology includes on-copy on-write file systems, journal file systems, point-in-time snapshots, point-in-time writeable clones, and the NFS technology stack. This technology stack will be explained and the presentation will discuss the differences in specific technologies as implemented by Oracle , Delphix, VMware, EMC, and NetApp.

Kyle Hailey is the designer of Embarcadero Technology’s DB Optimizer and a principal designer for the Oracle Enterprise Manager performance pages. He is a member of the Oracle Oak Table, co-author of Oracle Insights: Tales of the Oak Table, and was a technical editor of Oracle Wait Interface. Currently he is working with industry leading software, kernel, and filesystem designers at Delphix to take corporate data management to a new level of agility.

Back to Top
 

DBA/DEV TRACK:  "Mobile-Enable Enterprise Applications with Oracle ADF"

This session discusses and demonstrates how Oracle Application Development Framework (Oracle ADF) can easily extend Oracle Fusion Middleware and enterprise application functionality to mobile users. Whether users are accessing them from an iPhone, iPad, Android phone/tablet, or even feature phone, Oracle ADF provides a common framework to deliver browser-based as well as on-device mobile applications. Although most of the mobile platforms require extensive and expensive efforts to integrate with the enterprise platform, Oracle simply extends the enterprise platform to mobile devices through Oracle ADF, which lowers TCO and helps you deliver what really matters: compelling mobile applications for enterprise application users. This presentation explains the new ADF Mobile development fundamentals to extend Java EE enterprise applications to mobile devices and how
to leverage ADF skills to create mobile applications.

Juan Camilo Ruiz is a Principal Product Manager for Oracle Development Tools. He is a frequent speaker at Oracle user groups meetings.

Back to Top
 

DBA/DEV TRACK:  "Twelve Steps for Successful OBIEE/Applications Implementations"

This session will provide 12 tips from the field to help implement OBIEE and BI Applications, risk free. Attendees will learn about the best practices using real world customer case studies. In addition, the full tech-stack involved in Data Warehousing and how to configure and customize it will be described as well as how companies can take their BI experience to the next level by utilizing Advanced Analytics.

Shyam Varan Nath is an OBIEE Architect with IBM and has 22 years of industry experience. He is OCP as well as Certified in OBIEE / BI Applications. He is Director of Product Integration, an IOUG Board Member, and President of IOUG's BIWA and Exadata SIGs

Back to Top
 

DEVELOPER TRACK:  “Oracle Application Express 4.2 – New Features"

Application Express 4.2 is known as the "mobile release". With Oracle Application Express 4.2, APEX has evolved into a modern and productive mobile development platform. Via live demonstration, attendees will experience how easily you can optimize your own applications for mobile devices such as smart phones and tablets. With Oracle Application Express 4.2, APEX has been enhanced to be the underlying infrastructure of the Oracle Cloud Database service. This presentation will describe the new features in Application Express 4.2, driven by the development of the Oracle Cloud: RESTful Web Services, Responsive Web Design, Security and a new suite of Business Productivity Applications included with APEX 4.2.

Marc Sewtz is a Senior Software Development Manager at Oracle Corporation in New York. With over sixteen years of industry experience, Marc previously held roles in Consulting, Sales and Product Development and now manages a global Oracle Application Express (APEX) development team, part of the Oracle Database Tools group. Marc and his team are responsible for features such as the development of Mobile Web Applications with APEX, Reporting and Charting, Tabular Forms, Oracle Forms to APEX conversion and integration with Oracle Business Intelligence Publisher. Marc has a Master's degree in computer science from the University of Applied Sciences in Wedel, Germany.

Back to Top

DEVELOPER TRACK:  "The Database Emperor has no Clothes"

Transactional systems were designed for just that – transactions, namely a point in time when a purchase occurred or an event happened. Big Data is largely a result of the electronic record we now have about the activity that precedes and follows that purchase or event. This data dwarfs transactional data in terms of volume and, more importantly, it does not usually lend itself to the structure of tables and fields. This presentation will review the complex and time-consuming machinations we go through to build Data Warehouses using relational databases, and discuss Hadoop’s inherent advantages, especially where “Big Data” is involved.

David Teplow began using Oracle with version 2 in 1981, and has worked as a consultant for Database Technologies (1986-1999) and Integra Technology Consulting (2000-present). He served as president of the Northeast OUG from 1992-1999, and on the board of the IOUG from 2003-2008.

Back to Top
 

DEVELOPER TRACK:  "Responsive Web Design in Oracle Application Express with HTML5 and CSS3"

Users are no longer tied down to their PCs. They are interacting with Web applications from an increasing array of devices  and browsers, each with its own individual screen size and resolution, providing whole new challenges to Web developers. Oracle Application Express addresses these development challenges by extending its user interface themes to support different UI types, including modern HTML5 and Cascading Style Sheets 3 (CSS3)–based templates that deliver a quality experience to users regardless of screen size. This session introduces the UI-related changes in Oracle Application Express
Release 4.2 and shows how developers can incorporate modern CSS techniques and design principles such as fluid grids and media queries into their application designs.

Shakeeb Rahman is a Principal Software Developer at Oracle Corporation in Reston, Virginia. He has been a member of the Oracle Application Express (APEX) product development team for over three years and has played a key role in modernizing the look and feel of the product, including the Application Builder, Web Sheets, and Themes. Shakeeb has a keen interest in designing crisp and intuitive user interfaces that take advantage of emerging web standards (HTML5/CSS3) and applying them to several projects within Oracle, including APEX, Oracle Cloud, and Oracle Store.

See above for Marc Sewtz bio

Back to Top
 

IMPLEMENTATION TRACK:  "Alternative Approaches to Deploying Flash in the Data Center"

Database owners face constant pressure to increase application performance. Satisfying the I/O demand of application servers (with their ever-increasing core count and memory footprint) has proven challenging for legacy storage systems. New technology, such as flash storage (SSDs) and hybrid flash arrays, promise to overcome these challenges. This presentation addresses issues surrounding SSD technology and hybrid flash deployments with a focus on network-based options for high throughput applications such as databases and analytic systems.

Erik de la Iglesia is currently the chief architect at GridIron Systems, responsible for machine learning, analytics, and flash technology. He was previously a founder and chief architect of content security pioneer Reconnex (acquired by McAfee) and architect of WebStacks (acquired by Extreme Networks). With 30 patents issued, his work has spanned full and semi-custom logic design, programmable logic systems and software applications. Erik holds a BSEE from University of Florida and an MSEE from Stanford where he was an NSF Graduate Research Fellow

Back to Top

IMPLEMENTATION TRACK:  "DBAs: Take Control of the Storage Needs for your Oracle Environments"

Many database teams are trending towards managing the entire Oracle stack from the binaries down through storage. Moving away from a shared services IT model and towards a departmental team approach enables faster provisioning, reduces timeto-market, and empowers DBAs. This  presentation describes another option in owning storage that enables your Oracle team,remains an open platform, and has all of the built-in mobility, availability, continuity and recoverability that databases demand. The presentation will show how database teams can own their own storage service catalog with features like built-in web based user portal, easy administration requiring no storage skills, and select a performance level to meet their database IOPS requirements.

Sam Lucido has over 16 years experience with Oracle database (7.x – 11g) and the E-Business suite (10.6 – 12). Nine of those years were spent working at Oracle Consulting based in Chicago for the “Performance Architecture Group.” Sam now leads EMC's Oracle Solutions Enablement group in which he is the owner of the Everything Oracle at EMC Community: www.emc.com/everythingoracle.

Back to Top

IMPLEMENTATION TRACK:  "Exadata X2/X3-8: A Critical Review"

Almost every Exadata presentation is in praise of the system. While it may deserve praise, people should also be aware of the possible pitfalls. This presentation provides a look at Exadata's up and down sides. This presentation describes the pros and cons feature-by-feature. From the Exadata storage cell-only software bits to the hardware and licensing issues, this presentation covers the possible pitfalls associated with the Exadata platform.

Mike Ault has worked with Oracle since 1990. Mike has written or co-written over 25 Oracle related books. Mike is a frequent presenter at international, national and regional Oracle user meetings.

Back to Top

IMPLEMENTATION TRACK:  "Reduce Downtime During Migrations & Upgrades"

Perhaps your company has participated in a merger or acquisition and is experiencing a related data center consolidation. Or you may be considering a change in hardware platform, operating system or application upgrade. How can you reduce downtime in these situations and allow business to continue while the migration activities occur? You can minimize the downtime and risk required for upgrading your Oracle database, moving your Oracle database to a different hardware platform, or both using various methods. Although they reap long-term business benefits, migrations are a major availability
challenge that companies face today. Each method has its own trade-offs. Attendees will learn about which method is best for their organizations. Some typical migration situations include: data center and/or server consolidation, retiring older technology, platform version, and application upgrades.

Formerly a DBA, Jeffrey Surretsky has been in the IT industry for over 25 years and recently has been working at Dell Quest Software for over 12 years as a Strategic Systems Consultant where he has focused on their database solutions.

Back to Top

September 2012 General Meeting

• Keynote

• DBA Track

• Development Track

Databases keep getting bigger and bigger. Business applications that utilize these ever growing databases are expanding at an alarming rate. Businesses to stay competitive require additional functionality and technology. The Technology needed to make that additional functionality possible keeps getting more and more complex. To make matters even worse the DBAs needed to keep it all running are hard find hard to retain and good DBA skills take years to acquire. Now the role of the DBA is fundamentally changing in a way it has not changed before. In this keynote, we will review the trends in database administration, how they are affecting the DBA, and why the future of Database Administration (if it is to stay relevant) is the vDBA.

Michael Corey, founder and CEO of Ntirety, is widely recognized as a leading authority on relational databases, remote database administration and data warehousing. Michael is recognized as an Oracle Ace by Oracle and a vExpert by VMware. He is a past president of the Independent Oracle Users Group, a founder of PASS (Professional Association for SQL Server), and he currently serves on the executive committee of the Massachusetts Robert H. Goddard Council for Science, Technology, Engineering and Mathematics.

Don Sullivan has been a VMware SE Database Specialist covering North America since 2010. Don spent seven years with Oracle University teaching Oracle Server technologies and as an ATS consultant and five years with HP as part of the Polyserve acquisition. Don is an Oracle Certified Master.

Back to Top

DBA TRACK:  Reduce Your Disk Footprint by Sharing Read-Only Tablespaces

This presentation highlights the benefits of sharing read-only (RO) tablespaces among multiple non-production database copies. A thorough review of the standard, transportable tablespaces based, method for sharing RO tablespaces and a powerful, but not supported, universal method for sharing RO tablespaces is included. Implementation strategies and technological tips are discussed in detail.

Iordan Iotzov is a senior DBA at News America Marketing (NewsCorp) with more than ten years of database administration and development experience. He has an MS degree in Computer Science, holds numerous Oracle certifications, and has worked on complex database problems across various industries, providing original and effective solutions. Iordan presented at Hotsos 2012, NYOUG and BrainSurface VirtaThon, frequently participates in OTN forums and actively blogs at http://iiotzov.wordpress.com/.

Back to Top

DBA TRACK:  Virtualizing Oracle on VMware: Doing It Right

A database is very resource intensive by its very nature and one of the most resource intensive applications you will ever virtualize. If best practices are not followed, the database will never perform as needed. This presentation will teach the DBA best practices for virtualizing Oracle/MySQL/SQL Server databases on VMware. We will also discuss the business case for virtualizing a database.

See bios for keynote presentation

Back to Top
 

DBA TRACK:  RAC One-Node - Reduce costs, Replace Third-Party Cluster Services with CRS

There are several vendors providing clustering capabilities for databases. The beauty of using Oracle's RAC One-Node is that it is integrated with the Oracle stack and can help to reduce overall software costs. This gives you one vendor to handle both the clustering software and the database. Additionally, you gain the ability to upgrade to a fully RAC-enabled database at a later date with relative ease. This presentation discusses the basic Grid infrastructure required to implement RAC One-Node and how to avoid some of the pitfalls inherent in constructing a RAC environment. Additionally John will touch upon some of the utilities that can be used to manage this environment.
J
John Larkin has worked as an Oracle DBA for the last 18 years. He is currently working for a financial services company. His current project is to build the infrastructure to support the eventual migration of a Veritas-managed cluster with 140 databases from Solaris to Linux using RAC One-Node.

Back to Top
 

Back to Top

Back to Top

Back to Top

June 2012 General Meeting

• Keynote

• DBA Track

• Development Track

This presentation provides a critical review of the Exadata platform covering the strengths and weaknesses of the
Exadata system and its software. The special Exadata features are discussed including when they can and can't be
used. The Exadata is also compared to a COTS based system that is less expensive and more powerful.

Mike Ault has been working with Oracle since 1990. Mike has written or co-written over 24 books on Oracle
technology as well as dozens of articles and presentations. Mike is a frequent presenter at international, national and
regional conferences.

Back to Top

DBA TRACK:  New Enterprise Manager 12c Database Management Features

This session will focus on advanced database performance analysis techniques and describe recently introduced
features for Exadata management and monitoring. Oracle Enterprise Manager 12c has many new database
management features for the advanced DBA. Mughees will discuss new key features that help maximize database
performance, enable smart capacity planning, improve data security, and provide the basis for smart and effective
database administration.

Mughees Minhas is responsible for all aspects of product management relating to database, systems and quality
management solutions at Oracle Corporation. He has more than 17 years of experience working with Oracle
products with special interests in the areas of application testing and quality, performance diagnostics and tuning,
and SQL optimization. Mughees is a frequent speaker at various Oracle forums and has authored several papers on
the internal workings and usage best practices of a wide variety of Oracle technologies. Mughees holds an
undergraduate degree in Electrical Engineering from Washington University and an MBA from Columbia Business
School. He is currently senior director of product management in Oracle’s Server Technologies division.

Back to Top

DBA TRACK:  Validating Your I/O System: Coming Out of the Black Box

This presentation covers the techniques used to validate your I/O subsystem for IOPS, bandwidth and latency to provide a fingerprint that can then be used to check new systems for improvement or change.

Mike Ault has been working with Oracle since 1990. Mike has written or co-written over 24 books on Oracle technology as well as dozens of articles and presentations. Mike is a frequent presenter at international, national and regional conferences.

Back to Top
 

DBA TRACK:  The Essentials of Data Discovery: Do You Know Where Your Data Is?

Participants will learn why data discovery has become a recommended best practice by analysts and industry leaders to help ensure data quality and governance. They will also learn best practices to execute data discovery projects and how to evaluate solutions, whether vendor-built or internally-built, for discovery. Data Discovery is of fundamental importance to a wide range of projects, including business intelligence, data integration through master data management, data governance, and data archiving. This session explains what data discovery is, and why it has become such an important technology for organizations implementing enterprise data governance and data management strategies. Dhan will review the requirements for data discovery software and how data discovery technology should fit within the suite of tools needed to govern and manage data across your enterprise, regardless of where it is located.

Dhan Patel is a Sr. TPM within IBM's Software Group, specializing in data management for Oracle applications. He has spoken at numerous Oracle, OAUG, Quest International and IOUG events including Oracle OpenWorld, Collaborate and others. He has over a decade of experience in working with Oracle users to help optimize the management of their data.

Back to Top
 

DBA TRACK:  Under the Hood of Oracle ASM: Fallibility Analysis

Oracle Automatic Storage Management (ASM) has introduced a new concept of mirroring that is implemented differently than in any known RAID levels. So what happens when not one but two or more disks fail? Is such situation a hypothetical and highly unlikely? This session will help attendees to evaluate the data loss risks and adopt the best ASM configuration according to their risk profile. For a better understanding of ASM reliability features, Alex will peek under the hood of ASM and provide live demos simulating ASM disk failures and ASM handling of such failures.

Alex Gorbachev is an Oracle ACE Director and member of OakTable Network. Alex is sought after speaker at the user conferences around the world. Currently Alex is the CTO at Pythian and the search for the perfect fit between technology, engineering talents and business is what keeps him up at night.

Back to Top
 

Dynamic SQL is one of the most critical tools in the developer’s toolbox. It empowers well-written systems to
rapidly realign with the real world. In addition to the core elements required to properly utilize Dynamic SQL, this
presentation focuses on effective and appropriate usage of all 11g additions to the PL/SQL language (in conjunction
with other advanced features such as object types, collections, large objects etc). Real-life examples are used as
illustrations for all key points.

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system
tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and
researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006), contributing author of
Expert PL/SQL Practices (APress, 2011), and author of a number of database-related articles (IOUG Select Journal,
ODTUG Tech Journal) and conference papers. Michael is an Oracle ACE, a frequent presenter at various Oracle
user group conferences (Oracle OpenWorld, ODTUG, IOUG Collaborate, RMOUG, NYOUG, etc), and winner of
the ODTUG Kaleidoscope 2009 Best Speaker Award. In his native Ukraine, he received the scholarship of the
president of Ukraine, a Master of Science degree in Information Systems, and a diploma with honors from the Kiev
National University of Economics.

Back to Top

Data profiling tools are expensive and provide little value beyond what you could be written in a day. ETL tools are complex, VERY expensive and built to support extremely complex migration environments. Data migration is the hidden nightmare of a project. Incorrectly managed, data migration can consume more resources than development. This presentation provides a roadmap for data migration, from data profiling to final loading and incremental data updates. Several projects that had to move hundreds GBs of information will be discussed. A simple mapping repository that was used to generate 100% of all mapping code will also be demonstrated.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle Ace, past IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year.

Back to Top

Learn how to build an enticing data dashboard rich in features utilizing Oracle ADF Data Visualization Components. Spice up your applications with graphs, maps, gauges and more to help your customer understand the data in their database. See how you can get from data in the database to a full blown Web-based dashboard in less than 45 minutes of development in this live development demo-driven session. See how Oracle ADF Faces helps you create astonishing UIs with visual and declarative development.

Juan Camilo Ruiz is Principal Product Manager in the Oracle Development Tools organization for JDeveloper/ADF. Mr Ruiz specializes in rich internet applications development, Oracle ADF and integration of Oracle ADF with the rest of the Fusion Middleware stack. Mr Ruiz is frequent Oracle speaker at user group events, Oracle events, and IT conferences. He joined Oracle in 2006 working as a solutions architect for Oracle Partners and SI in Latin America. He graduated from Universidad Javeriana in Bogota, Colombia.

Back to Top

March 2012 General Meeting

• Keynote

• DBA Track

• Development Track

This presentation will provide a glimpse into the only NYC High School offering Oracle Academy class work. Students have the opportunity to complete their OCA in PL/SQL during their last two years of the program. Andrew will describe the Career Academy movement, projects that the students are working on, and the current Oracle Academy offerings. Finally an interactive discussion will identify which database skills are critical for success in business, and developing ideas for authentic classroom experiences.

Andrew Woodbridge has been teaching in the Academy of Information Technology at Grover Cleveland High school in Ridgewood, Queens for the past eight years. This is his fifth year as an Oracle Academy Instructor. Andrew is a leader in project based learning and instructional technology in the classroom. His recent research on Integrating Culture in to STEM appeared in ACMs: Transaction on Computing Education.

Back to Top

DBA TRACK:  Exadata Demystified

Exadata is super fast; but what is the science behind the speed? In this session, attendees will learn exactly what is different from a traditional Oracle database that adds to the performance gains. This presentation will also discuss the components of the rack that need management from teams with different skills what new information is needed for a DBA to become a Database Machine Administrator. All concepts will be presented using the backdrop of the author's real world experiences in implementing and maintaining Exadata systems.

Arup Nanda is the principal global database architect at Starwood Hotels supervising database architecture, strategy and deployments all over the world. He is a frequent speaker having delivered about 200 sessions all over the world, written about 300 articles, coauthored four books, teaches advanced technical courses and blogs aarup.blogspot.com. In 2003, he was named Oracle's DBA of the Year. He is an Oracle ACE Director and a member of the Oak Table Network.

Back to Top

DBA TRACK:  The SQLTXPLAIN Utility – Everything You Wanted To Know About Your Query

The SQLTXPLAIN utility was introduced in Oracle 10gR2 as a supplement to the Oracle Tuning Pack. The SQLTXPLAIN utility is separately downloaded and installed into the target database and invoked while SQL "of interest" is running. The utility performs a comprehensive analysis of the running statement (or set of statements) and everything related to them, from execution plans evaluated, to initialization parameters, to intimate detail of tables and indexes involved in the query. The results of this analysis are output in a nicely formatted HTML report. This presentation describes a real world sample of this report and how it is useful. In particular, the recommendations section of the report and how to implement the recommendations for all users or selected users through the use of SQL profiles is discussed.

Kevin Gilpin is an Oracle 10g OCP Certified DBA. Kevin has been a DBA for 16 years and has been working for TUSC for the last 11 years.

Back to Top
 

DBA TRACK:  SQL Tuning

This presentation gives a detailed view of SQL tuning including SQL Profiles, SQL Plan Baselines, Outlines, Statistics, manual tuning, and common pitfalls. The goal of the session is to demonstrate new and proven techniques. Also, the session accounts for new features so that a SQL statement can be quickly and properly tuned. The presentation uses practical logic rather than an analytical approach in quickly narrowing down problems – which renders better results that are quicker to implement and easier to master.

Frank Bommarito is Co-Founder and Chief Services Officer for DBAK and is widely recognized as a thought leader and expert in designing, delivering, tuning, and troubleshooting advanced technology, large-scale, highly complex systems using Oracle technology. With more than twenty-five years of Oracle-based experience covering the Oracle Database, Oracle Applications, Oracle Application Server, and Oracle’s development tools, Frank has a broad-based and comprehensive view of Oracle products and technologies. Frank is a frequent speaker at industry conferences and holds a Bachelor of Science degree in computer information systems from Ferris State University.

Back to Top
 

This presentation discusses how the MySQL database and associated tools work alongside and in a typical 11g environment.

Philip Antoniades has worked with MySQL since 1999, and joined MySQL AB in 2003 as their first Consultant and Sales Engineer. He currently heads the WW Sales Consulting team for MySQL within Oracle.

Back to Top

This presentation outlines the use of 11g ADF Faces, ADF Business Components and JDeveloper as a target platform for conversions from Oracle Forms and some of the patterns that can be adopted in performing such a modernization. ADF 11g was built with Form Developers in mind and can accommodate the functionality in forms but often in a slightly different way. Robert will examine some of the more common patterns in Forms and what some best practice approaches are with ADF 11g.

Robert Nocera is the CTO and co-founder of NEOS and Vgo Software. He is tasked with driving technology direction for the companies modernization solutions, but has also developed a key, focused, understanding of Oracle Fusion Middleware and ADF v11 in particular. Robert is deeply skilled in all Java related technologies/languages. He has over twenty years of IT experience and is the author of the www.java-hair.com blog.

Back to Top

Normally, connecting database data to the user interface of a web application requires some work. Oracle Application Development Framework (ADF) provides a feature called ADF Bindings that you can use to accomplish this task. ADF Bindings is part of the ADF Model layer, which is recognized as the most innovative and remarkable technology in the ADF stack. This presentation briefly reviews where ADF Model (ADFm) fits in ADF development and how one of its components, ADF Bindings, allows you to quickly connect components from a user interface library such as ADF Faces Rich Client to business services such as ADF Business Components. The presentation provides details and shows examples of how ADF bindings work; how to automatically bind data elements to visual elements; what types of bindings are available; and where binding code appears. It also explains the basics of the expression language used to bind Model layer components to View layer components.

Peter Koletzke is a technical director and principal instructor for Quovera, in Mountain View, California, and has over 27 years of industry experience. Peter has presented at various Oracle users group conferences more than 300 times and has won over a dozen Oracle user-group awards including NYOUG Editor's Choice (three times). He is an Oracle Certified Master and Oracle ACE Director as well as co-author of eight Oracle Press books about Oracle development tools.

Back to Top

This presentation demonstrates how APEX can be used to significantly reduce the overall cost of application development, improve time to market and maximize existing investment in Oracle technologies and skills within your organization. We will review the overall technology architecture of APEX and provide a comparison with other development technologies.

Kashyap Shukla is Principal Consultant at Mauli Systems, Inc., providing independent Oracle and Microsoft consulting services in the north-east region. He is an Oracle Certified Professional with 30 years of IT experience as a data architect, systems architect, developer and DBA. He has a successful track record with architecting and implementing large scale, complex solutions for numerous global fortune 500 companies spanning Data Warehousing, BI, custom and 3rd party System Integration, software development, system conversion and upgrade projects. In addition, he is author of commercial software products, including the registered Copyright Software “MSI Data Certification System”. He can be contacted by email at kashyap_shukla@mauli.com.

Back to Top

December 2011 General Meeting

• Keynote

• DBA Track

• Development Track

• Implementation Track

The term "big data" draws a lot of attention, but behind the hype there's a simple story. For decades, companies have been making business decisions based on transactional data stored in relational databases. However, beyond that critical data is a potential treasure trove of less structured data: weblogs, social media, email, sensors, and photographs that can be mined for useful information. This presentation will take a look at what Big Data is and means - and Oracle's strategy for handling it.

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Tom is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). He is also the author of Expert Oracle Database Architecture (Apress, 2005/2009), Expert One on One Oracle (Wrox Press, 2001/Apress 2004), Beginning Oracle Programming (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

Back to Top

DBA TRACK:  “Oracle Wait Event Tuning Using AWR”

Attendees will learn how to review AWR and statspack reports to determine what portion of the database needs further tuning based on wait events. This presentation coalesces nearly 20 years of statspack and AWR analysis experience into a how-to guide for wait analysis using AWR reports.

Mike Ault has worked with Oracle since 1990 and is the author or co-author of over 24 Oracle-related books. Mike is a frequent presenter at Oracle conferences worldwide. Mike is the Oracle Guru for Texas Memory Systems, manufacturers of solid-state devices for enterprise level storage.

Back to Top

This presentation provides a high-level overview of virtualization technologies and methodologies to discuss the options available for virtualizing Oracle databases and/or applications using Oracle databases. The advantages and disadvantages of different approaches, namely hosting the virtual machines in the public cloud or in-house, setting up templates, and configuring access will be discussed.

Leslie Tierstein is an independent consultant specializing in service catalog management for enterprise IT organizations. She was recently employed by Cisco Systems in their Intelligent Automation Business Unit, responsible for providing training for the Cisco Cloud Portal product suite. She has extensive experience in implementing custom Oracle software applications, and has presented at NYOUG, ODTUG, IOUG and other Oracle conferences.

Back to Top

Data profiling tools are expensive and provide little value beyond what could be written in a day. ETL tools are complex, VERY expensive and built to support extremely complex migration environments. Data migration is the hidden nightmare of a project. Incorrectly managed, data migration can consume more resources than development. This presentation provides a roadmap for data migration, from data profiling to final loading, and incremental data updates. Several projects that had to move hundreds of GBs of information will be discussed. A simple mapping repository that was used to generate 100% of all mapping code will also be demonstrated.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul has co-authored seven Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle Ace, past IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge, and Oracle selected him as the 2007 PL/SQL Developer of the Year.

Back to Top

This presentation reviews the step-by-step process of our experience with SQL performance issues after upgrading to Oracle Database 11g. It explains the various steps that can be taken to mitigate the risk of encountering SQL performance issues after the upgrade and how we addressed it. This will not only be helpful for those who are planning to do an 11g upgrade, but also for DBAs to identify the problems in non-prod and how quickly one can address the SQL performance issues between prod and non-prod.

Sridhar Doraikannu is an Oracle certified DBA with more than 20 years of IT experience including fifteen years of experience as an Oracle Database Administrator. He has a Bachelor of Science degree in Mathematics from the University of Madras, India and a Graduate Certificate in Project Management, MS and MBA degrees in Information Systems from the Stevens Institute of Technology. He has presented at Oracle OpenWorld and NYOUG.

Back to Top

PL/SQL turns 23 years old this year—it was first introduced in 1988 with the Oracle6 Database. This session looks at five technical things about PL/SQL you probably did not know: under-the-covers features that make PL/SQL quite simply the most efficient language with which to process data in the database.

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. (see full bio above)

Back to Top

In this session, two Oracle security professionals will explain how to centralize all of your database users in a directory, and then configure the Oracle database to accept authentication and authorization from that central directory. In this way, your administrative burden will be greatly reduced, your users will have many fewer user IDs and passwords to remember, the security in your Oracle database environment will be enhanced, and you will more easily meet your regulatory compliance requirements. User authentication methods discussed will include User ID/password, Kerberos, and more.

Paul Sullivan has been an information security professional for more than 10 years, and is a part of Oracle's East Coast Enterprise Security team. Paul joined Oracle with the acquisition of Sun Microsystems.
Kevin Moulton has been an information security professional for more than 25 years, and manages Oracle's East Coast Enterprise Security Team. Kevin has been with Oracle for 6 years.

Back to Top

Some database consolidations targeted for an Exadata machine can be quite complex and need careful planning to mitigate perceived (and real) project risks in order to satisfy the client's expectations and Exadata's promise. Attendees will learn about best practices to consider when consolidating into an Exadata environment including understanding Smart Scan readiness, presence of database hints, presence of database errors, presence of unruly queries, and the presence of unused data. This presentation examines several important deployment considerations through the lens of real-world customer experiences.

Kevin Courtney brings over twenty-five years of senior and executive information technology experience blending a set of consulting skills in business management, technology strategy, design and deployment, program and project management, product development and marketing across numerous industries He has developed and managed a data warehousing/business intelligence professional services practice.

Back to Top

Most DBAs want to do what they’re good at and enjoy: manage databases. However, securing the sensitive information that is stored in Oracle databases has become critical in our highly regulated world. Properly managing the keys that protect data that is encrypted in Oracle databases has become a big issue. In addition, DBAs need to consider sensitive data surrounding the Oracle database. For example, an Oracle database could encounter an error that would cause it to send information containing sensitive data into a trace file or the alert log. This presentation will discuss the general issues in encryption key management for DBAs and where sensitive data might reside in and around an Oracle database.

Jonathan Intner is an Oracle DBA by trade who started studying data and information security about 5 years ago. Over the past 20 years, he has been an Oracle DBA and *nix SA at a number of companies, mostly in the pharmaceutical arena. He currently works as a Solution Architect for Vormetric, a company that produces a comprehensive data security solution to protect customer data across applications, databases, file systems and storage architectures to defend against a broad set of threats to data, including admin abuse, rogue users, malware, physical theft and unintended user access.

Back to Top

This session provides an overview of the Oracle Database Cloud Service, which was introduced at Oracle Open World 2011 as part of Oracle’s Public Cloud. Attendees will learn about the architecture and features of this service, see some of the included business productivity applications, and get a demonstration of how to develop, test, and deploy Oracle Application Express applications and RESTful Web Services on the Oracle Public Cloud.

Marc Sewtz is a Senior Software Development Manager for Oracle Application Express (APEX) in the Database Tools Group. Marc has 16 years of industry experience, including roles in Consulting, Sales, and Product Development. Marc joined Oracle in 1998, works in New York City and manages a global team of APEX developers and product managers. Marc and his team are responsible for product features such as mobile development, user interface, Oracle Forms conversion, reporting, tabular forms, PDF printing and the integration with BI Publisher. Marc has a Master's Degree in Computer Science from the University of Applied Sciences in Wedel, Germany.

Back to Top

Application Development Framework Faces Rich Client (ADF Faces RC) components available in JDeveloper 11g offer a wide variety of choices for placing elements on the page using layout components. It also provides properties that allow developers to set properties to declare rather than writing lines of code to create the final layout. This presentation discusses those topics as well as providing tips such as changing the tab order and features like the embedded support for visual editing, including some little known utilities like the Design This Container. The session ends with some advice about how to approach creation of a specific layout including using resources such as cheat sheets, component guides, and component documentation.

Peter Koletzke is a technical director and principal instructor for Quovera, in Mountain View, California, and has over 27 years of industry experience. Peter has presented at various Oracle users group conferences more than 290 times and has won over a dozen Oracle user-group awards including NYOUG Editor's Choice (three times). He is an Oracle Certified Master and Oracle ACE Director as well as co-author of eight Oracle Press books about Oracle development tools.

Back to Top

Application Express introduced the ability to "plug-in" functionality to your applications if what you need is not provided by default. Plug-ins can be anything from a slider widget, to a star rating system, to just about anything. Why limit yourself to what the builder provides when you can expand by just "plugging-in?" This presentation shows how to take non-standard functionality and plug it into Application Express. This ability helps expand the capabilities of applications and make them more professional looking and easier for end users to perform their duties. In addition, Josh will discuss the basic steps of how to create plug-ins if the need ever arises.

Josh Millinger graduated in 1995 from the University of Wisconsin with a BS in Computer Science before joining Oracle Corporation for an 11-year stint. After Oracle he formed Niantic Systems, a leading provider of APEX solutions. He currently resides in Princeton, NJ.

Back to Top

Real Application Testing (RAT) with Database Replay and SQL Performance Analyzer provides the ability to be more proactive in ensuring that application, database, operating system, hardware, etc. changes and upgrades never negatively impact database and system operations again. This presentation will review the features and use of real application testing with test cases.

An Oracle ACE, Database OCP 9i/11g and Exadata Implementation Specialist, Michael Messina has over 18 years experience with Oracle Technology including in-depth background in Performance Tuning, High Availability and Disaster Recovery implementations. Michael has presented at Oracle Open World, Collaborate, Rocky Mountain Oracle Users Group Training Days, Midwest Oracle Users Group and Indiana Oracle Users Group.

Back to Top

IMPLEMENTATION TRACK:  "Exadata: Yes, You Still Need to Do Performance Tuning"

When you purchase Exadata, the common thought is that once it is in place, all performance problems are fixed. While Exadata can speed up many queries in the beginning, this does not mean that the query runs faster due to well written code. In these cases, as you get more data there is the potential for these queries to degrade in performance, at times, exponentially. In other cases, there are queries that aren't sped up when you move to Exadata and can even be slowed down. This presentation explores Exadata-related wait events and views along with common tips to quickly troubleshoot performance issues

Kathy Gibbs has over 18 years of IT work experience and over 12 years of DBA experience including architecting, design, development, implementation, monitoring, and disaster recovery of databases. Before starting with Confio, Kathy worked in the financial, retail, and telecom industries working with critical OLTP and OLAP databases. Kathy operates as a liaison between technical and the end-users or management teams to provide solutions.

Back to Top

The Oracle Database Appliance offers a unique pay-as-you-grow software licensing model to quickly scale from 2 to 24 processor cores without incurring the costs and downtime usually associated with hardware upgrades. In this introduction to the Oracle Database Appliance, Abdul will explore the key features and benefits, including Rapid Installation and patching process, ability to enable CPU cores as needed for a unique pay-as-you-grow licensing, triple redundant high performance storage, 12TB Raw and 4TB Usable, highly available dual node cluster based on a 11gR2 RAC database cluster, single 4U Enclosure requiring no integration of components, and single vendor support for hardware and software.

Abdul Sheikh, CTO and Partner, co-founded Cintra Software and Services in 1996, an Oracle Platinum Partner. Abdul is the technical force behind Cintra. By combining his deep knowledge in information systems technologies with his well-cultivated business sense, Abdul has co-piloted the growth of Cintra in the US and the UK since 1996.

Back to Top

This session presents actual IT case studies and reference architectures for integrating Solid State Disk (SSD) into existing storage infrastructures to boost performance and enable virtualization, especially in big data environments where data volumes are growing rapidly, and applications and users are demanding high-speed concurrent access. Attendees will see how large Oracle environments can be more strategic in their deployment of SSD and reap 10-fold performance acceleration without the need to reconfigure or move applications or data, without forklift hardware upgrades, and without changing data protection policies.

Erik de la Iglesia is currently the chief architect at Gridiron systems responsible for machine learning, analytics, and flash technology. He was previously a founder and chief architect of content security pioneer Reconnex (McAfee) and architect of WebStacks (Extreme Networks). With 23 patents issued and over 2 dozen in process, his work has spanned full and semi-custom logic design, programmable logic systems, and software applications. Erik holds a BSEE with Highest Honors from University of Florida and MSEE from Stanford where he was an NSF Graduate Research Fellow.

Back to Top

This session will describe the viability and value of running Oracle RAC on vSphere 5. The presentation will also include content focused on the skills necessary for a DBA to develop to remain current with Oracle and virtualization technology. It will include best practices and a step-by-step guide for virtualizing infrastructure for Oracle 11gr2 RAC on the VMware vSphere platform. Storage and networking design options will be discussed. Attendees will find out about lessons learned, recipes for success and common mistakes to avoid when virtualizing RAC databases. Attendees will also learn how to live migrate Oracle RAC nodes from one physical host a different host within the ESX cluster when under load, with minimal impact to the users.

Don Sullivan has been a VMware SE Database Specialist covering North America for the past year and a half. Don spent seven years with Oracle University teaching Oracle Server technologies and ATS consultant and five years with HP as part of the Polyserve acquisition. Don is an Oracle Certified Master.

Back to Top

September 2011 General Meeting

• Keynote

• DBA Track

• Development Track

Creating high-performance as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable. This paper describes those principles, linking them together in a coherent journey covering the goals, the terms, the
tools, and the decisions that you need to maximize your application’s chance of having a long, productive, high performance life. Examples in this paper touch upon Oracle experiences, but the scope of the paper is not restricted to Oracle products.

Cary Millsap is an entrepreneur, software technology advisor, software developer, and Oracle software performance specialist. His technical papers are quoted in many Oracle books, in Wikipedia, in blogs all over the world, and in dozens of conference presentations each month. His blog is read by thousands of people each month. He has presented at hundreds of public and private events around the world. He wrote the book "Optimizing Oracle
Performance" (O'Reilly 2003), for which he and co-author Jeff Holt were named Oracle Magazine's 2004 Authors of the Year.

Back to Top

DBA TRACK:  Solaris Performance Diagnostics for Oracle DBAs

DBAs are taught how to look at database performance - timed events, and other performance metrics. Not much is available regarding server performance and capacity. This presentation looks at some of the available tools that come with a Solaris system (and a couple that are freely available but not included) that can be used to examine the health of the server and what the server is doing. Tools discussed will show data for the major subsystems – CPU, memory, disk, and network. Dallas will also cover at sar, vmstat, iostat, top, prstat, netstat, uptime, and truss and provide examples of their use, sample output, and things to be aware of when using them.

Dallas Deeds has been working in IT for 16 years, with Oracle databases for 14 years, and as a DBA for 12 years. Since 2001, his primary focus has been on database, server, and application performance.

Back to Top

In our increasingly virtualized environments, it's ever more difficult to diagnose application defects—especially performance defects that affect response time or throughput expectations. Runtime diagnosis of defects can be an unbearably complicated problem to solve once the application is sealed up and put into production use. But having excellent runtime diagnostics is surprisingly easy if you design the diagnostic features into the application from its inception, as it is being grown, like you would with any other desired application feature.

Cary Millsap is an entrepreneur, software technology advisor, software developer, and Oracle software performance specialist. His technical papers are quoted in many Oracle books, in Wikipedia, in blogs all over the world, and in dozens of conference presentations each month. His blog is read by thousands of people each month. He has presented at hundreds of public and private events around the world. He wrote the book "Optimizing Oracle Performance" (O'Reilly 2003), for which he and co-author Jeff Holt were named Oracle Magazine's 2004 Authors of the Year

Back to Top

This presentation reviews the state of database security to help attendees understand the causes of this alarming trend. It also explores some common attack scenarios and describes how a new category of security solution, Database Activity Monitoring (DAM), can address many of these scenarios and provide additional protection for sensitive data assets.

Dhan Patel has spoken at numerous industry events including SIM CIO Forums, Oracle OpenWorld and Collaborate. He is a frequent speaker at Oracle User events and conferences, specializing in Information Governance, Data Privacy and Security and Information Lifecycle Management.

Back to Top

This presentation will review the steps for upgrading from 10gR2 to 11gR2 (clustered and non-clustered environments). Topics covered include how to plan for a upgrade, how to build test and staging environments, and how to upgrade your production infrastructure without any impact to your business users. At Liquidnet, we were able to successfully upgrade multiple RAC Clusters and standalone servers to 11GR2 without opening any Severity 1 Service Requests with Oracle. The presentation will also briefly cover ASM, Grid Control.

Moncy Varghes is an Infrastructure Engineer/DBA at Liquidnet, responsible for the long-term strategy and roadmap for database technologies. He has worked as an Oracle DBA for the past 13 years.

Back to Top

"Throw more hardware at the project to keep up the speed" is a phrase heard all too often among IT professionals. Sometimes, additional hardware doesn't solve performance problems. When dealing with computer systems, XML documents are an effective method to communicate real time information between two or more computers. However, XML documents may become exceedingly large, thereby ―clogging up the pipe‖ using both excessive bandwidth and computing resources in an attempt to move the XML document from point A to point B. This presentation focuses on two techniques using Oracle's XML DB and PL/SQL to demonstrate how to break up large XML documents into smaller ones, thus minimizing system resources and bandwidth during data transfer.

Coleman Leviter has presented at IOUG's Collaborate '07 - '11, at Oracle Open World 10 and the upcoming Oracle OpenWorld 11. He was the IOUG Collaborate 2011 Conference Co-Chair and is the NYOUG WEB SIG chair. His articles have been published in the IOUG Select Journal and ODTUG Journal.

Back to Top

This presentation will describe various techniques used to manipulate large amounts of data without generating excessive redo and or archive logs. Methods for scheduling reports to be automatically e-mailed to pick listed users will also be discussed. The presentation includes the form and function of a PL/SQL template with diverse enhancement options to generate and distribute reports via Microsoft Outlook e-mails.

Laurence Jennings is a DBA/Developer at the NYC Board of Education Retirement System. His experience with Oracle spans Versions 7.3.4 thru 11g.

Back to Top

Oracle Application Express integrates the jQuery Mobile framework to support building mobile web applications. This presentation describes the basic of jQuery Mobile, how it is integrated with Oracle Application Express, and how users can quickly build mobile web applications, or extend their existing Oracle Application Express applications with mobile capabilities.

Marc Sewtz is a software development manager for Oracle Application Express (APEX) in the Database Tools Group, part of Oracle Server Technologies. Marc has 15 years of industry experience, including roles in consulting, sales, and development and joined Oracle in 1998. Marc manages a global team of APEX developers and product managers and is responsible for product features such as Mobile Development, Oracle Forms to APEX conversion, the APEX reporting engine, tabular forms, PDF printing and the integration with Oracle BI Publisher. Marc has a master's degree in computer science from the University of Applied Sciences in Wedel, Germany

Back to Top

This presentation covers a case study that leverages the Oracle suggested backup strategy in RMAN to relocate a 10TB RAC database on ASM to a distant location with minimum downtime. Other techniques on Data Guard Switchover and long-distance storage mirror will also be discussed.

Tao Zuo is a Senior Production DBA, who has experience with Oracle databases from 7.3 to 11g, including Hybrid RAC database of 30+ Terabyte in size. Tao is an Oracle Certified Professional with a Master's Degree in Computer Science.

Back to Top

June 2011 General Meeting

• Keynote

• DBA Track

• Development Track

If you look at 10 modern systems you are likely to see 10 different architectures. Oracle is promoting the JavaEE based ADF, many users are moving to Oracle’s Application Express and the rest of us are still running on Oracle Forms and wishing there was an easy alternative. Outside of Oracle everyone seems to be touting SOA and Open Source. Where does the cloud fit in? Given the fragmented world we live in with no single architecture emerging as an industry standard, how do you decide on a good development platform? Given the ever evolving environments, how do you avoid building a system that is obsolete before it is even built? This presentation will attempt to answer some of these questions.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle ACE Director, SELECT Associate Editor, ODTUG Symposium chairperson, past IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year. Paul can be contacted at paul_dorsey@dulcian.com

Michael Olin is president of Systematic Solutions, Inc. an independent Oracle consulting firm that he founded in 1987. For over 25 years, Michael has been designing and developing Oracle-based systems for firms in a variety of industries including: Pharmaceuticals, Health Care, Entertainment, Direct Marketing, Banking, Insurance and Financial Services. He is currently the president of the New York Oracle Users Group, having previously served as membership coordinator and vice president during his over two decades with NYOUG. Michael has presented at both local and national conferences, chaired the developer tools symposium at the East Coast Oracle conference from 1993-2000 and served as a technical reviewer for books published by Oracle Press and O’Reilly. Michael can be reached at molin@systematic-solutions.com

Back to Top

DBA TRACK:  NFS Tuning for Oracle: Introducing Dtrace

NFS speeds are already on par with fiber channel and could pass up fiber channel by 2012. NFS is easier and cheaper to install, configure and maintain than fiber channel and includes robust error handling such as checksumming and retransmissions. On the other hand NFS has a reputation as being slow. This presentation explains how NFS can be optimally configured and how to analyze for NFS bottlenecks. NFS bottlenecks can be hard to identify using standard tools, but armed with the ultra powerful analysis tool Dtrace on Solaris, we can get a surprisingly rich picture NFS communication.

Kyle Hailey is the man behind the complete redesign of the Oracle Enterprise Manager 10g performance pages. His contributions shifted the screens to be graphically oriented and wait interface centric. Kyle currently works at Delphix as the performance Architect. He was also the designer of DB Optimizer, the first product in the industry to graphically describe the relationships of tables, views and subqueries of a SQL statement using Visual SQL Tuning (VST) diagrams. He has long and distinguished career with Oracle having worked at Oracle in support, porting, benchmarking, and kernel development. He has also worked at Quest, Embarcadero as well as other companies in the industry on performance tuning and optimization of Oracle. He has designed tools to improve high end performance monitoring such as direct SGA attach and interactive graphic displays of performance data. He has speaks at Hotsos, NoCOUG, RMOUG, NYCOUG, Oracle World, DB Forum as well as teaches classes around the world on Oracle performance tuning.

Back to Top

This presentation will be a review of ADDM, ASH, and AWR in 11g. Some DBAs used it in 10g. Some did not, and have not yet used it in 11g. It has been improved in 11g, but the basic concepts remain the same. Earl will discuss ADDM - the AI-base framework of the system, its collection of info, and the application of knowledge-based systems to that info to produce important data for the DBA. The two other systems, AWR and ASH, use this framework, and their own programming, to help the DBA analyze the database with a right-now focus or a longer-term focus.

Earl Shaffer has been using Oracle products since 1988 with V5.1. Earl has been a developer, project leader, and is now a senior DBA. He has a BS and MS in Computer Science and has worked in IT for almost 30 years.

Back to Top

This presentation covers our vast experience in migrating RAC production servers from 10g to 11gr2. The main topics discussed during this session will be cluster upgrade issues and the resulting performance issues after the upgrade. Our experience of upgrading multiple RAC servers and the pitfalls and the SRs opened to solve the issues will be discussed. Sridhar will also share his experiences opening PUMA with Oracle support and how it helped

Sridhar Doraikannu is an Oracle certified DBA with more than 20 years of IT experience including fifteen years of experience as an Oracle Database Administrator. He has a Bachelor of Science degree in Mathematics from the University of Madras, India and a Graduate Certificate in Project Management, MS and MBA degrees in Information Systems from the Stevens Institute of Technology. He has presented at Oracle OpenWorld and NYOUG.

Back to Top

ApEx can create highly productive applications right out of the box. However, at times a developer needs to make the application a bit more "dynamic." In this presentation, developers will learn the ins and out of using Dynamic SQL in their applications, in addition to using a new 4.0 feature called Dynamic Actions. Both of these technologies help bring applications to the next level and create a better user experience. Josh will describe the features and provide a demonstration showing examples of how to use them.

Josh Millinger was an 11 year veteran at Oracle Corporation before leaving to form Niantic Systems with Raj Mattamal. He has worked extensively with companies across verticals to help them better achieve their goals using Oracle Application Express. He presents on ApEx at various conferences nationwide.

Back to Top

With the rising cost of data security breaches and their increasing frequency, companies are starting to reevaluate how they protect their data. External and internal breaches have highlighted the need for companies to understand the flow of data within the enterprise and the need to take a more granular approach in terms of how it is secured. This session will discuss recent breaches and review different options for data protection strategies in a cloud and outsourced environment.

Ulf Mattsson created the innovative architecture of the Protegrity database security technology. Prior to starting Protegrity, he worked 20 years at IBM in software development as a consulting resource to IBM's Research organization, specializing in the areas of IT Architecture and IT Security. He is the inventor of more than 20 patents in the areas of Encryption Key Management, Policy Driven Data Encryption, Internal Threat Protection, Data Usage Control and Intrusion Prevention. He is a research member of the International Federation for Information Processing (IFIP) WG 11.3 Data and Application Security.

Back to Top

In 11gR2, Oracle introduced a new way of working with hierarchical data structures called “Recursive Subquery Factoring.” This presentation compares this method to the existing CONNECT-BY implementation with regard to both performance and functionality. In addition, best practices are discussed, including whether or not hierarchical models should be implemented at all. Real-life examples are used to pinpoint key ideas and solutions.

Dr. Paul Dorsey (see keynote bio)

Michael Rosenblum is a Software Architect/Development DBA at Dulcian, Inc. where he is responsible for system tuning and application architecture. Michael supports Dulcian developers by writing complex PL/SQL routines and researching new features. He is the co-author of PL/SQL for Dummies (Wiley Press, 2006) and author of a number of database-related articles (IOUG Select Journal, ODTUG Tech Journal) and conference papers. Michael is a frequent presenter at various regional and national Oracle user group conferences and winner of the ODTUG Kaleidoscope 2009 Best Speaker Award. 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 2011 General Meeting

• Keynote

• DBA Track

• Development Track

This presentation will teach you the basics of Exadata from a beginner's perspective with an intermediate level of material, but with many good real life examples. It will cover the advantages of using this hardware and how the hardware components provide the speed that you will realize when implementing it. Consolidation is the number 1 way that companies are saving money and eliminating data center complexity. Exadata provides both benefits! Rich will also show how you can prepare NOW so that you will be ready to implement Exadata on your next upgrade, migration or consolidation. Topics to be discussed include: Flash Cache, Storage Index , Smart Scans, Hybrid Columnar Compression (HCC), Enterprise Manager & Grid Control, Enterprise Manager Exadata Simulation, I/O Resource Manager, Security, Utilities , Best Practices

Richard J. Niemiec is President 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 2007, Rich authored Oracle10g Performance Tuning Tips & Techniques, a follow-up to Oracle9i Performance Tuning Tips & Techniques that he wrote four years earlier. Rich is 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 the MOUG Newsletter. Rich has delivered hundreds of lectures about Oracle technology to users around the world. Past accomplishments include top presenter honors at international Oracle user conferences. He has also conducted numerous expert class presentations at Oracle OpenWorld and other major shows.

Back to Top

DBA TRACK:  What if Kramer were your DBA and Seinfeld tuned your database?

This light hearted presentation will show what would happen if you had the characters from Seinfeld tune your database. It covers all areas of tuning from an intermediate perspective.

I. Jerry, I can't find my backup

A. I know I had it here somewhere
B. I think the UPS guys stole it
C. I may have taped over it with Brittany Spears

II. George, the database doesn't tune itself
III. Elaine, the DBA can't stop working at 5 PM
IV. Jerry, uses the AWR Report, 11g New Features & Grid Control... it works spectacularly

Richard J. Niemiec (see bio above)

Back to Top

Many organizations are considering migration paths away from legacy systems that include proprietary midrange and mainframe systems. There are sizable benefits to be reaped by this including lower hardware and support costs, increased performance and decreased down-time. Oracle‟s Real Application Clusters (RAC) is a key enabling technology that delivers carrier-grade reliability at a fraction of the cost. However, RAC is not designed as a solution to all problems, and one must understand its strengths and weaknesses to see where it can be used effectively. This session will cover an introduction to RAC architecture that focuses on the key components that can help systems architects understand where to employ it in the enterprise, and real-world solutions that reduce TCO.

Dr. Steele Arbeeny, PhD is Director of Strategic Business Technologies for GL Associates, Steele develops custom systems to ensure efficient data integration and system accuracy. His successes include interactive web sites that allow users to access centralized databases using a web browser, and web technology systems/networks that utilize email and video communication systems. He has patents pending for work in digital speech processing and securities trading. He is a member of the IEEE and the ACM. Steele earned his Ph.D. in computer engineering from Rutgers University, after completing his BS in electrical engineering at CUNY.

Back to Top

This presentation will discuss the changes in Oracle 11 to enhance Data Guard in order to meet business requirements. It will cover details and usage of various types of standby features available in Oracle 11g, such as Physical database, Logical database, Active Data Guard, Snapshot Standby, etc. It will also cover how to utilize the Data Guard environment for patching and upgrades including rolling upgrades.

Inderpal S. Johal has been working as a lead database administrator and architect for more than 13 years. He is the CEO of Data Softech Inc., a New Jersey based company that specializes in providing complete database support solutions and training to various fortune 500 clients. He has written various Oracle technical articles for journals and magazines including Oracle Magazine and has spoken at Oracle OpenWorld, IOUG, UKOUG, NYOUG, NJOUG and DBA Online. He has a Masters Degree in Computer Science from Punjabi University and worked as a Lead DBA and Architect for AT&T, UPS, Chase Bank, Citicorp, PR Newswire, HCL and IBM.

Back to Top

All DBAs encounter performance issues whenever there is a database/server upgrade or change in any optimizer parameter settings. The optimizer can come up with several new execution plans and can cause severe performance issues as the new plans are not verified against regression. This presentation addresses the challenge of eliminating/minimizing these issues using the Oracle 11g new feature - SQL Plan Management (SPM). This feature uses a preventive mechanism to automatically control SQL plan evolution with the help of what are called SQL plan baselines. The SPM's job is to capture and evaluate the execution plans over time and build SQL plan baselines containing only efficient execution plans. When a new plan is found for a SQL statement it will not be used until it has been verified by the database to have comparable or better performance than the current plan. This presentation also explains how to automatically identify and tune bad performing SQL without the manual intervention of DBAs, using the Automatic SQL Tuning Advisor. The Advisor also automatically tests SQL profiles and can automatically implement them, if configured. The Advisor targets SQL statements for the automatic tuning based on AWR Top SQL identification.

Sameer Malik has been working as Oracle DBA for over 7 years and specializes in Oracle database performance tuning including instance, application and SQL tuning. In addition, he is an Oracle certified OCP DBA on 9i/10g and 11g and Six sigma certified Green belt and frequent speaker at the Georgia Oracle user group meetings.

Back to Top

Without pointing fingers, tangible, real life examples of „Business Intelligence gone bad‟ are shared with solutions that cannot be found in a Google search. Even further, best practices are explained to prevent falling into these situations altogether. Participants will relate to both technical and business focused topics that include but not limited to: Database design for upgrades, not performance, business rules (bugs) in repository definition file, correctly assuming end user intelligence, beautiful, inaccurate reports.

Brian Halloran is a Business Intelligence consultant focused on the delivery and acquisition of OBIEE solutions. Brian has developed and maintained successful client relationships when leading both business and technical efforts for fortune 500 companies within the following industries: pharma, transportation, manufacturing, travel, high technology, financial, and retail services.

Back to Top

This session will introduce the concept of collections and walk through some of the most helpful use cases for them. Using the Oracle Application Express product-specific examples of a shopping cart, interactive reports with dynamic SQL, and running saved queries, the audience should leave the session feeling comfortable using collections in various scenarios. Although this session will contain demonstrations, the more important goal is to expose the audience to the potential uses of collections even beyond the proverbial shopping cart. The examples of interactive reports and running saved queries are two such uses of collections, and time allowing, the session will explain the use of collections when manually validating tabular forms.

Josh Millinger was an 11 year veteran at Oracle Corporation before leaving to form Niantic Systems with Raj Mattamal. He has worked extensively with companies across verticals to help them better achieve their goals using Oracle Application Express. He presents on APEX at various conferences nationwide.

Back to Top

Access to timely and comprehensive database-related historic data is essential for many DBA activities. The OEM repository not only stores the data for dozens of pre-defined metrics, but also allows easy expansion and customization with User Defined Metrics (UDM). Customization of retention and collection parameters provides the flexibility to address a wide array of DBA problems. Since the OEM repository resides on Oracle, the full power of SQL and PL/SQL as well as all built-in SQL and PL/SQL functions and packages can be used. Furthermore, even greater customization and flexibility can be achieved by creating data structures and packages (in a separate DB user/tablespace). This presentation emphasizes reliance on mathematical verification for DBA “theories.” It includes examples of ad-hoc issues that can be solved effectively with direct access to OEM repository structures. The presentation also covers a more complex enterprise-wide Oracle tablespace size forecasting utility.

Iordan K. Iotzov is a Senior Database Administrator at News America Marketing (NewsCorp) with more than 10 years of database administration and development experience. He presented at NYOUG DBA SIG in 2010.

Back to Top

December 2010 General Meeting
NYC Metro Area Oracle User Group Meeting

• Keynote

• DBA Track

• Development Track

• BI/DW Track

Oracle Senior VP Andy Mendelsohn will discuss the benefits of upgrading to Oracle Database 11g. Attendees will learn how customers are reducing IT costs and increasing quality of service for all their enterprise applications.

Andrew Mendelsohn is senior vice president for Oracle Database Server Technologies. He is responsible for the development and product management of Oracle's database product family. This includes the core Oracle Database and related products such as Exadata Storage Server, Database Machine, TimesTen, Berkeley DB, Secure Backup, Secure Enterprise Search, and Audit Vault. Mr. Mendelsohn has been at Oracle since May 1984. He began his career at Oracle as a developer on the Oracle 5.1 database release. Prior to joining Oracle, he worked at Hewlett-Packard and ESVEL. Mr. Mendelsohn holds a B.S.E. in electrical engineering and computer science from Princeton University and performed graduate work in computer science at M.I.T. In his spare time, he enjoys family activities, skiing, and tennis.

Back to Top

DBA TRACK:  "Cache Fusion Demystified"

Cache Fusion is fundamental to performance in RAC by reducing the need to go to disk for the data and getting it directly from the memory of another instance. But it is also a source of a lot of mystery, myths, and misconceptions. This presentation will explain in clear terms what cache fusion can or can’t do by traversing the course of a buffer from the disk to the instance and then to the others. Also covered will be the different states of the buffer, the global locking mechanism, the need for a CPU and I/O as opposed to a super-fast interconnect, the cause of the different global cache related wait events, and how they can be resolved. All will be shown with live demos.

Arup Nanda is the Principal Database Architect at Starwood Hotels. He has been an Oracle DBA for the past 16 years and has experienced everything from data modeling to performance tuning and disaster recovery. He is a frequent speaker at local and international conferences, a frequent writer who has co-authored three books. In 2003, Oracle selected him as DBA of the Year.

Back to Top

Data Masking is the act of replacing sensitive data with fictitious but realistic data in order to eliminate the risk of exposure to unauthorized parties. Implementing a sustainable data masking program in a modern enterprise environment can be surprisingly challenging—not just technically and organizationally, but culturally. The reactions and concerns you may encounter from your development and QA teams are understandable. You’re not just introducing new controls over confidentiality exposures in development and testing systems. You’re shutting off developers’ and testers’ unfettered access to live customer Production data—something that’s been quite normal and convenient for them to date, something they think they just can’t do their jobs without. Any project is only as successful as its level of buy-in from all involved. Getting colleagues to “do things a little differently” than they have traditionally means getting them on board early and anticipating their concerns. This presentation recounts lessons learned from years of implementing data masking programs at some very large companies.

Ilker Taskaya is a product manager for DMsuite, a web application data masking product, at Axis Technology, LLC. He manages the data masking product team at Axis, including services delivery and product development. Prior to this, Mr. Taskaya was a consultant in data warehousing for clients in financial services, insurance, and health care.

Back to Top

This presentation will show how to construct a flexible, non-database specific, data warehouse architecture using generic OTS components. The relative cost of this generic data warehouse architecture and its projected performance will be compared with other available solutions. Topics to be discussed include:
- Data warehouse hardware requirements
- The tier concept of data storage
- Suggested tier zero architecture
- Suggested tier one architecture
- Comparison of suggested architecture to Exadata architectures

Mike Ault is a recognized Oracle expert who presents at numerous Oracle conferences. Mike has written or co-written over 24 Oracle related books and is the author or numerous white papers, articles and presentations. Mike is employed as the Oracle Guru for Texas memory Systems, Inc. a manufacturer of solid state storage for Oracle databases.

Back to Top

Data Vault data modeling initiated by Dan E. Linstedt, has a distinct advantage over the traditional star schema modeling approaches of Bill Inmon and Ralph Kimball. With SOX, BASIL II, HIPAA and other regulatory compliance requirements, evolving SOA implementations and increasing data mining requirements, the Data Vault modeling approach is emerging as the future of Data Warehousing in the industry. This presentation will cove Hub Entity, Satellite Entity and Link Entity. Siva will also show how these Data Vault components differ from the Fact & Dimensions of traditional Star Schema modeling and the benefits of the approach with a sample case study of implementation in Oracle.

Siva Govindarajan is a skilled Database Architect working extensively on Oracle Databases as a Consultant for Globytes Technology Solutions, with more than 20 years of experience in data warehousing, real-time systems, SOA and distributed database applications in the areas of financial, telecommunication, Internet, Insurance and many other sectors.

Back to Top

Learn what's different about cost-based optimization in 11g Release 2. In this session Dave will guide you through some enhancements and other surprises in the Oracle 11g Cost Based Optimizer. Through live demonstrations and lecture, attendees will learn about features such as adaptive cursor sharing, new join techniques, DBMS_STATS enhancements, direct (PGA) reads for “large” full table scans, new hints and more.

Dave Anderson has 30 years of IT experience, 25 with relational databases, 14 with Oracle. He founded and is still happily employed by SkillBuilders, a consulting and training services firm.

Back to Top

One of the biggest concerns about the cloud is the threat of data being stolen. The cloud is a high risk environment that decreases the database administrators’ ability to control the flow of sensitive data. Because cloud introduces risk, exposure of database encryption keys becomes particularly vulnerable. Enterprises are currently on their own in deciding how to apply the principles of PCI data protection (e.g. segregation of regulated data) when reducing costs with virtualization or cloud computing, or reducing PCI exposure with tokenization and encryption. Tokenization eliminates keys by replacing sensitive data with random tokens to mitigate the chance that thieves can do anything with the data if they get it. This session will discuss new methods for protecting the entire data flow across systems in a cloud environment while minimizing the need for cryptographic services.

Ulf Mattson created the innovative architecture of the Protegrity database security technology. Prior to joining Protegrity, he worked 20 years at IBM in software development as a consulting resource to IBM's Research organization, specializing in the areas of IT Architecture and IT Security. He is the inventor of more than 20 patents in the areas of Encryption Key Management, Policy Driven Data Encryption, Internal Threat Protection, Data Usage Control and Intrusion Prevention. He is a research member of the International Federation for Information Processing (IFIP) WG 11.3 Data and Application Security, ANSI X9, Information Systems Security Association (ISSA) and Information Systems Audit and Control Association (ISACA).

Back to Top

Oracle Recovery Manager (RMAN) provides a comprehensive foundation for backing up and recovering Oracle databases. As database sizes continue to grow unabated, RMAN performance tuning is more critical than ever to satisfy required backup and recovery windows. This session presents an inside look at RMAN backup, restore, and recovery operations, including a step-by-step tuning methodology to diagnose performance bottlenecks and implement the database and system changes to achieve the desired performance characteristics. It also discusses key RMAN configuration best practices, including sizing of the Fast Recovery Area (FRA) and the trade-offs for various backup and recovery strategies.

Tim Chien is a Principal Product Manager with Oracle. He is recognized by the Oracle user community as a technical expert and evangelist for Oracle Backup and Recovery Technologies. He is a regular presenter at Oracle User Group meetings, frequently conducts hands-on technical training, and provides expert technical advice to customers worldwide.

Back to Top

Many times during a project life cycle, new technology is introduced that presents first time challenges. This presentation describes a project using Oracle XML DB and discusses why XML DB was chosen, how XML DB was used, and the technical issues encountered. Coleman will provide several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Participants will learn about methods, design considerations and issues using Oracle XML DB. Working examples are provided and may be used with the participant's Oracle environment (10g or 11g R2).

Coleman Leviter has presented at IOUG's Collaborate 07, 08, 09, 10 and at Oracle Open World 10. He is the IOUG Collaborate 2011 Co-education Chair and is the NYOUG WEB SIG chair. His articles have been published in Select Journal and OTDUG Journal

Back to Top

This presentation provides a new angle on a popular attack vector on the database layer of applications: SQL Injection, a common attack which can be used to gain control of a database. Though many types of SQL injection can be prevented by secure coding practices, one can limit and even stop SQL injection attacks by deploying the correct tools to protect applications and databases. Certain classes of SQL injection, including those exploiting zero-day vulnerabilities, can be entirely blocked by deploying deep inspection tools, which will be demonstrated in the presentation.

Rob David is a Security Consultant for Sentrigo, bringing with him over 11 years of experience in the design and implementation of IT infrastructure and security solutions. Rob is a regular speaker at industry conferences and has held senior roles in consulting, sales engineering and product management for Security Dynamics (RSA), a provider of trusted information access products, Milkyway Networks and Raptor Systems, providers of firewall and VPN technologies and Cloakware, a provider of privileged password management and Digital Rights Management (DRM) solutions

Back to Top

In the early days of web applications, Oracle created User Interface XML (UIX) -- a user-interface component set used to render HTML items. Oracle used UIX in JDeveloper 9i to build E-Business Suite applications up through release 12i. Then Oracle transformed UIX components into standard JSF components and called the new component set "ADF Faces," which evolved into ADF Faces Rich Client (ADF Faces RC). Oracle is now using ADF Faces RC to create Oracle Fusion Applications, but you can also use it to create custom web applications. This presentation examines the components available in ADF Faces RC. It explains how to use native ADF Faces RC features such as skins, internationalization support, and built-in Asynchronous JavaScript and XML (AJAX, also called Partial Page Rendering). Since an important aspect of web page design is managing screen real estate, this presentation explores how to achieve the perfect layout using the ADF Faces RC layout components. The presentation demonstrates container component techniques such as modifying the standard tab order and introduces the Data Visualization Tools (DVT) components, which provide super-rich, Web 2.0 functions such as interactive graphs, Gantt charts, pivot tables, and hierarchy viewers.

Peter Koletzke is a technical director and principal instructor for Quovera, in Mountain View, California, and has over 26 years of industry experience. Peter has presented at various Oracle users group conferences more than 270 times and has won over a dozen Oracle user-group awards including NYOUG Editor's Choice (twice). He is an Oracle Certified Master and Oracle ACE Director as well as co-author of eight Oracle Press books about Oracle development tools.

Back to Top

After developing and testing a Java web application, you need to deploy it -- make it available to users. Deploying a Java EE web application consists of wrapping all application files into a single Java archive file (the EAR, enterprise application archive) and then copying this file to the application server. The Oracle WebLogic Server (WLS, formerly, Oracle Containers for Java EE--OC4J) is a standard Java EE runtime process to which you deploy Java-based applications for use in a web runtime environment. This presentation explores the process of deploying to an Oracle WebLogic Server server. It outlines JDeveloper utilities and profiles that help you create an EAR file with all required libraries. The presentation then explains how to deploy the application using JDeveloper. It also discusses the benefits of and techniques for testing deployment on a local standalone server. In addition, the presentation describes and demonstrates the deployment services of the WLS console and why you might choose it to deploy an application instead of using JDeveloper.

Peter Koletzke is a technical director and principal instructor for Quovera, in Mountain View, California, and has over 26 years of industry experience. Peter has presented at various Oracle users group conferences more than 270 times and has won over a dozen Oracle user-group awards including NYOUG Editor's Choice (twice). He is an Oracle Certified Master and Oracle ACE Director as well as co-author of eight Oracle Press books about Oracle development tools.

Back to Top

September 2010 General Meeting

• Keynote

• DBA Track

• Development Track

Back to Top

DBA TRACK: Analyzing Application Performance in RAC

Tracing a session, either via SQL trace or the 10046 event, is one of the fundamental tools for performance
diagnosis. However, it becomes a challenge in the RAC environment with many sessions connecting and
disconnecting from multiple instances. Combined with this is the use of connection pools that can have data from
multiple applications, making it impossible to pinpoint a specific application. Attendees of this session will learn
how to use Automatic Enablement of tracing, combining the traces across multiple instances via trcsess, filtering
out the relevant applications from a set of traces, and analyzing through tools like tkprof or Trace Analyzer. All of
these tools are available free from Oracle and will be shown with live demos including 11g.

Arup Nanda is the Principal Database Architect at Starwood Hotels. He has been an Oracle DBA for the last 16
years and has experience with everything from data modeling to performance tuning and disaster recovery. He is a
frequent speaker at local and international conferences, a frequent writer and has co-authored three books. In 2003,
he was the Oracle DBA of the Year.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Oracle's recent focus on "Hardware and Software Engineered to Work Together" includes extensive work in business intelligence tools and applications, data warehousing & database, and Exadata development. Emerging from various development organizations within Oracle, the focus of this presentation is on technical integration points and emerging data models and solutions addressing horizontal and industry vertical business problems.

Robert Stackowiak, Vice President of Business Intelligence & Data Warehousing in Oracle’s Enterprise Solutions Group, is recognized worldwide for his work in business intelligence and data warehousing and has spoken at many conferences and events. He has authored articles and books on business intelligence and database technology including “Oracle Essentials: Oracle Database 11g” (O’Reilly Media), “Oracle Data Warehousing and Business Intelligence Solutions” (Wiley), and the soon to be released "Achieving Extreme Performance with Oracle Exadata" (Oracle Press). His blog is located on the O’Reilly Media web site.

Back to Top

This session provides an overview of the landscape of Oracle Data Warehousing and Business Intelligence technologies. With multiple options to choose from, often Oracle users look for some direction in their selection of tools and technologies. This presentation provides a bird's eye view of the spectrum of Oracle DW/BI technologies including OLAP /Essbase, Data Mining, OWB / ODI, OBIEE, BI Publisher, and other related BI and reporting products. Attendees will gain a good understanding of where each product fits into real world scenarios. The information presented will help attendees figure out the different components they need for their own BI / DW solutions.

Sameer Singhal runs the North American BI Analytics Consulting Practice and has spent more than 13 years with Oracle Consulting. He is a senior leader with hands-on experience leading technology transformations for large enterprises. Sameer specializes in helping customers create value through technology and creating solutions that maximize the business value of technology investments. Technology wise, Sameer’s practice is responsible for delivering consulting solutions around OBIEE, BI Applications and advanced reporting solutions by integrating OBIEE with Real Time Dynamics (RTD), Geospatial, Essbase etc.

Back to Top

This session will simplify the OBIEE technology for Oracle DBAs and Developers. Attendees will learn how the new features and advances of OBIEE 11g impact them. The topics of data warehouses and Business Intelligence Applications and the associated layers such as OBIEE and pre-built ETL connectors to deploy analytical solutions on top of Oracle ERP systems such as EBS, Peoplesoft, JD Edwards and Siebel CRM will be discussed. Attendees will learn about tips and tricks gained from several implementations of the above. In additional, attendees will learn how to determine the right BI strategy for their organizations.

Vivek Jain is a Managing Consultant at IBM, focusing on managing OBIEE with Essbase projects within IBM Global Business Services Oracle He has over 10 years experience in information systems working directly with Oracle BI and DW technology and tools. As a Sr. Principal Consultant at Oracle North America Consulting he managed all aspects of BI consulting projects and gained extensive hands on experience in data model design, data preparation, data manipulation, calculation optimizations, reporting, analytics, and tools deployment and implementation.

Rahul Kundavaram a Senior Principal Consultant with Oracle corporation specializing in Applications, Business Intelligence and Data Warehousing. He has worked extensively with BI tools including Oracle Business Intelligence Discoverer, OBIEE, BI Publisher and Oracle Reports 6i/9i. His other expertise is in PL/SQL programming and Oracle EBS implementations

Back to Top

Oracle Data Mining automatically discovers relationships hidden in data. Predictive models and insights discovered with ODM address business problems such as: predicting customer behavior, detecting fraud, analyzing market baskets, profiling and loyalty. Oracle Data Mining, an Option to the Oracle Database EE, embeds 12 cutting edge algorithms in the kernel of the Oracle Database. This eliminates data movement, delivers scalability and maintains security. ODM results can be accessed by OBI EE or built into predictive applications to help companies better "compete on analytics". The totally new Oracle Data Miner 11g Release 2 "workflow" Graphical User Interface (GUI) makes data mining easy with a new “workflow” look and feel for data analysts. ODM'r 11gR2 provides more graphics, the ability to define, save and share analytical "workflows" that solve business problems e.g. fraud, next-likely-product, customer segmentation, etc. and provides automation and simplicity. Oracle Data Miner 11gR2 GUI adds a wide range of graphical data and model viewers. For Exadata customers, ODM models built inside the database are “scored” at the storage layer.

Charlie Berger is the Senior Director of Product Management, Data Mining and Advanced Analytics at Oracle Corporation. He is responsible for product management and direction for the Oracle Databases' data mining and predictive analytics technology including Oracle Data Mining, text mining and the SQL based statistical functions. He has over 25 years of experience in leading edge technologies including Oracle, Thinking Machines, Bolt Beranek & Newman (BBN), and several others.

Back to Top

Testing is a critical part of any software development lifecycle, and yet, it is still one of the areas receiving the least amount of investment and attention. While the capabilities of technology continue to expand beyond expectations, far too many software development projects are still failing to meet quality measures, exceed delivery, and cost expectations -- to the point where it can no longer be ignored -- organizations must turn this trend around. Automation has grown to become a tremendous help in improving on meeting our goals and is critical to overall project success.
In this session, you learn how automation can be applied across all aspects of the test and development process: - Understanding and architecting your Data - Building the test environment - Data privacy and security tactics - Executing function and performance tests

Jon Bourner is an Oracle Technical Specialist with IBM who has been working with the Oracle e-Business suite of modules since Release 8. He has experience with all aspects from Pre Sale demonstration to implementation, and development.

Back to Top

June 2010 General Meeting

• Keynote

• DBA Track

• Development Track

• DBA & Developer Track

Back to Top

DBA TRACK: Holistic Tuning in Oracle11g

This presentation will demonstrate how to think globally when tuning in the Oracle11g environment. Participants will be shown the effects of local actions such as the addition of an index or alteration of a parameter on the database as a whole. All areas of the database environment will be covered. Attendees will learn how to focus on the entire database instead of just on the statement or other object of the tuning effort.

Mike Ault has been working with Oracle databases since 1990. Mike has written or co-written 25 books about Oracle technologies. Mike is a frequent highly rated presenter at regional, national and international Oracle conferences.

Back to Top

Back to Top

Back to Top

JavaServer Faces (JSF) is a Java-based user interface technology used primarily to develop web applications. It is currently the most popular UI technology in the Java world and it is a key technology in the Oracle Application Development Framework (ADF). Oracle's Fusion Applications (formerly E-Business Suite) use JSF as the main user interface technology.

This presentation provides an overview of JSF technology as it is used with ADF to build applications in JDeveloper. It discusses the basic communication paths used when running a JSF application. The presentation also explores development details for creating and testing JSF files. It describes the contents of runtime files such as backing beans and managed beans, message bundles, faces-config.xml, and web.xml. The presentation also briefly explores how to link data from the database into the JSF page so it can be saved or retrieved from the database. Throughout this presentation, sample code and demonstrations show how these concepts manifest in a sample application.

Peter Koletzke is a technical director and principal instructor for Quovera. He is an Oracle Certified Master, Oracle ACE Director, and has presented more than 260 times at Oracle conferences. Peter has won awards such as Pinnacle Publishing's Technical Achievement, ODTUG Best Speaker, ODTUG Editor's Choice (twice), the ECO/SEOUC Oracle Designer Award, ODTUG Volunteer of the Year, and NYOUG Editor's Choice (twice). He is the co-author, with Dr. Paul Dorsey, Avrom Roy-Faderman, and Duncan Mills, of eight books about Oracle development tools.

Back to Top

New applications architecture (call it SOA Integration Solution, BPM or Java EE Solution) must take into account the concepts of Quality of Service and Systemic Qualities. This presentation explains how architects can identify the non-functional requirements of their projects, how to classify them, and how to introduce them in order to achieve the right balance for systems to work for their business users, for the system as a whole, and for the development and the evolution of the solution over time. The presentation includes a demonstration of these concepts using a real-world example of an online personal banking Web interface integrated with two banks.

Mauricio Naranjo is an Oracle ACE Fusion Middleware Director, specializing in IT governance and enterprise architecture. He is an ITIL v3 certified professional and Oracle SOA architect certified expert. He is the co-author of the book Oracle 9i Java Programming (Peer Information). Over the past twelve years, he has architected, designed, and implemented enterprise solutions and business transformation plans for more than sixty banks, financial institutions, and government agencies. Mauricio is a frequent presenter at different Oracle seminars including ODTUG, NYOUG, Chilean Oracle Users Group, Peru Oracle Users Group, and IOUG.

Back to Top

Back to Top

March 2010 General Meeting

• Keynote

• DBA Track

• Development Track

Oracle Database 11g is helping organizations across the world reduce their computing costs through consolidation onto enterprise grids, reduced storage requirements and elimination of idle redundancy. Oracle Database 11g Release 2 includes major new features that make Grid computing more accessible and DBAs more productive. It offers up to 20x data compression ratios, and enables online application upgrades. This keynote presentation will discuss how to drive down costs and improve the quality of IT service while simplifying your software portfolio by utilizing the features in Oracle Database 11g Release 2.

Charlie Garry has over 20 years of experience in Information Technology. He is a former Vice President and Director for META Group’s Technology Research Services. Mr. Garry’s focus has been on relational database and infrastructure design, support staffing, licensing/pricing and data management best practices. Throughout his career, Mr. Garry has worked with hundreds of companies delivering support and education in areas such as database design, performance tuning, backup/recovery, licensing and negotiation strategies. He has been a frequently requested speaker at noted database conferences such as Oracle OpenWorld, IOUG, IDUG, Teradata Partners and the MySQL User Conference. He was the author of a regular column for eWEEK.com. Mr. Garry was a founding member of Divine Interventures and Vice President of Infrastructure Strategies for Platinum Technology as well as Director of Field Operations for Platinum’s data warehousing/BI division.

Back to Top

DBA TRACK: The Life of a Query

Have you ever wondered what happens when you execute a query? In this session, we'll take a walk through the Life of an Oracle Query from beginning to end. Not only does this help you better understand the various steps in the execution of your query, but it will also give you a good appreciation for the architecture of the Oracle Database server and, in particular, of the query optimizer. You will gain valuable information that will allow you to solve performance issues and write more efficient queries going forward. Additionally, I will share some of my insights into the Oracle optimizer as we move through this discussion. This discussion is also a great refresher for those of you familiar with Oracle concepts and architecture.

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 blogs on oracle-internals.com and provides support to the Database, Call Interface, Instant Client, ODBC, PHP, Linux, SQL, and PL/SQL community forums on OTN.

Back to Top

DBA TRACK: Oracle Total Recall – Flashback Data Archive

This presentation explains how to store data versions transparently without making application changes in order to satisfy audit and business requirements. It will cover the Oracle 11g Flashback enhancement, which helps to permanently store the version of data as long as necessary to meet business and security goals. Database maintenance can be performed automatically. Mr. Johal will cover the architecture showing how the data is saved in compressed and partitioned formats as well as discussing automatic purging. Improvements from Oracle 11 Release 1 to Release 2 will be discussed with emphasis on those that save development time.

Inderpal S. Johal has been working as a lead database administrator and architect for more than 13 years. He is the CEO of Data Softech Inc., a New Jersey based company that specializes in providing complete database support solutions and training to various fortune 500 clients. He has written various Oracle technical articles for journals and magazines including Oracle Magazine and has spoken at Oracle OpenWorld, 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, PR Newswire, HCL and IBM

Back to Top

DBA TRACK: Dimensional Modeling 101

The presentation will introduce attendees to the fundamental concepts of Data Warehousing Dimensional Modeling. It will explore the use of Surrogate keys, slowly changing dimensions, Star schema and Snowflake designs, utilizing practical real world examples.

Michael Davis is the President of OmegaSoft, LLC, a Software Development and Data Warehousing consulting company located in Bloomfield Connecticut. Founded in 1999, OmegaSoft provides services for small businesses and enterprise customers.

Back to Top

DBA TRACK: Tuning SQL Without the Tuning Pack

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways to fix this, some may jeopardize your job and others may make you a hero. As usual, money can grease the skids but there are also ways to do it on the cheap. The various options will be discussed in this paper.

John Larkin has worked as a DBA for the last 23 years, the last 15 with Oracle. He works for a major financial services company in Delaware and is currently working on a project to migrate a small single-instance datamart from AIX to a Linux / RAC environment.

Back to Top

DBA TRACK: Tuning SQL Without the Tuning Pack

In a perfect world (or maybe an 11g world) , your QA database would be an exact clone of production. Unfortunately, most of us live in the real world where cost is always consideration. This can lead to issues with a SQL statement performing well in QA, but sub-optimally in production. There are several ways to fix this, some may jeopardize your job and others may make you a hero. As usual, money can grease the skids but there are also ways to do it on the cheap. The various options will be discussed in this paper.

John Larkin has worked as a DBA for the last 23 years, the last 15 with Oracle. He works for a major financial services company in Delaware and is currently working on a project to migrate a small single-instance datamart from AIX to a Linux / RAC environment.

Back to Top

Looking to build cutting edge user interfaces for your Web and mobile applications? Don't have time to learn and overcome the complexity of JavaScript and Ajax development? Come and see a simpler approach to achieve your goal with a rich set of UI components and a visual and declarative approach to development. Learn about the standard UI framework that Oracle is using for the Fusion generation of applications and for various other products, and see how you can use it too.

Dana Singleterry is a Product Manager in the Oracle JDeveloper/ADF product management team. He has been working with JDeveloper since 2005 and with other Oracle Development Tools since 2000. His blog is at http://blogs.oracle.com/dana/

Back to Top

This session covers all of the exciting new features that are expected in Oracle Application Express 4.0 (APEX 4.0). It includes a demonstration of Websheets, the premier new feature for business users, and features such as dynamic actions, plug-ins, charts, improved application builder, tabular forms, error handling, and REST Web services. APEX 4.0 includes enhancements that will benefit every developer, from novice to expert, to be able to build, enhance, and maintain database-centric Web applications faster and easier.

Marc Sewtz is a Software Development Manager for Oracle Application Express in the Database Tools Group, part of the Oracle Server Technologies Division. Marc has sixteen years of industry experience, including roles in consulting, sales and development, and joined Oracle in 1998. He is based in New York City and manages a global team of Oracle Application Express developers and product managers and is responsible for the Oracle Application Express user interface and product features such as Oracle Forms to Oracle Application Express conversion, the Oracle Application Express Reporting Engine, Tabular Forms, PDF printing and the integration with Oracle BI Publisher. Marc has an MS degree in computer science from the University of Applied Sciences in Wedel, Germany.

Back to Top

Business Intelligence remains a top concern for CIOs as they understand one cannot improve upon what they cannot measure. To gain better visibility into its data and metrics, companies must strive to become insight-driven enterprises using Business Intelligence technologies. This presentation will show how implementation of a successful Business Intelligence project can be achieved using a combination of a practical architecture and the power of the Oracle Business Intelligence Platform.

Richard Rodriguez is a Business Intelligence Solutions Architect with Corporate Technologies, an Oracle Certified Business Intelligence Pillar Partner. Richard has over 13 years of extensive expertise in selling, architecting, and implementing Business Intelligence solutions, with a primary focus on Oracle, Microsoft and Business Objects technologies.

Back to Top

NYOUG 25th Anniversary/NYC Metro Area Meeting

• Keynote

• NYOUG 25th Anniversary Slides

• DBA Track

• Development Track

Back to Top

DBA TRACK: "Case Study-11g Upgrade with RAT, SPM & SnapshotStandby"

This session describes a real life case study with detailed steps, commands and screenshots of our 11g upgrade experience from 10g. Attendees will learn how to use Database Replay and SQL Performance Analyzer to gauge the impact of the upgrade in advance, fine tune parameters by replaying the captured workload from production. Arup will explain the differences between SQL Plan Management baselines and SQL Profiles, show how they were used them to stabilize the plans, and how SQL Tuning Advisor was used to tune the regressed queries. Snapshot Standby database was used to further tune the production database without jeopardizing operations. Attendees will learn from our success and failures to better plan your own upgrade process.

Arup Nanda has been an Oracle DBA for more than 16 years spanning every aspect of a DBA's work - from modeling to performance tuning. He is the Lead Database Architect at Starwood Hotels.

Back to Top

DBA TRACK: "Oracle SSD Technology for Performance"

Results of performance tests conducted with SAN storage, SAN SSD and FusionIO SSD technologies will be reviewed, with comparisons of each for TPC-C and Oracle disk I/O performance. A brief mention of the methods used to test including tools (Benchmark Factory and Orion) will also be included.

Steve Fluge has 15 years of Oracle experience, as a DBA and Consultant. He has presented at Oracle OpenWorld on the topics of migration to Oracle RAC with OCFS, and 10g performance on Itanium. Steve has also created a demo database for Oracle Spatial on Itanium for an Intel keynote presentation.

Back to Top

DBA TRACK: “Zero Slides: The Scripts and Tools to Make Your Life Easier"

As the title already says, this presentation has no slides at all! Instead Tanel will demonstrate some of the most useful tools he uses for accurate Oracle performance troubleshooting. The toolset ranges from plain SQL statements to UNIX and DTrace scripts and some custom-built GUI tools and of course a new version of Tanel's Oracle Session Snapper will be covered. During the session you will be taken through few troubleshooting case studies following a systematic troubleshooting methodology. For anyone interested in Oracle internals and performance tuning, this session should be a fun learning exercise!

Tanel Poder is an experienced consultant with deep expertise in Oracle database internals, advanced performance tuning and end to end troubleshooting. He is one of the first Oracle Certified Masters in the world, passing the OCM DBA exam in 2002; an Oracle ACE director and also a proud member of the professional OakTable Network. In addition to teaching his seminars and speaking at major Oracle conferences worldwide, he publishes his work at his Oracle performance tuning blog http://blog.tanelpoder.com

Back to Top

DBA TRACK: "Using Preferred Read Groups in Oracle ASM with Data Masking"

Oracle11gR2 ASM provides the capability to use a preferred read mirror to allow geo-mirroring and use of high and low speed assets in the same ASM disk group. This presentation shows how to utilize the preferred read mirror concept to optimize your performance and reliability. Attendees will see by example how to setup and utilize the new preferred read mirror in Oracle ASM. Examples form actual installations will be used as well as performance comparisons for when high and low speed disk groups are used with and without preferred read.

Mike Ault has worked with Oracle since 1990 and computers since 1980. Mike has written over 2 dozen books about Oracle and Oracle related technologies. Mike is a frequent presenter at international, national and regional user groups. Mike has also written numerous articles for various Oracle related publications. Mike works for Texas memory Systems as their Oracle Guru.

Back to Top

DBA TRACK: "Oracle 11g Cache Features Put to the Test”

Dave follows up his sought-after Oracle 10g New Features presentation with a look at the SQL and PL/SQL caching features found in 11g. Learn how to implement caching and see Dave's benchmarks. This will be a technical and practical presentation with working examples presented where possible.

Dave Anderson founded SkillBuilders.com in 1994. He has worked in the IT field since March 1980 and has 25 years of hands-on relational database experience. He currently makes Oracle databases work well and fast for large banks, insurance companies and small companies like SkillBuilders.com.

Back to Top

DBA TRACK: "Custom Monitoring Your Database with PL/SQL"

Want to know when a particular table is locked and who is locking it? Are current archive logs being shipped to that standby database? You can automate monitoring for these and a whole lot more conditions by using PL/SQL packages and dbms_ jobs to customize the monitoring - and alerting - of an Oracle Database. This presentation describes the fundamental concept of using Jobs to periodically call a PL/SQL procedure to watch for specific conditions, and then to take action.

Bill Schott has been a DBA at DTE Energy for 14 years, with experience using Oracle 7.3 thru 10.2. He is a past presenter at ECO, MOUG, IOUG-A and other conferences and he is passionate about sharing knowledge, tips and techniques across the Oracle DBA community.

Back to Top

DBA TRACK: "Advanced Oracle SQL Performance Tuning"

Many DBAs and Developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: indexing strategies, use of histograms, SQL wait event data, column selectivity and several more that will help the you succeed on future tuning projects.

Dean Richards has over 20 years of Oracle and SQL Server project development, implementation and strategic database architecting experience. Before coming to Confio Software, Dean held engineering positions at McDonnell Douglas and Daugherty Systems and was also a technical director for Oracle Corporation managing all aspects of key accounts including short and long-term technical planning and strategic alliances.

Back to Top

DBA TRACK: "Managing Risk: Understanding the New Options in Data Protection"

Sometimes data security and business processes do not play well with each other. The situation becomes even uglier when regulatory compliance is added into the mix. Too often, enterprises feel that they have to choose between data security, compliance and business needs. This session will detail the latest methodologies and technologies such as Type Preserving Encryption, Data Masking, Tokenization and Database Activity Monitoring to protect data in an Oracle environment with a focus on solutions designed specifically to support critical business processes. Attendees will also learn how to conduct a risk-based analysis to determine the scenarios where these new technologies are best suited in their environments. We’ll also explore new ways to measure and manage risk and compliance. This presentation also includes anonymous case studies that detail risk management security plans in an Oracle environment.

Ulf Mattsson created the initial architecture of Protegrity's database security technology, working closely with Oracle R&D, creating several key patents in the area of database security. His extensive IT and security industry experience includes 20 years with IBM as a manager of software development, and a consulting resource to IBM's Research and Development organization in the areas of IT Architecture and IT Security. Ulf holds a degree in electrical engineering from Polhem University, a degree in Finance from University of Stockholm and a master's degree in physics from Chalmers University of Technology.

Back to Top

Many organizations are seeking an HTML-based migration path for their Oracle Forms applications. The main platforms available, including JSP/JSF, .NET, and PHP, are object oriented and may require extensive time and training for those new to them. Another solution is Oracle Application Express, which can provide an HTML-based solution while leveraging existing SQL and PL/SQL knowledge. Attendees will learn about the main differences between the two platforms, the pros and cons of the alternatives (JSP/JSF, .NET, PHP), the general migration process and how to avoid some pitfalls along the way.

Dan McGhan is a senior Apex develop and instructor at SkillBuilders.com. He has been developing Apex applications since HTMLDB and is the designer and coder of the famous Brown University Energy Efficiency application (BEE). Dan can be reached at danMcghan@skillbuilders.com.

Back to Top

DEVELOPER TRACK: "De-Mystifying OBIEE/Oracle BI Applications"

Attendees will learn how to meet their BI and Analytical Reporting needs using OBIEE and/or Oracle BI Applications. They will learn how to simplify the implementation cycles, deal with real-world challenges and learn strategies for overcoming them. A product demo will show the step-by-step installation and configuration processes. Pointers to vital resources using real world customer implementation experience of Oracle BI Apps 7.9.6 and higher versions will also be discussed.

Shyam Nath is an OBIEE Architect at IBM. He has implemented several OBIEE and OBI Applications projects. He is a Certified DBA since 1998 and had worked on several Oracle Data Warehousing and BI projects including at Citigroup in NY. He is the founder and President of Oracle BIWA SIG (http://OracleBIWA.org) and a regular speaker at NYOUG, IOUG-Collaborate and Oracle OpenWorld. Shyam is also a regular blogger/micro-blogger on Oracle BI/DW topics. Currently (Aug '09), Shyam is the top expert in Oracle BI Apps Forum, helping several users to troubleshoot and plan their BI projects.

Back to Top

DEVELOPER TRACK: "Oracle Application Express API Primer”

Oracle Application Express comes with a series of provided API's such as APEX_UTIL,MAIL,ITEM, APPLICATION, CUSTOM_AUTH, etc. This presentation will go through the ones that we have found to be the most valuable and describe how and where to use them in your applications. Why build something when Oracle has already done it for you?! This presentation will walk through examples of using the provided Apex API's. We demonstrate how to build a manual tabular form using the APEX_ITEM API, how to reference arrays and debug using the APEX_APPLICATION API, in addition to a host of others.

Josh Millinger is the Founder of Niantic Systems, LLC, a Princeton, NJ-based consulting/development firm. He worked at Oracle for 11 years serving the partner community as their technical liaison. He currently focuses on Application Express development and related technologies

Back to Top

DEVELOPER TRACK: "Fraud and Anomaly Detection Using Oracle Data Mining"

How do you find needles in haystacks? How can you detect rare events, fraud, anomalies, and network intrusions in your corporate databases and operations? Oracle Data Mining’s (ODM) Anomaly Detection algorithm trains on what is considered “normal” and then flags any record(s) that, on a multi-dimensional basis, appear to not fit in. Find suspicious expense report submissions, find non-compliant tax submissions, combat fraud in healthcare claims and save huge amounts of money in fraud and abuse. This presentation and demo will show several use cases of ODM’s anomaly detection.

Charlie Berger is the Senior Director of Product Management, Data Mining Technologies at Oracle Corporation and has been with Oracle for ten years. Previously, he was the VP of Marketing at Thinking Machines prior to its acquisition by Oracle in 1999. He holds a Master of Science in Engineering and a Master of Business Administration from Boston Univerity as well as a Bachelor of Sciences in Industrial Engineering/Operations Research from the University of Massachusetts at Amherst.

Back to Top

DEVELOPER TRACK: "Effective Utilization of the Database in Web Development"

With the ever changing web application development environment, the benefits of placing more information in the database are becoming increasingly evident. This presentation (targeted at experienced PL/SQL developers) will discuss how to implement this approach in real world projects with a brief overview of the advantages of this approach along with specific details about how to implement the approach in SQL and PL/SQL Emphasis will be placed on using collections, dynamic SQL/PL/SQL and server-side support for stateless programming.

Dr. Paul Dorsey is the founder and 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 Business Rules Information Manager (BRIM®) tool. Paul is the co-author of seven Oracle Press books on Designer, Database Design, Developer, and JDeveloper, which have been translated into nine languages as well as the Wiley Press book PL/SQL for Dummies. Paul is an Oracle ACE Director. He is President Emeritus of NYOUG and the Associate Editor of the International Oracle User Group’s SELECT Journal. In 2003, Dr. Dorsey was honored by ODTUG as volunteer of the year, in 2001 by IOUG as volunteer of the year and by Oracle as one of the six initial honorary Oracle 9i Certified Masters. Paul is also the founder and Chairperson of the ODTUG Symposium, currently in its tenth year. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year. paul_dorsey@dulcian.com

Back to Top

DEVELOPER TRACK: "Benefits of Agile SOA Methodologies"

Service Oriented Architecture (SOA) is complex, lengthy, and riddled with challenges. Is SOA dead as claimed earlier this year? Many organizations have had frustrating experiences in the path they chose and some have even given up on their SOA initiatives and struggling how to show immediate results. This session will present a refreshing and effective approach to achieving rapid and incremental results in SOA, all the while educating participants on how to keep their projects aligned with the “big-picture” SOA Roadmap. Approaches include how to leverage an Agile methodology with SOA, when to use top-down vs. bottom-up vs. middle-out, and how to ensure business success through the use of SOA pilots. The session will also cover fundamental principles of Service Oriented Architecture by explaining definitions, concepts, and practices. This will help participants gain a common understanding of what SOA is, what constitutes SOA, and why it is so important to businesses.

Jordan Braunstein serves as the Business Integration & Architecture Partner at Rolta TUSC and is responsible for managing the TUSC SOA Center of Excellence. This includes delivering tangible results and support to customers through consulting, education, and overall partnership support, to ensure our clients achieve positive returns throughout their SOA Journey. Prior to joining, Braunstein started and Managed BearingPoint’s Public Services SOA practice, focusing on deriving value and hard-line results for defense and civilian government agencies, state and local governments, and higher education institutions.

Back to Top

DEVELOPER TRACK: "Tips & Techniques: Integrating Oracle XML DB"

Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will present a project using Oracle XML DB. The presentation will cover the project, why XML DB was chosen, how XML DB was used and technical issues encountered. This presentation describes several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Additionally, namespace examples and an introduction to XML Schema Definition (XSD) will be presented.

Coleman Leviter is employed as an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG's Collaborate 07, 08 and 09. He is the WEB SIG chair and sits on the steering committee at the NY Oracle Users' Group (www.nyoug.org). He has worked in the financial services industry and the aerospace industry where he developed Navigation, Flight Control and Reconnaissance software for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester Institute of Technology, an MBA from C.W. Post and an MSCS from New York Institute of Technology. Coleman recently completed Oracle’s Certified Professional Exam (OCP). He may be contacted at cleviter@ieee.org 

Back to Top

DEVELOPER TRACK: "What is ITIL and Why Should You Care?"

ITIL stands for "IT Infrastructure Library"; it consists of a set of practices and guidelines for standardizing IT practices. This presentation will start with an overview of some of those practices and discuss how they can affect your daily life as an database developer, DBA, server administrator or practitioner of another IT discipline. It will also include a discussion of commercial software products available for ITIL implementation and a demonstration of one such product (but without marketing hype).

Leslie Tierstein is Manager of Knowledge Services for newScale, Inc, a provider of Catalog and Portfolio Management software located in San Mateo California. Before joining newScale she accrued many years of experience as an Oracle developer and technical project manager. She is an experienced presenter, having presented at conferences such as NYOUG, ODTUG, IOUG, and RMOUG, and the technical editor of several Oracle Press books, including Oracle JDeveloper 10g Handbook and Oracle Designer Handbook.

Back to Top

September 2009 General Meeting

• Keynote

• DBA Track

• Development Track

Storage is no longer a “black box” to store data. New advances fundamentally change Oracle-based environments. When Oracle databases get large it becomes impossible to backup, recover, provision, and replicate according to business needs without the right architecture and solutions in place. This presentation discusses the trends and new technologies in storage related to Oracle and answers the questions:
• How can you backup and recover multi-terabyte databases in minutes?
• How can you provision a new copy of production in minutes while saving 90% storage?
• How do the features of disk-to-disk backup, virtual tape libraries (VTLs), storage-based replication, RAID-DP, aggregates, de-duplication, and tiered storage architectures change the playing field?
• What are the different types of snapshots available?
• Where do RMAN and hot backups work; where do they fall short; how can they be integrated with storage solutions?

Ari Kaplan is one of the world's leading authorities in the technology and database fields. Kaplan is a past President of the Independent Oracle Users Group (2005-2008). Educated at the elite California Institute of Technology, he is a recipient of their "Alumni of the Decade" award for the 1990's. Kaplan gained broad recognition in the IT marketplace as CEO /CTO of Expand Beyond Corp, a market leader in the database and server management market. Kaplan has experience in architecting, implementing, and supporting large-scale applications and back-end technologies.

Back to Top

DBA TRACK: Ghost Data & Spectral Data – When is Encrypted Data Not Encrypted?

A posting on the Internet mailing list Oracle-L raised an interesting situation, namely the existence of two types of data of concern to DBAs: ghost data and spectral data. During the lifetime of a table, data may become fragmented, re-arranged, sorted, copied and moved within the table space leaving “ghost copies” within the database file.” I coined the term “spectral data” to explain the case where the data ends up in a different tablespace. Worse yet, because of the way spectral data gets written, decrypted data gets written to a different tablespace! The presentation will demonstrate both types of data and discuss how to avoid the possible ensuing problems caused.

Jonathan Intner is an Information Technology professional who derives business value from optimizing the use of database technologies. He has been working with Oracle for more than 20 years, having started with 5.1.22 on VMS.

Back to Top

The concept of using connection pools involves keeping a limited number of persistent sessions that serve incoming requests on “first-in/first out” basis. This strategy can be applied to some of the most critical issues (both client/server and N-tier) currently faced by existing database system technologies. However, despite handling old problems effectively, the use of connection pools introduces some new ones. This presentation discusses some core use cases implementing connection pools and including the topics of resource utilization, effective session management, read/write consistency etc. Real-life examples will be included to pinpoint common hidden traps.

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

Oracle UM4DB is tool for managing users in heterogeneous database environment. It is designed to provide fast manageability and control over database accounts. UM4DB increases operational efficiency, decreases costs, improves the end user experience, enhances security, and reduces the effort and cost of proving compliance for your databases. This presentation describes how UM4DB can help automate the full lifecycle of users in multi-database environments.

Kevin Moulton, CISSP, is a Senior Sales Consulting Manager for the Oracle Corporation, managing a team of security consultants in the Northeast. He has been in the security space for over 20 years, and with Oracle Corporation for the last 3. Before joining Oracle, Kevin was the Director of Professional Services for Business Layers, the Director of Provisioning Technologies for Netegrity, and a Senior IDM Solution Architect for HP.

Back to Top

This presentation will demonstrate how to use external tables with the ORACLE_DATAPUMP access driver to move Terabytes of data in a timely fashion between 10gR2 RAC databases with data files residing on ASM, on different platforms, and in different locations. Other methods to move data across platforms are also discussed.

Tao Zuo is a Senior Production DBA who has experience with Oracle databases from 7.3 to 10g, including a Hybrid RAC database of 30+ Terabyte. He is also an Oracle Certified Professional with a Masters Degree in Computer Science.

Back to Top

Building an APEX application is quite easy to do. However, customizing it for Web 2.0 to provide a great end-user experience means that JavaScript is the way to go. Many people do not utilize the built-in capabilities of APEX to enhance their applications. This presentation shows how to use the most common and some of the less known functions to raise an application to the next level.

Josh Millinger is the Founder of Niantic Systems, LLC, a Princeton, NJ-based consulting/development firm. He worked at Oracle for 11 years serving the partner community as their technical liaison. He currently focuses on Application Express development and related technologies..

Back to Top

This presentation explains and shows what kinds of development methods will use and the types of code you will write when developing a web application using the Application Development Framework (ADF) in JDeveloper 11g. It focuses on the work needed to create an application with the Fusion technology stack, which Oracle is using to build its next version of Oracle Applications – Oracle Fusion Applications. In addition, this presentation provides guidelines for how much you need to know about the various languages used with these technologies: Java, JavaScript, XML, HTML, Expression Language, and Groovy.

Peter Koletzke is a technical director and principal instructor for Quovera, in Mountain View, California, and has over 24 years of industry experience. Peter has presented at various Oracle users group conferences more than 240 times and has won nearly a dozen awards including NYOUG's Editor's Choice (2005 and 2008). He is an Oracle Certified Master and Oracle ACE Director as well as co-author of seven Oracle Press books about Oracle development tools.

Back to Top

This technical session presents step-by-step the activities and deliverables related to Enterprise Architecture Modeling, which includes: defining a vision architecture, business architecture, information systems architecture (data and applications) and technology and solutions architecture. Real examples from the financial and telecommunications industries will be shown, as well as guidelines to implement the governance strategy and architecture change management process.

Mauricio Naranjo is an Oracle ACE Fusion Middleware Director, specializing in IT Governance and Enterprise Architecture. He is an ITIL v3 Certified Professional and Oracle SOA Architect Certified Expert. He is the co-author of the book, Oracle 9i Java Programming (Peer Information). Over the past 12 years he has architected, designed and implemented enterprise solutions and business transformation plans for more than 60 banks, financial institutions and government agencies. Mauricio is a frequent presenter at different Oracle seminars including ODTUG, Chilean Oracle Users Group, Peru Oracle Users Group and Independent Oracle Users Group.

Back to Top

June 2009 General Meeting

• Keynote

• DBA Track

• Development Track

This presentation will discuss some of the important challenges and how to overcome these challenges while upgrading to Oracle Database 11g. Topics like SQL plan management and real application testing will be covered.

Ashish Agrawal has been working in the Information Technology field for more than 15 years, including the last 8 years with Oracle Support Services in different roles. He currently works as a Senior Principal Technical Support Engineer with the Oracle Center of Excellence. He is an Oracle Certified Professional (OCP 11g, 10g, 9i, 8i, 7.3.4) who specializes in Oracle Database Administration, performance tuning, Database upgrades, and systems architecture. Ashish holds a Bachelor of Engineering Degree in Electronics Design and Technology from Nagpur University, India.

Back to Top

DBA TRACK: Get More for Less: Enhance Data Security and Cut Costs

The faltering economy has not slowed the alarming rate of attempted and successful data theft. This session will review in detail the different options for data protection strategies in an Oracle environment and answer the question “How can IT security professionals provide data protection in the most cost effective manner?” The presentation includes anonymous case studies about Enterprise Data Security projects at several companies, including the strategy that addresses key areas of focus for file and database security in an Oracle environment. The session will also present methods to protect the entire data flow across systems in an enterprise while minimizing the need for cryptographic services. This session will also review approaches to protect the data that are based on secure encryption, robust key management, separation of duties, and auditing.

Ulf Mattson created the initial architecture of Protegrity's database security technology, working closely with Oracle R&D, creating several key patents in the area of database security. His extensive IT and security industry experience includes 20 years with IBM as a manager of software development, and a consulting resource to IBM's Research and Development organization in the areas of IT Architecture and IT Security. Ulf holds a degree in electrical engineering from Polhem University, a degree in Finance from University of Stockholm and a master's degree in physics from Chalmers University of Technology.

Back to Top

DBA TRACK: DBA Best Practices: A Primer on Managing Oracle Databases

Database administration does not have to be challenging, if done right. This session discusses best practices that are vital to good database management while debunking many myths that are prevalent today. Topics include database configuration, space management, performance tuning, and backup and recovery for Oracle Database 10g and 11g.

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 13 years of experience working with Oracle databases and is currently senior director of product management in Oracle’s Server Technologies division

Back to Top

DBA TRACK: A Comprehensive Guide to Partitioning with Samples

This presentation discusses partitioning options for each currently available Oracle version, in particular Oracle11g. The focus is on implementing the new partitioning options available in 11g, while enhancing performance tuning for the physical model and applications involved. The presentation covers both middle-to-large-size and VLDB databases with significant implications for consolidation, systems integration, high-availability, and virtualization support. Topics covered include subsequent performance tuning and specific application usage such as IOT-partitioning and composite partitioning choices.

Anthony D. Noriega is a computer scientist and IT Consultant, OCP instructor and Adjunct Professor, 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 holds an MS Computer Science from NJIT, where he was also a doctoral candidate in the same field, an MBA from Montclair State University, and a BS in Systems Engineering from Universidad del Norte (Barranquilla, Colombia). He has been a Senior Consultant for several financial and industry-leading American and European corporations.

Back to Top

DBA TRACK: Migrating Database Character Sets to Unicode

To meet the needs of globalization, more and more companies are facing the challenge of migrating their existing database character sets to Unicode. Not understanding the issues and proper steps necessary to achieve this migration can lead to problematic outcomes. This presentation will show how to use csscan and csalter to convert database character sets to Unicode. It will also cover some of the issues, options, and resolutions that may be encountered during implementation.

Yan Li has been working with Oracle products for over 15 years as a DBA for different companies. She has been a member of NYOUG and benefited from her association with the group for many years. This is her first public presentation.

Back to Top

Oracle Data Mining, an Option to the Oracle Database EE, rapidly sifts through data to identify relationships, build predictive models, and discover new insights for many business and technical problems including: predicting customer behavior, finding a customer's next-likely-purchase, detecting fraud, discovering market basket bundles, developing detailed profiles of target customers, reducing warranty costs, and anticipating churn. This presentation will include an overview of data mining concepts and Oracle Data Mining features interspersed with several "live" demonstrations of ODM used as a "tool" and embedded inside Applications to make them Powered by Oracle Data Mining.

Charlie Berger is the Senior Director of Product Management, Data Mining Technologies at Oracle Corporation and has been with Oracle for ten years. Previously, he was the VP of Marketing at Thinking Machines prior to its acquisition by Oracle in 1999. He holds a Master of Science in Engineering and a Master of Business Administration from Boston University as well as a Bachelor of Sciences in Industrial Engineering/Operations Research from the University of Massachusetts at Amherst.

Back to Top

While data masking has become a popular control over confidentiality exposures in development and testing systems, implementing a sustainable program in a modern enterprise environment can be challenging, both organizationally and technically. This session recounts stories from the field of data masking in financial services corporations and reviews one vendor's most valuable lessons learned.

Ilker Taskaya is a data masking practice manager at Axis Technology, LLC specializing in financial services data security solutions. He manages the data masking solution offering for Axis, including services delivery and product development. Prior to 2006, he consulted in data warehousing for clients in financial services, insurance, and health care. Ilker began his career 15 years ago as a database analyst.

Back to Top

Oracle Application Express (Oracle APEX) is a robust, scalable and secure web application development and deployment tool that takes full advantage of the Oracle database. So when Oracle decided to build a new online store, Oracle APEX was the perfect choice to get up and running quickly. This presentation provides an overview of the techniques and processes employed in the development of the Oracle Online Store user interface. The live demonstration will walk to audience step-by-step through the creation of a new user interface design using Photoshop, deriving HTML mockups from the Photoshop files and converting the static HTML files into XHTML-compliant Oracle APEX themes and CSS style sheets.

Marc Sewtz is a Software Development Manager for Oracle Application Express in the Database Tools Group, part of the Oracle Server Technologies Division. Marc has over 15 years of industry experience, including roles in Consulting, Sales and Development and joined Oracle in 1998. Marc manages a global team of Oracle Application Express developers and product managers and is responsible for Oracle Application Express product features such as Oracle Forms to Oracle Application Express conversion, the Oracle Application Express Reporting Engine, Tabular Forms, PDF printing and the integration with Oracle BI Publisher. Marc has a Masters degree in Computer Science from the University of Applied Sciences in Wedel, Germany.

Back to Top

You need a VARCHAR2 field to hold data for a variety of purposes, e.g., for an extract, summary or generic view, perhaps as a base for a report or a foreign data import. How do you figure out an optimum length for that field/column, as well as determine how much data you can stuff into it? Unlike MS Excel/Access, table columns cannot "expand" (no matter the software, there are limits). How do you determine an optimum length for a field / column? How do you handle any exceptions? This presentation provides examples and ideas using statistical "analysis of variance" (ANOVA) principles to answer these questions.

Suzanne Michelle has been working with databases, database structures, and system interfaces since 1981 when she taught her MBA fellows how to use VisiCalc. She created her first relational system with Lotus123 in 1986 that fit on a floppy. Suzanne now works for NYC Transit where she created (in 1995) and still manages (and finds challenging) the "Unified General Order System" by which NYC Subways plans and manages track access work. Subway riders see the tip of the planning iceberg via Service Change signs fed by the Oracle 10g database (with a Forms6i front end) that Ms. Michelle and her colleagues design and support.

Back to Top

March 2009 General Meeting

• Opening:

  • Click to hear the President's opening remarks: March 2009 Opening Remarks.mp3

  • Opening Presentation
     

• Keynote

• DBA Track

• Development Track

March 2009 Keynote.mp3

This presentation will look at which 11g new features should be investigated for use. There will be simple examples to show the basic functionality of the following new features:

• Memory Target
• Partition Advisor
• Security Enhancements
• DDL Lock Timeout
• The Invisible Index
• Automatic Diagnostics Repository
• SQL Plan Management
• Real Application Testing (Workload Capture and Replay)
• SQL Repair Advisor
• ADDM Enhancements • Interval Partitioning
• Optimizer Enhancements

Richard J. Niemiec
In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master , one of the first six so recognized around the world. In 2007, Rich authored Oracle10g Performance Tuning Tips & Techniques, a follow-up to Oracle9i Performance Tuning Tips & Techniques that he wrote four years earlier. Rich is 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 the MOUG Newsletter. Rich has delivered hundreds of lectures about Oracle technology to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has also conducted numerous expert class presentations at OracOpenWorld and other major shows.

Back to Top

DBA TRACK: Tuning the Oracle Grid

This presentation will discuss the top ten tips when tuning your architecture for grid computing. Oracle has come a long way from when clustering was introduced. The tools continue to improve and the installation continues to get better and easier. This presentation will show many Grid Control screen shots so attendees can see the depth of the product. Topics to be covered are:

1. Know the basics; Introduction to RAC

2. Oracle Direction

3. Market direction - Consolidation

4. Grid Basics - Start with RAC

5. Grid Basics - Scaling it

6. Interconnect and block coordination

7. Tuning quick tips using Statspack & AWR Report

8. Use Grid Control to monitor

9. Grid Control for Multi-Node Systems

10. Use Grid Control to tune systems

See bio for Rich Niemiec above.

Back to Top

DBA TRACK: Honey, I Shrunk the Data Warehouse!

This presentation will examine use of the Oracle Database compression features to help shrink the size of data warehouses. Shyam will discuss SecureFiles used to reduce the storage needs for unstructured data. To complete the full solution, it is necessary to compress the metadata, dump files during the export using the Data Pump, and backup files. The last piece of the puzzle is the compression of data in motion over the network such as the redo logs. Some live examples and a case study of quantitative benefits on the compressed data alongside the uncompressed data will be shown. Examples of table/partitions, materialized view, and index compression will also be discussed along with the impact of compression on regulatory compliance and how this can help to achieve the industry-specific goals of increased retention of data in a tamper-proof environment.
 
Shyam Varan Nath is an Oracle BIDW professional with over 18 years of industry experience. Shyam is a part of Deloitte’s BI practice and formerly worked for Oracle Corporation’s BI consulting practice. Shyam is the founder of the BIWA SIG and is a regular speaker at NYOUG, Oracle OpenWorld, IOUG Collaborate, BIWA, ODTUG, and other regional user groups. He is a Certified DBA with hands-on experience in Data Warehouse architecture, OBIEE implementations, database tuining and optimization. He has worked on large data warehouse implementation projects. Shyam was awarded the Oracle IOUG Contribution Award in 2007.

Back to Top

DBA TRACK: Tuna Helper - Proven Process for Tuning SQL

Many DBAs and developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: indexing strategies, use of histograms, SQL wait event data, column selectivity and several more that will help you succeed on future tuning projects.

Dean Richards has over 20 years of Oracle project development, implementation and strategic database architecting experience. Before coming to Confio, Dean held engineering positions at McDonnell Douglas and Daugherty Systems - an Oracle solution provider. Dean was also a technical director for Oracle Corporation managing all aspects of key telecommunications accounts including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Dean has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

Back to Top

DBA TRACK: Advanced Performance Diagnostics: What the GUI Doesn’t Show You

The presentation will review "Performance Methodology", "Review - AWR versus ASH", a few interesting reports, mining your data and a Case Study. Using Enterprise Manager it will be shown how to tune your system for a given workload, identify operations consuming most DB Time, identify resource/capacity related bottlenecks and how to reduce “DB Time” consumed for the workload.

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 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 presented at NYOUG, NJOUG, IOUG, ODTUG, SEOUC and Oracle OpenWorld.

Back to Top

Oracle’s free developer tools, SQL Developer and Application Express (APEX) can provide Oracle Applications developers with quick and easy reports designed for multiple platforms and multiple audiences. This presentation will show how to successfully build a free APEX-based, fast, and effective reporting environment and how to make reports BlackBerry accessible. Attendees will learn how develop sophisticated multi-platform (Web and BlackBerry) reports using Application Express and SQL Developer against an Oracle Apps 11.5.10 environment.

Brian Caunitz has been working with Oracle Applications for the last ten years as a DBA/Developer at Oracle Consulting, UPS and most recently, illy caffè North America. He has a B.S. in Computer Science from Siena College

Back to Top

DEVELOPER TRACK: Oracle Fusion Middleware - Tales from the Trenches

The Oracle Fusion Technology stack is large and complex, encompassing many components. Some parts are free or nearly so such as JDeveloper, whereas other portions carry large licensing fees (WebCenter). What portions of the Fusion Middleware stack are organizations really using? How have their projects fared so far? This presentation will discuss the results of a number of projects from organizations that are using one or more parts of the Fusion Middleware technology stack. This presentation describes the results of a semi-formal survey where I interviewed some of the leading Fusion Middleware developers and ask them about their projects. Since the results are anonymous, the appraisals of the technology are candid.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul has co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle ACE Director, SELECT Associate Editor, ODTUG Symposium chairperson, past IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year. Paul can be contacted at paul_dorsey@dulcian.com

Back to Top

As important as it is, security is almost always added to an application as a last step, if at all. Designing your APEX application with security in mind is critical and should not be overlooked. This session will discuss how to build secure APEX applications from the ground up so that a hacker cannot exploit them. Josh will also discuss how to segment functionality inside of an APEX application so that only authorized users can perform specific tasks. The presentation includes information about what can be done to secure the underlying data of an APEX application and outline a list of things that need to be secured in an installation of APEX, as well as the associated infrastructure components.

Josh Millinger is the President of Niantic Systems, LLC which he co-founded with Raj Mattamal in 2007. Josh focuses on delivering complex APEX applications to customers across verticals in the Higher Education, Healthcare and Commercial arenas He has Computer Science degrees from UW-Madison and Johns Hopkins University.

Back to Top

Many times during a project life cycle, new technology is introduced that presents first time challenges. This presentation includes information about a project using Oracle 10g XML DB. The presentation will discuss why XML DB was chosen, how XML DB was used and technical issues encountered. Coleman will provide several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Additionally, namespace examples and an introduction to XML Schema Definition (XSD) will be presented.

Coleman Leviter is an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG's Collaborate 07 and 08. He is the NYOUG Web SIG chair and sits on the Steering Committee. He has worked in the financial services and aerospace industries where he developed Navigation, Flight Control and Reconnaissance software for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester Institute of Technology, an MBA from C.W. Post and an MSCS from New York Institute of Technology. He has recently completed OCP (Oracle Certified Professional) training. He can be contacted at cleviter@ieee.org

Back to Top

December 2008 General Meeting

• Keynote

• DBA Track

• Development Track

We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. In this keynote presentation, Steven will offer an intensive coding therapy session to help all attendees come to grips with their innate, unavoidable "issues," making it easier to write better code -- and help others on their team write better code.

Steven Feuerstein, one of the world's leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 15 years and serves as PL/SQL Evangelist for Quest Software.

Back to Top

This presentation discusses the standard and custom settings to size the Large Pool in conjunction with desirable outcome affecting backup size and duration. The speaker discusses a comparison between Oracle recommended values for the Large Pool and the specific effect of sizing the Large Pool with different values, and the outcome affecting the size of backup pieces, overall backup size, and overall backup and restore turnaround time. Several case studies will be included.

Anthony D. Noriega is a computational scientist and IT Consultant, OCP instructor, and Adjunct Professor, who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN/ebPortal, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony holds an MS Computer Science from NJIT, where he was also a doctoral candidate in the same field, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a Sr. consultant for Oracle University, IBM, AT&T, Bowne, Canon, Time, and Deutsche Bank.

Back to Top

DBA TRACK: Oracle Exadata - Extreme Performance

Data warehouses are tripling in size every two years and supporting ever-larger databases with ever increasing demands from business users to get “answers” faster requires a new way to approach this challenge. Exadata is the new hardware/software solution from Oracle targeted primarily at the data warehousing market. Oracle Exadata overcomes the limitations of conventional storage by utilizing a massively parallel architecture to dramatically increase data bandwidth between database and storage servers. This session will examine these limitations and demonstrate how Oracle Exadata delivers extremely fast and completely scalable, enterprise-ready systems.

Graham Wood is an architect in RDBMS Product Development at Oracle in Redwood Shores. After working in performance related areas for many years creating Statspack, ADDM, AWR amd ASH, Graham now works in the RDBMS Product Management group.

Back to Top

DBA TRACK: Take the Guesswork out of SQL Performance with SPA

Businesses want systems that are predictable, performant, and meet service-level agreements. However, SQL performance regression is the key cause of poor and unpredictable database performance. In this session, we will describe how you can demystify the working of the Oracle query optimizer and eliminate the unpredictability in SQL performance by using SQL Performance Analyzer (SPA), a feature of Oracle Database 10g and 11g. We will discuss the internals of SPA as well as best practices for its usage.

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: Faster Cross-Platform Database Migration with RMAN

You can always move a database from one operating system to another with DATAPUMP or EXPORT and IMPORT, but these methods are time consuming. You can reduce the time needed to convert the datafiles by up to 88% or more when you use RMAN to parallelize the datafile conversions. There are some challenges with some versions of Oracle, but there are ways around these issues. Based on Oracle documentation, you might even get away with converting only a fraction of all the datafiles in the database. Attendees will learn some basics about RMAN, understand cross-platform migration issues, and learn to be flexible with Oracle tools.

John Larkin has worked as a DBA for the last 23 years, the last 15 with Oracle. He works for a major financial services company in Delaware and is currently working on a project to migrate 30 databases from AIX to a Veritas-clustered Solaris environment.

Back to Top

DEVELOPER TRACK: Automated Testing Options for Oracle PL/SQL

We all know we should test our code more thoroughly, but who has the time and patience, and isn't our code "good enough" anyway? Did you know that that is widely accepted that if you have a program of 500 lines, you should expect to write 5000 lines of test code? Ah, so that's why we don't test our code! If you are not satisfied with the number of bugs in your code or if you sometimes find yourself embarrassed demonstrating your software to users, then attend this session to learn how you can automate the testing process, reduce bugs in your code, and increase confidence in your applications. This session reviews the tools, from open source to commercial, that offer varying levels of testing automation.

Steven Feuerstein, one of the world's leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 15 years and serves as PL/SQL Evangelist for Quest Software.

Back to Top

DEVELOPER TRACK: Introduction to Java - PL/SQL Developers Take Heart

If you know PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. It provides an overview of the language; reviews the concepts of object orientation; and describes the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables.

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 24 years of industry experience. Peter has presented at various Oracle users group conferences more than 230 times and has won numerous user group awards He is an Oracle Certified Master, Oracle Fusion ACE Director, and coauthor with Dr. Paul Dorsey, Avrom Roy-Faderman, and Duncan Mills of seven Oracle Press Books about Oracle development tools.

Back to Top

DEVELOPER TRACK: Advanced Report Printing with Oracle APEX

This session will provide an overview of the printing capabilities built into Oracle Application Express (APEX), discuss some of the printing enhancements introduced in APEX 3.1 and include a live demonstration of how to create custom RTF report templates. The presentation will also show charts and images and utilize the print API for scheduled generation and emailing of reports.

Marc Sewtz is a Software Development Manager for Oracle Application Express (APEX) in the Oracle Database Tools Group and is based on New York City. Marc manages a global team of APEX developers and product managers and is responsible for APEX product features such as Oracle Forms to APEX conversion, the APEX reporting engine, tabular forms, PDF printing and the integration with Oracle BI Publisher.

Back to Top

DEVELOPER TRACK: Forms Roadmap for Traditional Developers

This presentation discusses the evolution of Forms to meet the demands of customers and, in particular, for Forms to successfully integrate and join with the arrival of Web-based applications. Oracle has an updated plan (just released, October 2008) to integrate Forms into Web application architecture. Attendees of this presentation will get the most clear statement to-date of this plan. The extraordinary benefits of using an upgraded Forms deployment in a Service Oriented Architecture are the drivers behind the Oracle "Upgrade and Integrate" strategy for existing Forms deployments. The Oracle Application Server is highlighted as the central product platform chosen by Oracle as part of their strategy to unify Forms with newer Web-based services and SOA.

Gil Standen is Managing Partner of Stillman Real Consulting LLC, and more recently, joined the company founded in 1988 by Rich Niemiec, Joe Trezzo and Brad Brown, the well-known TUSC, in Chicago, where he has been a Senior Consultant for the past year. The author has supported a wide range of Oracle RDBMS and application products as a result of his wide-ranging consulting support of Fortune 50, government, and startup clients for many years. Gil has presented at local and national venues including several NYOUG general meetings and at the Australian National Conferences "Oracle with 20:20 Foresight" in both 2005 and 2007.

Back to Top

September 2008 General Meeting
NYC Metro Area User Group Meeting

• Opening Slides

• Keynote

• DBA Track

• Development Track

The technical decisions we make are based on things we know. But how did we get to know what we know in the first place? Did we learn it from trusted advisors? Technical forums? Experience? Word of mouth from peers? More importantly, how does the way we learned what we know affect the decisions we make every day? This presentation attempts to answer these questions.

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programming (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

Back to Top

A lot of time is spent by IT professionals studying best practices in the industry. This presentation turns that around and takes a look at some "worst practices," or the top things you can do to ensure failure, delays, and poor performance in your database applications. Instead of focusing on things to do in your database applications, the presentation looks at things you should never do. The presentation uses actual customer experiences to investigate the top 10 things done wrong over and over again, and how to avoid making the same mistakes yourself.

Tom Kyte is a Vice President in Oracle's Public Sector division (see full bio above)

Back to Top

Storage design and configuration in Oracle RAC environments are consistently the most challenging components in an Oracle RAC rollout. Attendees will learn about core storage concepts, how they apply in RAC environments, RAC-specific technologies, performance and availability considerations including examples of how real-world environments are leveraging them. The goal is to provide DBAs with enough information to make informed decisions to plan for storage in RAC environments, while providing a strong platform to continue learning on their own through experimentation.

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, he worked at EMC, where he designed and implemented a variety of storage infrastructures. Prior to joining EMC, Zito served as Infrastructure Architect at Register.com, where he pioneered the use of centralized management and automation.

Back to Top

So you have heard about partitioning but don't know where to start, or you are familiar with it, but want to double check your design. In this session, Arup will explain when to partition tables and indexes, which partitioning options to choose depending upon the problem you are trying to solve (purge, performance, archival, backup, etc.), potential issues to watch out for, and so on. This presentation will NOT describe the syntax and commands for partitioning, but rather discuss how to decide which partitioning scheme to choose. The presentation also includes information about Oracle 11g.

Arup Nanda has been an Oracle DBA for more than 14 years. He is the lead global DBA at Starwood Hotels. An author of many articles and four books, he was awarded the Oracle DBA of the Year distinction in 2003.

Back to Top

This presentation discusses and demonstrates the methods for passively capturing, analyzing, and reporting the details of Oracle network traffic in real-time for use in end-to-end Oracle tuning and troubleshooting scenarios. At the end of this session, participants will gain a better understanding of the Oracle Network Protocol, learn how to detect network-related issues and be able to diagnose and solve network-related issues

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.

Back to Top

Attendees will gain insight into what is important to keep their database(s) up and running. Many errors encountered do not affect service; the trick is to pay close attention to a handful of issues that could affect database availability. This presentation focuses on a small set of errors that, if not trapped, can lead to application outages. Initiating a database connection, with/without SQL*Net, and aggressive detection of looming space deficiencies are at the heart of smart database monitoring. Michael’s mantra of paging the DBA is simple: “If it cannot and need not be fixed at 3AM, why would/should anyone be paged?”

Michael Abbey is a recognized authority on database administration, installation, application migration, performance tuning, and implementation. Working with Ian Abramson and Michael Corey, he has co-authored 16 books for McGraw-Hill's Oracle Press Series, including most recently: Oracle Database 11g: A Beginner's Guide. Active in the international Oracle user community, Michael is a frequent presenter and keynote at many user group events.

Back to Top

Oracle Database 10gR2 has continued to expand upon its extensive table partitioning capabilities, providing an arsenal of weapons targeting Very Large Data Warehouse (VLDW) environments. Major partitioning schemes such as Range, Hash, and List have provided architects of very large databases with the tools to effectively reduce search space size against large fact tables. In addition, indexing techniques such as bitmap partitioning (bitmap and btree), bitmap-join, and function-based, provide the ability to address high cardinality plans written against large fact tables with precise lookups. However, even with these robust capabilities, the problems of vulnerability for the very large data warehouse query space persist. This presentation will describe a method for eliminating this vulnerability using the technique of Virtual Partitioning.

Brian Dougherty is Chief Architect of Business Intelligence for CMA Consulting. He was lead architect for the 1999 Data Warehouse Institute's Best Practice award winner in the Very Large Data Warehouse Category. His solutions have been nominated or selected for various other national awards in the Oracle and Data Warehousing fields.

Back to Top

This presentation demonstrates techniques to analyze Automatic Workload Repository (AWR), and by extension, Statspack, reports to find problem areas, isolate bad SQL, and determine system memory settings. Using AWR data for trending will also be discussed. The use of wait time analysis, I/O timing analysis and memory trending will be shown using actual client AWR reports (names changed to protect the innocent).

Mike Ault has been working with Oracle since 1990 as a DBA, developer and manager. Mike is a frequent presenter at conferences at all levels and has written many Oracle books, articles and webcasts. Mike works as the Oracle Guru for Texas Memory Systems.

Back to Top

Threat trend data clearly shows an increase in breaches focusing on confidential information. The Information Security industry has now acknowledged that the enterprise perimeter is easily penetrable. Data leakage from structured and unstructured sources is a major pain point for organizations. A successful information protection strategy requires building layered controls, starting from the inside, closest to the data and must include compliance to baseline configuration, aggregated and correlated event monitoring from host, databases, network, and applications. This presentation explains the key challenges of database security and offers a pathway for establishing a strong strategy for accomplishing comprehensive database security.

Ajoy Kumar is a Security Manager at DTCC and has a deep interest in database and application security issues. He was a DBA for over 13 years prior to moving into the Information Security area.

Back to Top

This presentation demonstrates the highly-automated process of creating RIA using several Eclipse plug-ins. The first plug-in generates a CRUD application with Adobe Flex talking to POJO on the server, which in turn communicates with a DBMS. A second plug-in generates an ANT build script for this application. The third plug-in adds logging capabilities. Finally, Yakov will create and customize a fancy report based on the retrieved data. He will annoy you with not more than five PowerPoint slides and spend the rest of this presentation developing the application described above.

Yakov Fain is a managing principal of Farata Systems, a consulting, training, and product company. He has authored several Java books and dozens of technical articles including “Rich Internet Applications with Adobe Flex and Java: Secrets of the Masters.” Yakov was nominated for and awarded the Sun Microsystems title “Java Champion.” He also leads the Princeton Java Users Group.

Back to Top

Traditional perimeter network security is not sufficient to defend against dynamic threats to applications already residing on enterprise systems and accessible over the Internet. Web-accessed databases are especially susceptible, partially because of the appeal of their lucrative repositories of customer and sales data, and partially because IP entry affords hackers a broader range of methods with which to invade and gain access to database information. This presentation describes some of the sophisticated methods used in invading enterprise databases and proposes essential steps IT managers can take to securely install and configure databases to guard against malicious breaches. The session will also provide guidelines and best practices on how businesses can secure databases against unauthorized access.

Aaron Ingram is the author of Practical Oracle Security: Your Unauthorized Guide to Relational Database Security. He has fifteen years experience developing enterprise software, focusing on database systems and security applications. Most recently, Aaron merged his extensive database background with his security skills to manage the development of Application Security's real-time database intrusion detection and security auditing solution, AppRadar.

Back to Top

Sluggish web pages with poor refresh rates have become the new “industry standard.” Well designed web applications can provide performance that is just as fast as their older client/server counterparts, but this requires a rethinking of application tuning strategies. Poorly performing web applications are rarely or only marginally improved by tweaking the database and tuning the SQL statements. Instead, the focus of tuning activities must shift to minimizing data transmission from the application server to the database and from the database to the client. Both the amount of data transferred and the number of roundtrips must be minimized. This presentation will discuss techniques that can be used to identify and resolve many common performance issues that arise when developing web applications.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle ACE Director, SELECT Associate Editor, ODTUG Symposium chairperson, past IOUG and ODTUG volunteer of the year, ODTUG 2007 Speaker of the Year (Topic & Content) and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year.

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

This presentation includes an end-to-end case study of Business Intelligence using the Oracle BIWA technology stack. It describes how a quick implementation can be done in a retail setting using Oracle components like OWB, Oracle Data Warehouse, OLAP, Data Mining and OBIEE in combination with Retail Industry Reference Data Model. Such BI accelerators allow faster implementations with reduced risk for the companies. This presentation discusses each of the technology layers and how it integrates with the other layers including a peek into the underlying data model, analytical model, and the workings of the advanced analytics that empower the end-user experience. The presentation will showcase all of the components in a demo to present the end-to-end solution stack.

Shyam Varan Nath is a hands-on DBA and Data Warehouse Architect, with over 17 years of experience. He has been an OCP since 1998 on 4 different Oracle RDBMS releases. He is President and Founder of the Oracle BIWA SIG (http://OracleBIWA.org) and winner of the Oracle Contribution Award 2007. Shyam was part of Oracle's BI and Advanced Analytics practice and now is a consulting Manager at Deloitte Consulting.

Forrest Snowden is a Sr. Mgr. at Deloitte Consulting with over 20 years of DW/BI experience. He specializes in high-level EDW architectures; defining client roadmaps; data encryption/fraud, BI Governance and data validation. Forrest won the 2002 NACHA Award for best design of an ACH system and led the design of the United Way of NYC Sept. 11 Website which processed over 500 payment transactions/sec collecting over $100MM in donations on a pro bono basis.

Back to Top

Debugging Application Express can be a conundrum. It's PL/SQL, but you can't step through it. View Source doesn't cover it. How does one know what is happening when, with what? This session will demonstrate a few options for tracking down APEX issues: APEX-supplied views and reports, the APEX debug session information, the Web Developer Toolkit, an overview of JavaScript debuggers, and remote debugging using SQL Developer to help resolve most APEX debug challenges.

Karen Cannell is a Principal with Integra Technology Consulting and editor of the ODTUG Technical Journal. She has analyzed, designed developed, converted, enhanced and otherwise tweaked database applications for over 22 years, focused on Oracle since 1994. Recent focus includes design and development of ETL processes, Application Express, Oracle Business Intelligence and migration of legacy applications to web technologies, leveraging the Oracle 10g/11g suite of tools.

Back to Top

This presentation will discuss the value difference between comparative infrastructures for Oracle solutions. Attendees will learn about "best practices" for sizing and implementing an advanced I/T Infrastructure for Business Intelligence and Data Warehousing Solutions with Oracle Database 11g.

Rick Kearns is a Solutions Consultant for IBM Systems and specializes in I/T infrastructure optimization for Oracle Solutions. With a long history at IBM, he has worked with hundreds of Oracle clients across North America to select and design infrastructures for Oracle projects.

Anirban Chatterjee is an IT Specialist at the IBM Executive Briefing Center in Austin, Texas. His primary role is to create and provide demonstrations of strategic POWER and AIX technologies to customers, industry analysts, press, and investors, both within the Center and around the country. Prior to his current assignment, Anirban developed firmware for IBM's POWER-based servers.

Back to Top

Attendees will learn how to create collections in Oracle, and how to use/interact with them in PL/SQL, SQL, Java and .Net. The presentation will include practical advice about when (and when not) to use this functionality. Debugging hints, a comparison of the solution discussed with a more traditional database implementation and the impacts on the database will also be discussed.

Travis Rogers is a Senior VP of Database Development for CDG Management LLC with over 15 years of software development experience including 10 years of Oracle development. He presented on Analytics at the NYOUG 2007 Winter General meeting.

Back to Top

Oracle Forms was. and still is. a very popular development tool, but many organizations are looking to modernize to a purely Web-based solution. Oracle Application Express, with its similar declarative nature and use of SQL and PL/SQL, has become a popular technology for Oracle Forms modernization. This presentation demonstrates the latest Oracle Forms migration tool being built directly into Oracle Application Express. Starting with the Forms Builder (.fmb) files, converted into XML, this presentation shows how you can migrate your Oracle Forms applications to Oracle Application Express applications, and generate reports, forms, tabular forms, and master-detail pages.

Marc Sewtz is a Software Development Manager for Oracle Application Express (APEX) in the Oracle Database Tools Group and is based on New York City. Marc manages a global team of APEX developers and product managers and is responsible for product features such as Forms to APEX migration, the APEX Reporting engine, Tabular Forms, PDF printing and BI Publisher integration.

Back to Top

June 2008 General Meeting

• Keynote

• DBA Track

• Development Track

KEYNOTE: Oracle e SOA Suite 11g - A Foundation Building Block for Oracle's Next Generation Fusion Applications

This session provides an overview of the upcoming SOA Suite, and introduces the concepts behind it, such as Service Component Architecture and how it simplifies the end-to-end lifecycle management of SOA composite applications. Application designers can now design, package, version, and manage their SOA composite applications (Web services, BPEL, Enterprise Service Bus flows, and the like) as one single entity, making it easily available for reuse. This session will also discuss the challenges associated with data and component integration while building Fusion applications and explain concepts needed to get ready for Fusion.

Clemens Utschig works for the SOA Product Management team at Oracle Headquarters, CA. As a native Austrian, he started his career years back at the local consulting branch, helping customers define their next generation J2EE and SOA architectures. Later, he founded the local Java Community to spread knowledge and help consulting teams with the uptake of Java for new projects. During his consulting years, he spent a year in Switzerland doing crisis management for a large scale program, in Dubai helping on ADF BC issues for the government and giving workshops all around Europe. Since his transfer some 2 years ago into the Product Management group, Clemens is responsible for cross product integration and is now the advisor for SOA to Oracle Fusion Applications development, helping to build the next generation standard software suite. Clemens is also an advisory member of the Applications Architecture Board. He is a frequent speaker at worldwide conferences (Oracle Open World, JAX, OOP, ODTUG) and has published countless articles in known industry journals on SOA and related challenges.

Back to Top

DBAs are not responsible for just databases any more. Most DBAs are also responsible for the entire production application performance including the middle-tier. Often they are challenged with the performance problems caused by the Java middle-tier. DBAs do not have enough tools to gain visibility into the production applications to identify the root cause of performance problems. To resolve performance problems, they depend on developers and architects who reproduce and diagnose the problems in the development environment. Reproducing problems in non-production environments is difficult, time consuming and increases the problem resolution time drastically.
This session focuses on diagnosing application problems in production. It shows how to diagnose database problems caused by the middle-tier and how to perform expert level Java diagnostics without much Java or application knowledge.

Rajagopal Marripalli is a principal product manager in the Oracle Applications and Systems Management division. His primary focus has been in the area of application performance management. He has more than 12 years experience in the software industry in product development and product management. He has published papers and articles as well as presented technical seminars at conferences and user groups

Back to Top

This presentation will cover some of the less obvious issues that arise while using Dynamic SQL, including: defining required privileges, preventing code injections, targeting performance tuning efforts, understanding resource utilization, handling object dependencies, etc. Examples will demonstrate when, why, and how to use Dynamic SQL in real-world situations in conjunction with other advanced features such as objects, object collections, ref cursors, and bulk operations.

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

At my organization, we make extensive use of DataGuard, including an international implementation (between two of our European locations). This presentation will describe the practical use of DataGuard focused on the differences between DataGuard and Standby databases. Time permitting, the presentation will also include a discussion of Cold Failover Clusters (aka, "a poor-man's RAC").

Jonathan Intner has been working with Oracle for over 17 years and started in the dark days before the CREATE CONTROLFILE command -- even before there were tablespaces! He is not only an Oracle Certified Professional but also a Certified Information System Security Professional and (now) ITIL V3 Foundation Certified. He currently heads the US DBA Group for one of the top generic pharmaceutical companies.

Back to Top

Oracle Real User Experience Insight (UXInsight) enables enterprises to maximize the value of their business critical applications by delivering insight into real end user experiences. It can help identify lost revenue from frustrated users, reduce support costs by lowering call center volumes, accelerate problem resolution of poorly performing applications, and help businesses adapt to changing needs by providing insight into business trends and user preferences. This presentation will explain how to manage end users’ experiences with your applications, using Enterprise Manager products, identify performance issues with your applications, as well as identify missed revenue opportunities because of end user problems.

Nadu Bharadwaj is a Principal Product Manager in the Applications and Systems Management group at Oracle HQ, with over seven years at Oracle in various roles- from Consultant, DBA, Developer and presently as Product Manager. He specializes in the areas of SOA Management and User Experience Management. He has presented at several Oracle events representing the Enterprise Manager suite of products.

Back to Top

The iBATIS Data Mapper framework makes it easier to use a database with Java and .NET applications. iBATIS couples objects with stored procedures or SQL statements using an XML descriptor. Simplicity is the biggest advantage of the iBATIS Data Mapper over object relational mapping tools. This presentation discusses how to use iBATIS with Java in an Oracle environment. It discusses topics of interests to both Java and Oracle developers.

Richard Ji is a Senior Manager, database engineering from RealNetworks. He architected databases that handle over a billion transactions per day and 27TB in size. He is also a past presenter at NYOUG on "How to Build Your own Instantclient".

Back to Top

This presentation will introduce advanced concepts of the SOA platform, from transaction handling and fault policies to usage patterns of BPEL, ESB and the service registry. The goal is to provide attendees with a solid understanding of how the transaction model in BPEL works, and how it can best be leveraged. Clemens will show how the Service Registry can be used to dynamically discover and bind to services at runtime, rather than hard-wiring the service consumer with the provider. The presentation will also discuss common usage patterns for BPEL and ESB, which is a topic often requested by those new to the platform. Finally, Clemens will include an overview of what developers can expect from the upcoming 10.1.3.4 release, what features are recommended to use it efficiently, and its new diagnostic features.

Clemens Utschig works for the SOA Product Management team at Oracle Headquarters, CA. (see full bio above)

Back to Top

This presentation discusses the desupport of Oracle JInitiator in the context of the widespread deployment of JDeveloper. The presentation references several position papers from Oracle from the summer and fall of 2007 which describe the way in which Forms will participate in the BPEL-SOA landscape. Attendees will learn how to reconfigure forms to use the generic Sun JRE instead of JInitiator, and also will be presented with a comprehensive upgrade strategy designed to leverage their existing Forms environment through use of PL/SQL wrappers for Java and through forms which can register an interest in a BPEL event.

Gil Standen is the Founder and Managing Partner of Stillman Real Consulting. Gil more recently has joined Rich Niemiec's company, TUSC, in Chicago, IL as a Sr. Consultant. Gil has 12 years experience supporting large Oracle enterprise deployments on all flavors of UNIX, Windows, OS/390 and VAX/VMS and Novell OS platforms, including all versions of Oracle beginning with Oracle 7.1.3.2.3 through 10gR2.

Back to Top

Recent updates to the Federal Rules of Civil Procedure (FRCP) have placed an increased burden on IT organizations to produce data as part of a civil or criminal “e-discovery” request. If your company received an e-discovery request today, would your IT organization have the capability to retrieve the appropriate information and supporting evidence to comply? Would you be able to meet the timeframes dictated by law and civil procedure? With the rise of the “new data center” and “paperless” application environments, most corporate data is managed electronically. Improving the way in which you manage information and being prepared for e-discovery simply makes good business sense. This presentation provides an overview of the potential challenges that new eDiscovery rules and regulations could pose for them their IT organizations. It explores best practices to support data retention and ensure compliance requirements for accessibility and production of data within deadlines, and some case studies of how others have succeeded and failed in implementing them.

Eric Offenberg, CIPP and Product Marketing Manager at IBM, has established himself as a thought leader on data governance, database archiving, enterprise data management and data privacy. With nearly 10 years of technology marketing experience across industries, Eric is a regular speaker in live Webinars, industry events and with media and analysts on behalf of IBM. He holds an MBA with a concentration in marketing from Rider University and a BA degree in communications with a concentration in public relations from Rutgers University.

Back to Top

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-time analytics. The speakers will also highlight the growing importance of real time analytics in a world where the advertising and campaigns are undergoing paradigm change due to DO NOT CALL lists, spam blockers, digital media recorders etc. This presentation will also cover how Extraction, Transform and Load (ETL) can be done in the Oracle database, leading to data for advanced reporting, analytics such as data mining, OLAP, etc. for the automation of critical decision making in a business organization which results in actionable tasks.

Richard Solari is the Senior Director of the Business Intelligence and Reporting Consulting Practice at Oracle and is responsible for data mining implementations worldwide. For more than 13 years Mr. Solari has led or contributed to dozens of statistical and data mining projects for clients which include the Internal Revenue Service, Blue Cross Blue Shield, Fannie Mae, Department of State, New York City Comptrollers Office, World Bank, Wells Fargo, Equifax, Anderson Consulting, Deloitte & Touche, MCI, Bell South, Pacific Bell, US West, British Telecom, Omnitel, and Columbia Health Care.  Project areas have included customer acquisition and retention, marketing and cross selling, network analysis, and fraud detection in the telecommunications, financial, insurance, and health care industries. 

Shyam Varan Nath is a Principal Analytical Consultant of the BI Group at Oracle Corporation. He chairs the Special Interest Group on DW & BI. He as been an OCP since 1998 (version 7.3 of database) and has presented at Oracle OpenWorld, IOUG/Collaborate, NYOUG and several other industry related events.

Back to Top

DBA TRACK: Data Pump - Not Just for Data Movement

Oracle Data Pump, introduced in Oracle 10g, has been touted as tool for data movement across databases; but it’s so much more than that. It can be used as a source code control system to achieve regulatory compliance as in SOX; to publish offline data securely; to design a better backup and archival tool, etc. In this presentation, attendees will learn about advanced operations (including performance enhancements), using external tables, enabling metadata movement, creating user objects, and creating a backup of user source code to satisfy compliance, using data pump APIs for sending data to a remote database not connected online and much more.

Arup Nanda has been an Oracle DBA for more than 12 years working in all aspects of database management from modeling to performance management and disaster recovery. He is the author of books Oracle PL/SQL for DBAs (O'Reilly 2005) and Oracle Privacy Security Auditing (Rampant 2003). He was awarded the DBA of the Year by Oracle in 2003.

Back to Top

DEVELOPER TRACK: Introducing Oracle Queuing/Messaging Technology

This presentation will introduce Oracle Queuing and Messaging Infrastructure from an administrative and development integrative perspective from the DBA viewpoint and the resource availability from the PL/SQL and Java perspectives. It will introduce concepts such as peer-to-peer and broadcasting queues. It will expand on intelligent agent and gateway architecture technologies including MQ Series streams and relate Oracle messaging technology to other technologies such as JMS and DCOM.  The transparent benefits enhancements proposed by queues on both privacy and security issues will be emphasized. In addition, the presentation will briefly discuss advanced features such as transformation mechanism and symmetric and asymmetric encryption (PKI) and introduce the Oracle Database and Architecture framework, explicitly the OPMN-based technology.

Anthony D. Noriega is a Senior Oracle Consultant and computer scientist who has focused his efforts in Oracle database technology, network computing, software and network engineering, and object-oriented programming paradigms.  Anthony spends most of his time as a database analyst, architect, and developer, and DBA. He is a Senior Oracle DBA/Developer and a member of IOUG and NYOUG.

Back to Top

DBA 101 TRACK: Reporting from the RMAN Repository

Oracle Recovery Manager provides some limited reporting with the LIST and REPORT commands, but how about answers to some of the really important questions, such as:  Can I recover to a specific point-in-time?  How long will it take me to restore and recover?  How much space are my backups taking?  This presentation will describe the both repositories used by RMAN, in the control file (i.e. NOCATALOG) as well as the "recovery catalog", and how to report from them.

DEVELOPER 101 TRACK:  Tired of Oracle's SQL*Plus? Try SQL Developer!

SQL Developer is a new, free graphical tool from Oracle that allows anyone to graphically view or change any database object. For example, you can easily see all of a table's data in a spreadsheet-like view. From the spreadsheet like view you can easily update specific fields or delete entire rows with the click of a mouse button. All this can be done without writing one bit of SQL.  SQL Developer is Oracle's answer to 3rd party products like TOAD or SQL Navigator. Participants will learn about Oracle's new SQL Developer product and see a live, full demo of SQL Developer.

Chris Grabowy is a database architect with Lockheed Martin in Valley Forge, PA.  He has over twenty years of experience in the computer industry, including ten years with Oracle.  Chris has presented at IOUG, local user groups and at company events.

Back to Top

ORACLE FUSION TRACK: Data Mining for Real Time Analytics

This presentation will discuss data mining and its usefulness for businesses. It will focus on how data mining couples with the Oracle RDBMS. In view of the paradigm change in marketing, the growing importance of real time decisions for businesses will be covered as well as how analytics can drive these real-time decisions. Preparing the database and the data for such analytical use will be discussed along with how DBAs can learn about data mining and assist in this process.

Shyam Varan Nath is a Principal Analytical Consultant of the BI Group at Oracle Corporation. He chairs the Special Interest Group on DW & BI. He as been an OCP since 1998 (version 7.3 of database) and has presented at Oracle OpenWorld, IOUG/Collaborate, NYOUG and several other industry related events.

Back to Top

June 2006 General Meeting

Back to Top

Alok Pareek brings over 10 years of database development experience from Oracle’s Recovery/High Availability area.
Currently he is a software solutions architect for GoldenGate Software’s High Availability and Disaster Tolerance
offerings. He was responsible for the redo generation component of the Oracle database from 8i to 10.2, and his
contributions at Oracle include the development of Cross Platform Transportable Tablespaces (Oracle 10g), Multithreaded redo generation (9i), Multiple block size cache support (9i), and Whole database transport (10.2). He has
presented technical sessions at Oracle OpenWorld and regional Oracle User Group chapters, and holds a graduate degree

Back to Top

Faruk Cay is a Principal Consultant at Oracle working on data mining. He has been with Oracle for six years and
previously worked in Oracle Data Mining development team. He has over 13 years of experience in software industry.
Shyam Varan Nath is a Principal Consultant at Oracle as part of the Data Mining group. He is an Oracle certified DBA
since 1998. Shyam has worked in the health care and telecommunication industry. His consulting projects have been in
the law enforcement and finance industry. He has worked with Oracle data mining for building customer churn models
and intrusion detection models for enhancing security. He has presented at Oracle Opeworld, IOUG/Collaborate and
several other similar events on topics related to database administration and data mining

Back to Top

Kirtikumar Deshpande works for Verizon Information Services as a Senior Oracle Database Administrator. He has over 25 years of IT experience in various capacities, including over 11 years as an Oracle DBA. He coauthored two Oracle Press books, Oracle Performance Tuning 101 and Oracle Wait Interface - A Practical Guide to Performance Diagnostics & Tuning. He is a frequent speaker at various Oracle conferences in the U.S. and abroad.

Back to Top

Jeff Bernknopf is a team leader at Morgan Stanley. Jeff has over 25 years of experience in developing
applications and has recently concentrated on technologies like Java/J2EE, C#, HTML DB, XML/XML DB and
Web Services. Jeff is the Vice President of NYOUG where he handles Vendor Relations. Jeff is also a
Contributing Editor of SELECT Magazine, on the Editorial Board of Oracle Magazine and the Contributing
Editor of the ODTUG Technical Journal's Tool Talk column.

Back to Top

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, where he designed and implemented a variety of storage infrastructures and
conducted research on deployed security models used within EMC technology.Prior to joining EMC, Mr. Zito served as
Infrastructure Architect at Register.com, where he pioneered the use of centralized management and automation to run
large production application infrastructures.. His expertise in technologies such as Oracle, distributed clustering, and
infrastructure performance optimization allowed Register.com's infrastructure to scale cost-effectively and far beyond its
original life expectancy.His code is running in a number of open-source software projects and he is currently writing the
O'Reilly "animal" book on Enterprise Storage. He attended New York University.

Back to Top

Bruce Mathis has been using Oracle products for 10 years, since database release 7. He is now concentrating on using
Application Express to its fullest potential.

Back to Top

Sean Hull is the founder 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 & Open Source (O'Reilly, 2001) as well as various open source database tools, scripts, and applications. Sean has also written articles for various print and online publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

Coleman Leviter is currently employed as a Programmer/Analyst at Arrow Electronics. He has worked in the financial
services industry and the aerospace industry where he developed Navigation, Flight Control and Reconnaissance software
for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester Institute of Technology, an MBA
from C.W. Post and an MSCS from New York Institute of Technology. He can be contacted at cleviter@ieee.org

Back to Top

2006 March General Meeting

Back to Top

Back to Top

Average Active Sessions - A New Tuning Paradigm - Average Active Sessions is a natural extension of Oracle's now famous and revolutionary wait interface. Now with Oracle 10g, Enterprise Manager (EM) has a clear, easy presentation of waits via the average active session measurement. Average active session is used as the pillar from which all other tuning decisions are made in Oracle's EM 10g. Learn how this new feature works, how it relates to the wait interfaces, how it revolutionizes tuning, how it can be used for SLAs, charge back, and load balancing, and how it can be extended in the industry to other databases, operating systems, and application code.

Kyle Hailey has been in the industry for a decade and a half.  Working at Oracle for over 13 years, he spent time in support, porting, benchmarking, and kernel development. Kyle has created tools to improve high-end performance monitoring, such as direct SGA attach and interactive graphic displays of performance data. He recently redesigned the Oracle Enterprise Manager 10g performance pages to be graphically oriented and wait interface centric. He currently works at Embarcadero Technologies and is responsible for their suite of performance tuning and monitoring tools

Back to Top

Back to Top

Data Warehouse Design for OLTP Data Modelers - Logical and physical data modeling for a data mart or data warehouse require a set of skills which intersect with those skills generally used by OLTP data modelers. What skills carry over from one realm to the other? What do OLTP modelers need to "unlearn" to be proficient data mart designers? And what new skill sets are required? Logical data mart design builds on some principles of normalized database design but requires practitioners to contradict others. On the physical design level, the developer needs extensive database tuning and configuration expertise to build a data warehouse that performs adequately, as well as objects such as materialized views, partitions, and bitmap indexes. The design must take into account both the time required to process queries and produce reports, and the use of the maintenance window during which the warehouse's contents can be refreshed.

Leslie Tierstein is a Professional Services Technical Architect with newScale, Inc., a company headquartered in Foster City, CA which provides packaged solutions for IT Service Portfolio Management and IT Service Catalog Management. She has over 15 years of IT experience, including the development of large-scale OLTP applications as well as data warehouses using the Oracle database. She has presented at conferences including NYOUG, IOUG-A, ODTUG, and MAOP-AOTC.

Back to Top

Mastering Grid Computing - The focus of this presentation is to provide a comprehensive set of expert tips and techniques to optimize the usage of Oracle10g Enterprise Manager Grid Control and its components from installation to production and maintenance approaches. It will also include a discussion of emctl, opmnctl, and dcmctl command lines and a method for adding a target to the grid using the Oracle10g SNMP Intelligent Agent. The focus will be on optimizing usage of administration, performance, and metrics handling on hosts, databases, application servers, high availability, and other significant. The presentation includes both a study of the Grid GUI and command line interfaces and relevant process in interaction with different targets involved. It will emphasize the convenience of using grid control over other IT resource management tools. Overall grid deployment and an ARIMA-based mathematical tuning model is proposed and briefly outlined.

Anthony D. Noriega is a computer scientist who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN/ebPortal, Anthony spends most of his time as a database analyst, architect, and developer, and DBA.  Mr. Noriega is an OCP-DBA and he holds an MS Computer Science from NJIT, an MBA from Montclair State, and a BS in Systems Engineering from University of the North. He has been a consultant for AT&T, M&M Mars, Tosco, Honeywell (Allied-Signal) and an associate for Deutsche-Bank, Bowne & Co, Reed-Elsevier, MCS Canon, and FMC. He is the author of several technical papers and a presenter and exhibitor at IOUG LIVE, Oracle Open World and NYOUG events. He is fluent in Spanish and French. He is a Senior Oracle DBA/Developer.

Back to Top

An Introduction to Oracle 10g SQL Enhancements - This presentation will give you an introduction to and a working example of the SQL features introduced with Oracle 10g. This includes the following features: Regular Expression support, Case-Insensitive Sort and Search, Partition Outer Joins, MODEL Queries, CONNECT BY Enhancements and more.

Dave Anderson has 25 years of hands-on experience in the I.T. industry. The last 10 have been spent working with Oracle - as a programmer, administrator and instructor. Dave speaks regularly at Oracle conferences including NYOUG, ODTUG, CTOUG, VOUG, NOUG and SEOUC (where he won “Best of Conference” for his RMAN presentation).

Back to Top

SQL Developer: Oracle's Graphical Database Development Tool - There are many tools that allow you to interact with an Oracle database available in the market today.  These range from command line tools to rich GUI tools.  SQL Developer, Oracle’s newest graphical alternative to SQL*Plus, allows the database Developer a convenient way to perform basic tasks. With SQL Developer you can manage objects in Oracle databases.  You can browse, create, edit, and delete (drop) database objects; create, edit, and debug SQL statements and PL/SQL code; manipulate data; export and import database objects; and create reports.   Using a combination of presentation and hands on, this presentation walks through various aspects of the new tool, including editing and debugging PL/SQL, creating user defined reports and more.

Craig Silveira joined Oracle back in 1997. For the last 7 plus years, he has covered some of the largest financial services customers on Wall Street. His areas of specialization include Real Application Clusters, Replication, High Availability, Migrations and competitive benchmarks. Craig has focused on migration of non-Oracle databases to Oracle since the beginning of his career. He has performed over a dozen migrations from databases such as IBM UDB, Sybase, Informix and Microsoft SQL Server. He is regarded as an authority in this area and participates in spec reviews with the migration development team. Craig has also been involved in one of the largest open system data warehouse benchmarks as part of an effort to prove Oracle technology for the JPMC Credit Card Services group. Craig has worked with heritage JPMorgan Chase throughout his career.

Back to Top

Back to Top

2005 December General Meeting

3 Major Trends in the Oracle World - Over the past five years there are three major trends that seem to be molding the future of the Oracle database:
 The first is the adoption of clustering and an accelerating trend toward grid computing.
 The second is a movement toward Linux for smaller and mid-sized systems.
 The third is the pendulum swing first toward offshoring database work and then a shift away from offshoring and toward a new mixed model.

All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs.  This presentation shows how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

Essential Performance Forecasting - At a basic level, forecasting Oracle performance is absolutely essential for every DBA to understand and perform.  When performance begins to degrade, it’s the DBA who hears about it and is supposed to fix it.  It’s the DBA who has the most intimate knowledge of the database server, so shouldn’t he/she be able to forecast performance?  When a bunch of new users are going be added to a system, it’s the DBA who is quickly asked, “That’s not going to be a problem, is it?”  Therefore, DBAs need the ability to quickly forecast performance.  Low precision forecasts can be done very quickly and are a great way to get started with forecasting Oracle performance. This presentation will prepare a DBA to perform performance forecasting using basic queuing theory math.  It will also introduce more advanced forecasting methods.

Craig Shallahamer has 18-plus years experience in IT. As the president of OraPub, Inc., his goal is to empower Oracle performance specialists by "doing" and teaching them to "do" whole system performance optimization (reactive and proactive) for Oracle-based systems.  In addition to course development and delivery, Craig is a consultant who is involved in product development, technically reviews Oracle books and articles, and keynotes at Oracle conferences.

Back to Top

Performance Monitoring and Tuning RAC/Grid - This presentation will answer your questions about how database tuning is different in a RAC or Grid environment.  It will also cover some common things to watch for in your RAC/Grid environment. It includes many RAC/Grid scripts, what to look for in statspack when you have RAC/Grid and a quick look at 10g Enterprise Manager.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

Oracle 10g New Job Scheduler - This presentation explains how the Job Scheduler works within the Oracle 10g architecture. It will discuss the benefits of the new Scheduler in comparison to the old DBMS_JOB as well as how you can convert existing DBMS jobs to the Job Scheduler. A demo will be included to show how to create new jobs as well as how to move existing DBMS jobs to the Scheduler, troubleshoot, and manage the new Scheduler. It will also explain how to create a chain of jobs and how to prioritize and allocate the resources to the jobs.

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 Masters Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire. Indy can be reached at indy.johal@prnewswire.com

Back to Top

The J2EE Server: The Black-Box in the Oracle World? - Conventional performance management and database tuning lead to finger pointing between owners and developers of Oracle and Java systems.  This is due to the lack of visibility into the exact causes of bottlenecks on the tiers of Web, J2EE and Oracle servers.  Conventional technologies monitoring the Java server treat the database as a black box without identifying details of how Oracle impacts Java processes.  They also leave the DBA with no visibility into J2EE applications.  This session will cover how Wait Time methods can be used to track detailed end-to-end transaction performance in a multi-tier system, showing the interaction between Oracle databases and the Java applications they serve.

Don Bergal is the Chief Operating Officer at Confio and is responsible for overseeing all of the company’s sales, marketing, product management and business development initiatives. Don has over 15 years experience in the software, services and data communications industries, most recently with software developers Jabber, Inc. and Antepo, leading companies in the XMPP Instant Messaging market. He served as Vice President of Business Development for Antepo, launching the company’s US operations. As Vice President of Marketing at Jabber, Inc., he led the product marketing, demand generation and communications programs, and established and executed the technology partnerships and positioning for Jabber, servicing the enterprise, ISP and mobile network marketplaces.

Back to Top

Oracle 10g's Expression Filter Uncovered - In an age where we are increasingly moving towards data warehouse environments, being able to store information about your business’ customer buying trends, demand analysis, task assignment, and information distribution, is becoming more valuable than ever. Reporting on this type of information can be greatly enhanced with the use of Oracle 10g’s Expression Filter. Expressions help developers/users describe interests in expected data. Developers can store, index, and evaluate conditional expressions in one or more columns of a relational table. Data of interest is identified when Expression Filter matches incoming data with stored column expressions. Complex relationships can be derived when expressions in one table are matched with data in another table. Additionally, Expression Filter enables reuse of conditional expressions in business rules by storing them in the database and separating them from the application. This presentation provides an introductory overview of this feature. 

Melanie Caffrey is a lead consultant for Proximo Consulting Services, Inc. in New York City, providing front-end and back-end Oracle solutions for the business needs of various clients. She is co-author of several technical publications including Oracle Web Application Programming for PL/SQL Developers, The Oracle DBA Interactive Workbook, and Oracle Database Administration: The Complete Video Course, all published by Prentice Hall. Additionally, she instructs students in Columbia University’s Computer Technology and Applications program in New York City, teaching courses in advanced Oracle database administration and PL/SQL Web development tools, and she is a frequent Oracle conference speaker, having most recently presented at IOUG - 2005.

Back to Top

Reducing and Eliminating “Planned Outages” when Moving to Oracle 10g - Drawing on 10 years of experience with Oracle in database development and within the data recovery/high availability group, this technical presentation is designed for those planning or evaluating a move to Oracle 10g, including RAC and ASM.Oracle 10g offers a wide variety of new features and enhancements, ranging from superior performance and availability to security. In 10g, Real Application Clusters (RAC) increase reliability for your mission-critical applications and offer better manageability using Automatic Storage Management (ASM). But as with any upgrade and migration project, moving to Oracle 10g requires a well-planned approach that mitigates risk, minimizes downtime, and poses the least amount of complexity. Traditionally, database upgrades and migrations have always required planning a lengthy outage. With stringent service level commitments, many companies may delay moving to Oracle 10g to avoid the impact of service outages. This presentation serves to accomplish two goals:
(1)   Technically compare and contrast different approaches and solutions that may be considered for moving to 10g
(2)   Review a step-by-step process and configuration using “transactional data management” solutions that can provide near-zero or zero downtime for such projects.

Different migration scenarios will be considered, including 8i to 10g, 9i to 10g, cross platform, RAC, ASM, and non-Oracle to 10g.

Alok Pareek is a solutions architect for GoldenGate Software’s High Availability and Disaster Tolerance offerings, bringing more than 10 years of database development experience from Oracle’s Recovery/High Availability area. He was responsible for the redo generation component of the Oracle database from 8i to 10.2, and his significant (patent-filed) contributions at Oracle include the development of Cross Platform Transportable Tablespaces (Oracle 10g), Multi-threaded redo generation (9i), multiple block size cache support (9i), and whole database transport (10.2). He has presented technical sessions at Oracle OpenWorld and regional Oracle user group meetings, and holds a graduate degree in Computer Science from Stanford University.

Back to Top

Back to Top

2005 September General Meeting

Along with updates from the previous week's Oracle OpenWorld in San Francisco, Ken will discuss the evolution of the related concepts of Grid Computing and Service Oriented Architecture.  He'll discuss recent developments in Oracle's Database and Fusion Middleware product families.

 

Ken Jacobs - VP Product Strategy, Oracle Server Technologies
Since helping to establish the first Oracle office in Washington, DC in 1981, Ken has been a prominent spokesperson for Oracle and an advocate inside the company for customers' interests.  He has held a number of technical and management roles for Oracle, including consulting, support, product management and product marketing. Ken is also often a featured speaker at Oracle conferences and events and is known as "Dr. DBA" to thousands of Oracle Database administrators.   He is the Oracle liaison and a member of the board of directors of the International Oracle User Group (IOUG).

Back to Top

Best Practices for Managing Databases

The complexity of managing databases has increased so significantly some are considering Outsourcing as their only relief.  New regulations are driving IT Governance that further increases the pressure on IT as ways are sought to reduce costs and still effectively manage the myriad of databases supporting business. Auditors, consultants, ITIL, COBIT, ISO, Six Sigma - what is a DBA to do? This presentation focuses on the new business challenges, best practices approach to managing relational databases, and where and how database administrators should be educating themselves and spending their time to be successful in business.

Steve Lemme Steve Lemme is a Director of Product Management at Computer Associates International, Inc. (CA) for the Unicenterâ Database Management product solutions. Mr. Lemme joined CA in 1993 upon its acquisition of Platinum Technology International, Inc. where he was responsible for product management and marketing for distributed database tools. Mr. Lemme is author of the book Implementing and Managing Oracle Databases. He serves as a Director on the International Oracle Users Group board and is Vice President of the Arizona Oracle Users Group. He is a regular speaker at IT industry conferences worldwide and a monthly columnist for Database Trends and Applications Magazine.

Back to Top

Improve Performance & Comply with SOX

Sarbanes-Oxley, Gramm-Leach-Bliley, Basel II requirements effect almost everyone in IT including data professionals. Using data compliance audit and enforcement tools from Oracle and other software providers can deliver important performance, productivity and data management benefits, in addition to meeting compliance demands. Learn how companies use some of these compliance tools to increase performance and business value.

 Chris Doolittle is Vice President of Product Management and a founder of Teleran Technologies, a database and application usage management software company. He has over 25 years of experience in the IT industry working in data intensive application environments including data warehousing, financial analysis and business intelligence.  Mr. Doolittle has held technical management positions at companies such as General Electric, Pepsico, Information Builders and Metaphor.

Back to Top

Oracle’s new Automatic Workload Repository (AWR) component automatically places important Oracle performance data right at your fingertips.  The data structures are remarkably similar to the STATSPACK utility. This presentation will show attendees how to easily write custom AWR reports to gather important time-series performance information. Attendees will get a better understanding of the AWR table structures, see the similarities between AWR and STATSPACK, learn how to write AWR scripts and see how to create time-series exception reports

Donald K. Burleson is considered one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems. A former Adjunct Professor Emeritus, Burleson has written over 30 books, published more than 100 articles in national magazines, and serves as Series Editor for Rampant TechPress.

Back to Top

This presentation will discuss what JavaServer Face (JSF) is all about - components. It will give attendees a new perspective on application development and what can be done with the new standard - JavaServer Faces. The session will also cover Oracle's extensive component library for JSF - ADF Faces, and Oracle JDeveloper 10.1.3 JSF design time support.

Jonas Jacobi is a Principal Product Manager and Evangelist for Oracle JDeveloper and is responsible for the JSF and ADF Faces development features within JDeveloper. Before Joining Oracle, he worked at several software companies in Europe, covering many roles ranging from support, consulting, development and project team leader. Jonas holds a Bachelor's of Science in Computer Based Pneumatics with a specialization in Computer Science. Jonas is currently authoring a book Pro JSF: Building Rich Internet Components for Apress.

Back to Top

Attendees will learn how to lower the cost of secure information availability through automated database management functionality. Topics covered will include:

1. New features for backup and recovery using RMAN 

2. New Features for Security 

3. Self Manageability Features

4. New Features for Data Guard 

5. Miscellaneous other features of 10gR2 

Ranbir Singh, Sr. is a Principal Instructor for Oracle University. His areas of expertise include: High Availability Oracle Solutions (Real Application Clusters), Data Guard, Adv Replication, Performance Tuning, SQL Tuning and RMAN). Ranbir has 20 Years of IT industry experience in Education, Health Care, Publishing, 12 of those with Oracle and 5 years as a DBA and SA.

Back to Top

You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? You used a cursor FOR loop to process data one row at a time? If slip-ups like these sound familiar (or if you don't know why these are mistakes), this presentation will show you how to correct such mistakes to improve the maintainability and performance of your application.

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written nine 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 a Senior Technology Advisor to Quest Software. His latest projects include Qnxo, the world's first active mentoring product (www.qnxo.com) and Oracle PL/SQL Programming 2005, a conference on and celebration of the PL/SQL language (www.oracleplsqlprogramming.com). You can reach Steven at steven@stevenfeuerstein@com.

Back to Top

Upgrade Completed Successfully! Has it Really?

This presentation will look at what should be done pre-upgrade, planning for an unfortunate need to back out, and development of a bullet-proof checklist to assist the process. It will discuss what tests to perform at the infrastructure level (e.g., constraints and triggers) as well as looming character set issues that can creep up if not attended to. Items as detailed as object counts before and after (outside of the data dictionary) are crucial for ensuring that an upgrade was truly 100% successful. This presentation will cover the bases, and address issues that are all too often neglected during a database upgrade process.

Michael S. Abbey is a frequent and popular presenter at Oracle user group and vendors forums, having assembled a following in the software community over the past 17 years. He helps facilitate the IOUG's annual event, a cooperative effort for 2006 with the Oracle Applications User Group and Quest, in Nashville next April 23-27.

Back to Top

Project Fusion is the consolidation of the technology stack between the Oracle E-Business Suite, PeopleSoft, and JD Edwards. This session will present the technology upon which Project Fusion is based, focusing mainly on JDeveloper and the Oracle Application Development Framework (ADF). A technical overview and roadmap of the architecture (Oracle ADF, JavaServer Faces) will be discussed along with how customers can already take advantage of these open standard technologies to simplify and increase productivity for their J2EE development.

Lynn Munsinger is a Principal Product Manager in the Java Tools Development group at Oracle, specializing in EJB, TopLink, and ADF.  She has been working at Oracle since 1998, initially in product support, and then as a Curriculum Developer for JDeveloper courses.  She is the author of many Oracle University courses, including, "Oracle10g: Build J2EE Applications.”

Back to Top

This presentation is a "How Oracle works at the block level" presentation. It will cover how to do block dumps and read them.  Attendees will also learn how Oracle moves things at the block level, how blocks move from disk to memory, how they become Current blocks, how they become Consistent Read (CR) versions and other interesting tidbits of information that only keep you from achieving the business goals of the company.  Rich will also discuss some of the cool x$ tables out there that you should stay away from including many that begin with x$ksm  (like x$ksmsp - kernel storage memory SGA heap) what they'll reveal to you, as well as why the move toward 64-bit technology, memory resident databases and RAC/Grid makes this even more important to understand.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

This presentation describes how Oracle 10g Portal can be configured to authenticate users based on an organization’s existing Active Directory tree.  Deployment details are provided for the Oracle Directory Integration and Provisioning component, the Active Directory External Authentication Plug-in, and the Windows Native Authentication scheme.

Craig Warman is Chief Technical Officer at Computer Resource Team, Inc., a consulting practice in Virginia.  He has presented at Oracle venues that include Oracle OpenWorld, IOUG-A Live, ODTUG, UKOUG, OAUG, NYOUG, SEOUC, and VOUG.

Back to Top

This presentation will highlight some of the most valuable techniques & features for monitoring databases and managing scheduled jobs with OEM 10g R2.  It will also discuss some scripts & scripting methodology for creating jobs to manage data.  Enhancements to OEM in 10g including R2 will be highlighted and the presentation will end with time for Q&A.

Lucas Lukasiak is a Senior DBA with Verizon Wireless and has been working with Oracle since version 7 in 1998.  He co-founded the Connecticut Oracle Users Group (http://www.ctoug.org/) in 2003 and is currently serving as President.  Lucas also leads a team of Decision Support Systems  professionals to deliver enterprise reporting, multi-dimensional data, and OLAP applications.

Back to Top

Attendees will learn what the view layer is; the popular alternatives for creating view layer code in JDeveloper 10g -- JSP, UIX, and JSF; how to create these styles of code in JDeveloper 10g. This presentation explains these view layer technologies and describes how to develop them using Oracle JDeveloper 10g. It reviews the principles of the MVC design pattern as a context for the view layer discussion. The presentation also discusses JSP, UIX, and JSF architectures, code libraries, coding styles, benefits and drawbacks, key features, and  intended uses. In addition, it provides conclusions about which style is best for specific situations. Additionally, the presentation will  demonstrate how to develop a web application using JDeveloper.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has 20 years of industry experience. Peter has presented at various Oracle users group conferences more than 130 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, and the ODTUG Volunteer of the Year. He is an Oracle Certified Master and coauthor of 6 Oracle Press books.

Back to Top

Participants will learn exactly what data mining is and what types of business problems it is meant to solve.  Through short examples, they will learn to recognize the types of business questions that can be answered by using data mining techniques, as well as their limitations.  Finally, the presentation will include a brief overview of Oracle's Data Mining solution.

Carol Brennan Baldan has worked with Oracle for nearly ten years as a developer, DBA, and technical manager.  She is an Oracle9i Certified Database Administrator and a recent recipient of a Master of Business Administration degree from the Stern School of Business at New York University, where she specialized in Statistics and Operations Research.

Back to Top

Attendees should come away with some knowledge of how to put RMAN® to use in their companies and how to accomplish basic RMAN® tasks including recovery, point-in-time recovery and cloning.  Scripts will be provided. This presentation will review some of the reasons for choosing RMAN® and show how our old friend has become even better with age including implementation strategies and options you can select to customize an RMAN® implementation to fit your company’s needs. The presentation will include the once ominous but now so important task of cloning (duplicating) databases.

Ruth Gramolini has been an Oracle DBA for 7+ years with the State of Vermont Department of  Taxes.  Ruth had been system manger and DBA for an HP3000 system running the proprietary Image Database for 14+ years before this. Prior to this, she was a research and statistic analyst.

Back to Top

Participants will be introduced to Oracle HTML DB 1.6 beginning with an overview of the architecture. Discussion will include the various steps involved in building a database-centric Web application with reporting and form building capability. Application items, buttons and page processing will also be explored. Workspace administration and security implementation through authorization and authentication schemes will also be discussed and, time permitting new features in Oracle HTML DB 1.6 vs. HTML DB 1.5 will also be covered.

Wayne Abbott is a manager at Oracle University with credentials that include senior principal instruction in the area of languages and tools. Wayne has 12 years tenure at Oracle with previous experience working with  hardware vendors including Unisys.

Back to Top

2005 June General Meeting Presentations

Back to Top

Back to Top

DBA TRACK

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

Back to Top

2005 March General Meeting

DBA TRACK

Aaron Newman
Application Security, Inc.

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

Tanel Põder - integrid.info

Back to Top

Back to Top

Back to Top

2004 December General Meeting

DBA TRACK

Back to Top

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

2004 September General Meeting

DBA TRACK

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Nick Donatone - MFG Systems

Back to Top

Back to Top

Back to Top

Back to Top

APPS TRACK

Back to Top

Back to Top

Back to Top

Back to Top

2004 June General Meeting

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 is a frequent presenter at technical events in North America and Europe. He has accumulated an avid following in the Oracle user group community, having served on the board of directors of the IOUG from 1992 until 2000. Michael was re-elected to the Board in the 2002 election process, and was responsible for the delivery of Live! 2004 in Toronto. Michael is co-author of 12 successful works in the Oracle Press series, the most recent being Oracle Database 10g: A Beginner's Guide. Since 1999, he has been the technical lead for the remote DBA team at the Pythian Group in Canada's capital.

Back to Top

Back to Top

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.

Back to Top

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.

Peter Koletzke is a Technical Director and Principal Instructor for the Enterprise e.Commerce practice at Quovera, in Redwood Shores, CA (http://www.quovera.com.) Peter is a technical content manager for the IOUG web committee. He has presented over 120 times at various Oracle users group conferences and has won awards and acknowledgements such as Pinnacle Publishing's Technical Achievement, ODTUG Editor's Choice, the ECO/SEOUC Oracle Designer Award, ODTUG Volunteer of the Year, top-rated presentation at IOUG Live!, and is an Oracle University Oracle Certified Master. He is coauthor, with Dr. Paul Dorsey of the Oracle Press (Osborne McGraw-Hill) books: Oracle9i JDeveloper Handbook (also co-authored with Avrom Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook. http://ourworld.compuserve.com/homepages/Peter_Koletzke

Back to Top

2003 December General Meeting

Back to Top

Oracle 10g HTML DB - HTML DB is targeted at opportunistic application developers, sometimes called power users who typically work on projects that need to be completed quickly and with small development teams. Learn how to rapidly build applications on your Oracle 9iR2 or 10g database using HTML DB.  This presentation will demonstrate how you can develop, secure, skin, and scale a data centric web application. Oracle database features including LDAP, Oracle Text, regular expressions, and of course SQL will be covered as well as the types of applications our customers are currently using HTML DB for.

Back to Top

Oracle 9i Streams: The Fast Information Sharing Technology - This presentation will discuss the architecture behind Oracle 9i Streams and focus on some of its practical application areas, compare it to other Oracle High Availablity/Failover options such as RAC, Advanced Replication, and standby databases. Some changes added to Oracle 10g will also be discussed.

Back to Top

New 10g PL/SQL Features & PL/SQL Programming Tips - This presentation will give an overview of the top new PL/SQL 10g features including performance improvements, support for regular expressions, as well as sparse array bulk binds.  Tips about writing HTML DB may help improve the performance of your PL/SQL code.

Back to Top

Oracle Change Data Capture (CDC) - Sometimes you need to know what information has been changed in your database.  It may be for reports or as a part of an elaborate ETL process. If the database wasn't designed with this in mind, you may have to develop a custom solution. This can be a costly and error-prone process including triggers and big inefficient queries.  The alternative is to use Oracle's 9i feature - Change Data Capture (CDC). This is a nice solution and completely independent from the rest of the database design.  However, there is still the problem of Tmaking sense of the Oracle documentation. This presentation will demonstrate some of the benefits of using CDC.

Back to Top

Oracle Spatial: Enabling Locational Analysis in Oracle - Locational analysis is an important component of most business applications. Such analysis ranges from visualizing customer and business locations on maps, identifying potential customers in store neighborhoods, identifying potential sites for new businesses, computing routes for delivery trucks to customer addresses to analyzing raster images of weather patterns etc.

Traditionally, such analysis using locations of objects has been possible only through proprietary tools from GIS vendors.  Oracle Spatial offers a rich set of functionality for analysis based on object locations: it provides efficient mechanisms for storing, managing, querying, analyzing and visualizing data objects using their locations inside an Oracle database. In this talk, we give an overview  of the existing spatial functionality in Oracle 9i and the new functionality in Oracle 10G.  We illustrate how to integrate such functionality in existing applications running on Oracle database and describe some customer applications using Spatial.

Back to Top

Experience the GRID Today - This presentation discusses the benefits, challenges, and results of deploying applications on Oracle 10g Real Appllication Clusters (RAC), with a focus on implementation using generic Intel-based hardware and Linux environments.

Back to Top

2003 September General Meeting

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

2003 March General Meeting

Back to Top

How to Set Up Apache and JSERV w/Oracle XSQL, JSP, and Developer - This presentation examines the steps needed to set up the Apache Web Server so that it is fully integrated with Oracle8i web products.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 December General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 September General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 June General Meeting

Back to Top

2002 March General Meeting

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

2002 January General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2001 June General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

2001 March Training Day

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

2000 December Training Day

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

1999 December General Meeting

Back to Top

Back to Top

Back to Top

1999 September General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

1999 February General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

General Information - Developer

Back to Top

Back to Top