Coskan’s Approach to Oracle

February 2, 2010

Blogroll Report 08/01/2009 – 15/01/2010

Filed under: Blogroll Report — coskan @ 6:57 pm

<—- Blogroll Report 01/01/2010 – 08/01/2010

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

Charles Hooper-Drilling into Session Detail from the Operating System – On the Windows Platform 2

3-How does force_match work with SQL_PROFILEs?
Jonathan Lewis-force_match

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

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

Blogroll Report 15/01/2010 – 22/01/2010 –>

Create a free website or blog at