Finally I am able to finish the missing weeks. Oracle released 11G Release 2 this week , and as you might guess most of the posts were about 11GR2 new features. Virag Sharma, Amit Bansal ,Arup Nanda (as usual) and Amis Group were the ones who won the race of posting about new features. Some of them were excerpt from documentation but still nice to know so I put them in my list. I also tried to put the posts under the correct topic of official guide so you can find your way in new features documentation.
1-How to use DBMS_UTILITY ?
Aman Sharma – DBMS_UTILITY, A Good Helping Hand For A DBA….
2-Select for update and Redo Generation
Aman Sharma –Select For Update A DML, Yes It Is….
3-How to perform easy math in Unix
John Hallas – Performing calculations in unix
4-Using database resident connection pooling with Perl
Rajeev Ramdas Thottathil – Perl and database resident connection pooling
5-Security issues with JAVA_ADMIN role
Paul M Wright – JAVA_ADMIN to OSDBA
6- Securing the Data Dictionary O7_dictionary_accessibility parameter
James Koopmann – Oracle 11g Security – Securing the Data Dictionary
7- How histogram gathering works when first N character are same?
Hemant K Chitale – Histograms on “larger” columns
8-Effects of OPTIMIZER_INDEX_CACHING parameter
Richard Foote-OPTIMIZER_INDEX_CACHING Parameter
9-How does response time increase while throughput is also increasing (Don’t miss comments)
Jonathan Lewis-Queue Time
10-How to use Linux /proc filesystem to get Oracle trace directory
11-How to install BBED
Steve Callan – Installing Oracle Block Browser and Editor tool (bbed)
11GR2 New Features Posts
1-Moving the database audit trail tables out of the SYSTEM tablespace to a different tablespace. – New security feature of 11GR2
2-Single Client Access Name (SCAN)- New clustering feature of 11GR2
3-Edition Based Redefinition – New availability feature of 11GR2
4-Recursive With Clause – New Business Intelligence and Datawarehousing feature of 11GR2
5-Flash Cache – New Database Management feature of 11GR2
Marco Gralike-Oracle RDBMS 11gR2 – Flash Cache
6-Preprocessing Data for ORACLE_LOADER Access Driver in External Tables- New Business intelligence and Datawarehousing feature of 11GR2
7-LISTAGG-New Business intelligence and Datawarehousing feature of 11GR2
8-Enhance CREATE or REPLACE TYPE to Allow FORCE-New availability feature of 11GR2
9-Improved Deinstallation Support With Oracle Universal Installer- New clustering feature of 11GR2
Arup Nanda-Oracle 11g R2 Features
10-ASM Dynamic Volume Manager and ASM Cluster File System – New Server Manageability feature of 11GR2
11-Oracle Restart and Grid Infrastructure for Single Instance – New clustering feature of 11GR2
Arup Nanda –Oracle 11g Release 2 is Finally Out
12-Installation Fixup script – New Installation GUI feature of 11GR2
13-Step by step 11gR2 Database Installation with ASM on OEL5
Amit Bansal-11gR2 Database Installation with ASM on OEL5
14-How to install single 11GR2 RAC instance with ASM using Grid Infrastructure Software?
15-ASM Dynamic Volume Manager and ASM Cluster File System – New Server Manageability feature of 11GR2
Surachart Opun – ASM (DVM) & ACFS by command-lines
16-Deferred_Segment_Creation- New database management feature of 11GR2
Christian Antognini-Deferred Segment Creation
17-How to compate execution plans with dbms_xplan.diff_plan_outline – New 11G feature
Optimizer Magic-What’s Changed between my New Query Plan and the Old One?