Coskan’s Approach to Oracle

September 9, 2009

Blogroll Report 28/08/2009 – 04/09/2009

Filed under: Basics — coskan @ 2:16 am

<—- Blogroll Report 21/08/2009 – 28/08/2009

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

Kevin Closson – Using Linux /proc To Identify ORACLE_HOME and Instance Trace Directories.

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

Virag Sharma-11G R2 New Feature : Purge audit trail records using DBMS_AUDIT_MGMT

2-Single Client Access Name (SCAN)- New clustering feature of 11GR2

Virag Sharma – Oracle 11g Release 2 (11.2 ) New Features : SCAN – Single Client Access Name

3-Edition Based Redefinition – New availability feature of 11GR2

Virag Sharma -Oracle Database 11g Release 2 New Features : Edition based redefination

4-Recursive With Clause – New Business Intelligence and Datawarehousing feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – goodbye Connect By or: the end of hierarchical querying as we know it

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

Marco Gralike-Oracle RDBMS 11gR2 – New PREPROCESSOR Syntax for External Table Use

7-LISTAGG-New Business intelligence and Datawarehousing feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – LISTAGG – New aggregation operator for creating (comma) delimited strings

8-Enhance CREATE or REPLACE TYPE to Allow FORCE-New availability feature of 11GR2

Lucas Jellema-Oracle RDBMS 11gR2 – alter or replace user defined types even when there are dependencies

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

Arup Nanda – ASM Dynamic Volume Manager and ASM Clustered File System

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

Amit Bansal – 11gR2:What if Oracle gives you Kernel parameter fixup script

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?

Charles Kim-Single Node RAC Grid Infrastructure Installation With Oracle Database 11g Release 2

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?

Blogroll Report 04/09/2009 – 11/09/2009–>

About these ads

2 Comments »

  1. [...] Blogroll Report 28/08/2009 – 04/09/2009—- > Comments (1) [...]

    Pingback by Blogroll Report 21/08/2009 – 28/08/2009 « Coskan’s Approach to Oracle — September 9, 2009 @ 2:19 am

  2. [...] Blogroll Report 04/09/2009 – 11/09/2009 Filed under: Blogroll Report — coskan @ 6:28 pm <—- Blogroll Report 28/08/2009 – 04/09/2009 [...]

    Pingback by Blogroll Report 04/09/2009 – 11/09/2009 « Coskan’s Approach to Oracle — September 19, 2009 @ 6:07 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 193 other followers

%d bloggers like this: