<—- 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
[…] Blogroll Report 06/06/09 – 12/06/09 Filed under: Blogroll Report — coskan @ 7:32 pm Blogroll Report 12/06/09 – 19/06/09—–> […]
Pingback by Blogroll Report 06/06/09 – 12/06/09 « Coskan’s Approach to Oracle — June 23, 2009 @ 11:26 am
Thanks for recommending my post about tablespace renaming. I’m glad you enjoyed it 🙂
Comment by prodlife — June 24, 2009 @ 4:04 am
[…] Blogroll Report 19/06/2009 – 26/06/2006 Filed under: Blogroll Report — coskan @ 8:07 pm <—- Blogroll Report 12/06/09 – 19/06/09 […]
Pingback by Blogroll Report 19/06/2009 – 26/06/2006 « Coskan’s Approach to Oracle — June 26, 2009 @ 8:09 pm