Coskan’s Approach to Oracle

April 29, 2010

Blogroll Report 12/03/2010 – 19/03/2010

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

<—- Blogroll Report 05/03/2010 – 12/03/2010

1-POC for adding additional VIP network to RAC for isolating the traffic?
Murali Vallath-10gR2 RAC – POC – additional VIP to isolate network traffic

2-How to install 11GR2 on Ubuntu 9.10?
Mike Smitthers-Installing Oracle 11gR2 on Ubuntu 9.10

3-How to install Oracle ACFS on CentOS?
Marcin Przepiorowski-Oracle ACFS on CentOS

4-Adaptive Cursor Sharing behaviour with different cursor_sharing parameter value
Optimizer Development Group-Explain adaptive cursor sharing behavior with cursor_sharing = similar and force.

5-Difference between rebuilding a valid index and an unusable index
Hemant K Chitale-ALTER INDEX indexname REBUILD.

6-How to add EM console into clusterware resource control?
Ronny Egner-Integrate EM Console Startup/Shutdown into Clusterware Control

7-Logical corruption bug with deferrable constraints
Alex Fatkulin- Deferrable constraints in Oracle 11gR2 may lead to logically corrupted data

8-How does SCAN work on 11GR2?
Joel Goodman-Scan you listen to this

9-How to personalize login.sql for different users?
Sean Molloy-conditional login.sql in the SQLPATH

10-How to increase process priority within Oracle with _high_priority_processes?
Kerry Osborne-Increasing Priority of lgwr Process using _high_priority_processes

11-Ora-01555 via DB link is not captured with Ora-1555 trigger
Yu “Denis” Sun-How to find out which session caused ORA-01555?

12-Numa architecture with Oracle
Kevin Closson-You Buy a NUMA System, Oracle Says Disable NUMA! What Gives? Part I.

Blogroll Report 19/03/2010 – 26/03/2010–>

April 23, 2010

Blogroll Report 05/03/2010 – 12/03/2010

Filed under: Blogroll Report — coskan @ 1:06 am

<—- Blogroll Report 26/02/2010 – 05/03/2010

1-How is 11GR2 Grid Infrastructure memory footprint-possible solution to decrease memory
Alex Gorbachev-Oracle 11gR2 Grid Infrastructure — Memory Footprint

2-Oracle Goldengate tutorials installarion and configuration for certain operations
Gavin Soorma-Oracle GoldenGate Tutorials now available …..

3-How to get around corrupted database after dropping OUTLN user in 11G ?
Jonathan Lewis-Dropping OUTLN

4-How to automate to read index treedump via external table ?
Jonathan Lewis-treedump-2

5-Differences between validation types of RMAN backups
Hemant K Chitale-Misinterpreting RESTORE DATABASE VALIDATE

6-Unusual CPU/time consumption during inserts on a table with trigger (scalibility problem related with bug 6400175 in
Christian Antognini-Inserts Experiencing an Increasing CPU Consumption

7-How to sort remained threads problems after converting RAC to single instance
David Marco-Two or more Threads on an Oracle single instance

8-Most important Oracle Enterprise Manager Agent ( parameters
Werner de Gruyter-Top 10 Agent parameters

9-How does row migration effect execution plans via bogus clustering factor?
Markus Winand-Clustering Factor: Row Migration’s Victim

10-How to change ODS password when Grid control is used with OID
Frank van Bortel-Grid Control & OID: a deadly combo

11-How to trace DBCA?
Ronny Egner-How to trace DBCA (>= 10g)

12-How to sort in doubt transactions when official way is not working ?
Kellyn Pedersen-ORA-02050 Remote DB in Doubt? How About Gone for Years??

13-How to use 10G RAC with 11GR2 clusterware?
Ronny Egner-Creating a Oracle 10g Release 2 or 11g Release 1 database on a 11g Release 2 Cluster

14-How to sort free space problem when there is free unbalanced space in asm – ORA-15041
Surachart Opun-ORA-15041 – ASM Disk Group Unbalanced

15-Why does my sql not show up in v$session_longops -possible reasons for time_remaining=0 (how does v$session_longops work) ?
Charles Hooper-V$SESSION_LONGOPS – Where’s My SQL Statement

16-What is the impact of trunc function on an indexed date column?
Charles Hooper-Impact of the TRUNC Function on an Indexed Date Column

17-Effect of filters taking the place of joins in plans
Martin Widlake-Fun with filters

18-How does Cardinality of table collection expression-table function works in 11GR2 ?
Timur Akhmedeev-Cardinality of table collection expression

19-How to sort performance degradation of materialized view fast refreshes on versions after 9i?
Alberto D’ellera-fast refresh of join-only MVs: _mv_refresh_use_stats and locking log stats

20-Degree of Parallelism and partition/subpartition relationship?
Tony Hasler-Parallel Query Distribution Methods

21-How does sample clause work?
Jonathan Lewis-Sample Clause

22-Performance comparison between KEEP DENSE_ RANK and ROW_NUMBER
Jeff Moss-KEEP DENSE_RANK versus ROW_NUMBER – further details

Blogroll Report 12/03/2010 – 19/03/2010-—>

Blog at