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

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

http://forums.oracle.com/forums/thread.jspa?threadID=925935

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

About these ads

6 Comments »

  1. 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

  2. [...] 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

  3. [...] 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

  4. […] 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

  5. 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


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 202 other followers

%d bloggers like this: