Coskan’s Approach to Oracle

July 24, 2009

Blogroll Report 17/07/2009 – 24/07/2009

Filed under: Blogroll Report — coskan @ 2:05 pm

<—- Blogroll Report 10/07/2009 – 17/07/2009

This was one of those weeks that you really need a summary of the blog activities, it was more than fruitful.
The most popular topic was new 11G feature Direct Path Access and they all were very interesting.
My personal choice of the week is Index Quiz series from Jonathan Lewis, they were very informative and I strongly recommend you, not miss any of the comments.

1- Direct path pros/cons and how to disable direct path access.

Miladin Madrakovic –Direct path reads and serial table scans in 11g

Christian Antognini-Impact of Direct Reads on Delayed Block Cleanouts

Dion Cho-Disabling direct path read for the serial full table scan – 11g

2- Indexes and ITL

Jonathan Lewis –
Index Quiz 1
Index Quiz 2

3- table stats Choked by Auto Stats Gathering Job.

Martin Widlake-
Automated Statistics Gathering Silently Fails
Automated Statistics Gathering Silently Fails #2
4- Explanation of min segment size – Richard Foote vs Myths
Richard Foote-Why A Segment Really Has To Be At Least 2 Blocks In Size

5- Negative effects of optimizer_index_cost_adj
Richard Foote-The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part II
6- Difference between NOT IN and NOT EXISTS with NULLs
Hemant K Chitale-The difference between NOT IN and NOT EXISTS

7- How to find out parameters and diagnostic events of specific session ?
Dion Cho – Spying on the other session

8- Case of failed Stored outlines in 11G
Dion Cho-Stored outline does not work – the stupidity of Oracle 11g

9- How to automate AWR report generation ?
Rajeev Ramdas Thottathil- Shell script to generate awr reports for a range of snapshots

10- What does not effect plan_hash_value generation ?

Randolf Geist – PLAN_HASH_VALUE – How equal (and stable?) are your execution plans – part 1

11- How to use logminer when flashback is not option ?

Uwe Hesse- Logminer: Not as modern as Flashback but still useful!

12 – Summary of most known PL/SQL features

Steven Feuerstein – Must Know Features of PL/SQL

13- How to automate test script generation for SQLs with bind variables ?

Kerry Osborne-Creating Test Scripts With Bind Variables

14- How to check possible bind variable needs ?

Alberto Dell’Era – Bind Variables Checker for Oracle – now install-free

15- Faster fixed table access.

Miladin Madrakovic-Accessing Fixed Tables using Direct Access

16- Explanation of Securefile deduplication in 11G

Liang Gang Yu –Oracle 11g SecureFile System-Part 1- Deduplication of LOBs

17- Solution to emctl “WARN http: snmehl_connect: connect failed to (hostname:): Connection refused (error = 111)” problem

Asanga – Enterprise Manager Error

18- How to inspect LUNs on Linux ?

Krishna Manoharan-Map Disk Block devices on a Linux host back to the SAN Lun

Blogroll Report 24/07/2009 – 31/07/2009–>


  1. Hello Coskan,

    Seems the link does not work. Please check the syntax, find redundant backslash in the url.

    BR, Tim

    Comment by Tim — July 26, 2009 @ 6:31 am

    • Which link Tim ?

      All the links works fine and all the links opens in new windows.

      Comment by coskan — July 26, 2009 @ 8:25 am

  2. Hi Coskan,

    Firstly would like to thank you for the blogroll report that you post every week.

    Secondly,the link for this week blogroll does not work/open.It shows

    “Sorry, no posts matched your criteria.”


    Comment by Anand — July 27, 2009 @ 10:33 am

  3. Thanks Anand,

    All the links are working fine now (sorry for the typo on the links)

    Comment by coskan — July 27, 2009 @ 10:50 am

  4. […] Blogroll Report 24/07/2009 – 31/07/2009 Filed under: Basics — coskan @ 1:53 am <—- Blogroll Report 17/07/2009 – 24/07/2009 […]

    Pingback by Blogroll Report 24/07/2009 – 31/07/2009 « Coskan’s Approach to Oracle — August 1, 2009 @ 1:53 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

Create a free website or blog at

%d bloggers like this: