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

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