<—- Blogroll Report 26/06/2009 – 03/07/2009
This weeks technical post selections
1- How to get object name from using file# and block# by block dump
Dion Cho – Object Name from File and Block
2- How to run huge sql files from sqlplus by using FIFO
H.Tonguc Yilmaz – Oracleturk hints running huge sql files from sqlplus and deleting huge amount of data best-practices
3- Performance of PLSQL Native Compilation
Pat Lehane – PL/SQL Native Compilation
4- Parallel execution interconnect performance on RAC systems. (When to use and when not to use parallel execution on RAC)
Greg Rahn – Oracle parallel execution interconnect myths and misunderstandings
5- How does optimizer_index_cost_adj parameter effects CBO decision when IO cost is active
Richard Foote – The CBO and Indexes optimizer_index_cost_adj Part I
6- How to diagnose SQL*NET tracefile with trcasst utility
Miladin Madrakovic – Troubleshooting SQL*NET
7- Materialized Views for beginners
Uwe Hesse -Brief introduction into Materialized Views
8- atomic_refresh parameter and high redo generation with Meterialized Views
Amit Bansal – Mview Complete Refresh and Atomic_refresh parameter
9- How to manage Voting Disks in Oracle RAC
Brijesh Dubey – Voting Disk Management in RAC
10- Oracle bug – gather_schema_stats fails with function based indexes
Amardeep Sidhu – GATHER_SCHEMA_STATS & ORA-03001: unimplemented feature
11- How to use cursordump for top truncated sql trace.
Tanel Poder – Identify the SQL statement causing those WAIT #X lines in a (top-truncated) sql tracefile
12- How to detect when a cursor was closed from SQL trace output?
Tanel Poder – How to detect when a cursor was closed from SQL trace output?
13- How to use/read/interpret Data Block Dump
Liang Gang Yu – Data Block Dump in Oracle – part 1 – how to dump block
Liang Gang Yu – Data Block Dump in Oracle – part 2 – how to read block dump file
Liang Gang Yu – Data Block Dump in Oracle – part 3 – object_id, data_object_id, block clean up
14- How to tune WHERE NAME LIKE ‘%ABC%’ queries with index hint
Laurent Schneider – How to tune WHERE NAME LIKE ‘%ABC%’
15- How to get rowcount faster – Fastest way to get rowcount
Martin Widlake – Counting the Cost #5 – accurate and fast
16- How to concatenate LOB columns for minimal resource usage
Jonathan Lewis – Concatenating LOBs
17- _PGA_MAX_SIZE parameter behaviour with PL/SQL
Husnu Sensoy – _pga_max_size = 200M : Maximum size of the PGA memory for one process ?!?
18- How to add tables to Oracle Stream between different Releases
Marcelo Lopes – Adding Tables to a Stream Between Oracle 9i and 10G
Charles Kim – Cloning an Oracle Home after you tar the binaries from one server to another
Oracle Forums
1- Tuning PL/SQL Code
http://forums.oracle.com/forums/thread.jspa?threadID=925857
2- Which nologging way is better for performance?
http://forums.oracle.com/forums/thread.jspa?threadID=926001
3- SQL Query Statistics
Hi Coskan,
Thanks for the wonderful collection. It is very useful. Found a small typo. End date is given as 10/07/2006, instead of 10/07/2009.
Giridhar Kodakalla
Comment by Giridhar Kodakalla — July 11, 2009 @ 12:01 am
Thank you very much Giridhar you saved the future of this post. If you did not catch it will continue like this forever because of the copy paste issue
Comment by coskan — July 11, 2009 @ 12:38 am
[...] Blogroll Report 03/07/2009 – 10/07/2009 –> [...]
Pingback by Blogroll Report 26/06/2009 – 03/07/2009 « Coskan’s Approach to Oracle — July 11, 2009 @ 12:21 am
[...] Blogroll Report 10/07/2009 – 17/07/2009 Filed under: Basics — coskan @ 3:09 pm <—- Blogroll Report 03/07/2009 – 10/07/2009 [...]
Pingback by Blogroll Report 10/07/2009 – 17/07/2009 « Coskan’s Approach to Oracle — July 17, 2009 @ 3:09 pm