Pre 2012 General Meeting Presentations

In 2013 NYOUG redesigned its web site. To keep the presentations older 2012, they were grouped together and posted as one post. The following are all the General Meeting presentations that occurred prior to 2012. 

2011

2010

2009 2008
2007 2006 2005 2004
2003 2002 2001 2000
1999

 

Contents

 2011

December 2011 General Meeting

  • Keynote

  • DBA Track

  • Development Track

  • Implementation Track

KEYNOTE:  Big Data

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.

 

 

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.

 

DBA TRACK:  “Virtualization and Oracle Databases”

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.

 

DBA TRACK:  “Do it Yourself Data Migration”

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.

 

DBA TRACK:  “SQL Plan Stability – Post 11g Upgrade – Our Experience at Verizon Wireless”

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.

 

DBA TRACK:  “Five Things You Probably Didn’t Know About PL/SQL”

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)

 

DBA TRACK:  “Centralize Oracle Database Authentication and Authorization in a Directory”

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.

 

DBA TRACK:  “Exadata Customer Case Studies: Key Considerations”

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.

 

DBA TRACK:  “Key Management and Sensitive Data for DBAs”

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.

 

DEVELOPER TRACK: “Oracle Database Cloud Service”

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.

 

DEVELOPER TRACK“ADF Faces RC Screen Layout Basics”

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.

 

DEVELOPER TRACK“Just Plug It In!”

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.

 

DEVELOPER TRACK“Real Application Testing – Never Get Caught By Change Again”

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.

 

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.

 

IMPLEMENTATION TRACK:  “An Introduction to Oracle Database Appliance”

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.

 

IMPLEMENTATION TRACK:  “Increase Performance of Existing Oracle RAC Up to 10x “

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.

 

IMPLEMENTATION TRACK:  “RAC on vSphere5”

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.

 

September 2011 General Meeting

 

Share

 
KEYNOTE:  Thinking Clearly About Performance

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.

 

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.

 

DBA TRACK:  Instrumentation: Why You Should Care

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

 

DBA TRACK:  Database Attacks Exposed

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.

 

DBA TRACK:  Tips & Tricks for a Successful Upgrade to 11gR2

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.

 

DEVELOPER TRACK: Techniques for Sending/Receiving XML packets Using SQL Developer, 11gR2

“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.

 

DEVELOPER TRACKFast Manipulation of Client Data with Automated E-mail Distributions

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.

 

DEVELOPER TRACKBuilding Mobile Web Applications on the Oracle Database with jQuery Mobile

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

 

DEVELOPER TRACKUse RMAN to Relocate a 10TB Database with Minimum Downtime

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.

 

June 2011 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  How Will You Build Your Next System?

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

 

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.

 

DBA TRACK:  A Review of ADDM, ASH, and AWR in 11g

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.

 

DBA TRACK:  Lessons Learned – RAC Upgrade at Verizon Wireless

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.

 

DEVELOPER TRACK: Dynamic Duo: SQL and Actions

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.

 

DEVELOPER TRACKSecuring Data Today and in the Future

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.

 

DEVELOPER TRACKLooping the Loop: Different Ways of Working with Recursive Structures

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.

 

March 2011 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  Exadata 101: What You Need to Know

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.

 

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)

 

DBA TRACK:  Achieving Mainframe Reliability Using Oracle RAC and Commodity Hardware

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.

 

DBA TRACK:  Oracle 11g Release 2 Data Guard Options

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.

 

DBA TRACK:  Oracle 11g SQL Plan Management and Automatic SQL tuning Advisor

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.

 

DEVELOPER TRACK: Avoiding Common OBIEE Mistakes: Learning from Post-Implementation Assessments

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.

 

DEVELOPER TRACKUsing Collections in APEX – The Definitive Intro

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.

 

DEVELOPER TRACKUnleash the Value of Data in your OEM Repository

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.

 

December 2010 General Meeting
NYC Metro Area Oracle User Group Meeting

  • Keynote

  • DBA Track

  • Development Track

  • BI/DW Track

KEYNOTE:  “Why Standardize on Oracle 11g?”

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.

 

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.

 

DBA TRACK:  “Data Masking Tips & Tricks”

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.

 

DBA TRACK:  “A Flexible Data Warehouse Hardware Architecture”

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.

 

DBA TRACK:  “Data Vault Modeling – The Next Generation of Data Warehouse Approach”

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.

 

DBA TRACK:  “What You Should Know About the 11g CBO”

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.

 

DBA TRACK:  “Database Security Solutions in the Cloud and Outsourced Environments”

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).

 

DBA TRACK:  “RMAN Configuration and Performance Tuning Best Practices”

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.

 

DBA TRACK:  “Successes and Failures Integrating Oracle XML DB (11g R2) with SQL Developer”

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

 

DEVELOPER TRACK: “Solving SQL Injections that Exploit Zero-Day Vulnerabilities”

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

 

DEVELOPER TRACK:  “… and UIX Begat ADF Faces: How Rich is ADF Faces Rich Client?”

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.

 

DEVELOPER TRACK:  “Just Get it Written: Deploying Applications to WebLogic Server Using JDeveloper and WebLogic Server Console”

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.

 

September 2010 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  Building Applications in Developing Nations

Developing nations face many problems when building IT systems. Finding and training local talent is difficult.
Working within the limitations of local network and internet infrastructure is frequently a challenge (particularly in
areas outside of the cities). Providing an easy to maintain system was solved by using a 100% business rules-based
development method. Dealing with the internet environment required a new architecture that only needed minimal
network bandwidth. This presentation discusses our experiences building a financial system for the country of
Ethiopia.

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

 

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.

 

DBA TRACKDatabase Performance Made Easy Through Graphics

This presentation begins with a discussion of the use of sample data to create Active Sessions History (ASH). ASH is
dense, multidimensional data, which can make it difficult to analyze. To overcome this roadblock, ASH can be
simplified using a metric called Average Active Sessions (AAS). AAS shows the load on the database and allows you
to drill down with precision and clarity into the cause of each bottleneck. Most often, bottlenecks are caused by poorperforming
SQL statements. For analyzing suboptimal SQL statements, Mr. Hailey will demonstrate how to lay out the
query graphically in a Visual SQL Tuning (VST) diagram. Through the VST, it is possible to quickly visualize any
coding errors in the query, discover flaws in the underlying database schema and, most importantly, find the best
execution path through the query.

Kyle Hailey has been in the industry for a decade and a half and working with Oracle for over 13 years, having spent
time in support, porting, benchmarking, and kernel development at Oracle. After creating tools to improve high-end
performance monitoring such as direct SGA attach and interactive graphic displays of performance data, he redesigned
the Oracle Enterprise Manager 10g performance pages to be graphically oriented and wait-interface centric. He now
works at Embarcadero on their suite of performance tuning and monitoring tools. He is a member of the Oak Table and
co-author of Oracle Insights: Tales of the Oak Table. He is also a regular speaker at Hotsos, NoCOUG, RMOUG,
NYOUG, Oracle World and Dbforum and he teaches classes around the world on Oracle performance tuning.

 

DBA TRACKExadata2: Porting a Complex Application/Lessons Learned

This presentation will focus on how best to make an application work in Exadata. The reviewed application domain is
a large scale trickle feed ETL for very high volume reporting, also including a variety of smaller transactional and adhoc
query systems. Mr. Werman will discuss porting and running a large mature ODS and reporting data warehouse
from Oracle 10g to Exadata. Migration strategies, tuning, and application re-architecture will also be covered.

Aaron Werman is a senior architect at a large prime brokerage and architect for the common data warehouse and its
technical strategy and performance. He has deep experience in VLDB, Oracle, and heterogeneous systems. (And has
worked on all roles in Oracle applications going back to Oracle 5.)

 

DEVELOPER TRACK: Analytic Functions are Cool!

Have you ever had to compute the Top-N records of a result set using SQL ? This is extremely difficult to do using straight SQL. To answer such a question would require multiple SQL queries, a very mangled and complicated SQL query, or procedural programming logic. In contrast, analytic functions make answering these types of questions trivial. They also make such database queries faster and more efficient. This presentation will demonstrate how to use most of the Analytic functions to move backward and forward within a result set, compute running totals and Top N queries, and pivot database tables (turn rows in a result set into columns).

Michael Davis has over 15 years of Information Technology experience. He is the President of OmegaSoft, LLC, a Software Development and Data Warehousing consulting company located in Bloomfield Connecticut that provides services for mid-size and large businesses. He has written Oracle technical articles and has presented at NYOUG.

 

DEVELOPER TRACKAchieving Great Web Application Performance Using ONLY SQL and PL/SQL

The two main reasons for performance degradation in web application architecture are:
1. Excessive round trips between the database and the application server
2. Large pages sent from the application server to the client

This presentation demonstrates a 100% “thick database” approach (virtually no code in the application server).
Using this approach provided very good performance in the server as well a huge (10x) reduction in network traffic in comparison with standard web applications. This architecture was developed to support the budget and finance system for the country of Ethiopia and has been productized as BRIM®-UI.

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 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. Michael 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 MS in information systems, and a diploma with honors from the Kiev National University of Economics.

 

DEVELOPER TRACKApplication Express 4.0: Collaboration with Websheets and Team Development

With Application Express 4.0, Oracle introduces two new modules that focus specifically on the collaboration within teams: Websheets and Team Development. Websheets target primarily the typical end user or business user of a web application, by providing an easy way to upload and share content on the Web. This content can include text, pictures, reports and charts, all of which can be easily combined, and published to other team members, enabling teams to jointly view and edit information. Team Development on the other hand targets software developers and makes the joint
development of Oracle Application Express applications easier for them. Team Development is designed to manage the development process. The tightly integrated feature-tracker, to-dos, bugs, and milestone components will assist with the management of software releases. The feedback component allows end-users to provide comments back to the development team where they can be converted into features, to-dos or bugs. This presentation provides an overview of these new modules, and includes a demonstration that outlines the creation and deployment of Websheet applications and the management of Oracle Application Express Software projects using Team Development.

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.

 

BI/DW TRACK: “Oracle BI/DW Technology & Applications Integration Points”

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.

 

BI/DW TRACK:  “Intro to Oracle Data Warehousing and Business Intelligence”

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.

 

BI/DW TRACK:  “OBIEE/Business Intelligence Applications Simplified”

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

 

BI/DW TRACK:  “Oracle Data Mining: In-Database Data Mining Made Easy!”

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.

 

Lunch Presentation:  “Smarter Testing: Improve Quality, Accelerate Delivery and Reduce Costs”

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.

 

June 2010 General Meeting

  • Keynote

  • DBA Track

  • Development Track

  • DBA & Developer Track

KEYNOTE:  Golden Rules for Developers

We all want to write better code: fewer bugs, faster algorithms, readable blocks. Yet again and again our best intentions are thwarted by…all sorts of people and things:

• ourselves
• our managers
• our users
• crazy deadlines,
• lack of tools
• ….and more

We have, unfortunately, control over only so much of our professional lives. We generally can’t do much about our managers or our users. We usually can’t change the deadlines. So we have to look at what each of us can do individually to move to the next level of software developer. This session offers a set of “golden rules” that we all can agree on and will definitely improve our code – and then offers some practical advice to help you follow them.

Steven Feuerstein is considered one of the world’s leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL (all published by O’Reilly Media), including Oracle PL/SQL Programming. Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and has served as PL/SQL Evangelist for Quest Software since January 2001. He is also an Oracle ACE Director. He writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. In June 2009, he received the first Lifetime Achievement Award from ODTUG. Steven currently obsesses about how to improve the quality and quantity of testing of PL/SQL code, manifested by Quest Code Tester for Oracle. And, most recently, he launched the PL/SQL Challenge, a daily quiz for PL/SQL developers. Steven lives in Chicago with his wife, Veva (a ceramist). Neither of his two sons, Chris and Eli, are software developers. Explore the non-PL/SQL side of his life (what little of that there is) atwww.StevenFeuerstein.com.

 

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.

 

DBA TRACKNew 11g Alert Log Monitoring Capabilities

Starting with Oracle Database 11g, the alert log now also comes in XML format which opens up a whole suite of capabilities for simple custom monitoring of the Oracle database. This presentation describes how to use ADRCI, X$ views, and XML DB. Andy will then demonstrate how to create a simple application using APEX to track events that occur in the database.

Andy Klock has been an Oracle database administrator, developer since version 8. He uses his Oracle knowledge integrating the latest Oracle technologies with Portware’s leading automated trading platform.

 

DEVELOPER TRACK: Hack Your Database Before Others Do

This presentation shows typical security flaws found in PL/SQL and Java code due to programmer mistakes. Slavik will demonstrate how to use existing open-source scanning and fuzzing tools to automatically find and flag such flaws, as well as how to create your own tools in PL/SQL to help keep your code secure.

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.

 

DEVELOPER TRACKHello Worldwide Web: Your First JSF in JDeveloper

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.

 

DEVELOPER TRACK: The Importance of Quality of Service for Architecting Business Applications

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.

 

DBA & DEVELOPER TRACK: High Performance PL/SQL

Users hate to wait – for anything. For our applications to be successful, they not only must be correct (meet user requirements) and maintainable. They must also execute efficiently enough to avoid user frustration. This session reviews the most important techniques for improving PL/SQL performance, including data caching, FORALL and BULK COLLECT. After attending this session, you will be able to proactively identify opportunities for applying techniques that will most dramatically (generally, an order or magnitude or more) improve the performance of your PL/SQL code.

Steven Feuerstein is considered one of the world’s leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL (all published by O’Reilly Media), including Oracle PL/SQL Programming. Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and has served as PL/SQL Evangelist for Quest Software since January 2001. He is also an Oracle ACE Director. He writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. In June 2009, he received the first Lifetime Achievement Award from ODTUG. Steven currently obsesses about how to improve the quality and quantity of testing of PL/SQL code, manifested by Quest Code Tester for Oracle. And, most recently, he launched the PL/SQL Challenge, a daily quiz for PL/SQL developers. Steven lives in Chicago with his wife, Veva (a ceramist). Neither of his two sons, Chris and Eli, are software developers. Explore the non-PL/SQL side of his life (what little of that there is) at www.StevenFeuerstein.com .

 

March 2010 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  What’s New in Oracle Database 11g Release 2

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.

 

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.

 

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

 

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.

 

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.

 

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.

 

DEVELOPER TRACK: Developing RIA Without the Headache

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/

 

DEVELOPER TRACK: Oracle Application Express 4.0 – New Features

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.

 

DEVELOPER TRACK: Oracle Business Intelligence Platform Value Proposition

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.

 

December 2009

NYOUG 25th Anniversary/NYC Metro Area Meeting

  • Keynote

  • NYOUG 25th Anniversary Slides

  • DBA Track

  • Development Track

KEYNOTE:  “Oracle’s Business Transformation: The Next Phase”

Oracle’s business transformation strategy has enabled the company to grow revenues and maintain strong operating margins during the downturn, while freeing up funds to expand Oracle’s investment in innovative new products and services. Oracle Chairman Jeff Henley will share how Oracle is preparing internally for the recovery, from integrating the SUN acquisition, to deploying new Oracle applications to help support the company’s ongoing transformation into an integrated technology solutions provider.

Jeffrey O. Henley is Chairman of Oracle Corporation. He has held this position since January 2004.Mr. Henley was Oracle’s Chief Financial Officer and an Executive Vice President from March 1991 to July 2004, and he has been a member of Oracle’s Board of Directors since June 1995. He also serves on Oracle’s Executive Management Committee. Prior to joining Oracle in 1991, Mr. Henley served as Executive Vice President and Chief Financial Officer at Pacific Holding Company, a privately held company with diversified interests in manufacturing and real estate, and as Executive Vice President and Chief Financial Officer at Saga Corporation, a multibillion-dollar food service company. He also served as Director of Finance at Memorex Corporation in its large storage division, and as Controller of International Operations at Fairchild Camera and Instrument Corporation. Mr. Henley has a BA in economics from the University of California at Santa Barbara and an MBA in finance from UCLA. In 2004, he received the UCLA Anderson School’s Outstanding Alumnus award.

 

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.

 

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.

 

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

 

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.

 

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.

 

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.

 

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.

 

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.

 

DEVELOPER TRACK: “Oracle Forms to Oracle APEX – A Migration Roadmap”

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.

 

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.

 

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

 

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.

 

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

 

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.

 

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 atcleviter@ieee.org 

 

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.

 

September 2009 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  How Storage Innovations Change the Oracle Playing Field

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.

 

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.

 

DBA TRACK: Implementing Connection Pools for Data-Centric Applications

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.

 

DBA TRACK: UM4DB

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.

 

DBA TRACK: Moving Data Across Platforms Using External Tables

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.

 

DEVELOPER TRACK: Maximizing your APEX Applications Using JavaScript APIs

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..

 

DEVELOPER TRACK: ADF On-Ramp – What You Need to Know to Use the ADF Fusion Technology

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.

 

DEVELOPER TRACKThe Process of Modeling Enterprise Architectures

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.

 

June 2009 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  Upgrading to 11g – Best Practices

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.

 

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.

 

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

 

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.

 

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.

 

DEVELOPER TRACKOracle Data Mining Option Overview and Demo

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.

 

DEVELOPER TRACK: Practical Data Masking: 7 Tips for Sustainable Security in Non-Production Environments

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.

 

DEVELOPER TRACK: Designing the Oracle Online Store with Oracle APEX

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.

 

DEVELOPER TRACK: How Long is Long Enough? Using Statistics to Determine Optimum Field Length

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.

 

March 2009 General Meeting

KEYNOTE:  The Best Oracle Database 11g New Features

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.

 

 

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.

 

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.

 

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.

 

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.

 

DEVELOPER TRACKAPEX & 11i – Custom Reporting via BlackBerry

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

 

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

 

DEVELOPER TRACK: How to Secure Your APEX Applications

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.

 

DEVELOPER TRACK: Integrating Oracle 10g XML: A Case Study Part II

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

 

December 2008 General Meeting

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  Coding Therapy for Software Developers aka “How does this code make you feel?”

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.

 

DBA TRACK: Tuning the Large Pool for RMAN

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.

 

DBA TRACKOracle 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.

 

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.

 

DBA TRACKFaster 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.

 

DEVELOPER TRACKAutomated 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.

 

DEVELOPER TRACKIntroduction 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.

 

DEVELOPER TRACKAdvanced 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.

 

DEVELOPER TRACKForms 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.

 

September 2008 General Meeting
NYC Metro Area User Group Meeting

  • Opening Slides

  • Keynote

  • DBA Track

  • Development Track

KEYNOTE:  “How Do You Know What You Know?”

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.

 

DBA TRACK: “Database Worst Practices”

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)

 

DBA TRACK: “Storage Architectures for Oracle RAC”

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.

 

DBA TRACK: “Partitioning – When, Which & 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. 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.

 

DBA TRACK: “Listening In: Passive Capture and Analysis of Oracle Network Traffic”

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.

 

DBA TRACK: “The Right Way to Monitor an Oracle Database”

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.

 

DBA TRACK: “Virtual Partitioning in Oracle VLDWs”

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.

 

DBA TRACK: “AWR Report In-Depth Analysis”

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.

 

DBA TRACK: “A Comprehensive Approach to Database Security”

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.

 

DEVELOPER TRACK: “Rapid Development of Rich CRUD Internet Applications”

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.

 

DEVELOPER TRACK: “Anatomy of a Database Attack”

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.

 

DEVELOPER TRACK: “Performance Tuning Web Applications”

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.

 

DEVELOPER TRACK: DW/BI Design Philosophies, Accelerators, & BI Case Study

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.

 

DEVELOPER TRACK: “APEX Debug Options”

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.

 

DEVELOPER TRACK: “Advanced IT Infrastructure for Oracle Solutions”

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.

 

DEVELOPER TRACK: “Control Complexity with Collections”

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.

 

DEVELOPER TRACK: “Oracle Forms Modernization with Oracle Application Express”

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.

 

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.

 

DBA TRACK: Application diagnostics for DBAs – JVM Visibility

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

 

DBA TRACK: Dynamic SQL in a Dynamic World – The Sequel

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.

 

DBA TRACK: Use of DataGuard and Cold Failover Clusters

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.

 

DBA TRACK: Manage End User Experience with Enterprise Manager

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.

 

DEVELOPER TRACK: Working with iBATIS in the Oracle Environment

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”.

 

DEVELOPER TRACK: Advanced SOA Suite Concepts & Tricks

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)

 

DEVELOPER TRACK: JRE Cutover for Oracle Forms

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.

 

DEVELOPER TRACK: The Rise of eDiscovery

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.

 

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++.

 

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.

 

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 TRACKProtect 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

KEYNOTE: Trends in Database Management…Is this 1987 or 2007? 

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.

 

DBA TRACK: Oracle Enterprise Manager 

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.

 

DBA TRACK: Secure Your Database in Just One Day 
With the myriad of laws and mandates such as SOX and PCI-DSS, DBAs are under pressure to comply very quickly with these rules. But how difficult is it? In this presentation, you will learn the easy ways to fix issues that have the broadest impact such as: listener securing, session auditing to match patterns of attacks, removing SUID bits and permissions on Oracle executables and many others. This presentation will also discuss how seemingly innocuous packages like utl_tcp can be used to mount attacks or how lsnrctl can be used to move to a different machine. All concepts will be demonstrated using live examples. 

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.

 

DBA TRACK: Upgrade and Archive Strategies for Enterprise Database Applications 

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.

 

DBA TRACK: Triaging a Database Slowdown 

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.  

 

UCM TRACK: 10gR3 File Store Provider 
This session demonstrates the power and flexibility of the new File Store Provider in 10gR3. This component has abstracted the content storage from the Content Server allowing the use of multiple file systems and even database storage for very large file stores including HSM. 

Bob Wicklund is a Consulting Technical Senior Director at Oracle Corporation

 

DEVELOPER TRACK: Oracle 11g SQL PLAN Management 
This presentation will describe how Oracle 11g manages SQL execution plans in order to preserve SQL performance in a production environment which will be affected due to changes in the Optimizer statistics/parameters/version. It will provide an architectural overview demonstrating how Oracle 11g allows you to create SQL PLAN baselines manually or by using default configured Scheduler tasks. It will also explain the process of moving the SQL PLAN baselines from one database to another and use the same SQL execution plan on a new machine. 

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.

 

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.

 

DEVELOPER TRACK: Time Zones – From the Big Picture to the Small Picture 

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. 

 

DEVELOPER TRACK: Testing Oracle – Strategies for Success 

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.

 

October 2007 General Meeting
NYC Metro Area User Group Meeting

  • Keynote

  • DBA Track

  • Development Track

  • Fusion Track

KEYNOTE: Linux Futures – Why you Should Consider Linux and Dispel the FUD

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.

 

DBA TrackDBA Best Practices from the Field

You are starting out as an Oracle DBA, a road that is as exciting as it is treacherous. How can you tread safely? This session distills the speaker’s experience of 13 years as an Oracle DBA to 10 best practices that will save you someday, as well as make you look like a hero. The concepts presented are battle-tested and ready for the real world, which may be different from other preaching, including that from Oracle. Questions that DBAs face every day such as choosing between a large number of small datafiles and a small number of large files will be discussed, along with tips such as setting the audit_trail to DB. Regardless of your level of expertise, this session will make you a better DBA.

Arup Nanda
 has been an Oracle DBA for more than 13 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.

 

DBA TrackOracle 11g – Top Features for DBAs

2007 marks 30 years of Oracle helping businesses and governments manage their most valuable asset—information. This presentation introduces the new features in Oracle Database 11g including: Total Recall, Flashback technologies, new compression algorithms, automatic SQL and memory tuning, new partitioning methods and more. The topics covered in this seminar are primary for database administrators.

Daniel Liu is a Principal Solution Architect at Oracle Corporation and co-author of Oracle Database 10g New Features (Rampant TechPress). A recognized Oracle expert and a frequent speaker at various Oracle conferences, Daniel has published articles with DBAzine, Oracle Internals, Oracle Technology Network, and the SELECT Journal. Daniel received the 2001 SELECT Editor’s Choice Award and has been named Architect of the Week by the OTN in 2004. Prior to joining Oracle Corporation, he worked as a Senior Technical Manager at First American managing one of the largest and most complex database environments in the world.

 

DBA Track: Custom Performance Reporting Changes Going to Oracle10g

This presentation will discuss some of the areas where Oracle has changed its internal reporting structures and what you should be aware of when developing or migrating custom performance monitoring scripts from one release to another. When migrating to Oracle 10g, most people are focused on the new functionality that is being made available with the new release. Along with this new functionality, there is existing functionality that changes its behavior. This is where the biggest risks and surprises lie. The focus areas of this presentation will be Oracle10g reporting changes of: GV$ queries and their operation across multiple instances in a RAC Cluster, CPU time calculations for Parallel Query executions, determining the DOP achieved for Parallel Query operations, and identifying some data element precision changes.

Brian Doyle is responsible for product management, technical support and customer training at BEZ Systems. As chairman of the company’s Product Strategy Committee, Doyle also plays an active role in guiding the future direction of BEZ Software’s product solutions. He is responsible for evaluating market opportunities and establishing market requirements for existing and future products being developed by BEZ Systems. Prior to joining BEZ, he was responsible for managing the customer support operation for the Precise i3 product line at VERITAS Corporation. He was previously Director of Technical Services Operation for Precise Software, which was acquired by VERITAS. In this role, Brian was responsible for managing a team of technical service engineers that handled the daily call center operation, escalation processing and follow-the-sun handoffs for North and South America customers and partners.

 

DBA TrackEffective Use of Table Functions

This presentation begins with a brief description of table functions and covers the specification using both nested tables and indexed tables. The goal is to illustrate where the table function can be a tremendous advantage, especially in the world of web applications. Optimization plans are illustrated with the specific operations of a table function, as well as how to enable the table function for parallel processing. The final section of the presentation will discuss specific areas where the table functions can be misused.

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.

 

DBA TrackAutomating Database Management – How NOT to RAC Your Brain

Today’s organizations will reap tremendous benefits from the advanced capabilities of Oracle 11g database as the new features introduce a more sophisticated set of technologies into the IT environment. The introduction of Oracle 11g also requires a great deal of understanding and knowledge prior to implementation. Attendees will learn how automation can help companies overcome possible hurdles during the upgrade to Oracle 11g and ease ongoing management of the database infrastructure.

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. In addition, he has worked with Linux for almost 10 years, testing, contributing, and advocating Linux as the future of the enterprise datacenter. His code is running in a number of open-source software projects, and he currently serves as Chief Scientist of GridApp Systems, Inc.

 

DBA TrackDatabase Growth – Problems & Solutions

Critical Oracle Database application environments in many enterprises are growing larger and larger. Unmanaged data growth impacts application performance, escalates IT infrastructure costs, and reduces application availability for backup and recovery. The pros and cons of strategies for managing database growth will be discussed. This session is helpful for those who are experiencing database performance degradation, increasing database capacities (footprint), or increased time for database recoveries and backups.

For the last 15 years of his 25 year career, Eric Popiel has worked in Enterprise Software applications including Oracle, PeopleSoft, and SAP. Eric managed OuterBay’s North American pre-sales engineering resources, and now manages Hewlett Packard/OuterBay’s Americas Pre-Sales for Reference Information Manager for Databases, HP’s enterprise archiving solution. He is a frequent presenter at local, regional, and national conferences.

Brian Bent of Solution Beacon has over eight years of experience in all phases of design, development, and implementation of Oracle systems. He has worked with clients within the transportation, healthcare, and manufacturing industries. His areas of expertise include Database Administration, E-Business Suite Administration (installing, maintaining, patching and cloning), RAC and UNIX administration. Brian is adept at architecting infrastructure solutions, which includes O/S, Network, Storage, Database and Inter/Intranet design. He has been extensively involved in database and application performance tuning, capacity planning and implementing backup and recovery strategy for large 24×7 Oracle databases. Brian is currently an Oracle Certified Professional, a Red Hat Certified Engineer, and holds an ITIL Foundation Certificate in IT Service Management. Brian can be reached by email atbbent@solutionbeacon.com.

 

DBA TrackOracle 11g Database Replay

This presentation will explain the benefits of Oracle 11g Database Replay to IT Professionals and Managers. It includes all of the details for capturing the workload on one server and then replaying it on a second server so attendees will understand the impact of moving from one server/database version to another.

Inderpal Johal has been working as alead 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 also 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.

 

DBA TrackDatabase Security & the Insider Threat

Insiders attacks account for 80% of security breaches, and privileged users often have unlimited access to data without being monitored. This presentation will discuss how to maintain regulatory compliance related to insider threats. It will also describe several attacks that have been in the news recently and what countermeasures could be taken to avoid similar situations. Attendees will learn about database attacks initiated by employees of an organization and effective countermeasures against them.

Aaron Ingram has fifteen years of experience developing enterprise software, focusing on database systems and security applications. After graduating with a Bachelor’s Degree in Computer Science from Columbia University, he worked at Accenture as a consultant for Fortune 500 financial and telecommunication companies and for various government agencies. Most recently, he 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.

 

Developer TrackOracle 11g/10g Developers: What You Need to Know

New features of the Oracle 11g database geared to developers will be discussed and demonstrated. Attendees will be introduced to the new and improved features of Oracle11g/10g that directly impact application development. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL statements, case/accent-insensitive query, regular expressions, expanded LOB storage, new data types (Binary XML, BINARY_FLOAT, BINARY_DOUBLE, SDO_GEORASTER), new Statistical functions, Model clause, recycle bin, XML support improvements, MERGE improvements, Object improvements, expanded Java capabilities, Regular Expression expansion, virtual columns, and PL/SQL improvements. Attendees will be better equipped to create new applications or modify existing applications to take full advantage of Oracle11g/10g.

John King founded King Training Resources in 1988; he has been working with Oracle products since Oracle Version 4 and has been teaching Oracle-related courses since 1986. He has presented papers at various user group conferences including: IOUG-Collaborate, ODTUG, UKOUG, EOUG, AUSOUG, NYOUG, and the RMOUG Training Days.

 

Developer Track: Records and Information Rights Management

Attendees will learn how Oracle Universal Records Management (URM) and Information Rights Management (IRM) can greatly reduce organizational risk and lower the costs associated with discovery and other legal proceedings. Oracle URM allows you to enforce consistent records and retention management across the enterprise and enables you to apply your records management policies and practices on content in remote repositories such as file systems, content management systems, and email archives. URM also enables you to apply records management practices to non-records content. Oracle IRM allows organizations to protect content, even when it leaves the enterprise. Oracle IRM (formerly SealedMedia) is the best system to secure and track the use of sensitive documents and emails-even when copies are sent beyond your own network.

Brian Dirking has been in the electronic publishing industry for over 15 years, as Marketing Manager for Barrington House Publishing, Product Manager for OWL International Inc. and Director of Marketing for InfoAccess Inc. There he was responsible for the development of Web publishing technology that is now an industry standard, and licensed by most major content management vendors. He is currently Principal Product Director for Oracle Content Management, where he is responsible for Oracle URM and Secure Enterprise Search products.

 

Development TrackUsing OracleAS Portal to ‘Bring it all Together’

Oracle markets OracleAS Portal as the “Face of SOA.” This presentation will show how easy it is to create an “SOA-like” environment using OracleAS Portal’s sophisticated integration features (with minimal coding required). A live demonstration will be presented. This presentation shows how to integrate external applications into Portal and how to use Portal’s security features to provide a seamless environment for your end-users.

Chris Ostrowski is a Technical Management Consultant for TUSC in Lakewood, Colorado. He has worked with Oracle technologies for over 15 years and has presented at all of the major Oracle conferences. He is an Oracle Ace Director, coauthor of the Oracle Press book Oracle Application Server 10g Web Development with Brad Brown and is the author of The OracleAS Portal Handbook.

 

Developer TrackIntegrating Oracle 10g XML: A Case Study

Many times during a project life cycle, new technology is introduced that presents first time challenges. The author will describe a project using Oracle 10g XML DB and discuss why XML DB was chosen, how XML DB was used, and the technical issues encountered. The author will provide several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Attendees will learn about methods, design considerations and issues using Oracle 10g XML DB.

Coleman Leviter is employed as an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG’s Collaborate 07. He is the WEB SIG chair and sits on the steering committee at the NY Oracle Users’ Group. 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.

 

Developer TrackUsing Application Express with Fusion Middleware

Oracle Application Express (APEX, formerly HTML DB) can be used to rapidly develop web-based applications leveraging the features of Oracle database. The latest release of APEX integrates directly with Oracle BI Publisher and includes new functionality that can be used to invoke web services or processes built using Business Process Execution Language (BPEL). Oracle BI Publisher and Oracle BPEL Process Manager are both components of Oracle Fusion Middleware. This presentation will introduce attendees to aspects of APEX, BI Publisher and BPEL Process Manager that make this interaction possible. Participants will learn how to build simple user interfaces using APEX to interact with BPEL Process Manager and BI Publisher.

Basheer Khan, president and founder of Irvine, California-based Innowave Technology, was named the Oracle Magazine’s Integration Architect of the Year 2006 and Oracle Application Users Group (OAUG) Member of the Year in 2003. A frequent speaker on the capabilities of Oracle Applications & Technology at major conferences including OAUG Collaborate and Oracle OpenWorld, he has been published numerous times. With 20 years of experience in information technology & solution architecture, his specialization includes enterprise/business process integration using SOA, Web Services and Oracle technologies.

 

Development TrackReal-Life Data Mart Design Challenges

This presentation describes a real-life exercise in constructing a data mart to meet many of the challenges recognized in data mart design and implementation methodologies. Foremost among these is the need to load dynamically defined data (like Oracle Applications’ Flex fields) into the data mart, and build the reporting tool’s metadata so it correctly reflects the source system’s metadata. It will also address the issue of handling a very large number of dimensions (in the 100’s!) in a design that performs adequately, but also provides an intuitive end user query interface as well as the challenge of building an incremental refresh process that will also accommodate updates to the data mart contents. The presentation concentrates on design and methodology and describes the tools used (the Cognos ETL and reporting suite).

Leslie Tierstein is a Senior Technical Architect at newScale, Inc, a Silicon Valley-based company that provides and customizes ITIL (IT Infrastructure Library) applications. She has over 15 years of experience with Oracle technology, including project management, design, and implementation of OLTP systems and data marts. She is a recognized Oracle speaker and technical editor, and has spoken at Oracle conferences including ODTUG, IOUG, and NYOUG.

 

Development Track: ADP Implements a Real-Time Reporting System

ADP has initiated an enterprise-wide data integration initiative. The objective is to provide cross-product reporting/analytics capabilities across multiple HR, payroll, and benefits products that are implemented on disparate, heterogeneous platforms in an ASP environment. This has spawned a critical initiative called “ADP Reporting,” driving the IT team to implement a solution to enable real-time data integration from source systems into a centralized enterprise Oracle Data Warehouse. The first phase is to build an Operational Data Store by integrating data from multiple product lines and offering cross-product operational reporting. Participants will learn how to evaluate and deploy solutions that offload reporting demands from primary OLTP databases and allow for the enablement of a real-time, low-impact enterprise reporting environment, using the Oracle database and GoldenGate Software.

Amit Mukherjee is Sr. Director, Reporting Services at ADP. He has been leading the ADP Reporting Initiative as part of the Integration Services organization in the IT department at ADP Employer Services. He is responsible for the data replication and ETL of data for ADP Reporting as well as the front-end reporting application. Amit has over 12 years experience in the IT industry focusing on Data Warehousing, Data Integration, Business Intelligence and Decision Support Tools.

 

Development Track4GL Mini-Languages for Fast, High-Volume Reporting

Oracle (and other) databases are usually optimized to handle as many concurrent independent read and write transactions as possible, and most discussions of optimization focus on this usage pattern. This applies both to runtime speed and ease of development. However, the right mini-language can make use of tools and techniques specifically geared to work with complex reports in large batch processing situations. Even better, it can facilitate rapid development by using entity relationship introspection to ease query development and by including support for automatic print-vendor integration. Attendees will learn about techniques for using Oracle to quickly develop complex, flexible reports that perform well in very high-volume situations. The presentation also discusses the details of high-volume dynamic printing, interfacing with independent print vendors, and how software support can facilitate that communication and ease the fulfillment of large print jobs.

For the past five years, Joshua Kobrin served as the Data, Analytics and Reporting Architect for The Grow Network, a McGraw-Hill company. The Grow Network’s need to provide fast, high-volume reporting on standardized test results, led Kobrin to developed tools and techniques for the rapid development of such reports and for the optimization of their performance, using Oracle, Java, Python, and XSLT.

 

Fusion TrackThe Path to Fusion Using a Database-Centric Approach

The only portion of the Fusion platform that is not rapidly evolving or is likely to be obsolete in the near future is the database. Enforcing data-intensive logic in the database requires less code than when written in Java in the middle tier. The logic also executes much faster and requires less network traffic if placed in the database. This presentation describes a number of techniques using SQL and PL/SQL in the database including INSTEAD OF trigger views, views based on functions accessing object collections and various bulk SQL operations. It will also discuss how to successfully integrate these components into a Fusion application using ADF BC. The main sources of poor performance in a web application are poorly written SQL and high numbers of network round trips between the application server and database. A “thick database” approach to web development improves performance and reduces the amount of rewriting required as web development tools continue to evolve.

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 (Wiley). He is an Oracle ACE Director, SELECT Journal Associate Editor, ODTUG Symposium chairperson, 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.

 

Fusion TrackMade from the Same Mold: Templating Approaches for Fusion Applications

Users will more easily understand your application and will therefore be more productive if all pages of your web application are designed to look and act the same. The requirement for a common look-and-feel has traditionally been met by the use of templates. However, the methods for implementing template systems change with each new technology. This presentation discusses how to work with templates and other common look-and-feel options in JDeveloper 10.1.3. It explains and provides code examples for template systems using ADF Faces and JSP tags as well as additional Java frameworks. It also describes the Oracle Browser Look and Feel (BLAF), which is used for the E-Business Suite as well as the ADF Faces skinning feature and the JHeadstart plug-in to JDeveloper templates.

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 23 years of industry experience. Peter has presented at various Oracle users group conferences more than 200 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 Ace 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)

 

Fusion Track: Building Rich Web Applications Based on SOA
Do you want to know how you can build rich Internet applications based on SOA? Then this session is for you. Attendees will learn how to build rich internet applications using ADF Faces, build a SOA using BPEL and the ADF Business Components, and put together the web pages and the SOA using the ADF Model framework. This presentation will also discuss the benefits of using Oracle JDeveloper as a unique development tool.

A senior consultant in Fujitsu Consulting’s Quebec City office, Éric Marcoux is passionate about Java and Fusion Middleware. He acts as a technical architect and system integrator on his projects and he is an Oracle ACE Director and an Oracle Fusion Champion. Éric has written various technical articles, has given numerous presentations about Java and its many possibilities, has taught how to use Java and Oracle products. He has previously presented at Oracle OpenWorld, IOUG Collaborate, ODTUG Kaleidoscope and JavaOne.

 

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.

 

DBA TRACK: Anatomy of a Database Attack

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.

 

DEVELOPER TRACK: Introduction to Oracle Application Express

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 ofwww.skillbuilders.com which uses Oracle and Coldfusion. She also designed, developed and maintains www.RIOUG.org and www.RIRenewableEnergy.com

 

Oracle Database 11g: Unbreakable Meets Best Practices

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.

 

DBA TRACK: Using RMAN to Clone New and Refresh Existing Databases

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.

 

DEVELOPER TRACK: Globally Implementing Oracle Database Security

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).

 

DBA TRACK: Inside Oracle Database Vault

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.

 

DEVELOPER TRACK: Large Issues with Large Objects

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.

 

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.

 

DBA TRACK: In Bed with Oracle – Lifting The Covers on Database Creation

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.

 

DEVELOPER TRACK: Build Your Own Instant Client

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

 

DBA TRACK: Tuning Oracle 9i Using Statspack & AWR

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.

 

DEVELOPER TRACK: Web Application Security with JAZN – Implementing the Superstition in JDeveloper 10g

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).

 

DBA TRACK: Effective Use of Column Histograms

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.

 

DEVELOPER TRACK: BI Modeling and Forecasting with SQL

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.

 

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)

 

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.

Tom Kyte is a Vice President in Oracle’s Public Sector division. Before starting at Oracle, Kyte worked as a system 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. Kyte is also the author of 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.

 

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.

 

DEVELOPER TRACK: JDeveloper with ADF Faces and JHeadstart – 
Is It Oracle Forms Yet?

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).

 

DBA TRACK: RBaby to RMAN – Simplifying the Transition

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)

 

DEVELOPER TRACK: The Tie That Binds: An Introduction to ADF Bindings
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 and how one of its components, ADF Bindings, allows you to quickly connect components from any user interface library such as ADF Faces and JSF Reference Implementation 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 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).

 

DEVELOPER TRACK: Knit Data Together – Cleansing & Matching Techniques
This presentation is a review of key techniques used to accomplish a huge business imperative: high-confidence matching between huge, unrelated data stores. Techniques discussed include data cleansing, a “learning 
system” approach to improve tolerance for bad data over time, basic confidence routines used to build tolerance for bad data and the value of a ‘swarm’ approach for Oracle 10g when comparing huge volumes of data between sources. Topics covered include:
1. Data cleansing & matching techniques to help match up unrelated data. 
2. Learning Systems-type techniques to improve Bad Data Tolerance over time. 
3. Concurrency/”Swarm” techniques to take best advantage of Oracle’s 10g grid structure.

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

 

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 .

 

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.

 

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.

 

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.

 

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.

 

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.

Ranjeet Vidwans is a Director of Product Management in Oracle’s Identity Management group with responsibilities spanning the entire Identity Management portfolio.  Prior to Oracle, Ranjeet was with Thor Technologies for several years during which he ran Product Management and then Technology Alliances. Previously he has held sales, consulting, and product management positions at enCommerce, Entrust, and Cambridge Technology Partners. Ranjeet holds a Bachelor’s degree in Computer Science from Rutgers University. 

 

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.

 

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 atsteven@stevenfeuerstein.com.

 

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.

 

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.

 

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).

 

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.

 

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 9iCertified Master. 

 

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.

 

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.

 

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.

 

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.

 

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.

 

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.

Tim Gorman has worked in IT with relational databases since 1984, as an Oracle application developer since 1990, and as an Oracle DBA since 1993.  He is an independent contractor(http://www.EvDBT.comspecializing in performance tuning, database administration (particularly availability), PL/SQL development, and data warehousing.  He has been an active member of the Rocky Mountain Oracle Users Group (RMOUG) since 1992, been a board member since 1995, and is past president.  He has co-authored three books, “Oracle8 Data Warehousing”, “Essential Oracle8i Data Warehousing” (both from John Wiley & Sons) and “Oracle Insights:  Tales of the Oak Table” (from Apress), and he has presented at Oracle Open World, IOUG “Live”, UKOUG, Miracle Database Forum and Master Classes, as well as local Oracle users groups in North America and the Caribbean.

 

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.

 

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.

 

June 2006 General Meeting

KEYNOTE: Oracle Wait Interface: What, Why and How
This presentation will introduce you to Oracle Wait Interface. It was introduced in Oracle7 database, and now it has
become the primary tool for tracking database performance starting in Oracle Database 10g. We will discuss the reasons
why one needs to know about Oracle Wait events and how one can use those to diagnose and tune bottlenecks in the
system.

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.

 

High Availability and Recovery: Modern Considerations
This presentation provides a modern view of assessing and improving your data’s High Availability and Disaster
Recovery needs. Attendees will walk through three systematic views for high availability: active database states,
unplanned outages, and planned outages. The presenter will discuss ways to better understand and differentiate the
requirements for each of those three availability states, and real-world customer examples will be provided.

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

 

Getting Ready for Oracle Data Mining
This presentation provides an introduction to the major types of business problems where Oracle Data Mining can be used successfully. Oracle Data Mining is an Oracle database option embedded in the database server. This presentation shows how to prepare a data mart for data mining activities from an operational database. DBAs, data architects and data
analysts can learn how to get started with Oracle Data Mining. We will review the steps needed to operationalize data
mining following the CRISP-DM methodology. A demonstration of the steps needed to identify proper data/sources for
mining, data preparation and building preliminary models using the Oracle Data Mining GUI and also using the PL/SQL
APIs will be included. These models will then be applied to solve a given business problem. We will also demonstrate a
real time recommendation engine that is built using data mining to solve a real world problem.

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

 

Oracle10g Streams: Data Replication Made Easy
Oracle Streams was introduced as a solution for information sharing. Using Oracle Streams you can propagate data,
transactions, and user-defined events in a stream of information within a database, or from one database to another. In this
session, you will learn how to use Oracle Streams for data replication in a distributed environment. We will discuss the
main components of Streams, which include capture, propagation, apply, event staging, and the rules engine.

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.

 

Using 10g XQuery to Retrieve and Transform XML
This presentation provides an introduction to XQuery as implemented in Oracle 10g Release 2. Through a series
of real-life examples, Jeff will walk through the XQuery syntax from basic retrieval and transformation through
joining XML and relational tables. He will also discuss the basic operations for generating XML documents in
the format required by your application.

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.

 

IT’s Overlooked Security Threat: The Database
In this session, you’ll learn why forward-thinking enterprises are implementing database automation technology and how
they are quickly reaping the benefits of an automated database infrastructure. This presentation will examine industry
acknowledged best practices in the area of database management and share lessons learned straight from GridApp’s
experience managing databases for some of the nation’s leading e-commerce sites. It will also delve into the intricacies of
managing heterogeneous database environments and how automation can help your organization reap the benefits of a
clustered database infrastructure.

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.

 

Hierarchy in a Relational World
Attendees will learn about hierarchical relationships in a relational database and how to use hierarchical SQL, hierarchical
reports, trees and cascading lists of values in Application Express. The presentation will cover: parents, children, roots,
trees, leaves and cascading LOVs in Application Express.

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.

 

A Hitchhiker’s Guide to Oracle 10g RAC
Oracle Real Application Clusters remains a technology somewhat out of reach for many Oracle professionals. Without
special hardware, it’s difficult to get into the driver’s seat. But this is no longer the case. This presentation will provide a
step-by-step explanation of how to set up 10gRAC on a laptop or tower without additional external hardware, or even
virtualization software such as VMWare.

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.

 

Technical Challenges – TIFF Image Scanning and Retrieval Using Forms
Participants will learn how to retrieve, store and print TIFF image files residing on a remote database using Forms on AIX
5.2L. Challenges presented by this architecture will be discussed. Additionally, UNIX commands that may aid in
repairing unreadable and unprintable TIFF files will be addressed. Finally, workaround techniques and alternate
programming methods when conventional methods fail will be reviewed.

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

 

   

2006 March General Meeting

SOA & The Agile Enterprise – Leading companies are tackling the complexity of their application and IT environments with Service-Oriented Architecture (SOA), which facilitates the development of enterprise applications as modular business services that can be easily integrated and reused, creating a truly flexible, adaptable IT infrastructure. The result is closer alignment of IT and business execution for faster response to new customer requirements, competition, and changing market conditions. Using an SOA approach within your IT infrastructure provides significant benefits:
·         Simplified integration – Connect disparate applications quickly by creating standardized SOA services that know how to work together.
·         Increased reuse – Application components exposed as SOA services are easily reused, saving development time and increasing application reliability.
·         Greater agility – Rapidly deploy new business processes or modify existing ones in response to market changes using services as SOA process building blocks.
·         Reduced risk – Adaptable processes and a single security model for accessing services enables ongoing regulatory compliance in a timely, cost-effective manner.

This keynote will show Oracle’s application platform vision and strategy, and explain how to implement Service Oriented Architectures.

Roel Stalman is senior director of product management for Oracle’s Application Development Tools – including Oracle JDeveloper and Oracle ADF. He has held product management positions at Oracle since 1996 and is currently responsible for tools evangelism, product direction, and Java courseware. More recently, Roel has taken on the role of SOA evangelist for Oracle’s Fusion Middleware. Prior to product management, Roel was a trainer for Oracle Education in the Netherlands. He has been with Oracle since 1994.

 

Repository-Based J2EE Development – It has been difficult for traditional Oracle shops to make the transition to the J2EE technology stack. Getting up to speed building applications in this space takes a great deal of time. Applications that seem to perform well in development and test environments do not scale well in production. By using a repository-based approach, it is possible to cleanly and consistently generate entire applications, thus improving productivity and guaranteeing scalability. This presentation will describe an appropriate repository and a generation algorithm to generate JSP/Struts applications using Oracle’s ADF Business Components (ADF BC) framework.

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.  Paul is an Oracle Fusion Regional Director. He is the President of the New York Oracle Users’ Group and a Contributing 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 Business Rules Symposium, (now called Best Practices Symposium), currently in its seventh year, and the J2EE SIG.

 

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

 

Database Security: The Past, The Present, The Future – This presentation includes a live database hacking demonstration, database security trends, and an interactive discussion directly applicable to your database security challenges including:
·         Next generation blended database attacks (SQL injection, Web worms, Phishing, etc.)
·         Dynamic SQL Profiling for high performance database platform security
·         Vulnerability Profiling
·         Techniques for attack correlation and validation
·         How such trends and approaches to securing databases can be applied towards sustaining regulatory compliance requirements such as SOX 404, HIPAA, etc.

Mark Kraynak
, Director of Product Management, at Imperva, has years of hands-on experience in database technology, IT security and compliance across industries. Formerly of Ernst & Young Technology Services, Mark is a seasoned panelist and presenter at conferences worldwide and is currently spearheading the technical product management and marketing of Imperva SecureSphere.

 

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.

 

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.

 

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).

 

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.

 

Tired of Oracle’s SQL*Plus? Try Raptor! – Raptor 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. Raptor is Oracle’s answer to 3rd party products like Toad and SQL*Navigator. Stop by for a quick presentation and a full demo of Raptor. 

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

 

   

December 2005 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.”

 

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.

 

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.”

 

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

 

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.

 

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 DevelopersThe Oracle DBA Interactive Workbook, andOracle 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.

 

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 10grequires 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.

 

Ultra-High Performance SQL and PL/SQL in Batch Processing – Dr. Paul Dorsey, Dulcian, Inc.

 

   

2005 September General Meeting

KEYNOTE: Updates from Oracle HQ on SOA, Grid Computing and Oracle OpenWorld
 

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).

 

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.

 

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.

 

Extending the Power of Oracle AWR

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.

 

Multi-Client Development with JSF and ADF

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.

 

New Features of Oracle 10g, R2

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.

 

Common PL/SQL Programming Mistakes and How to Avoid Them

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.

 

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.

 

The Technology Behind Project Fusion

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.”

 

Tuning Oracle at the Block Level:

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.”

 

Integrating Oracle Portal with Active Directory

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.

 

Oracle Enterprise Manager 10g R2

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.

 

JDeveloper 10g View Layer Alternatives

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.

 

Demystifying Data Mining

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.

 

RMAN: Backup & Recovery Has Gotten Better

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.

 

HTML DB 1.6 New Features

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.

 

   

2005 June General Meeting Presentations

KEYNOTES
Rachel Carmichael Life in the Trenches – Database Administration in the Real World

 

Tom Kyte – Oracle  Corp. Things You “Know”

 

DBA TRACK

Tony Nicoletti – Oracle Corp. Oracle 10g Grid Control

 

Matt Larson – Confio Software Resource Mapping: A Wait Time-Based Methodology for Database Performance Analysis

 

Sean Hull – iHeavy, Inc. Open Source Tools for Oracle DBAs

 

DEVELOPER TRACK

Cameron Purdy
Tangosol, Inc.
Resource Mapping: A Wait Time-Based Methodology for Database Performance Analysis

 

Michael Rosenblum
Dulcian, Inc.
Code Generation in the World of Business Rules

 

   

2005 March General Meeting

DBA TRACK

Aaron Newman
Application Security, Inc.

New Vulnerabilities in the Oracle Database and Application Server

 

John Zhong 
Senior Technical Specialist Citigroup and
VP of American DBAOnline
Oracle Data Guard for High Availability and Disaster Recovery

 

  Integrating Data In Oracle Environments

 

DEVELOPER TRACK

  Recoding Slow Correlated Subqueries for Fast Results

 

Tanel Põder – integrid.info

Interpreting Execution Plans

 

Dai Clegg – Director, JDeveloper UK Development
Oracle Corporation
Agile MDA: an obvious oxymoron or a winning approach

 

Dai Clegg – Director, JDeveloper UK Development
Oracle Corporation
10g Application Server

 

   

December 2004 General Meeting

DBA TRACK

Darron Clark, Oracle Corp. Oracle Real Application Clusters: Expert Advice on Using RAC

 

Howard Horowitz, 
HGH Consulting
New and Improved Methods for Administering Your Database

 

Prat Moghe, Tizor Corp. Database Auditing for Privacy Compliance

 

Leslie Tierstein, 
Vision Chain Inc.
Taming the VLD Beast

 

DEVELOPER TRACK

Brahmaiah Jaugumulli, GE Laying the Foundations for High Performance Data Warehouses on Oracle

 

   

2004 September General Meeting

DBA TRACK

Michael S. Abbey –
The Pythian Group
up and Recovery – A Completeness Check

 

Anthony Noriega – Consultant A Robust Blueprint to Performance Optimization in Multiblock Databases

 

Ron Ben-Natan – 
Guardium
Beyond Intrusion Detection: The Next Frontier in Safeguarding Corporate Assets

 

Arup Nanda
Starwood Hotels & Resorts
Partitioning Beyond The Basics

 

Dave Anderson – SkillBuilders Oracle 10g New Features for DBAs

 

DEVELOPER TRACK

Nick Donatone – MFG Systems

Oracle Application Server 10g: Quick Installation Guide

 

Inderpal S. Johal – Consultant Oracle Data Pump: New ULTRA Octane Value for the 10g DBA Engine

 

Jeff Bernknopf – Technical Advantage Associates Rapid Development of Web Applications with HTML DB

 

Dr. Paul Dorsey – 
Dulcian, Inc.
Struts Development

 

APPS TRACK

Mike Guthrie – SceptreDB EDI and the Oracle Applications

 

Brian Deneroff  & Kim Flannagan – Oracle Corp. Self Service Modules and an Introduction to 11.5.10

 

Heidi Zee – ThoughtDigital Upgrading to 11i

 

Rob Lepanto – AppCentric Overview of Oracle Customer Relationship Management (CRM)

 

   

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.

 

Michael Abbey Jeopardy

 

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.

 

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

 

   

December 2003 General Meeting

Arup Nanda
Proligence
Fine Grained Access Control or Virtual Private Database in Oracle 10g – In this session, attendees will learn about the concept and workings of VPD via a live demonstration. Attendees will learn how to extend the functionality of the VPD using application context, where the usage of an application-authenticated user does not preclude VPD usage. Oracle 10g introduced the concept of static, context sensitive, and shared policies, which improved the performance significantly. These will be explained along with examples where they can be used.

 

Mike Hichwa
Oracle Corp.

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.

 

Inderpal Johal
Prnewswire

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.

 

Mike Hichwa
Oracle Corp.

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.

 

Boris Knizhnik
BIK Information Services, Inc.

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.

 

Ravikanth V. Kothuri
Oracle Corp.

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.

 

Shig Hiura
Etagon

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.

 

   

2003 September General Meeting

Tom Kyte – Oracle Corp. Tom’s Favorite 3 New Things Coming in Version 10g

 

Dave Anderson
SkillBuilders
Oracle9i New Features for DBAs: Oracle9i New Features for DBAs will provide you with an overview of many of the new DBA-centric features available in Oracle9i.  Release 1 and Release 2 features are discussed.  Our goal is to provide you with an understanding of the purpose and functionality of the feature, and in many cases provide a working example of the feature.

 

Richard Sarwal
Oracle Corporation
Oracle Database 10G: The Self-Managing Database: Enterprise databases continue to grow in size and number, resulting in increased systems management complexity. Oracle Database 10G introduces a sophisticated self-managing database that automatically monitors, adapts, and fixes itself. This presentation provides a technical overview of these self-managing solutions that allow DBAs to become more productive, help their organizations reduce management costs, and scale to manage the Enterprise Computing Grid.

 

Azeem Mohamed
Quest Software
Understanding and Leveraging Oracle 9i Advisories: In Oracle 9i, new features called “Advisories” help a DBA to choose the optimal sizes for the required memory components.  This session will investigate the new features of Oracle 9i relative to memory management and give insight on how a DBA can leverage these new available performance options.  The listener will learn about the dynamic SGA, new memory measurement units, as well as view SGA statistics, track resize operations, understand the new advisories, monitor SQL memory usage, enable automatic SQL memory management and other related memory management information.  Specific examples and scripts will be included to highlight use case scenarios of these advisory options.

 

Paul Baumgartel Oracle Data Guard Logical Standby:  A New High-Availability Option: This presentation discusses the new Logical Standby option introduced in Oracle9iR2, starting with a review of Data Guard concepts and the idea behind Logical Standby.  After summarizing the differences between physical and logical standby databases, it offers step-by-step instructions on preparation, creation, management, and tuning of a logical standby database, all based on experience.

 

Steve Muench
Oracle Corporation
JDeveloper 10g and Oracle ADF: More Visual and Flexible Than Ever: Creating a single, comprehensive development environment that appeals both to low-level J2EE gurus and higher-level business application developers has been a tall task, but has long been the vision of the Oracle9i JDeveloper product. The 9.0.5 release moves us miles closer to this finish line. A new, common approach to visual page editing and data binding, enhancements to our visual modeling tools, support for emerging standards, new mix- and-match capabilities in our application framework, along with plenty of polish, promise to please many more J2EE developers. This presentation will highlight all of the new features in JDeveloper 9.0.5 and the Oracle Application Development Framework (ADF). Some insights on the remaining areas of complexity to be tackled along with future ease-of-use features will also be discussed.

 

Ulka Rodgers
eTransitions
Migrating to a Unified Customer View: There have been many attempts at consolidating customer data under the guise of CRM, data warehouse, customer data mart and so on. This presentation discusses particular challenges of this data with example data models. We will examine the challenges of one-time migration as well as on-going updates and “continuous update” interfaces. In the context of urgency of business requirement, we will look at compromises that are possible and their consequences on maintaining data integrity.

 

Jeff Bernknopf
MFG Systems, Inc.
Developing Applications and Generating XML Documents using XML DB: Release 9.2 of the Oracle database introduced a facility for developing XML applications and generating XML documents known as XML DB.  In this presentation, Jeff Bernknopf, Director of Business Development for MFG Systems Corporation, will discuss how XML DB can be incorporated into the application development process.  The presentation will provide a brief overview of XML DB and the XMLType datatype.  The presentation will then describe a sample application, step-by-step, that receives XML documents, validates the XML document against its schema and then stores the XML document in an Oracle table.  The presentation concludes with a look at using the newly incorporated SQL/XML functions that provide extensions to SQL for generating XML documents.

 

Dr. Paul Dorsey
Dulcian, Inc.
Object Types vs. PL/SQL Tables: A Practical Example: There have been many new additions to SQL and PL/SQL in recent years. However, few developers and designers are taking advantage of these new capabilities. A recent project involved a very complex report where users could dynamically specify rows, columns and which of several statistics could appear in the cells. All this had to be done from a large database (millions of records). Traditional methods applied to the problem resulted in a solution with grossly inadequate performance. The ultimate solution involved using procedural coding to build an object collection which was then cast to a table for reporting purposes. This presentation will outline the construction of the report giving participants a practical example of where these new techniques in SQL and PL/SQL may prove useful.

 

   

2003 March General Meeting

Dave Anderson
SkillBuilders
Oracle 9i New Features for Developers

 

Joseph DeArce &
Yuriy Filonenko

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.

 

Michael Lynott
eTransitions
Adventures of a Development DBA: Iterative Development – Like it or not, application development is iterative (or “agile” or “”. This presentation discusses how an iterative project might be structured to bring discipline to this process.

 

Dan Hotka
Independent Consultant
Introduction to PSP, JSP, and XML – Using examples from his new book, Oracle9i Development by Example, Dan will illustrate how easy it is to adapt PL/SQL, and Java to existing web pages (PSP and JSP) and develop web-based apps using TOAD.

 

Jennifer McNeill
CipherSoft, Inc.
Converting Oracle Forms and PL/SQL to Java – With the emergence of Oracle 9i and Oracle 9iAS, users are trying to understand how to migrate their applications into the new “web enabled” environment. This presentation discusses the challenges of moving Oracle Forms and PL/SQL into Java and XML and reviews the pros and cons of migrating the applications.

 

Jorge Vargas
Independent Consultant
Oracle Workflow: Delivering What it Promises – This presentation will discuss the benefits of using the Oracle Workflow to model and run business processes.

 

   

December 2002 General Meeting

Dr. Paul Dorsey
Dulcian, Inc.
A Business Rules-Based Approach to Information Systems Development

 

Arup Nanda
Proligence, Inc.
Digging Deeper: Segment Level Statistics in Oracle 9iR2

 

Leslie Tierstein
STR Inc.
Goin’ Live: Deploying 9iAS to Intranet and Internet

 

Tim Gorman
SageLogix
Cats, Dogs, and ORA-01555

 

Craig Warman
CRT Inc.
Portal Release 2 Seminar

 

Claudio Fratarcangeli
Adept Technology Inc.
Query Tuning Using Advanced Hints

 

Daniel W. Fink
Optimal DBA
Applying A Blockcentric Approach To Oracle Tuning

 

   

2002 September General Meeting

Rachel Carmichael, 
Sony Music
How NOT to be a DBA — the Top 20 Mistakes – 45K

 

Ruth Gramolini,
State of Vermont
RMAN: Your New Best Friend – 40K This presentation will discuss reasons for using RMAN in your up & recovery and implementation strategies.

 

John King,
King Consulting, Inc.
Inner, Outer, Full? Oracle9i Join Syntax – 60K This presentation will discuss the standard ISO/ANSI Join syntax incorporated by Oracle9i.  ISO/ANSI standard Join allows more functional relationships than previously possible in Oracle. The “new” Join syntax will be explained and demonstrated.

 

Aaron Newman
Application Security, Inc.
Hack-Proofing Oracle – 280K This presentation addresses several of the most overlooked topics on Oracle security and presents a view of Oracle from a hacker’s perspective.

 

Paul Baumgartel
Adept Computer Associates
An Introduction to Oracle Advanced Replication – 25K The presentation introduces the concepts behind Oracle Advanced Replication (AR); the different modes in which AR can operate; and the tools required to implement and maintain it.  It includes a case study of a simple application of AR for one-way replication.

 

Michael Rosenblum
Dulcian, Inc.
Fire and Forget: When to Use Autonomous Transactions – 285K Autonomous transactions enable a PL/SQL routine to spawn a new session and execute code with an independent commit. This advanced transaction control is a very powerful tool that can solve a number difficult problems.

 

Leslie Tierstein
STR
Integrating Quality Assurance into the Software Development Life Cycle – 450K The ability to design, develop, and deliver a quality software product on time and within budget is, of course, the goal of every software development organization. By “building in” the quality from the very beginning of the software development life-cycle, and emphasizing the need for everyone to take responsibility for the quality of the product, the reliance on “testing in” quality at the end of the life cycle is reduced, as is the cost of rework.

 

 Back  

2002 June General Meeting

Michael Bell, BMC V$Views: Don’t Leave $Home Without Them – 810K Understanding Oracle’s V$VIEWS is the key to obtaining valuable performance related information. This paper looks at the information provided by the V$Views, and demonstrates how the DBA can use this information to diagnose and resolve many Database performance problems.

 

   

2002 March General Meeting

Richard J. Niemiec, TUSC The Uncommon Leader: Managing the Blur of IT – 765K

 

Dr. Paul Dorsey, Dulcian Is JDeveloper Ready for Prime Time? – 1M – For those new to the product, JDeveloper 9i represents a different way of building applications. Rather than telling attendees how to point and click, this presentation will provide an overview of the JDeveloper development environment and a list of the things you will need to know prior to building applications with the tool.

 

Kevin Loney, TUSC Online Database Block Size Rebuilds In Oracle9i – 765K– Oracle9i offers support for multiple database block sizes in the same tablespace.  DBAs can use this feature to support rebuilding their databases to a higher database block size while the database remains online.  This article will provide a demonstration of the steps required to increase the database block size for almost all tablespaces in an Oracle9i environment.  Topics covered include database quiescing, supporting multiple block caches, using the Oracle-managed files feature, and online object reorganization.

 

Richard J. Niemiec, TUSC Oracle9i New Tuning Features & Oracle8i Key Tuning Features – 765K – This fast-paced presentation will focus on some of the new features that you can use in Oracle9i. It will also cover a few of those things that you may not be using yet in Oracle8i that also provide a nice impact.

 

John Beresniewicz, Precise PL/SQL Practicum #2: Assertions, Exceptions and Module Stability – 90K – This presentation examines the subject of developing stable, bug-free PL/SQL code using Design by Contract principles.  The use of assertions to verify preconditions combined with modular code decomposition will be discussed as a means to achieve highly reliable code.  The difficult and often confusing topic of exceptions is also analyzed, with emphasis on the de-stabilizing effects of the ad-hoc (random?) approaches to exception handling that characterizes much existing PL/SQL code. Attendees should come away with a clear understanding of how modular code that asserts preconditions and handles exceptions in a disciplined and consistent way results in more reliable and bug-free systems.

 

Ari Kaplan, Expand Beyond Corp. Managing Your Database in a Wireless World – 500K – It is crucial for corporations that value their mission-critical data to explore, develop and deploy wireless initiatives within their Oracle environments. Today’s overburdened database professionals and end-users need the very latest tools and solutions in a fast-paced market. This presentation will address the business need for wireless database management, the technological barriers, and the current and future wireless world.

 

Gaja Krishna Vaidyanatha, Quest Software Oracle Performance Management – A Radical Approach 230K – Oracle performance tuning has developed a reputation as part science, part art, and part wizardry.  This presentation imparts the core principles of performance management by sharing a step-by-step process of iteratively investigating, determining, and implementing tuning solutions using a proven methodology. It propagates the idea that the bulk of possible performance gains can be achieved quickly and with minimal effort, if you truly know how to identify and understand the nature of your system and more importantly its bottlenecks. And we will do this without one infamous cache hit ratio within Oracle.

 

Douglas Scherer, CoreParadigm More Oracle Text Tips – 50K – This session presents a quick review of Oracle Text and CONTEXT indexes (the topic of Mr. Scherer’s last NYOUG presentation), and then introduces another Oracle Text index type, CTXCAT. CTXCAT supports features such as: transactional synchronization of an Oracle Text index, a more “web-like” set of search operators, and better performance of mixed queries.

 

Ulka Rodgers, eTransitions Prototypes: Methods, Mysteries and Magic – 400K – In web development, user interface can make or break an application’s success. Everyone agrees that prototyping is a useful way to design the user interface. Prototypes help us discover what the users need in spite of what they say they want. However, there are few methodologies that provide specific guidelines on how to develop prototypes. Prototypes are commonly used in other engineering disciplines to:
Model the concept to be implemented on a small scale
Prove that a particular technique or technology will work as envisioned
Present the look and feel of the completed project without incurring the full cost
This paper will focus on the use of prototypes for this last purpose: presenting the look and feel of the completed project. Keep in mind that prototypes may also be constructed for the other two purposes in our industry too, even though we practice more craftsmanship and less engineering discipline.

 

   

2002 January General Meeting

Dan Verton, Computerworld Securing Systems – 690K

 

Anita Bardeen, Oracle Corporation ORA-3113’s, 600’s and 7445’s Oh My! – 2M

 

Rod LeDieu, Business Enterprise Software & Training Inc. The Myth Of Business Intelligence – 1M

 

Leslie Tierstein, STR Consulting You’ve Got Mail – 1.2M

 

Ed Kosciuszko, Sequel Consulting Data Analysis SQL Functions In Oracle8i – 200K

 

Claudio Fratarcangeli, Adept Technology Inc. Processing Large Search Results In JAVA Internet Apps – 75K

 

Jason Couchman The Five-Day iDBA – 260K

 

Rob Edwards The State Transition Engine:Development Of Applications With A Business Rules Approach – 250K

 

   2001

2001 June General Meeting

James Viscusi High Availability & Parallel Fail Safe – 145K

 

Nicholas J. Donatone, Jeff Bernknopf, 
Peter Brassington
Oracle9iAS Portal: From DBA To Development To Deployment – 685K

 

Quest Software Corp SQL Tuning 101 – 1M

 

Veritas Corp Oracle Storage Management: New Techniques & Choices – 2.4M

 

   

2001 March Training Day

Leslie Tierstein Corporate Politics 101 – 240K

 

Paul Baumgartel Oracle8i Parallel Server In Enterprise-Level Clusters – 20K – Paper 20K

 

Jeff Bernknopf Developing Oracle Wireless Applications – 70K

 

Archana Asthana-Daniels Message Management with Advanced Queuing

 

John Beresniewicz PL/SQL Practicum: On Fetching and Explaining SQL From the SGA – 90K

 

Oracle Support Special: Oracle Support Answers Your Questions – 100K- Paper 150K

 

Ari Kaplan Moving to the Web: How to Prepare for the Switch – 230K – Paper 45K

 

Jason M. Cohen Developing Web Applications Using XML – 365K – Paper 40K

 

Erika Lawrence Clickstream Data Warehousing – 45K – Paper 20K

 

   2000

2000 December Training Day

Rachel Carmichael Congratulations, You’re The New DBA Don’t Panic – 65K – Paper 55K

 

Douglas Sherer Within You and About You: Getting Started With interMedia Text – 315K – Paper 35K

 

Craig Warman Oracle Portal 101 – Getting Started, Step-By-Step – Paper 30K

 

Chris Grabowy Oracle Database Monitoring For The Beginner – 60K

 

Eric Gray The Fundamentals: Moving From Paper-Intensive Commerce to e-Business – Paper 256K

 

Michael Ault Tuning When You Can’t Touch The Code – 1M – Paper 640K

 

William Cunningham Strategies For Rapid Development In Internet Time – 315K – Paper 175K

 

   1999

1999 December General Meeting

Meryl Surgan METADATA: A Walk On The Wildside – 200K

 

Rachel Carmichael 24 x 7: Contingency In The Real World – 40K

 

Edward Van Orden, Dulcian Go Kill All Reference Tables – Go Kart – 40K

 

   

1999 September General Meeting

Samir Shah, Oracle Oracle XML Support – 850K

 

Dr. Paul Dorsey, Dulcian Best Practices For Oracle Developer Forms: Beyond Base Table Blocks – 25K

 

  Business Applications – 990K

 

Jeff Bernknopf Developing JAVA Stored Procedures – 100K

 

Rachel Carmichael 
Marlene Theriault
The Care & Feeding Of Tablespaces In 8i – 100K

 

Rob Edwards Designing Star Schemas For Data Warehousing – 40K

 

Peter Brassington Introduction To Oracle Discoverer – 750K

 

   

1999 February General Meeting

Shriram Mani, Kumaran Converting Forms Vs Re-Engineering – 26k

 

Kenneth Walsh, Oracle Oracle’s Internet Platform 118k

 

Netdynamics Netdynamics 490k

 

  Recovery Manager 88k

 

Dr. Paul Dorsey, Dulcian Oracle Reports & Report Templates 96k

 

   

General Information – Developer

Tony Ziemba Developing Database Applications with JDeveloper – 275k

 

Dr. Paul Dorsey, Dulcian The Promise of the Object-Relational Paradigm – 40k