<—- 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
