<—- 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
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
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.”
Regards,
Anand
Comment by Anand — July 27, 2009 @ 10:33 am
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
[…] 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