Partitioning, More Cost Savings, Better Performance, Better Management in 11g (911KB) Presented at: Midwest Oracle Users Group (MOUG) Presented by: Mike Messina Date: 11/05/2010 Abstract: Not available.

The Best Oracle Database 11g New Features (6.79MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 05/05/2009 Abstract: This presentation covers the following 11g topics: Using Memory_Target, The buffer cache and the result Cache, Virtual Columns, Invisible Indexes & Online Index Rebuilds, Creating & Rebuilding Indexes Online, 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, Real Application Testing, Interval Partitioning & Partition Compression, Automatic Diagnostic Repository (ADR), Auto Sample, Creating Pending Statistics, Adaptive Cursor Sharing and bind peeking, and Security Enhancements in 11g.

The Best Oracle Database 11g Tuning Features (7.03MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 05/03/2009 Abstract: This presentation is focused on the best new features in 11g related to tuning. It includes topics on Tuning using ADDM and ADDM Enhancements in 11g, SQL Plan Management, SQL Plan Baselines, SQL Performance Analyzer (SPA), Real Application Testing, The Result Cache, Invisible Indexes, Interval Partitioning, Partition Compression, Optimizer Enhancements including using extended statistics for correlated columns, Grid Control and Summary. This is a great presentation to learn, in a simple way, some new features in Oracle 11g.

Oracle High Availability (RAC, ASM, RMAN, and Data Guard) - A Case Study (5.08MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Rama Balaji Date: 02/12/2009 Abstract: Businesses today cannot tolerate downtime. Downtime means loss of business, and ultimately loss of revenue to the company. The real challenge of achieving 24/7 availability comes from productively utilizing all the available resources, software, and hardware. This presentation is a case study of one such customer, whose storage array failed during the heavy transaction processing time. We quickly brought the database back up and subsequently got their entire system restored, all the while maintaining at least two copies of production databases. This presentation is a perfect example of how a mission critical production shop can utilize all Oracle HA features such as RAC, ASM, RMAN, and Data Guard to acheive maximum availability.

The Best 11g New Features (5.70MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/17/2007 Abstract: This presentation will look at which 11g new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of all features. The features covered include: Start Me Up – Using Memory Target The Result Cache Invisible Indexes & Online Index Rebuilds Virtual Columns and other Nice Developer Tools ADDM Enhancements SQL Plan Management and SQL Plan Baselines SQL Access Advisor & Partition Advisor SQL Query Repair Advisor SQL Replay Advisor and DB Workload Capture & Replay Interval Partitioning & Partition Compression DBA Tools, ADR and DBMS_STATS Enhancements Grid Control & EM Security Enhancements & the Future Sizes Summary

Tuning the Oracle Grid (10.6MB) Presented at: Georgia Oracle Users Group (GOUSER) Presented by: Rich Niemiec Date: 03/05/2007 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. The main focus is to show many of the Grid Control screen shots so that the attendee can see the depth of the product.

Tuning Oracle9i/10g using Statspack & AWR (7.18MB) Presented at: Suncoast Oracle Users Group (SOUG) Presented by: Rich Niemiec Date: 02/15/2007 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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. We will also look at block level dumps and the rare case that you would use them for tuning.

Tuning Oracle9i/10g using Statspack & AWR (11.4MB) Presented at: Dallas Oracle Users Group (DOUG) Presented by: Rich Niemiec Date: 02/15/2007 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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.

Tuning the Oracle Grid (10.6MB) Presented at: Suncoast Oracle Users Group (SOUG) Presented by: Rich Niemiec Date: 02/15/2007 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. The main focus is to show many of the Grid Control screen shots so that the attendee can see the depth of the product.

Tuning Oracle9i/10g using Statspack & AWR (4.88MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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.

Tuning the Oracle Grid (10.0MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. This presentation will show many screen shots of what the product encompasses.

Tuning Oracle9i/10g using Statspack & AWR (11.1MB) Presented at: Oracle Development Tools Users Group (ODTUG) Presented by: Rich Niemiec Date: 06/19/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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.

Controlled Flights Into Terrain: Learning from Catastrophic Database Design Failures (643KB) Presented at: Collaborate Presented by: Kevin Loney Date: 04/24/2006 Abstract: Many database application failures result from design errors. These errors limit the performance and functionality of the application, ultimately limiting the business process the application is supposed to service. This presentation will provide a review of database application failures and a list of design principles that would have avoided the failures. From a performance perspective, every system is designed to fail at some point - and the system design is the key to extending the viability and usefulness.

Tuning the Oracle Grid (16.7MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. Getting good information RAC SIG OTN Oracle Technical Guides Grid Basics The interconnect and block coordination Tuning quick tips Tuning using statspack Tuning using grid tools High inserts Load balancing and FAN Future trends Installation Tips Where does ASM fit in? Enterprise Manager and Grid Control

Tuning Oracle at the Block Level; Beginners, Go Away! (1.54MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: If this talk doesn't kill me nothing will. This is a look at Oracle moving at the block level. We'll look at 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. Ok, it's because you want to know why. We'll also look at 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. We'll look at why the move toward 64-bit technology, memory resident databases and RAC/Grid makes this even more important to understand. Why you should understand some block level concepts Move toward memory resident databases Move toward RAC/Grid computing This is where the problems are hiding Block level concepts Current, CR and other blocks Versions of blocks Over the years Delayed block cleanout Blocks and the Grid Useful Scripts Summary

Tuning Oracle9i/10g using Statspack & AWR (5.07MB) Presented at: Collaborate Presented by: Rich Niemiec Date: 04/24/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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. Overview of statspack Top 5 wait events Load Profile Instance Efficiency Hit Ratios Wait Events Latch Waits Top SQL Instance Activity File I/O Memory Allocation Undo Oracle Recommendations Using Enterprise Manager Using other OEM screens to monitor and tune Helpful V$/X$ Scripts Summary

Tuning Oracle9i/10g using Statspack & AWR (1.98MB) Presented at: Virginia Oracle Users Group Presented by: Rich Niemiec Date: 03/01/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick 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. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as 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.