Coskan’s Approach to Oracle

June 12, 2009

Blogroll Report 06/06/09 – 12/06/09

Filed under: Blogroll Report — coskan @ 7:32 pm

As you see from the blogroll page I follow over 140 Oracle DBA related blogs and all blog aggregators from I try to read updates from all of them but  this huge amount of different source of information about different topics started to blow my mind. I start not to remember what I read and which one was useful in technical context, and most of the blog headers do not match with my future search criteria. For these reasons, I decide to write my own weekly blogroll report just for indexing technical oracle blog posts with my own keywords. ( Log Buffers of Pyhtan Group are very nice but not enough) . I am planning to write every Friday night. If you find anything useful please leave a comment so the post will be complete.

Here is this weeks selection.

1-How to deal with memory leaks by using memory dumps. (PGA leak bug)
Jonathan Lewis – PGA Leaks
Dion Cho – Troubleshooting PGA leak with PGA heap dump

2- How to fix ASM disk header

Jason Arneil – Fixing up ASM Disk Header Corruption

3- How to use Perfsheet and TPT tools for Diagnosing RAC wait events

Karl Arao –Diagnosing and Resolving “gc block lost”

4- How to use  XPLAN  tool of Alberto Dell’era

Alberto Dell’era – Optimizing SQL statements with xplan

5- How CBO use Dynamic Sampling on partitioned tables

Randolf Geist – Dynamic sampling and partitioned tables

6- How to limit query time with Resource Manager

Martin Ruthner – Limiting Query Runtime Without Killing the Session

7- How Oracle choose tablespaces for interval partitioning

Yasin Baskan – Tablespace selection in interval partitioning

8- DB_CACHE_ADVICE  bug causes simulator lru latch

Don Seiler – Turn Off db_cache_advice To Avoid Latch Contention Bugs

9- CBO and INDEXES for beginners Part – 1

Richard Foote – The CBO and Indexes: An Introduction (Absolute Beginners)

10 – How to unload  data with Data Pump and External Tables – How to move data between servers with DBMS_FILE_TRANSFER  packages

Jean-Pierre Dijcks – Unloading data using External Table and Data Pump

11- How to exclude scan on single paths with ASM multipathing

Surachart Opun – Check the device ASMLib on multi-path

12- PL/SQL Functions and their CBO costing

Adrian Billington – pl/sql functions and cbo costing

13- Tutorial for grouping rows with group by

Joe Fuda – Grouping Rows with GROUP BY

Oracle Forums – (The ones I caught)

1- db writer processes and working data sets

2- Performance tuning issue on parallel query

3- What should be the value of Optimizer_index_cost_adj in oracle 9i    (they are  back 🙂 )

These are all for this week. Hope it will be helpfull to find the right blog posts for you

Blogroll Report 12/06/09 – 19/06/09—–>


  1. Coskan,

    Nice idea.
    Don’t forget to put forward and backward links to connect each new one with the previous one so that anyone can walk back and fore along a doubly linked list. (Like the thing I do with my statspack series).

    Comment by Jonathan Lewis — June 12, 2009 @ 8:30 pm

  2. Nice addition to my initial idea I will add the navigation as you did for the statspack series thank you very much for the suggestion Mr Lewis.

    Comment by coskan — June 12, 2009 @ 8:40 pm

  3. Coskan, nice try and it’s a honor to have my post on the list.

    Comment by Dion Cho — June 12, 2009 @ 11:26 pm

  4. […] Blogroll Report 12/06/09 – 19/06/09 Filed under: Basics — coskan @ 11:23 am <—- Blogroll Report 06/06/09 – 12/06/09 […]

    Pingback by Blogroll Report 12/06/09 – 19/06/09 « Coskan’s Approach to Oracle — June 23, 2009 @ 11:23 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Blog at

%d bloggers like this: