Coskan’s Approach to Oracle

November 17, 2009

Blogroll Report 06/11/2009-13/11/2009

Filed under: Blogroll Report — coskan @ 12:53 am

<—- Blogroll Report 30/10/2009 – 06/11/2009

1-How to upgrade to 11GR2?

Mike Dietrich-New version of “Upgrade to 11g – The whole Story” slides available

2-How to diagnose row cache lock?

Surachart Opun-Investigate row cache lock

3-Cases where Oracle Wait Interface is Useless?

James Morle-The Oracle Wait Interface Is Useless (sometimes) – Part One: The Problem Definition

4-How to do logging in PL/SQL ?

Dion Cho-Logging in PLSQL

5-Index freelist problem during mass delete insert

Jonathan Lewis-Index Freelists

6-How to change password of database link in 11GR2?- New manageability feature of 11GR2

Ittichai Chammavanijakul-11gR2 New Feature – Alter Database Link to Change Password

7-How querying GV$ dynamic views works?

Jacco H. Landlust-px-slaves and gv$session

8-How to troubleshoot network connection problems?

HP NZ Database Services-Troubleshooting network connection

9-How to automate sql_advisor tasks from ADDM reports in 10G?

John Hallas-Automatically running sql_advisor tasks from ADDM reports

10-Why performance gain of rebuilding index is minimum?

Richard Foote-An Index Only Performs How Much Work ???

11-How to use DBMS_METADATA to generate user creation scripts?

Alex Nuijten-Create Users with DBMS_METADATA

12-Possible reasons of slowness with same execution plan (check the comments)

Jonathan Lewis-No change

13-How to detect and empty CLOB column?

Alex Nuijten-An Empty Clob is not NULL, it’s NOT NULL

14-Solution to ORA-04030: with SGA multiple of 4GB and having high CPU count

John Hallas-Problems with SGA being a multiple of 4Gb (and high cpu count)

15-Index BLEVEL and CBO cost relationship

Martin Widlake-BLEVEL and Height of Indexes

16-Detecting real-time archive lag and running statspack with 11GR2 Active Dataguard

Robert Geiger-MAA for Active Dataguard

17-How to get dataguard related metrics from OEM?

Robert Geiger-Select metrics from the OEM repository

18-How does AUTO_SAMLE_SIZE and SIZE_AUTO differs from each other for DBMS_STATS?

Hemant K Chitale-Sample Sizes : Table level and Column level

19-How to use rsyslog to log syslog and database audit message to an Oracle database?

Ronny Egner-Logging syslog and database audit messages to an oracle database with rsyslog

Blogroll Report 13/11/2009 – 20/11/2009–>


  1. […] Blogroll Report 13/11/2009-20/11/2009 Filed under: Blogroll Report — coskan @ 9:41 pm <—- Blogroll Report 06/11/2009 – 13/11/2009 […]

    Pingback by Blogroll Report 13/11/2009-20/11/2009 « Coskan’s Approach to Oracle — November 22, 2009 @ 9:56 pm

  2. Hello! I came across your page web page on Yahoo. I am posting to
    find what theme you’re using on this page, I would love to use the theme
    that you are using so I can put it on my page (emulateur 3ds pour mac).

    Comment by Bianca Carmichael — May 9, 2014 @ 4:33 am

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

Blog at

%d bloggers like this: