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.
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.
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.
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.
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
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
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.|
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
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 30, 2008
|Formulating the Grid Reliability and Performance Model|
Researcher and Database Engineer
March 4, 2008
|Advanced Oracle Troubleshooting|
October 11, 2007
|Real Life RAC Performance Tuning
|Sanjeev Jonglekar Technical Project – Advanced Customer Services. Oracle
February 28, 2007
|Mike Erwin – Hotsos Entreprise, Ltd.||RAC Performance Presentation Notes
|MatthewZito, Chief Scientist forGridApp Systems||Strategies & Tools for Centralizing and Automating Database Management|
|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.
|Logicworks||Migrating To 10g On Linux|
|Jarugumilli, Barhmaiah, Entreprise Architect
GE- Consumer Finance
|Analysis of Oracle System Load for Performance Management and Simulation
|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|
|DBA101: A Refresher Course – 50k|
|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|