<—- 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
[…] Pingback: Blogroll Report 03/07/2009 – 10/07/2006 « Coskan’s Approach to Oracle […]
Pingback by Mview Complete Refresh and Atomic_refresh parameter | mkjay — August 2, 2013 @ 10:11 pm
I enjoy reading a post that will make people think. Also, thanks for allowing me
to comment!
Comment by web page — January 12, 2014 @ 8:55 pm
The drugs are related the highest quality, and the drug
store meets all i would say the necessary safety standards.
Any option to attain medicine on generally internet provides a complete more affordable clean to the concern.
Comment by bcp pharmacy — January 26, 2015 @ 10:57 am