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:
|
| 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 |
| 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. |
| 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. |
| 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 Skillbuilders 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 |
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 NMHCrx |
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 |