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.