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 ?
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?
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 ?
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?
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
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
3- How to create disk groups with ASMCMD Command Extensions- New Server Manageability Feature of 11GR2
4- ASMCMD Command Extensions- New Server Manageability Feature of 11GR2
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
8- How to configure ACFS for auto-startup – New Server Manageability Feature of 11GR2
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