<—- Blogroll Report 06/06/09 – 12/06/09
Last 5 days, I was at Hurricane Festival enjoying Hard Rock, without any internet access and I couldn’t keep my promise to write blogroll report on time 
After 4 days of tiring camping conditions, I am now ready to write last weeks highlights.
1-What is “consistent gets” and “db block gets”
Jonathan Lewis- Consistent gets
3- How to track bind variables with errorstack dump
Dion Cho - Tracking the bind value with errorstack dump
4- What is cleanout in Oracle
Jonathan Lewis-Clean it up
5-Q/A on Oracle Temporary Tablespace Groups
Randolf Geist - Temporary Tablespace Groups
6- How to record DDL statements in alert log of Logical Standby
Uwe Hesse - Record DDL Statements in DBA_LOGSTDBY_EVENTS & alert.log
7- How to kill a session on other node in Oracle 11G
Chandra Pabba - Oracle11g – Killing session in RAC (in remote instance)
8-How to remap_tablespace with original export import
Chen Shapira - Did You Know You Can Rename Tablespaces?
9 -CBO and INDEXES for beginners Part – 2
Richard Foote - The CBO and Indexes: Introduction Continues …
10- How to dinagnose PGA with oradebug (new oradebug parameter on 11g unit_test_nolog)
Miladin Madrakovic - Memory Diagnostics – PGA Part 1
11 – SMON and Tablespace name problem
Jonathan Lewis – Tablespaces
12- How to resolve corruption issue with file_hdrs dump
Riyaj Shamsudeen - Resolving corruption issue with file_hdrs dump
13 – Pure SQL version for OSTAKPROF of Tanel Poder
Dion Cho - Pure SQL version of ostakprof(from Tanel Poder)
14- Re-writing query instead of creating index
Karen Morton – You dont really need that index (or that SQL )
15 – SQL Trace anomality for LOB columns
Dion Cho - LOB vs. SQL*Trace
Oracle Forums
1- What happens when you Flush buffer cache
http://forums.oracle.com/forums/thread.jspa?threadID=913831&start=15&tstart=0
2- Histograms and Explain plan differences
http://forums.oracle.com/forums/thread.jspa?threadID=914152&start=30&tstart=0
3- db file sequential read
http://forums.oracle.com/forums/thread.jspa?threadID=916549&messageID=3562867
