Coskan’s Approach to Oracle

July 10, 2009

Blogroll Report 03/07/2009 – 10/07/2009

Filed under: Blogroll Report — coskan @ 6:40 pm

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

19- How to clone Oracle Home

Charles Kim – Cloning an Oracle Home after you tar the binaries from one server to another

Oracle Forums

1- Tuning PL/SQL Code

2- Which nologging way is better for performance?

3- SQL Query Statistics

Blogroll Report 03/07/2009 – 17/07/2009–>

Create a free website or blog at