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

<—- 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 11.1.0.6)
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 (emd.properties) 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-—>