Coskan’s Approach to Oracle

December 18, 2009

Blogroll Report 27/11/2009-04/12/2009

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

<—- Blogroll Report 20/11/2009 – 27/11/2009

1-How to limit number of CPU for an instance with instance caging feature of 11GR2 ?
Christian Antognini-Instance Caging

2-How to diagnose undo problem ?
Kellyn Pedersen-Undo Brain Damage

3-How to solve invalid registry objects problem with upgrade and migration ?
Surachart Opun-Invalid Objects on SYS and ORA-04063: package body “SYS.DBMS_REGISTRY_SYS” has errors

4-How to sort Collections ?
Adrian Billington-Sorting Collections

5-How does Oracle Flash Cache work in 11GR2?
Guy Harrison-More on the Database Flash Cache

6-Alternative workarounds for plans suffering from bind peeking?
Martin Widlake-Dealing with Bind Issues

7-How to Create a Database Link in Another User’s Schema without password hacking?
Neil Johnson -How to Create a Database Link in Another User’s Schema

8-Workaround for Result Cache for Ref Cursor returning PL/SQL codes
Asanga Pradeep-Result Cache for Ref Cursor returning PL/SQL codes

9-How to unwrap PL/SQL?
Pete Finnegan-Unwrapping PL/SQL

10-How to solve interrupted drop disk from diskgroup in ASM ?
Martin Bach-Do not shut down ASM when dropping a disk

11-Diagnosing and solving a multipath problem with ASM. ([Device or resource busy] [16])
Martin Bach-Let there be multipathing (when there wasn’t before)

12-How to use V$SQL_MONITOR and V$SQL_PLAN_MONITOR views ?

13-How to optimize table functions by cardinality feedback ?
Joze Senegacnik-Table Expressions, Cardinality, SYS_OP_ATG and KOKBF$

14-Service name operation logged in alert log during Data Pump on RAC
Surachart Opun-DATAPUMP with SYS$SYS.* service_names

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

December 12, 2009

Blogroll Report 20/11/2009-27/11/2009

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

<—- Blogroll Report 13/11/2009 – 20/11/2009

1-How does ora_hash function works ?
Jonathan Lewis-ora_hash function

2-How to gather specific histogram size for a column?
Hemant K Chitale-SIZE specification for Column Histograms?

3-How to manage Oracle HAS in 11GR2?
Surachart Opun-Disable/Enable Automatic startup Oracle HAS

4-How does fast refresh of on-commit materialized views works on 11GR2?
Alberto Dell’era-11gR2: new algorithm for fast refresh of on-commit materialized views

5-Database Statistics Metalink notes compilation
Anthony Shorten-Keeping your database statistics up to date

6-How does SQL92_Security parameter works?
John Hallas-What does the SQL92_SECURITY parameter actually do?

7-How to use Binding sparse arrays in a FORALL statement?
Steven Feuerstein-Binding sparse arrays in a FORALL statement?

8-How does locally managed tablespaces work and third type of locally managed tablespaces?
Joel Goodman-How Good is your “Local” Management?

9-Make most out of partitions
Martin Widlake – Assisting Partition Exclusion – Partitions for Performance

10-How to use RMAN with DBMS_PIPE – managing rman via SQLPLUS?
Joel Goodman-The RMAN “PIPE” Interface

11-How does Automatic Degree of Parallelism work in 11GR2?
Uwe Hesse-Automatic DOP in 11gR2

12-How CPU costing model works with indexes?
Richard Foote-The CBO CPU Costing Model: Indexes vs. Full Table Scans

13-How to get row count of each partition of a partitioned table?
Jonathan Lewis-Counting

14-How to monitor direct NFS in 11G on Solaris?
Glenn Fawcett-Monitoring Direct NFS with Oracle 11g and Solaris… pealing back the layers of the onion.

15-How does zero size unusable indexes effect execution plans ?
Christian Antognini-Zero-Size Unusable Indexes and the Query Optimizer

16-11G Advanced compression vs basic compression
Luis Moreno Campos-The Difference between Online and Offline compression

17-New features of Result Cache in 11GR2
Uwe Hesse-Result Cache: Another brilliant 11g New Feature

18-Cross Platform upgrade and migration case study for large DB
Marko Sutic-Cross-platform migration – large Oracle 9i db from Solaris 64 to Linux 64

19-Connect-by vs the recursive subquery factoring
Rob Van Wijk-Recursive subquery factoring

Blogroll Report 27/11/2009 – 04/12/2009 –>

November 22, 2009

Blogroll Report 13/11/2009-20/11/2009

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

<—- Blogroll Report 06/11/2009 – 13/11/2009

Here is your long reading list for starting a good week

1-How does compress parameter work with traditional export / import?

2-Why Isn’t Oracle Allocating More Parallel Slaves?
Kellyn Pedersen-Why Isn’t Oracle Allocating More Parallel Slaves?

3-How to set up external authentication via Radius on Active Directory?
Ronny Egner-Authentificate Oracle user passwords against Active Directory using Radius


5-Bug on Running Parallel Query with Order by on already sorted data causes problem?
Christo Kutrovsky-Oracle Parallel Query Sorting and Index Creation Performance Problems

6-How to set up OS Authentication ?
James Koopman-Securing Client Connections: OS Authentication

7-How to hammer your CPU ?
John Hallas-Maxing out CPUs – script

8-Chance of having index with blevel>=4
Martin Widlake-Depth of Indexes on VLDBs

9-How to disable unnecessary hints and keep the necessary ones only after upgrade?
Optimizer Team- What should I do with old hints in my workload?

10-How to convert controlfiles to be oracle managed files?
Neil Johnson-Converting Control Files to be Oracle Managed Files

11-How to add cached memory to free memory on linux ?
Kevin Closson-Linux Free Memory: Is It Free Or Reclaimable? Yes. When I Want Free Memory, I Want Free Memory!

12-How to overcome package owners defaults temp tablespace problem (authid current_user)?
Kellyn Pedersen-Utilizing Separate Temp Tablespace

13-”Explain plan for” reports wrong plan because of implicit conversion of bind variables
Tanel Poder-Explain Plan For command may show you the wrong execution plan – Part 1

14-How to change index hints with new index hint format automatically in sql profiles?
Kerry Osborne-Fixing Bad Index Hints in SQL Profiles (automatically)

15-How to promote partition pruning with applying predicates into using clause of merge statement
David Aldrid-Applying Predicates and Partition Pruning to MERGE Target Tables

16-If a stored subprogram fails with an unhandled exception, PL/SQL does not roll back database work done by the subprogram.
Gary Myers-The amazing disappearing row trick

17-How to find reasons excessive LIO?
Tanel Poder-Finding the reasons for excessive logical IOs

18-How to configure direct NFS on Solaris
Glenn Fawcett-Direct NFS access to Sun Storage 7410 with Oracle 11g and Solaris… configuration and verifcation

19-Oracle and NFS compilation of Kevin Closson
Kevin Closson-Words About Oracle Direct NFS On Sun Storage 7410 And Chip Multithreading Technology (CMT) For Oracle Database 11g Release 2.

20-How to get report of PL/SQL codes using buggy exception
Timo Raitalaakso-PLSQL Warnings

21-How does changing password profile works when the password expire period is already activate?
Robert Geiger-Analysis of Oracle password expiry

22-How to configure FSFO(Fast Start Failover) for 11G Data Guard with Dataguard Broker?
Jim Czuprynski-Fast-Start Failover in Oracle 11g Data Guard

23-How to use transportable tablespaces for moving tablespace from 9i to 11G?
Luis Moreno Campos-How to transport a tablespace from 9i to 11g

24-Orion tool only works when full path is given-Bug on 11GR2
Kevin Closson-Oracle Database 11g Release 2 Includes The Orion I/O Test Tool, But You Better Get That Full Path Name Right.

25-Alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring
Lucas Jellama-Alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring

26-Action to take without applying CPU for vulnerable packages
Paul M Wright-DAMS for Post and PRE-CPU Change Management

27-Why revoking Public execute from a package is not enough for vulnarable packages?
Pete Finnegan-Revoking PUBLIC Execute on SYS.DMP_SYS

28-Online free MSSQL 2008 training for Oracle DBA’s
MSDN-SQL Server 2008 for Oracle DBA

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

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

November 10, 2009

Blogroll Report 30/10/2009-06/11/2009

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

<—- Blogroll Report 23/10/2009 – 30/10/2009

This one is written at Lisbon, after the most amazing concert I have ever seen at this very nice city (If you love Rammstein or you love fire shows, don’t miss their concert, I will definitely be at Wembley )

I am trying to write it on an Apple machine with Portuguese keyboard layout and it is a bit torture for a regular UK layout windows keyboard user.  I hope I did not make a mistake during html editing.

1-Different approach to BCHR

Martin Widlake-Buffer Cache Hit Ratio my guilty Confession

2-Become user privilege in Oracle ?

Paul M Wright-Oracle Identity Integrity

3-Automatic adjustment of CLUSTER_DATABASE_INSTANCES parameter after CLUSTER_DATABASE=FALSE


4-Unnecessary primary bounce step while Increasing the Dataguard Protection Level

Jason Arneil-Increasing the Dataguard Protection Level

5-How to use ACFSUTIL for Snapshots?

Ronny Egner-ACFS Snapshots

6-OCR Mirror Failover bug on NFS and OS Bonding bug with RACVIP

Freek D’Hooge-Two Oracle RAC bugs on the wall, two Oracle bugs. Take one down

7-How to choose passwords ?

Pete Finnigan-One more point on Oracle password crackers

8-How to configure OEM Blackouts ?

Dave Best-Setting EM Blackouts from the GUI and Command Line

9-Changes on Materialized View Logs in 11GR2 (timestamp-based and new commit SCN-based)

Alberto Dell’era-11gR2: materialized view logs changes

10-Using 11gR2 LISTTAG function for Tom Kytes Unindexed Foreign Keys script

Timo Raitalaakso-unindex 11.2

11-ORA-00942 with mixed case table names?

Anand-Table name silly but interesting

12-How to troubleshoot high redo generation growth?

Chen Shapira-The Senile DBA Guide To Troubleshooting Sudden Growth In Redo Generation

13-When foreign key indexes are not necessary?

Jonathan Lewis-Foreign Keys 2

14-Easy to read CRS_STAT output

Orhan Biyiklioglu-crs_stat for mere mortals

15-How to detect Migrated Chained Rows using v$sesstat and how to estimate the impact of them?

Tanel Poder-Detect chained and migrated rows in Oracle Part 1

16-How to choose right filesystem for Oracle on linux?

Ronny Egner-Which file system to choose for running Oracle on Linux

17-Cases where partitioning causes performance problems

Martin Widlake-Partitions are Still Not for Performance – Sometimes

18-How to use RDA Health Check utility for prerequisite check for installations?

Yossi Nixon-RDA – Health Check (HCVE)

19-How to use Open LDAP to store DB connection strings?

Ronny Egner-Storing Oracle database connection strings in OpenLDAP instead of OID

20-Revisited version of Upgrade to 11GWholo story to cover 11GR2

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

21- stop system command on Redhat crashes DB

Frits Hoogland-Do you crash your database on machine shutdown?

22-How to solve manual kernel header update problem on OEL 5 version 4 update?

Vitaliy Mogilevskiy-OEL 5.4 Unresolvable chain of dependencies on kernel-headers

23-How to get client IP from AUD$?

Anand-IP in aud$ table

24-How to use EXP/IMP commands in Datapump with legacy mode?

Oracle Contractors-DataPump Legacy Mode in 11g Release 2

25-How to recover from lost online redo logs with dataguard?

Mahias Zarick-Recover from Lost Online Redo Logs with Data Guard

26-Factors affecting LIO

Harald van Breederode-Explaining the number of Consistent Gets

27-Index space allocation anomalies

Jonathan Lewis-Did you know?

28-FAQ about Flashback Database

André Araujo-Questions you always wanted to ask about Flashback Database…


Blogroll Report 06/11/2009 – 07/11/2009–>

November 3, 2009

Blogroll Report 23/10/2009-30/10/2009

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

<—- Blogroll Report 16/10/2009 – 23/10/2009

1-Solution to ASMLIB creadisk problem with EMC Power Path

Orhan Biyiklioglu-ASMLIB createdisk problem on emcpower devices — solved

2-How to create a database link in another users schema ?

Marko Sutic-Create a Database Link in another user’s schema

3-How DST works for current running sessions?

Freek D’Hooge-Wintertime (again)

4-How join key effects CBO for multi-column joins ?

Randolf Geist-Multi-column joins

5-More on How Intra-Block Row chaining effects with tables with more than 255 columns?

Hemant K Chitale-Some MORE Testing on Intra-Block Row Chaining

6-pros/cons of linux distrubutions for Oracle from DBA perspective

Ronny Egners-Oracle on linux – yes of course – but what linux?

7-What happens when you drop table during select operation?

Uwe Hesse-Dropping a table during SELECT

8-How to tune kernel settings for Linux-x86_64 Error: 28: No space left on device?

Surachart Opun-Shared Memory Tuning: startup database – ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device

9-How to move datafiles in ASM with ASMCMD CP command?


10-Tom Kyte’s Favourites from 11GR2 New Features

Tom Kyte-Looking at the New Edition

11-How partitioning can cause bad performance on wrong partition implementations?

Martin Widlake-Partitions are Not for Performance

12-New semantic hints on 11GR2 ?

Rob Van Wijk-Three new “hints”

13-How to apply PSU for ?

John Hallas-PSU for

14-How to find waiters with oradebug in 11GR2 ?

Miladin Modrakovic-Find waiter with Oradebug 11gR2

15-How to install TOra on Ubuntu 9.10 ?

Brad Hudson-Installing TOra with Oracle Support on Ubuntu 9.10 (Karmic Koala)

16-Reasons to move 11GR2 ?

Kerry Osborne-11g Release 2 Technology Day – Dallas Cowboy Stadium

17-Netbackup 6.5.4 does not work with 11GR2

Jason Arneil-Netbackup 6.5.4 and Oracle 11gR2

18-Ways to copy schema stats from one schema to another schema?

Ronny Egner-How to copy schema stats from one schema to another schema

19-All about checkpoints

Harald Van Breedore-Checkpoint presentation presented at the RAC SIG

20-How to recover from crashed ASM disk in normal/high redundancy ?

Ronny Egner-ASM resilvering – or – how to recover your crashed cluster – Test no 5

21-Logging “log file parallel write” relationship and nologging with dataguard

Jonathan Lewis-logging


Blogroll Report 30/10/2009 – 06/11/2009–>

October 26, 2009

Blogroll Report 16/10/2009-23/10/2009

Filed under: Blogroll Report — coskan @ 11:53 pm

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

1-How Intra-Block Row chaining effects consistent gets with tables over 255 columns ? (read Oracle L question as well)

Hemant K Chitale – Some Testing on Intra-Block Row Chaining

2-Consolidation Story of 15 Oracle Databases into 5 RAC nodes

Husnu Sensoy-“How to Achieve All in One with Oracle 11g” Material

3-Oracle Backup Recovery Best Practices

Husnu Sensoy -“Oracle Database Backup-and-Recovery Best Practices and New Features” Material

4-Min Privilege required to run FLUSH_DATABASE_MONITORING_INFO

Martin Widlake -Privileges required to FLUSH_DATABASE_MONITORING_INFO

5-How to see uncommitted transactions ?

Miladin Modrakovic- Uncommitted Transactions

6-Shell Scripting tips summary from OOW09

Chen Shapira-Lessons From OOW09 #1 – Shell Script Tips

7-How to convert Physical Standby into Logical standby when DG Broker in place?

Grégory Guillou-Turning a Physical Standby and its Broker into a Logical Standby

8-New Grid Infrastructure ASM Installation and Scheduler features summary of 11GR2

Jim Czuprynski-Oracle Database 11g Release 2 New Features Summary, Part 1

9-How to escalate an Oracle DB user with CREATE TABLE privilege to OSDBA?


10-How to start a Job When a File Arrives on a System – 11GR2 New Features File Watcher?

Ittichai Chammavanijakul-11gR2 New Feature – File Watchers

11-How to use DBFS-11GR2 New features Database File System?

Ittichai Chammavanijakul-11gR2 New Feature – DBFS Database File System

12-How to Setup 10gRAC with Solaris (IPMP)?

Surachart Opun-How to Setup 10gRAC with Solaris (IPMP)

13-Activating supplemental logging is not replicated to standby db

Freek D’Hooge -Multiple standby databases and supplemental logging

14-Global indexes and partition maintenance operations

David Kurtz-Partition Maintenance with Globally Partitioned Indexes

15-Where to use XML DB?

Marko Gralike-Oracle XML(DB) Use Cases

16-How to reduce redo generation for updates on bitmap indexed columns?

Jonathan Lewis- Bitmap Updates

17-Possible cause of ORA-01008: not all variables bound ?

Marko Sutic-Cursor_sharing=FORCE causing “ORA-01008: not all variables bound” error on Oracle

18-How to use RMAN for moving datafiles between ASM diskgroups?

Surachart Opun-Moving datafile (system) from one ASM Diskgroup to Another

19-Solutions for DTS prblems with DBMS_SCHEDULER

Freek D’Hooge-switching to wintertime

20-IF a package is created such that it is executed with invokers rights then roles are seen in PL/SQL.

Martin Widlake-Accessing Roles in stored PL/SQL

21-Solution to ORA-24062

Frank Van Bortel-ORA-24062 ( Subscriber table inconsistent with queue table)

22-How can index clustering factor can be smaller after index rebuild?

Jonathan Lewis-Quiz Night

23-APPEND hint with values clause behavior in different Oracle versions

Christian Antognini-Hints for Direct-path Insert Statements

24-New flashback query through DDL for Flachback Archive

Uwe Hesse-“Total Recall”: Brief introduction into Flashback Data Archive

25-How does edition based redefinition works?

Jean Pierre Dijcks-Edition Based Redefinition

26-How new density works with frequency histograms?

Alberto Dell’Era-CBO: NewDensity for Frequency Histograms,11g- (densities part IV)


Blogroll Report 23/10/2009 – 30/10/2009 —>

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

October 14, 2009

Blogroll Report 02/10/2009-09/10/2009

Filed under: Blogroll Report — coskan @ 3:21 pm

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

Everybody is at OOW09 and I am not, this is not fair  :( .  I hope next year I will make it and meet with people at bloggers meeting.

1-Grid control patch fails when you have “/oracle/product” in your home on Windows

Marcin Przepiorowski-What can happen if you have “\p” in your ORACLE_HOME

2-How to take rolling forward image copy backup?

Asanga Pradeep-Rolling Forward Image Copy Backups

3-Oracle password solver – Can be useful if you dont know the password but the hash

Pete Finnigan-60 million password hashes/second Oracle password cracker available

4-How to create database service on 11gR2?

Surachart Opun-How to create Oracle Service on 11gR2

5-Possible solution “for unable to extend segment in undo tablespace”?

Jonathan Lewis- Undone

6-Problems with data recovery advisor in 11G

Luis Moreno Campos-Advanced Corruption Resolution with RMAN

7-How to do cascaded update on child tables?


8-How to do base conversions to decimal hexadecimal binarc etc?

Thomas Kyte-Base Conversion Routines

9-How to find foreign keys which are not indexed (unindex script)?

Thomas Kyte-Unindexed Foreign Keys

10-How to find who called and what is the caller in a running procedure?

Thomas Kyte-How Can I find out who called me or what my name is?

11-How to unload data to a flat file?

Thomas Kyte-How Can I unload data to a flat file?

12-ORA-01792 at index creation

Timo Raitalaakso-Not overlapping daily

13-How to use Datapump and Diff command for schema comparison?

André Araujo-Free and Easy Schema diff for Oracle

14-What happens when OCR Non-Master cannot see/loose OCR mirror ?

Geert De Paep-Scenario 4: Loss of ocrmirror from the non-OCR MASTER

15-Hash Cluster Problems

Jonathan Lewis-Hash Clusters-2

16-How to do online san storage migration for 11G Rac with ASM?

Ittichai Chammavanijakul-Online SAN Storage Migration for Oracle 11g RAC database with ASM

17-How to configure OLTP with reporting queries using Streams

Alisher Yuldashev-How to configure OLTP with reporting queries

18-Worst Practices for Oracle database security

Pete Finnegan-Oracle Security Worst Practices

19-Interval data type for beginners

Luis Moreno Campos -Everything you wanted to know about INTERVAL datatype but was too guru to ask

20-How to use XStream In ?-New database overall feature of 11GR2

Grégory Guillou-XStream Inbound… A Sample Java Program

21-How to use XStream Out?-New database overall feature of 11GR2

Grégory Guillou-XStream Outbound… A sample Java Program

22-FAQ about XStreams -New database overall feature of 11GR2

Grégory Guillou-My XStream FAQ

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

October 6, 2009

Blogroll Report 25/09/2009-02/10/2009

Filed under: Blogroll Report — coskan @ 7:34 pm

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

Finally, managed to finish this weeks selection. I was in Rotterdam for MSSQL 2008 training and did not have time to read anything.  I am also moving my house this weekend and as you guess also a time consuming issue but after I move I will have a study room which means more stuff to write other than list/index what I read and liked (My Plans depend,  if BT moves my land line quickly otherwise 20 days without internet at home  )

1-MTU size and RAC

Glenn Fawcet-Jumbo Frames with Oracle RAC really does Rock!!

2-Performance impact of functions in SQL

Hemant K Chitale-SQLs in Functions : Performance Impact

3-Solution for ORA-00942 when querying USER_QUEUE_SUBSCRIBERS

Flavio Casetta-ORA-00942 when querying USER_QUEUE_SUBSCRIBERS

4-How to multiply/migrate controlfiles in ASM by restore command?

John Hallas-Managing control files in ASM

5-How to write your queries against dictionary views?

Dion Cho-Tuning query on the fixed table

6- How filtering as much as you can, can help data dictionary table performance?

Martin Widlake-Data Dictionary Performance 2

7-How default user passwords and account statuses behave?

Pete Finnigan - Default Users

8-How to generate grammatically random passwords ?

Pete Finnigan-A grammatically correct random pass phrase generator

9- How to duplicate database via Enterprise Manager-11GR2 new manageability feature?

Luis Moreno Campos-Duplicating a database has never been so easy! (11gR2 new feature)?

10-How to use LNNVL function?

Luis Moreno Campos-Conditional function LNNVL: the bullsh*t detector

11-Questioning the reliability of V$SQL.BUFFER_GETS?

Luke Davies-Over 4 Billion Buffer Gets?

12-What is latency hiding means in real life?

James Morle - Latency Hiding For Fun and Profit

13-Characterset and client and client codepage reletionship (Please Read all the series if you are struggling with different charactersets highly recommended)

Frank Van Bortel - “Special” characters – part IV

14-SYSTEM tablespace does not have RECYCLE_BIN option

Luis Moreno Campos -How many times have I told not to create objects in the SYS schema?


Virag Sharma – Automatic Diagnostic Repository (ADR)

16-What does _smm_isort_cap parameter do ?

Jonathan Lewis - _smm_isort_cap

17-What happens when OCR Master cannot see/loose OCR mirror ?

Geert De Paep-Scenario 3: Loss of OCRmirror from the OCR MASTER only

18-How to install 11GR2 RAC on Linux on VMWare Server 2?

Tim Hall-Oracle 11g Release 2 RAC On Linux Using VMware Server 2

19-Scheduler Related enhancements in 11GR2-New server manageability feature of 11GR2

Tim Hall-New scheduler stuff in 11gR2

20-New enhancements on hierarchical queries with Recursive Subquery Factoring-11GR2 New Feature

Lucas Jellema - Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring

21-How in memory parallel execution works in 11GR2-New Data-New Business Intelligence and Data Warehousing feature of 11GR2?

Maria Colgan-In-Memory Parallel Execution in Oracle Database 11gR2

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

« Newer PostsOlder Posts »

The Silver is the New Black Theme Blog at


Get every new post delivered to your Inbox.

Join 193 other followers