  |
Hacking and Defending Databases - Slavik Markovich - CLTOUG - August 2007 |
|
|
Characterizing Workload for the Oracle E-Business Suite - Larry Klein - CLTOUG - May 2007 |
|
|
Oracle RAC and Other Database Availability Options - Dan Norris - CLTOUG - March 2007 |
|
|
|
|
|
Building Mappings with Oracle Warehouse Builder 10GR2 - Jim Rapper - CLTOUG - February 2007 |
|
|
|
|
|
Beefing Up Memory for 10g - Mike Ault - CLTOUG - January 2007 |
|
|
Automatic Undo Management and Flash Back Queries - Kirtikumar Deshpande - CLTOUG - July 2005 |
|
|
.... learn how undo segments attempt to
minimize 'Snapshot too old' |
|
|
Histograms - Myths and Facts - Wolfgang Breitling - CLTOUG - June 2005 |
|
|
.... explore different options available in Oracle 9 and 10 to gather column histograms and their effect on the histogram. .... |
|
|
9i/10g Tuning - Tuning Oracle has Radically Changed - Rich Niemiec - CLTOUG - April 2005 |
|
|
.... an overview of Oracle10g as well as an in-depth look at tuning Oracle9i using statspack and other methods .... |
|
|
If Your Memory Servers You Right... - Richmond Shee - CLTOUG - February 2004 |
|
|
Get acquainted with the Strange Oracle sort phenomenon |
|
|
Operational Timing Data - Cary Millsap - CLTOUG - January 2004 |
|
|
The old fashioned way of 'tuning" Oracle systems just doesn't work very well. When a program is slow.... |
|
|
Internals of 'SQL Parse Phase' - Murali Vallath - CLTOUG - November 2002 |
|
|
Parsing of SQL statements is the most expensive part of a transaction, ............... |
|
|
'Developing in Oracle 9i' - (Seminar) - Tom Kyte - CLTOUG - October 2002 |
|
|
1) Oracle Best Practices, database development (ask Tom's view of the world): 2) Oracle 9i R2 new features for developers and DBAs: 3) Asktom Live: |
|
|
'Oracle 9i LogMiner: Beginning to End, Command Line and GUI' - Joseph Testa - CLTOUG - September 2002 |
|
|
This mini-lesson covers beginner- to advanced topics of the 9i LogMiner. |
|
|
'Oracle Performance Management - A Radical Approach' (Seminar) - Gaja Krishna Vaidyanatha - CLTOUG - August 2002 |
|
|
Oracle performance tuning has developed a reputation as part science, part art, and part wizardry. This seminar will impart the core principles of performance management by sharing a step-by-step process of iteratively investigating, determining, and implementing tuning solutions using a proven methodology. This time-tested and field-proven methodology looks at performance management as having a system-wide scope. |
|
'ORA-3113's, 600's and 7445's Oh My!' - Anita M Bardeen - CLTOUG - June 2002 |
|
These three errors strike terror into the hearts of even experienced DBA's. This presentation is designed to give you a basic understanding of these errors, how to troubleshoot the, and how to effectively work with Oracle Support on these issues. |
|
|
'Myths & Folklore about Oracle Performance Tuning' - Gaja Krishna Vaidyanatha - CLTOUG - May 2002 |
|
|
It is hard to believe that the Oracle RDBMS has been in existence for over 22 years, a fascinating but true fact. In this period of time, it has undergone significant change. Over the years, with core functionality transformed, it has become imperative that we keep up with change. Every major release of Oracle makes some of us feel as though we have to re-learn the concepts all over again. Personally, with the advent of every major release of Oracle, I feel like a brand-new DBA..... |
|
|
'Tuning when you Can't Touch the Code' - Mike Ault - CLTOUG - April 2002 |
|
|
This presentation covers the situations where a DBA doesn't have access to the SQL code which is causing performance problems. The presentation deals with internal and external factors that the DBA can manipulate to improve performance without altering source code. |
|
|
'Oracle JDeveloper Seminar' - Dr. Paul Dorsey - CLTOUG - March 2002 |
|
|
JDeveloper
is Oracle’s tool for writing Java code. It is emerging as Oracle’s
premier development environment. The product supports stand-alone Java
development, as well as web development.
The latest release includes UML support and sophisticated
configuration management.
This product represents Oracle’s future direction in application
development |
|
|
'Applying Method to Tuning - Using STATSPACK' - Murali Vallath - CLTOUG - September 2001 |
|
|
Tuning databases should be performed in a methodical way. This presentation looks into the performance and tuning methodology. After discussion around the methodology, tuning using STATSPACK is discussed. In this part I of a two part presentation, the speaker will go into details on how to install STATSPACK on versions 8.1 and 8.0. The speaker will also discuss the report generation and what kind of details does this report provide. |