1-How to use v$sesstat when wait interface is not enough?
Tanel Poder-Beyond Oracle Wait Interface – Part 2
2-How to get Oracle process info from OS on Windows?
Charles Hooper-Drilling into Session Detail from the Operating System – On the Windows Platform
3-How does force_match work with SQL_PROFILEs?
4-How to report bar chart of frequency histograms in sqlplus ?
Guy Harrison-Histograms of histograms
5-How to get around from _pga_max_size limitation?
Kelly Pedersen-When PGA Size is Not Enough
6-How to drill down and detail sys_time_model data ? –Highly Recommended
Charles Hooper- Working with Oracle’s Time Model Data
Charles Hooper-Working with Oracle’s Time Model Data 2
7-Diagnosing CBC Latches and their causes and possible solutions
Kyle Hailey-Oracle Waits – latch : cache buffer chains
8-Oracle and Netapp best practices
Neil Gerren-Oracle on NetApp White Papers
9-How to setup dataguard with OEM Grid Control?
Porus Homi Havewala-Easy Disaster Proof Production
10-How does execution plan gathering can be wrong?
Charles Hooper-Explain Plan Lies, Autotrace Lies, TKPROF Lies, What is the Plan?
11-How to drop partitions from interval partitioned table?
Harald van Breederode-dropping inverval partitions
12-How does Join Elimination works in 11G for unnecessary self joins?
Christian Antognini-Join Elimination
13-How to recover from “ORA-00752: recovery detected a lost write of a data block” on Standby in 11G?
Mladin Modrakovic-ORA-00752 on standby and DB_ULTRA_SAFE parameter
14-How to troubleshoot buffer busy waits?
Kyle Hailey-Oracle Wait: Buffer Busy Wait
15-CPU cost and execution time relationship
Richard Foote-The CPU Costing Model: A Few Thoughts Part V (Reality)
16-Global Index behaviour with DDL on empty partitions?
Hemant K Chitale-DDL on Empty Partitions — are Global Indexes made UNUSABLE ?
17-How does RELY clause works with foreign key constraints?
Timo Raitalaakso-Rely constraint validated mess
18-How to hide sql query from spool file ?
Martin Bach-hide SQL query in spool file
19-How to use DBBS API’s ?
Tim Hall-Oracle Database File System (DBFS) PL/SQL APIs
20-Introduction to Oracle Analytic Functions
Adrian Billington-introduction to 8i analytic functions
21-How does not null constraint effect updates with subqueries?
Charles Hooper-The Effects of Potential NULL Values in Row Sources During Updates Using an IN Subquery
22-How to rename cloned ASM diskgroups in 10GR2 – 11GR2 renamedg alternative?
Martin Bach-Rename cloned diskgroup in Oracle 10.2
23-Possible reason begin poor performing first_rows_n ?
Jonathan Lewis- first_rows_N again
24-Side effects of setting db_file_multiblock_read_count on 10GR2 and above
Kerry Osborne-Autotuned DB_FILE_MULTIBLOCK_READ_COUNT
25-How to do what if analysis for index clustering factor?
Randolf Geist-CLUSTERING_FACTOR What-If Analysis
26-11GR2 edition based redefinition detailed analysis
Christian Antognini-Edition Based Redefinition