Coskan’s Approach to Oracle

October 21, 2009

Blogroll Report 09/10/2009-16/10/2009

Filed under: Blogroll Report — coskan @ 11:27 pm
<—- Blogroll Report 02/10/2009 – 09/10/2009

<—- Blogroll Report 02/10/2009 – 09/10/2009

Finally BT managed to re-connect my home broadband and I am ready to give you stale news (yes I was busy again :) ) from blogosphere.

1-Density calculation in Oracle CBO

Alberto Dell’Era-CBO: about the statistical definition of “cardinality” (densities part I)

Alberto Dell’Era-CBO: the formula for the “density” column statistic (densities part II)

Alberto Dell’Era-CBO: “NewDensity” replaces “density” in 11g, (densities part III)

2-How to automate partition maintenance in 10G

Luis Moreno Campos-Automatic Partition Management for Oracle 10g

3-How to configure data guard broker in 11G

Simon Ryan-Configuring Dataguard Broker in 11G

4-Possible solution for PROC-5: User does not have permission to perform a cluster registry operation on this key

Geert de Paep-Scenario 5: Loss of ocrmirror from non-ocr-master – reloaded

5-External table enhancements in 11G (compression,encryption,preprocessor)

Adrian Billinton-external table enhancements in 11g

6-How to list directories with external table preprocessor in 11G?

Adrian Billinton-listing files with the external table preprocessor in 11g

7-How to bypass DBMS_ADVANCED_REWRITE DML restriction?


8-How to solve Authentication Failed!Null on OEM?

Emre Baransel-Authentication Failed!Null

9-How to solve sudoku with recursive subquery dactoring-11GR2 new feature

Anton Scheffer-Oracle RDBMS 11gR2 – Solving a Sudoku using Recursive Subquery Factoring

10-Edition Based Redefinition – 11GR2 new feature

Lucas Jellema-OOW 2009: The killer feature of Oracle Database 11gR2 – Edition Based Redefinition (or database object versioning)

11-How to attach a sql profile to a different statement ?

Kerry Osborne-How to Attach a SQL Profile to a Different Statement – Take 2

12-How to do Blind SQL injection in Oracle ?

Slavik Markovich-Blind SQL Injection in Oracle

13-Alternative Solutions to VLDB backup duration problems

Martin Widlake-VLDB Backups

14-How does statistic gathering effect global temporary tables?

David Kurtz-Global Temporary Tables Shared Statistics Across Sessions

15-Possible solution to ORA-15555 when you are running flashback query?

Shakir Sadikal-ORA-01555: snapshot too old, When Running Flashback Query

16-How to protect data from user DML?

Steve Callan-Protecting Data from Users

17-How does undo redo work with recovery in nutshell?

Jonathan Lewis-Nutshell-1

18-How to use V$row_cache_parent for finding row cache lock holder?

Dion Cho-Finding out the row cache lock holder through V$ view

19-How does AQ notification works in Oracle 11G ?

Luke Davies-AQ Notifications in Oracle 11gR1

20-How to see blocking locks happaned in the past?

Miladin Modrakovic-Blocking locks history

21-How do LOBS and Streams work together ?

Grégory Guillou-Streams LCRs and LOBs

Grégory Guillou-LOB Chunks


Blogroll Report 16/10/2009 – 23/10/2009 –>

The Silver is the New Black Theme Blog at


Get every new post delivered to your Inbox.

Join 193 other followers