Pre Oct. 2013: DBA 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 DBA SIG presentations that occurred prior to October 2013.

Robert Stackowiak, Vice President Data Systems Architecture
Oracle Enterprise Solutions Group

Sep 21, 2012

Oracle ZFS Storage Appliance for Exadata Backup & Recovery

When it comes to the backup and recovery infrastructure of the Exadata Database Machine, conventional solutions often have only limited performance to keep up with Exadata throughput, whereas Oracle ZFS Storage Appliance can be configured as a very fast, capable, and easy-to-manage backup and recovery solution for any Exadata environment. In this session Husnu Sensoy will describe some of the configuration possibilities of the ZFS Storage Appliance to create a flexible backup and recovery environment for Exadata, as well as various tuning do’s and dont’s to maximize your backup and recovery performance.
 

 

Robert Stackowiak, Vice President Data Systems Architecture
Oracle Enterprise Solutions Group

Sep 21, 2012

An Integrated Analytics & Big Data Infrastructure

This webinar will discuss An Integrated Analytics & Big Data Infrastructure.
 

 

Michael S Abbey

Feb 3, 2012

RMAN – Don’t Forget the Basics

This webinar will discuss the bare bones RMAN setup items that will bulletproof your image backups. There are many emerging bells and whistles with 11gR2. This session will present the top 10 setup items that are fundamental to writing recoverable RMAN backups from day one. After the basic setup, the technologist can move on to leverage some of the new-fangled functionality of this legacy but developing backup solution. Topics covered include: present configuration and implementation items. use of a recovery catalog, block change tracking, restore database validate, and the ultimate configuration requirement-controlfile autobackup. If you read the fine print in the documentation, you would find assumptions of setup items that are expected to be in place to allow feature XYZ to work as documented. The nature of those assumptions is at the heart of this webinar. The target audience is beginner to experienced.
 

 

Stephane Faroult
RoughSea Ltd

Oct 28, 2011

What Oracle Can Tell You About Your Applications

For most database administrators, monitoring performance means checking that nothing is horribly wrong with waits or locks or the top 5 SQL statements by CPU, logical I/Os, or physical I/Os. For most developers, the database is something fairly abstract, usually at the root of their performance issues, for which the usual panacea is called “indexing”. When they meet, they have trouble reconciling their visions and looking for solutions or improvements. But in fact Oracle can tell more about the application it runs than the top waits or the top SQL statements – even if you have to read between the lines. I’ll try to briefly take you through a few analysis that can be made and can help DBAs and developers to discuss more effectively.

 

George Trujillo

Oct 14, 2011

Virtualization Workshop for Oracle DBAs/Developers

The default platform for Oracle database/application servers is rapidly moving towards virtual machines. This is why virtualizing Oracle Databases on VMware is one of the largest growth areas in the IT industry. This presentation will show attendees the various virtualization alternative technologies and how virtualization works under the covers. Key features such as vMotion, Storage vMotion, DRS /HA clusters and SRM will show attendees how virtualization is completely changing how Oracle environments are being managed. Success recipes for virtualization projects and virtualization best practices will be covered.
 

 

Jordan Braunstein
Oracle Ace Director Visual Integrator Inc.

June 24, 2011

Flying in the Clouds – An Introduction to Cloud Computing

An Introduction to Cloud Computing, fundamental concepts, principles, benefits, and challenges. The session will start with an overview of Cloud and help to define what cloud is and what it consists of. Jordan will cover what makes cloud computing unique from its predecessor paradigms and why the industry is so excited about moving companies and data centers into the cloud. The session will also cover practical approaches to implementing a cloud project, both as a cloud provider or a cloud consumer-in other words a methodology for “entering the cloud”. Also discussed will be challenges, dispelling myths, and how to take incremental steps for getting started with a cloud implementation.

 

Arup Nanda, Principal Database Architect, Starwood Hotels

March 11, 2011

Deferred Statistics and SQL Plan Management for Performance in Oracle 11g

Statistics can make or break performance. While it may help in many cases, it may hurt as well. Pending stats in Oracle 11g solve the problem by bringing a sort of try-before-you-buy concept into statistics management. In this session attendees will learn how to enable, test and promote deferred statistics, gather history, use it for a test database and use SQL Plan management to fix a plan using the statistic gathered to go around the inefficient execution plan. Shown with live demos.

 

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
 

Iordan Iotzov
News America Marketing (NewsCorp)

March 2, 2010

The presentation provides guidance for selecting the optimal number of hash or range index partitions in OLTP databases. The presented method focuses on the height of the index partitions, and can deliver index scan improvements of up to 12%. Experimental results and practical hints are reviewed and discussed.

Presentation: Flatten indexes by tuning the number of partitions 
Text file with test setup scripts: Flatten indexes by tuning the number of partitions.txt
 

Jim Williams
Oracle Corporation

October 6, 2009

A vital element of all enterprise database environments is the underlying management of storage. Before Oracle 10g, storage management components below the database were left for others to provide. Vendors often developed general solutions that did not account for essential requirements of large databases. Many point solutions addressed certain problems, but created weaknesses in other areas. Furthermore, some of the most difficult problems involved databases in clusters. Consequently, Oracle developed ASM in response to these shortcomings. This presentation discusses some of these challenges and how ASM addresses them.

Automatic Storage Management

Michael New
April 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

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 30, 2008

Formulating the Grid Reliability and Performance Model
Tanel Poder
Researcher and Database Engineer

March 4, 2008

Advanced Oracle Troubleshooting
Arup Nanda
Lead DBA
Starwood Hotels

October 11, 2007

Real Life RAC Performance Tuning
 
Sanjeev Jonglekar Technical Project – Advanced Customer Services. Oracle

February 28, 2007

Oracle Streams
 
Mike Erwin – Hotsos Entreprise, Ltd. RAC Performance Presentation Notes 
 
MatthewZito, Chief Scientist forGridApp Systems Strategies & Tools for Centralizing and Automating Database Management
Tom Kyte 
Oracle Corporation
Tom Kyte describes common SQL techniques he has encountered and utilizes day to day to tune query performance. Features such as scalar subqueries, using rownum (yes, to ‘tune’), analytics, some hints and more will be demonstrated. Emphasis is on when they work (where the ‘trick’ applies) as well as when they don’t work and where they do not apply. Care is taken to show these not as a “top 10 things to do” but rather techniques to keep in mind when looking at problems in general.
ZIP FILE
Logicworks Migrating To 10g On Linux
Jarugumilli, Barhmaiah,  Entreprise Architect   
GE- Consumer Finance
Analysis of Oracle System Load for Performance Management and Simulation
PRESENTATION
PAPER
Dave Anderson – SkillBuilders Oracle10g New Features: Flashback Enhancements
Simay Alpoge Bulk Collections and Inserts in Oracle 9i & 10g
Dave Anderson – SkillBuilders Oracle 10g Feature: RMAN Incrementally Updated Backups
Larry Carpenter, Oracle Corporation Oracle DataGuard New Features in 9i and 10g
Larry Carpenter, Oracle Corporation Introduction To DataGuard
Jeff Holt and Gary Goodman, Hotsos Enterprises, Ltd. Using 10046 trace data to resolve Oracle performance issues – A review of three case studies 
Paper ;Presentation – This is a very interactive presentation where we will review 3 actual case studies from the last year.  We will examine our client’s performance problems and how the Hotsos method was utilized to rapidly determine and repair the root cause issues.  We will use these case studies to show the effectiveness of using 10046 level 8 trace data as the basis for Oracle optimization.  We will close with a brief discussion of Hotsos and a short demo of the Hotsos Profiler.
Bill Beauregard Oracle 9i Workspace Manager Overview
Kristina M. Murray Automating Database Startup and Shutdown on Unix 2/6/02 – 440k
Paul Baumgartel Designing For Performance 07/10/01 – 25k
Henry Pikner Oracle Pipes- Presented on 05/17/00
Rachel Carmichael 
Marlene Theriault
DBA101: A Refresher Course – 50k
Rachel Carmichael 
Marlene Theriault
Exploding The Myths – by Rachel Carmichael & Marlene Theriault – 70kPaper 40k
Marlene Theriault Oracle8 Challenges for DBAs
Megh Thakkar Oracle8 On Windows NT- 120k
Marlene Theriault Let’s Tune Oracle8 For NT – By Marlene Theriault 95kPaper 60k