Coskan’s Approach to Oracle

September 27, 2009

Blogroll Report 18/09/2009 – 25/09/2009

Filed under: Blogroll Report — coskan @ 8:41 pm

<—- Blogroll Report 11/09/2009 – 18/09/2009

Here come this week’s selection,

1-Solution to “ORA-38760: This database instance failed to turn on flashback database” after interrupted flashback database

Fairlie Rego – Interrupting Flashback Database

2-ASSM bug with different data block size

Jonathan Lewis – Bugs

3-Functions in SQLS and read consistency behaviour

Hemant K Chitale-SQLs in Functions : Each Execution is Independent

4-What happens and how to recover when you lose your OCR mirror and all the nodes were down?

Geert De Paep-The ultimate story about OCR, OCRMIRROR and 2 storage boxes – Chapter 1

5-Why do we need to have power of 2 numbers of partitions for hash partitioning?

Jonathan Lewis – Hash Partitions

6-Diagnosing network problem by tracing system calls

Amit Bansal-Sqlplus connection on AIX taking too long

7-Limits on Triggers with LOB’s

Grégory Guillou-Triggers and LOBs: Synchronous CDC and Synchronous Streams Capture

8-Different behaviour of dictionary tables for Deleted tables

Martin Widlake-Beware Deleted Tables

9-How to use BBED for data extracting/hacking?

Steve Callan-Oracle’s Block Browser and Editor tool

10-How to do manual failover with 11G Data Guard Broker

Jim Czuprynski-Performing Database Failover with Oracle 11g Data Guard

11-How to configure alternate pfile/spfile location on windows systems by using registry keys

Matt Canning-Alternate locations for database parameter files in 11g – Part 4 of 7

12-Auditing for beginners

Robert Geier-Enable Oracle auditing BEFORE you need it

13-How to configure Data Guard Broker

Apun Hiran - How To: Configure Data Guard Broker

14-How to configure Data Guard Fast-Start Failover with Data Guard Broker

Apun Hiran - How To: Configure Data Guard Fast-Start Failover Step By Step

11GR2 Related Posts

1-Architecture behind exadata v2 flash cache?

Jean Pierre Dijcks-500GB/sec and Database Machine Generation 2

2-SSH User setup for Clusterware installation-11GR2 New feature

Luis Moreno Campos-SSH User Equivalence in 11gR2 Real Application Clusters Clusterware installation

3-Video for installing 3 node Oracle RAC 11G in VMWare

Eric (masterschema)-Install Oracle RAC 11g R2 in VMWare – 3 nodes

4-Video for adding 4th node on 3 node Oracle RAC 11G in VMWare

Eric (masterschema)-Extending RAC 11gR2 to 4th node

5-Video for having more than one DB in a single RAC cluster in VMWare

Eric (masterschema)-More than one database in a single RAC cluster

6-How to create new mount point with ASMCA-11GR2 New database manageability feature

Luis Moreno Campos-Putting ACFS to work: how to create a mount point in the new Oracle File System

7-Technical whitepaper for Sun Oracle Exadata V2 database machine (PDF file)

Oracle – A Technical Overview of the Sun Oracle Exadata Storage Server and Database Machine

Blogroll Report 25/09/2009 – 02/10/2009–>

September 19, 2009

Blogroll Report 11/09/2009 – 18/09/2009

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

<—- Blogroll Report 04/09/2009 – 11/09/2009

Another 11GR2 week but this time with  addition of Exadata V2 announcement. It was hard to pick one and I chose Alex Gorbachev’s views about this new database machine.

1-What are simulators in shared pool buffer cache ?

Tanel Poder - KGL simulator, shared pool simulator and buffer cache simulator – what are these?

2-When does Plan_hash_value changes?

Riyaj Shamsudeen – Is plan_hash_value a final say?

3-Nologging and recovery relationsip

Uwe Hesse -How do NOLOGGING operations affect RECOVERY?

4-Pros and Cons of the supported ways to solve index explosion

Jonathan Lewis – Index Explosion 4

5-How to move from ASM to filesystem?

John Hallas – Moving from ASM storage back to filesystem

6-How to regress Opatch version?

John Hallas – Regressing an Opatch version

7-How to use MV_CAPABILITIES_TABLE for fast refreshable materialized view restrictions?

Rob Van Wijk-Fast refreshable materialized view errors, part six: MV_CAPABILITIES_TABLE

8- Why/How to split check constraints when there is top-level AND?

Rob Van Wijk-Check constraints and AND

9- What happens and how to recover when you loose your OCR mirror ?

Geert De Paep-The ultimate story about OCR, OCRMIRROR and 2 storage boxes – Chapter 1

10- Report need backup and retention policy relationship

Khurram Siddiqui – coreletion between report need backup and retention policy

11- How histogram gathering works when first N characters is same?

Martin Widlake – Decrypting Histogram Data #3 – is 7 or 15 Characters Significant?

12- In what cases System statistics gathering can fail and workarounds (ORA-20003: Unable to gather system statistics)?

Martin Widlake – Another Day, Another Obscure Oracle Error

13- What is a VLDB and Who is VLDB DBA?

Martin Widlake – What is a VLDB

14- How to install Oracle Database 10g on Mac OS X Snow Leopard?

Raimonds Simanovskis – How to install Oracle Database 10g on Mac OS X 10.6 Snow Leopard

15- ASM Hands on Trainings by Alejandro Vargas (22 labs so far so I put archive link instead of all)

Alejandro Vargas – ASM Hands on Trainings

16- How to configure and use Oracle Public Yum?

Charles Kim – Public Yum with Oracle

17- How system statistics and CPU costing model works with indexes?

Richard Foote-The CBO CPU Costing Model and Indexes – Another Introduction

18- How to create read only OEM user?

Rajeev Ramdas Thottathil – Creating a view only user in Enterprise Manager grid control

19 – How to diagnose a problem for solving with Method-R?

Carry Milsap-On the Importance of Diagnosing Before Resolving

20- What privileges you need to  copy schemas over database link in a procedure

Dani Ray-The gains and pains of dbms_datapump. Part I

11GR2 New Features Posts

1- Exadata V2

Alex Gorbachev -Unveiling the OLTP Oracle Database Machine & Exadata v2

2- How to do maintenance on ASM Volumes and Cluster File Systems- New Server Manageability Feature of 11GR2

Charles Kim – Maintaining ASM Volumes and Cluster File Systems in Oracle Database 11g Release 2

3- How to create disk groups with ASMCMD Command Extensions- New Server Manageability Feature of 11GR2

Charles Kim -New ways to create disk groups in Oracle Database 11g Release 2

4- ASMCMD Command Extensions- New Server Manageability Feature of 11GR2

Charles Kim -Ways to mount and dismount disk groups in Oracle Database 11g Release 2

5- How to rename disk groups with renamedg utility – New Server Manageability Feature of 11GR2

Charles Kim – Rename Disk Group

6- How to manage volumes with ASMCMD Command Extensions – New Server Manageability Feature of 11GR2

Charles Kim – Volume Management with asmcmd

7- ASM Cluster File System (ACFS) command line – New Server Manageability Feature of 11GR2

Charles Kim – ACFS command-line tools available in Oracle Database 11g Release 2

8- How to configure ACFS for auto-startup – New Server Manageability Feature of 11GR2

Charles Kim – Configure ACFS for auto-startup for non-RAC database servers

9- New DBMS_COMPRESSION package – New Server Manageability Feature of 11GR2

Chandra Pabba-Oracle11gR2 Table / Tablespace Compression

10- Intelligent Data Placement – New Server Manageability Feature of 11GR2

Chandra Pabba-Oracle11gR2 ASM New Feature – Intelligent Data Placement

11- Deferred Segment Creation behaviour with traditional Export / Import – New Server Manageability Feature of 11GR2

Chandra Pabba- Oracle11gR2: Deferred Segment Creation and export behavior!

12- NTH_VALUE Analytic function – New Business Intelligence and Data Warehousing feature of 11GR2

Lucas Jellema - Oracle Database 11gR2 – New analytical function NTH_VALUE

Blogroll Report 18/09/2009 – 25/09/2009—->

September 14, 2009

Simple blank matters

Filed under: Basics, Bugs — coskan @ 1:16 pm

I saw this interesting bug on Metalink headlines and I thought it will be nice to post it here.

This is the heading of the bug ‘ADDING COLUMN WITH DEFAULT NULL LEADS TO UNNECESSARY FULL TABLE UPDATE ‘ numbered 8840491.

Normally, if you add a column with a default null value, there won’t be an update on the table itself (I think after 10G because trace for 9i shows update on table), running at the background, but if you put some spaces to make your alter statement look better, it is where the problem begins.

What I mean is these 4 statements are different during runtime due to the bug.

alter table test add (id number default null);

alter table test add ( id number default null);

alter table test add (id number default null );

alter table test add ( id number default null );

Lets see how do they differ.  Actual bug is reported on  and I am able reproduce it on

SQL> set timing on
SQL> create table test (id number not null);

Table created.

Elapsed: 00:00:00.54
SQL> insert into test
  2  select rownum from dual connect by level<=1000000;

1000000 rows created.

Elapsed: 00:00:01.65

SQL> alter session set tracefile_identifier=null_bug_test;

Session altered.

Elapsed: 00:00:00.00
SQL> exec dbms_session.session_trace_enable;

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.09
SQL> --no space before after ()
SQL> alter table test add (id2 number default null)  ;

Table altered.

Elapsed: 00:00:00.09
SQL> --space after (
SQL> alter table test add ( id3 number default null)  ;

Table altered.

Elapsed: 00:00:00.01
SQL> --space before )
SQL> alter table test add (id4 number default null )  ;

Table altered.

Elapsed: 00:01:12.90
SQL> --space before and after ()
SQL> alter table test add ( id5 number default null ) ;

Table altered.

Elapsed: 00:01:34.27
SQL> -- spaces everywhere but not after before ()
SQL> alter table test add (id6  number   default   null)  ;

Table altered.

Elapsed: 00:00:00.04

As you see from the timings some of them are longer than expected. Lets find them in tracefile

These are the update statements from the trace file.

PARSING IN CURSOR #1 len=29 dep=1 uid=82 oct=6 lid=82 tim=21689660840 hv=720540867 ad='30679e28' sqlid='7nb3cf4pg5563'
update "TEST" set "ID4"=null 
PARSE #1:c=15625,e=17207,p=0,cr=106,cu=1,mis=1,r=0,dep=1,og=1,tim=21689660835
PARSING IN CURSOR #5 len=29 dep=1 uid=82 oct=6 lid=82 tim=21762749484 hv=1088193227 ad='30679058' sqlid='f4g28hd0dt0qb'
update "TEST" set "ID5"=null 
PARSE #5:c=46875,e=146504,p=294,cr=100,cu=0,mis=1,r=0,dep=1,og=1,tim=21762749480

As you see space before ) and space before and after () causing full table update and guess the damage of this tiny hidden change on over 10 million row huge table.

Next time, if you wait your not null new column getting added longer than it needs on 10G>, check the syntax you might be hitting this bug.

September 11, 2009

Blogroll Report 04/09/2009 – 11/09/2009

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

<—- Blogroll Report 28/08/2009 – 04/09/2009

This week was again busy with 11GR2 new features and the absolute winner of the new feature blog entry competition is Charles Kim and his posts are not just excerpts from available documentation. Nicolas Gasparotto was the first one who finds  a bug in 11GR2 for popular new feature deferred segment creation.   I could not even find time to install release, but people started to find bugs, I think I am loosing my speed :)  11GR2 selections are again grouped separately and will, till everything goes to normal.

1-Dangerous sorting behaviour of Oracle for Analytic functions

Jonathan Lewis – Analytic Agony

2-How to use ADRCLI in 11G?

Charles Kim – Automatic Diagnostic Repository (ADR) Command Line Interface

3-How to use REGEXP for argument validation in Shell Script (check the comments)?

Jared Still - Shell Tricks

4-Behaviour change of CBO when partition level stats are available but table level are not

Hemant K Chitale-Table and Partition Statistics

5-How to avoid password hardcoding in Shell scripts with Oracle Wallet ?

Amit Bansal-Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password?

6-How to disable ocssd.bin for non-rac non asm environments?

Charles Kim – Disable ocssd.bin daemon when running non-RAC environments

7-How to use SQL Performance Analyzer (SPA) in 11G?

Steve Callan-SQL Performance Analyzer

8-Why buffer cache buffers can reside in shared pool and what are KGH NO ACCESS in shared pool?

Tanel Poder -KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!

9-What are the reasons for chained rows and How to deal with them ?

Joel Goodman – Are you chained to your tables.

10-ORA-01792 with inline views

Dion Cho-Interesting case of ORA-01792 error.

11-When your backup policy might not be enough?

Martin Widlake – Your Backups Are Probably Too Simple

12-The new version of the Upgrade to Oracle Database 11g – The whole Story

Mike Dietrich-New version of 11g upgrade slides available

13-Invalid Oracle Internet Directory problem after Oracle identity management upgrade

Frank Van Bortel – Upgrade IDM from 10.1.2 to 10.1.4: dba_registry invalid OID

11GR2 New Features Posts

1-ASM Storage Management Configuration Assistant- New server manageability feature

Charles Kim -Oracle has a new configuration assistant in 11g Release 2 – ASMCA

2-ASM Intelligent Data Placement-New Server Manageability feature of 11GR2

Charles Kim – ASM – Intelligent Data Placement

3-How to install 11GR2 on Linux?

Charles Kim-Installing Oracle Database 11g Release 2 – Enterprise Database Edition

4-Enterprise Manager Support for ASM Cluster File System (ACFS) – New Server Manageability feature of 11GR2

Charles Kim - Creating ASM Volumes and Cluster File Systems with Enterprise Mangers in 11g Release 2

5-ASM FS Snapshot – New Server Manageability feature of 11GR2

Charles Kim -Creating ASM Snapshots with Enterprise Mangers in 11g Release 2

6-How to start DBCONSOLE in 11GR2 ?

Charles Kim -Starting dbconsole from command line in Oracle Database 11g Release 2

7-How to fix PRVF-5472: or PRVF-5439: during 11GR2 installation?

Chandra Pabba – Oracle11gR2 CRS Install – ntpd requirement

8-How to install Peoplesoft on 11gR2 64-bit?

Nicolas Gasparotto – Peoplesoft on 11gR2 64-bits

9-Lib32 Dir is not available in 11GR2 64 bit

Nicolas Gasparotto – 11gR2 64-bits : where is lib32 ?

10-Bug # 8816562 Deferred Segment Creation is not working with move and workaround for the bug.

Nicolas Gasparotto – Get rid off segment of empty table (11gR2)

11-Step by step 11GR2 upgrade

Saurabh Sood-Get Upgrading: Steps To Upgrade To 11gR2

12-No need of voting disk backuo for 11GR2 clusterware-New clustering feature of 11GR2

Syed Jaffar Hussain- Voting Disk Backup Procedure Changed in Oracle 11g Release 2

13-SQL Generation – New server managealibility feature of 11GR2

We do streams-The New Streams 11.2 SQL Generation Facility

14-XMLType Partitioning – New Unstructured Data Management feature of 11GR2

Marco Gralike – Oracle RDBMS 11gR2 – XML Data Partitioning

15-IGNORE_ROW_ON_DUPKEY_INDEX Hint-New availability feature of 11GR2

Luis Moreno Campos-Oracle 11gR2 feature of the Day!

16-Step by step 11gR2 rac installation on 64 bit Linux

Rajeev Ramdas Thottathil - 11gR2 rac installation on 64 bit Linux step by step

Blogroll Report 11/09/2009 – 18/09/2009 –>

September 10, 2009

Oracle Performance Firefighting by Craig Shallahamer

Filed under: Book Reviews, Diary, Performance — coskan @ 3:42 pm

Today I am going to write about an amazing book Oracle Performance Firefighting by Craig Shallahamer, which was released in July 2009. After all the papers I read from Craig, my fingers were crossed for the release date and I ordered the book for our company immediately after release.  The reason I was very excited about the book is that  I always feel uncomfortable with overall system performance tuning and this is the area where Craig looks  very good at.

During the review, I will try to cover what this book promises and gives us by going through  all the chapters one by one. For overall, this book is not for sql tuning  It is about how to find the problem and giving possible other solutions for common problems ( in addition to tuning your code as a first option.) by giving the information about how Oracle works in most problematic areas like buffer cache, shared pool, redo, undo and especially  latches and mutexes.

Before starting to go through chapters, I want to say that the book is very well organized  and the way Craig teaches avoids boredom about numbers and math.   I could not  leave the book even on holiday.  The way he covers the very hard to understand topics brings curiosity about the next topic.  One more thing is the number of usage of the word OraPub (his company) kept minimum.  While reading  Optimizing Oracle Performance by Cary Millsap and Jeffrey Holt, I really hated the word Hotsos because  it was nearly on every page and that was very annoying. If you are curious about this problem it is not happening that much in this book.

Lets start with going through chapters (Chapters with * are the ones that really needs attention)

1- Methods and madness: This is the introduction to how to be a firefighter from both methodic and holistic perspective. Craig gives information  What you need during Oracle firefighting and how you can build a methodology . He covers the basics of analysing the system as a whole under the name of  OraPub 3 Circle Analysis.  When I first read about the OraPub 3 Circle Analysis I did not expect much but after a few chapters I admit that it works quite fine.  Most interesting topic to me was how to write the summary of your firefighting story.  That is something I need to work on.

2- Listening to Oracle’s Pain: This chapter tries to explain how to understand what Oracle is crying for by using Oracle Wait Interface and ORTA (oracle response time analysis). It covers how Oracle kernel developers instrumented their code for creating Oracle Wait Interface. It wasnt something I did not know but still nice to remember most them.

3- Serialization Control (*): This chapter is where this book starts to rock about explaining what is going on in Oracle by telling how Latches Mutexes and Locks work and differ from each other.  After finishing this chapter I believed that the book already worth the money I paid and there were 6 more chapters to go. Craig definitely knows how Oracle works and better than just knowing he knows how to explain it like latches for dummies.  It is really hard not to remember or not understand what he is explaining.

4- Idenfying and Understanding Operating System Contention: This chapter tries to cover how to use unix/linux tool to gather information from operating system to do the operating system circle of OraPub 3 Circle Analysis. Apart from using tool it is very good about the way Craig teaches about how to talk and convince Network, OS and Storage guys in case of a problem without making their nerves. I personally liked very much the word Craig uses like “there is a memory pressure” instead of “paging” :)

5- Oracle Performance Diagnosis: This chapter is going deep into how to gather overall performance related data from Oracle and how to interpret the data you gathered without going to compulsive tuning disorder. He covers the wait event myths section which was very interesting and he tries explain why profiling is not “always” the best approach. Making the most out of DBMS_MONITOR  tool is also covered well. Craig also gives internals about ASH (Active Session History). How it works why it is good and how to use it. Craig also gives the simple trick about how to learn Oracle internals which is reading Oracle patents also search oracle in (

6- Oracle Buffer Cache Internals(*): Till I read this book, I never dreamed  about that, one day I will really fully understand and be able to explain to others, how  Oracle buffer cache, shared pool and latches works, despite all official documentation and the books I read so far. This and upcoming 2 chapters  gave me this opportunity and I want to thank Craig very much for explaining these topics this well. Diagrams and way he explains are totally amazing.  Chapter is not just explaining buffer cache it is also how to tune it.  Knowing the internals of Buffer Cache can be the only reason to have the book because it is nearly the main thing for optimal performance. I really like too much about latch and enqueue subtopics.

7- Oracle Shared Pool Internals(*): This is another reason that makes this book unique.  I already wrote my own compilation about shared pool in a blog post but this chapter taught me many more things like lathes and mutexes in shared pool , In memory undo   and how to tune them. This chapter is also a must to learn to do proper performance firefighting.

8- Oracle Redo Management Internals(*): In this chapter Craig gives how redo management works in Oracle and how to tune redo related issues which is again very important performance related topic.  He goes over  every redo related problem and gives possible solutions to them. Learning the dangerous commit_write parameter usage was  completely new to me.

9- Oracle Performance Analysis(*): In this chapter every topic so far is integrated with each other in  a possible problem scenario. Before going into the scenario Craig cover response service and queue time calculations and prepares us to scenario. In this chapter Craig starts an Overall system performance tuning in OraPub three circle analysis by analysing Oracle OS and Application together. He goes into the analysis three times and this gives reader the clues when and where  to or not to stop tuning.  This chapter totally depends on math and to be honest it is really easy to understands

Now it is time to talk about what I don’t like about the book. Craig introduces and explains too many internal parameters and he gives them as an option in case there is a problem. I loved to learn them because it is very helpful when you talk with Oracle support and also they are part of understanding Oracle but I prefer he mentioned more about not to use them before asking Oracle . He says not to use them couple of times but still not enough to me.   Second thing is that we don’t  have option to download the test case codes Craig mentions apart from OraPub monitoring kit.  Third there is no index at the end of the book.Although I don’t use indexes that much but still nice to have.  One last thing because it is only available from OraPub you might wait a bit if you are ordering outside of US like me, I wish there was an e-book option which I always find it easy but probably it is because of avoiding pricy.

After negative part lets come to the conclusion. This book is very informative very well written and in my humble opinion, a must on every DBA’s desk and I suggest it to every DBA. If you are experienced and read too many performance tuning books and feel comfortable with performance tuning but still struggling to understand latches mutexes buffer cache shared pool  or overall performance tuning and if you want to fully understand them Oracle Performance Firefighting is totally for you. If you are a new for Oracle Performance Tuning,  this book is a must to understand how Oracle works but please be careful about hidden/unsupported parameters.

My only regret is not to order 2 copies one for company and one for me. :) I hope you will like the book as much as I liked.

Many thank to Craig Shallahamer for bringing  deep knowledge and experience about Oracle Performance tuning and sharing in this very special book.

September 9, 2009

Blogroll Report 28/08/2009 – 04/09/2009

Filed under: Basics — coskan @ 2:16 am

<—- Blogroll Report 21/08/2009 – 28/08/2009

Finally I am able to finish the missing weeks. Oracle released 11G Release 2 this week , and as you might guess most of the posts were about 11GR2 new features. Virag Sharma, Amit Bansal ,Arup Nanda (as usual) and Amis Group were the ones who won the race of posting about new features. Some of them were excerpt from documentation but still nice to know so I put them in my list. I also tried to put the posts under  the correct topic of official guide so you can find your way in new features documentation.

1-How to use DBMS_UTILITY ?

Aman Sharma – DBMS_UTILITY, A Good Helping Hand For A DBA….

2-Select for update and Redo Generation

Aman Sharma -Select For Update A DML, Yes It Is….

3-How to perform easy math in Unix

John Hallas – Performing calculations in unix

4-Using database resident connection pooling with Perl

Rajeev Ramdas Thottathil – Perl and database resident connection pooling

5-Security issues with JAVA_ADMIN role

Paul M Wright – JAVA_ADMIN to OSDBA

6- Securing the Data Dictionary O7_dictionary_accessibility parameter

James Koopmann – Oracle 11g Security – Securing the Data Dictionary

7- How histogram gathering works when first N character are same?

Hemant K Chitale – Histograms on “larger” columns

8-Effects of OPTIMIZER_INDEX_CACHING parameter


9-How does response time increase while throughput is also increasing (Don’t miss comments)

Jonathan Lewis-Queue Time

10-How to use Linux /proc filesystem to get Oracle trace directory

Kevin Closson – Using Linux /proc To Identify ORACLE_HOME and Instance Trace Directories.

11-How to install BBED

Steve Callan – Installing Oracle Block Browser and Editor tool (bbed)

11GR2 New Features Posts

1-Moving the database audit trail tables out of the SYSTEM tablespace to a different tablespace. – New security feature of 11GR2

Virag Sharma-11G R2 New Feature : Purge audit trail records using DBMS_AUDIT_MGMT

2-Single Client Access Name (SCAN)- New clustering feature of 11GR2

Virag Sharma – Oracle 11g Release 2 (11.2 ) New Features : SCAN – Single Client Access Name

3-Edition Based Redefinition – New availability feature of 11GR2

Virag Sharma -Oracle Database 11g Release 2 New Features : Edition based redefination

4-Recursive With Clause – New Business Intelligence and Datawarehousing feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – goodbye Connect By or: the end of hierarchical querying as we know it

5-Flash Cache – New Database Management feature of 11GR2

Marco Gralike-Oracle RDBMS 11gR2 – Flash Cache

6-Preprocessing Data for ORACLE_LOADER Access Driver in External Tables- New Business intelligence and Datawarehousing feature of 11GR2

Marco Gralike-Oracle RDBMS 11gR2 – New PREPROCESSOR Syntax for External Table Use

7-LISTAGG-New Business intelligence and Datawarehousing feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – LISTAGG – New aggregation operator for creating (comma) delimited strings

8-Enhance CREATE or REPLACE TYPE to Allow FORCE-New availability feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – alter or replace user defined types even when there are dependencies

9-Improved Deinstallation Support With Oracle Universal Installer- New clustering feature of 11GR2

Arup Nanda-Oracle 11g R2 Features

10-ASM Dynamic Volume Manager and ASM Cluster File System – New Server Manageability feature of 11GR2

Arup Nanda – ASM Dynamic Volume Manager and ASM Clustered File System

11-Oracle Restart and Grid Infrastructure for Single Instance – New clustering feature of 11GR2

Arup Nanda -Oracle 11g Release 2 is Finally Out

12-Installation Fixup script – New Installation GUI feature of 11GR2

Amit Bansal – 11gR2:What if Oracle gives you Kernel parameter fixup script

13-Step by step 11gR2 Database Installation with ASM on OEL5

Amit Bansal-11gR2 Database Installation with ASM on OEL5

14-How to install single 11GR2 RAC instance with ASM using Grid Infrastructure Software?

Charles Kim-Single Node RAC Grid Infrastructure Installation With Oracle Database 11g Release 2

15-ASM Dynamic Volume Manager and ASM Cluster File System – New Server Manageability feature of 11GR2

Surachart Opun – ASM (DVM) & ACFS by command-lines

16-Deferred_Segment_Creation- New database management feature of 11GR2

Christian Antognini-Deferred Segment Creation

17-How to compate execution plans with dbms_xplan.diff_plan_outline – New 11G feature

Optimizer Magic-What’s Changed between my New Query Plan and the Old One?

Blogroll Report 04/09/2009 – 11/09/2009–>

September 8, 2009

Blogroll Report 21/08/2009 – 28/08/2009

Filed under: Blogroll Report — coskan @ 12:04 pm

<—- Blogroll Report 14/08/2009 – 21/08/2009

1-Workaround for LOB Concatenation performance problem

Dion Cho- Reducing CLOB concatenation

2-How to use flashback and guaranteed restore points for Data Guard?

Vitaliy Mogilevskiy-Using Flashback Database to strengthen Data Guard Setup

3-Possible reasons for changing bind variable names (read the comments)

Jonathan Lewis- Quiz Night-2

4-Detecting low memory starvation on Red Hat <5 Linux x86-32bit

Martin Decker -Out-of-Memory killer on 32bit Linux with big RAM

5-SUMDELTA$ table is not purged when MVIEW base table is using Direct path insert

H.Tonguc Yilmaz -Materialized views and sys.sumdelta$ UPDATE-DELETE performance

6-Tuning SQL*Net message from dblink with USE_HASH hint

Marko Sutic- SQL Tuning – using USE_HASH hint – dblink issue

7-New infiniband monitoring with OSWatcher

Husnu Sensoy -Full Coverage in Infiniband Monitoring with OSWatcher 3.0: IB Monitoring

8-Workaround for setting maxtrans for indexes in 10G

Jonathan Lewis- Index Explosion-3

9-How to detect violating rows for constraints

Shailesh Mishra -Constraints: How to resolve the duplicated primary key exceptions

10-Diagnosing “latch: cache buffer chains “

Tanel Poder -latch: cache buffers chains latch contention – a better way for finding the hot block

11-How to use Oracle Q-quote with dbms_advanced_rewrite.

Kerry Osborne-Quotes in Strings (Oracle Q-quote)

12- Does oversize of datatype VARCHAR2 causes performance problem?

Mohammad Abdul Momin Arju – Does oversize of datatype VARCHAR2 causes performance problem

13- Workarounds for ORA-00600 ORA-12085 ORA-03113 with GV$SQL and GV$SQL_PLAN

Martin Widlake-RAC GV$SQL type Bugs

14-Issues while validating database backups with restore database validate command

Miladin Modrakovic-Bugman ( RMAN ) validate restore “bug”

Oracle Streams—-

15-How to use Oracle Advanced Queuing Buffered Messages (demo for exchange messages between 2 queues in different databases.

We do streams-Oracle AQ Buffered Queues 101 (Part 2)

16-Simple way to fix propogations errors with streams

We do streams- Propagation Error And Exception Queue Management

17- How to do data comparison between tables using DBMS_COMPARISON in 11G

We do streams- Data Comparison with DBMS_COMPARISON

18- Behaviour of fire_once=false triggers with streams

We do streams- Are your triggers triggered by Streams?

19- How to use V$STREAMS_MESSAGE_TRACKING for Tracking LCRs Through a Stream

We do streams- Tracking Streams Changes with V$STREAMS_MESSAGE_TRACKING

Blogroll Report 28/08/2009 – 04/09/2009—- >

September 7, 2009

Blogroll Report 14/08/2009 – 21/08/2009

Filed under: Blogroll Report — coskan @ 4:39 pm

<—- Blogroll Report 07/08/2009 – 14/08/2009

I am back from holiday and I think did my best to filter these blog posts from large number of blog posts, when I am away even Oracle released 11.2 :). Next time I won’t take a holiday longer than 10 days. I will cover the missing weeks one by one instead of 3 weeks in 1 post.

1- Using REGEXP_LIKE with outer joins ?

Peter Scott -Slightly Fuzzy Lookups

2- How to use alert log for error trends ?

Karl Arao – Knowing the trend of Deadlock occurrences from the Alert Log

3-How to read treedump for what happened in indexes ?

Jonathan Lewis – Treedump

4- Using alter system kill session in procedure

John Hallas-Procedure to kill a session

5- How to get the date for the last day of the previous month?

Jonathan Lewis - Why test ?

6- How to bulk insert cursor data into a table ?

Liang Gang Yu-BULK INSERT cursor’s data INTO A TABLE – Oracle10g, 11g

7- How to use UTL_COMPRESS to compress files ?

Steve Callan-Compressing files in Oracle

8- When you lost your spfile?

Matt Canning-Dealing with a lost SPFILE

9- Transparent Application Failover (TAF) for Data Guard ?

Uwe Hesse – Connect Time Failover & Transparent Application Failover for Data Guard

10 – Using backup copy to move files after changing the recordsize on filesystem ?

Don Seiler-Moving Oracle Datafiles to a ZFS Filesystem with the Correct Recordsize

11- What are Synthetic Commits and Rollbacks?

Christian Antognini - Synthetic Commits and Rollbacks

12 -ORA-16069 after switchover?

Don Seiler – ORA-16069? You May Need A New Standby Controlfile

13 -Possible solution for slow network connection in 11G ?

Marcin Przepiorowski – Slow network connection in 11g

14 -How to escalate Oracle SR ?

Chris Warticki- Support Escalation Process…Again!

15-How to adjust optimizer_index_cost_adj if you really want to use it ?

Richard Foote – The CBO and Indexes: OPTIMIZER_INDEX_COST_ADJ Part III

16 -How to track DDL changes in 11G ?

Miladin Modrakovic – Tracking DDL changes in 11g

17 -How to do Oracle Cross-Platform Migration with Minimal Downtime ?

Don Seiler – HOWTO: Oracle Cross-Platform Migration with Minimal Downtime

18 -How to use Active Data Guard in 11G ?

Jim Czuprynski - Using Oracle 11g’s Active Data Guard and Snapshot Standby Features

19 -How to install Oracle Client on unsupported OS ?

Marko Sutic – How to install Oracle Client 11g on Windows 7?

20 -How to use unix EXPECT utility to simulate non-interactivity for interactive only installations?

Advait Deo – Spawn, Expect, Send and Interact

Blogroll Report 21/08/2009 –28/08/2009—->

The Silver is the New Black Theme Blog at


Get every new post delivered to your Inbox.

Join 193 other followers