Pre Oct. 2013: Long Island SIG Presentations

In 2013 NYOUG redesigned its web site. To keep the older presentations they were grouped together by SIG and posted as one post. The following are all the LI SIG presentations that occurred prior to October 2013.

Gurcan Orhan

December 7, 2012

Oracle Data Integrator (ODI) seems slow when it is installed out-of the box. Since it has to comply with different versions of the databases and operating systems, this default installation is not the optimal choice. ODI is a flexible product can be customized for specific requirements and to implement new features of the database or operating systems. Attendees will learn how to easily create a customized ODI environment. This presentation will demonstrate the flexibility of the Knowledge Module, configuration best practices, and the best query response time tips and techniques. It will include information about how to load an extensive number of files quickly with a special algorithm, as well as how to define new or customized data types and analytical functions.

Presentation: Best practices with Oracle Data Integrator (ODI): Do you know how flexible ODI is?




Erik de la Iglesia

February 22, 2012

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.

Presentation: Increase Performance of Existing Oracle RAC Up To 10x


Rich Niemiec, Oracle Ace Director and a co-founder and CEO of TUSC

November 16, 2010

This presentation discusses which 11g new features should be investigated for use. Most of the features covered are relevant for DBAs, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of the following new features:

  • Start Me Up – Using Memory Target, The Buffer Cache & The Result Cache
  • Virtual Columns
  • Invisible Indexes & Online Index Rebuilds
  • DDL Lock Timeout, PL/SQL Expressions/Simple Integer
  • Secure Files
  • ADDM Enhancements
  • SQL Plan Management (SPM) and capturing SQL Plan Baselines
  • SQL Performance Analyzer, Access Advisor & Query Repair Advisor
  • Exadata Simulation
  • Real Application Testing (Database Capture and Replay) & Adding Nodes
  • Interval Partitioning & Partition Compression
  • Automatic Diagnostic Repository (ADR)
  • Auto Sample, Creating Pending Statistics
  • Adaptive Cursor Sharing and Bind Peeking
  • EM, Grid Control, Security Enhancements & the Future Sizes


Girish Venkat CISSP, Oracle Corporation

June 3, 2010

Virtualized hardware is all the rage in enterprise IT. However, is a purely virtualization-focused, Infrastructure-as-a-Service (IaaS) approach really the right one for enterprises and government? What is becoming clear is that virtualization is but one piece of a much bigger strategy for fast, self-service deployment and ultra-efficient operations, referred to as “platform as a service” (PaaS). PaaS leverages a wider set of middleware capabilities to enable application deployment in minutes rather than days and reduces operational costs by up to 90%. This general session will compare and contrast the IaaS and PaaS approaches, discussing architectural and operational considerations for PaaS using examples of best practices. It’s a must-attend session for anyone considering building a private cloud.

Presentation:PaaS is the Remedy for VM Hangover

Marshall Presser
David Partridge
Oracle Corporation

June 1, 2010

The new Exadata V2 database machine goes beyond data warehousing to also deliver extreme performance and scalability for online transaction processing applications (OLTP). Oracle Exadata Storage Servers combine Oracle’s smart storage software and Oracle’s industry-standard Sun hardware to deliver the industry’s highest database storage performance. To overcome the limitations of conventional storage, Oracle Exadata Storage Servers use a massively parallel architecture to dramatically increase data bandwidth between the database server and storage. In addition, smart storage software offloads data-intensive query processing from Oracle Database 11g servers and does the query processing closer to the data. The result is faster parallel data processing and less data movement through higher bandwidth connections. This massively parallel architecture also offers linear scalability and mission-critical reliability. Marshall Presser and David Partridge will provide a technical overview of the Exadata hardware and software platform. An Exadata demo will also be featured.

Presentation: Oracle Exadata V2 – The World’s First OLTP Database Machine with Sun Flash Fire Technology

Michael New
May 14, 2009
Oracle Enterprise Manager 10g Grid Control is a robust web-enabled systems management product, having matured considerably since its OEM 9i client/server roots. Accompanying this expanded functionality is a more complex installation and configuration process. This presentation begins with installation issues, including Grid Control architectural design considerations and recommendations for high availability and disaster recovery. The second half of the presentation deals with configuration matters — notification rules, Agent configuration tips, metric tuning recommendations, job and user-defined metrics examples, Grid Control backup recommendations and methods, and recovery configuration settings and procedures.

Presentation:Oracle Enterprise Manager 10g Grid Control  
Podcast: Oracle Enterprise Manager 10g Grid Control.mp3

Abdul Hafeez Shaik Apps Associates.

March 12, 2009

This Presentation will provide an overview of how Datawarehousing Administration Console (OBIEE DAC) abstracts underlying Complex ETL, handles the Incremental Extraction & Load processes. It also discusses advantages of Micro ETL of DAC and best practices in customizing existing or creating the new DAC and ETL processes . You will learn how Oracle DAC is used in scheduling & managing the ETL runs and its role in ETL performance tuning and OBIEE.

Datawarehousing Administration Console (OBIEE DAC)

Sanjeev Joglekar
Oracle Solution Support

March 12, 2009

Oracle Database 11g contains many new features and enhancements that are beneficial for DBAs, developers, and end-users. This presentation will describe some of the most popular new features for DBAs, including hot patching, Snapshot Standby, Active Data Guard, Real Application Testing, Oracle Total Recall, and a few others. At the end of this session, attendees will have a high-level understanding of the change management functionality along with some other features to help simplify the upgrade of existing databases to Oracle Database 11g.

Oracle Database 11g – New Features for DBAs

Anthony D. Noriega
Advanced Data Networks

October 28, 2008

Case Studies in RMAN Metrics
Bill Rose
Estee Lauder Companies

October 28, 2008

Leveraging Oracle with Microsoft .Net
Jamon Bowen 
Texas Memory Systems

March 13, 2008

Understanding Storage Impact on Oracle Performance
Nick Donatone
Grid Sales Consultant, Oracle Corporation

January 29, 2008

PL/SQL Tips and Techniques 
Geoffrey Wiland

January 29, 2008

XML in Oracle
Simay Alpoge
Next Information Systems, Inc.

March 1, 2007

Oracle 10g analytical SQL for Business Intelligence Reporting
Larry Klein, 
VP of Hotsos Entreprises, Ltd.

June 27, 2006

Business consumers of an Oracle-based application measure the success of “the system” based on the metrics of availability, response time, and throughput.
Technical support staff measure that same system success using metrics of utilization and transactions per second. These two views use different vocabulary which often leads to miscommunication, ineffective problem management, substandard performance, and over utilization of hardware resources. This presentation suggests how “the system” can be modeled as a factory, and common metrics can be established and shared among all stakeholders in simple and meaningful ways. Characterizing Workload thru an Oracle Database
Prabhu Shanmugam
Arrow Electronics

June 27, 2006
LI & Web SIG Meeting

Currently, application frameworks are very prominent in software development whether you work with home grown or COTS-based applications. This presentation will describe the changes from function-oriented to object-oriented to service-oriented development. Attendees will learn how having a framework helps application development with focus on some of the MVC (Model-View-Controller) based frameworks, and how component oriented development helps you work in the service-oriented framework world.
Application Frameworks
Vikas Sawhney A Look at Partitioning
Howard Horowitz – Oracle Oracle 10g (OCP) Certification Preparation
Sandeepan Banerjee – Oracle Integrating A Heterogeneous Environment Using XML
Alex Hoyos, Senior Data Architect Cablevision Accessing Oracle from C# and Microsoft .NET
Jack Raitto 
CDC Development Manager, Oracle Corp.
Change Data Capture in Oracle 10g
Martin Farber
Qualitec Inc.
The Art Of SQL Tuning
Michael Fargo
Cablevision/Data Modeler / Data Architect
Materialized Views – Euphoria, Reality and altering your Design
  Backup Scripts (ZIP FILE)Restore Scripts (ZIP FILE)
Raj Sakthi
Senior Oracle DBA
GO LOCAL..! ALL ABOUT LOCALLY MANAGED TABLESPACES – The audience will learn all about LMT’s. What makes them tick, Why it is a better choice, what are the advantages, and more.
Yomi Odedeyi, 
Euro RSCG Circle
Migrating From Unix To Linux – An Oracle’s Journey – Yomi discusses his trials and tribulations migrating his Oracle Databases from Solaris to Linux. He discusses topics such as cost justifications for doing it, resources necessary, critical success factors, installation process, lessons learned.
Rob Edwards, Dulcian Oracle 9i Data Warehouse Review  – Oracle9i Server presents the latest move by Oracle in establishing a data warehouse platform for supporting e-business intelligence applications. This new version release of Oracle Server lays the foundation for a “Data Warehouse Platform” that adds integrated OLAP services, data mining, an ETL infrastructure, and additional analytical SQL functions to the relational database.  The new Oracle Warehouse Builder 3i, with its new mapping architecture and enhancements, will also be reviewed.
Howard Horowitz Oracle Certification Preparation (OCP) – Attendees are introduced to general Oracle Certification Professional (OCP) exam info, what’s needed to pass the exams and an overview of each exam. This 45 minutes to one hour session is divided into two parts. First part focuses on what OCP is and how it can help you in today’s market/economy. It examines the resources used to prepare for the exam and discusses the structure of the exams and strategies used to pass them.

The second part of the presentation discusses each section of the exam and focuses on various topics 
from each of the six sections. Exams discussed: (1Z0-001-Intro to SQL and PL/SQL, 
1Z0-023- Oracle 8i Architecture and Administration, 1Z0-025- Oracle 8i Backup and Recovery, 
1Z0-024-Oracle 8iPerformance and Tuning, 1Z0-026- Oracle 8i Network Administration,
1Z0-030-Oracle 9I New Features).