The Best Oracle Database 11g New Features (6.79MB) Presented at: Collaborate 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.

Exceptional Leadership; Be the Uncommon Leader (848KB) Presented at: Collaborate Date: 05/04/2009 Abstract: This presentation is focused on how to work on your atttibutes to build your leadership ability. Everyone has something that they need to work on, so this is a reminder of things that we should work on every week so that we can lead teams to do great things. It covers the following topics: Are you a Boss or a Leader?, How Leaders Become Leaders, Uncommon Leader Traits, Set your goals now - Build the Team, Historical Ages, and Summary.

The Best Oracle Database 11g Tuning Features (7.03MB) Presented at: Collaborate 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.

How Oracle Won the Database World (5.89MB) Presented at: Collaborate Date: 05/03/2009 Abstract: This presentation is focused on how the relational database came about and how Oracle took the lead and kept it. It also covers the state of Open Source competors and why Oracle will continue to lead in the future. It covers the following topics: The Paper that started it all – E. F. Codd, System-R & Ingres, Oracle is Founded as SDL, V1-V11g of the database, Why did Oracle win?, Future market direction, and Summary. Learn where Oracle has been and where it is headed in the future.

Giving Winning Presentations (4.10MB) Presented at: Collaborate Date: 05/02/2009 Abstract: The key to great speaking and giving great presentations is that extra effort after the tough technical part is built. Start with the idea that a great presentation is painful to build and it's a learning process for you the speaker as well. Write the presentation with the audience in mind, give the audience visual slides not just bullet points, teach to multiple levels within the audience, and truly care about your audience. Do all of this and you'll never do a bad presentation as long as you also practice! There are 35 tips included here that lead to great presentations and will definitely take your presentations to the next level if you make the effort.

Three Major Trends in the Database World (5.22MB) Presented at: Collaborate Date: 04/17/2007 Abstract: I've worked on Oracle, for almost two decades. Over the past five years, I've seen three major trends that seem to be molding the future of Oracle architecture and administration. The first is the adoption of clustering and an accelerating trend toward grid computing. The second is a movement toward Linux for smaller and mid-sized systems. The third is the pendulum swing first toward off-shoring database work and then a shift away from off-shoring and toward a new mixed model. All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs. This presentation will show how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.

What if Kramer was your DBA and Seinfeld Tuned your Database (9.25MB) Presented at: Collaborate Date: 04/17/2007 Abstract: This light hearted presentation will show what would happen if you had the characters from Seinfeld tune your database. Topics include: Jerry, I can't find my backup I know I had it here somewhere I think the UPS guys stole it I may have taped over it with Brittany Spears George, the database doesn't tune itself Elaine, the DBA can't stop working at 5 PM Jerry, uses Grid Control, Statspack and AWR Report...his system works spectacularly.

The Best 11g New Features (5.70MB) Presented at: Collaborate 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

How Oracle Came to Rule the Database World (5.71MB) Presented at: Twin Cities Oracle Users Group (TCOUG) Date: 04/12/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

How Oracle Came to Rule the Database World (6.33MB) Presented at: New York Oracle Users Group (NYOUG) Date: 03/15/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning the Oracle Grid (10.6MB) Presented at: Georgia Oracle Users Group (GOUSER) 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.

How Oracle Came to Rule the Database World (5.71MB) Presented at: Georgia Oracle Users Group (GOUSER) Date: 03/05/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning Oracle9i/10g using Statspack & AWR (7.18MB) Presented at: Suncoast Oracle Users Group (SOUG) 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) 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) 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.

Exceptional Leadership - Be the Uncommon Leader (3.39MB) Presented at: Suncoast Oracle Users Group (SOUG) Date: 02/15/2007 Abstract: How do you really succeed in your profession and in life? This presentation focuses on some of traits that can help elevate you to the next level. Those leadership skills discussed include: integrity, moral courage, physical courage, self control, enthusiasm, knowledge, initiative, respect, tact, loyalty, unselfishness and humility. It also focuses on mentoring the next generation and leading the next historic wave.

Tuning Oracle9i/10g using Statspack & AWR (4.88MB) Presented at: Los Angeles Oracle Users Group (LAOUG) 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.

How Oracle Came to Rule the Database World (4.76MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Date: 02/06/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning the Oracle Grid (10.0MB) Presented at: Los Angeles Oracle Users Group (LAOUG) 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.

Giving Winning Presentations (7.58MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Date: 02/06/2007 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include:

How Oracle Came to Rule the Database World (4.76MB) Presented at: Midwest Oracle Users Group (MOUG) Date: 09/08/2006 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Giving Winning Presentations (14.6MB) Presented at: Oracle Development Tools Users Group (ODTUG) Date: 06/19/2006 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include: Why you're giving the presentation Why your audience came to listen The opening Your speaking style and tone The abstract and material to cover Practicing Keeping it exciting The handouts Taking questions The summary and ending

How Oracle Came to Rule the Database World (7.93MB) Presented at: Oracle Development Tools Users Group (ODTUG) Date: 06/19/2006 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success. The Paper that started it all - E. F. Codd System-R & Ingres Oracle is Founded as SDL V1-V10g Why did Oracle win? Future market direction Summary

Tuning Oracle9i/10g using Statspack & AWR (11.1MB) Presented at: Oracle Development Tools Users Group (ODTUG) 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.

Exceptional Leadership; Be the Uncommon Leader (1.00MB) Presented at: Mid-America Association of Educational Opportunity Date: 05/16/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

Tuning the Oracle Grid (16.7MB) Presented at: Collaborate 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 Oracle9i/10g using Statspack & AWR (5.07MB) Presented at: Collaborate 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 Oracle at the Block Level; Beginners, Go Away! (1.54MB) Presented at: Collaborate 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

Giving Winning Presentations (4.45MB) Presented at: Collaborate Date: 04/24/2006 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include: Why you're giving the presentation Why your audience came to listen The opening Your speaking style and tone The abstract and material to cover Practicing Keeping it exciting The handouts Taking questions The summary and ending

Beginner Tuning Tips for Developers (3.19MB) Presented at: Collaborate Date: 04/24/2006 Abstract: This is a beginner level presentation on developer tuning. This presentation is focused on developers who are relatively new to Oracle. It will focus on some basic tuning tips and techniques that you can use to tune your code. After a brief look at how Oracle works and where a query fits into the process. We will look at how to find the problem queries in your system. We will also look at various indexes that can be built and things to watch out for with certain indexes. We'll review how to use explain plan and Autotrace. Lastly, we'll look at using hints to tune queries and joining tables. Overview of how Oracle works and where queries fit into the process Finding the problem queries Your indexing arsenal Using Explain Plan and Autotrace Hints that can help Joins and the Driving Table Partitioning Basics

Exceptional Leadership; Be the Uncommon Leader (1.00MB) Presented at: Upward Bound Date: 04/01/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

Exceptional Leadership; Be the Uncommon Leader (3.57MB) Presented at: Virginia Oracle Users Group Date: 03/01/2006 Abstract: This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that a leader must have from a character perspective to combine with technical prowess. To be a leader that builds a truly great organization, you must build into the team: Integrity, Moral Courage, Physical Courage, Tact, Loyalty, Unselfishness, Initiative, Enthusiasm, Knowledge, Respect, Self Control, and Humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine these attributes and bring out the Uncommon Leader within you.

Tuning Oracle9i/10g using Statspack & AWR (1.98MB) Presented at: Virginia Oracle Users Group 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.

3 Major Trends in the Database World (3.59MB) Presented at: WebEx Briefing Date: 02/15/2006 Abstract: I've worked with TUSC, a major Oracle integrator, for almost two decades. Over the past five years, I've seen three major trends that seem to be molding the future of database administration. The first is the adoption of clustering and an accelerating trend toward grid computing. The second is a movement toward Linux for smaller and mid-sized systems. The third is the pendulum swing first toward offshoring database work and then a shift away from offshoring and toward a new mixed model. All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs. This presentation will show how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.