All of the following articles may be viewed free of charge. You have permission to distribute these materials within your company; but you may not, however, re-publish or use any presentations without first asking for permission.
Thanks, Mike.
Beefing up Memory Sizes in Oracle 10g
Microsoft Word Document & Powerpoint files (zipped format); 457kb
|
This presentation examines the various memory components of the Oracle10g SGA and PGA environments. It examines the use of ASMM, considers the existing issues with ASMM use and discusses the other pools and their sizing issues. Finally, the PGA and its unique sizing issues are discussed.
|
Database Scalability and Goal Testing
Microsoft Powerpoint file (zipped format); 3.9mb
|
This presentation covers:
-
Scalability and goal type testing are important aspects of system management
-
OEM, while good for SQL tuning and regression testing, can’t support scalability or goal type tests
-
Using scalability and goal type tests you can easily and quickly find out how well your system does perform and how well it will perform
|
Managing and Administering with High Availability and Scalability
Microsoft Powerpoint file (zipped format); 2.8mb
|
This presentation presents why:
|
Oracle 11g SQL Advisor Improvements
Microsoft Powerpoint file (zipped format); 8.8mb
|
This presentation explains why:
-
SQL Advisor can help you with tuning
-
You must throw lots of resources at it
-
Try not to do complex analysis during production
-
It may not give you everything you want
-
As implemented in 10.2.0.3 for 11g there may be some problems…BEWARE
|
Oracle RAC - With or Without ASM
Microsoft Word Document & Powerpoint files (zipped format); 3mb
|
This presentation covers:
-
Oracle has provided the Grid Control system.
-
Gird control uses the database control to manage and maintain Oracle databases.
-
The cornerstone technology in Grid control is RAC.
-
RAC allows virtualization of multiple shared instances into a single database entity.
-
RAC depends on cluster file systems.
-
Many vendors offer cluster file systems.
-
Oracle provides two cluster file system solutions (ASM and OCFS2)
|
Performance Optimization and Benchmarking
Microsoft Powerpoint file (zipped format); 4mb
|
This presentation addresses:
-
Establishing performance benchmarks
-
Tracking performance of key SQL against the benchmarks
-
Why to optimize SQL proactively -- not reactively
|
SQL Tuning for Developers 101
Microsoft Word Document & Powerpoint files (zipped format); 1.8mb
|
This presentation:
-
Shows what Oracle provided tuning tools are available to the developer who needs to tune their code to perform optimally.
-
Discusses Explain Plan, tracing and tkprof, use of events and use of statspack and AWR to assist with the tuning of SQL and PL/SQL.
|
Testing to Destruction - Benchmarking Oracle Databases
Microsoft Word Document & Powerpoint files (zipped format); 5.4mb
|
This presentation examines:
-
The uses of benchmark tools to perform capacity analysis and prediction.
-
Examples using the Benchmark Factory tool to demonstrating the use of such tools for trending and planning for future needs.
-
The use of manual tools such as spreadsheets to do predictions of needed CPUs, memory and disks in server consolidations.
|
Common Performance Errors in Oracle Databases
Microsoft Word Document & Powerpoint files (zipped format); 478kb
|
This presentation illustrates the major tuning issues I have seen at many sites during tuning engagements. I have presented ways of determining if the issues exist and how to determine settings to help mitigate the issues in an active database.
|
Using STATSPACK to Track Down Bad Code
Microsoft Word Document & Powerpoint files (zipped format); 316kb
|
This presentation shows the importance of using statspack to help find and isolate SQL statements that need tuning. It covers the installation and use of Statspack and discusses AWR and its use along with statspack.
|