Coskan’s Approach to Oracle

November 22, 2009

Blogroll Report 13/11/2009-20/11/2009

Filed under: Blogroll Report — coskan @ 9:41 pm

<—- Blogroll Report 06/11/2009 – 13/11/2009

Here is your long reading list for starting a good week

1-How does compress parameter work with traditional export / import?

2-Why Isn’t Oracle Allocating More Parallel Slaves?
Kellyn Pedersen-Why Isn’t Oracle Allocating More Parallel Slaves?

3-How to set up external authentication via Radius on Active Directory?
Ronny Egner-Authentificate Oracle user passwords against Active Directory using Radius


5-Bug on Running Parallel Query with Order by on already sorted data causes problem?
Christo Kutrovsky-Oracle Parallel Query Sorting and Index Creation Performance Problems

6-How to set up OS Authentication ?
James Koopman-Securing Client Connections: OS Authentication

7-How to hammer your CPU ?
John Hallas-Maxing out CPUs – script

8-Chance of having index with blevel>=4
Martin Widlake-Depth of Indexes on VLDBs

9-How to disable unnecessary hints and keep the necessary ones only after upgrade?
Optimizer Team- What should I do with old hints in my workload?

10-How to convert controlfiles to be oracle managed files?
Neil Johnson-Converting Control Files to be Oracle Managed Files

11-How to add cached memory to free memory on linux ?
Kevin Closson-Linux Free Memory: Is It Free Or Reclaimable? Yes. When I Want Free Memory, I Want Free Memory!

12-How to overcome package owners defaults temp tablespace problem (authid current_user)?
Kellyn Pedersen-Utilizing Separate Temp Tablespace

13-“Explain plan for” reports wrong plan because of implicit conversion of bind variables
Tanel Poder-Explain Plan For command may show you the wrong execution plan – Part 1

14-How to change index hints with new index hint format automatically in sql profiles?
Kerry Osborne-Fixing Bad Index Hints in SQL Profiles (automatically)

15-How to promote partition pruning with applying predicates into using clause of merge statement
David Aldrid-Applying Predicates and Partition Pruning to MERGE Target Tables

16-If a stored subprogram fails with an unhandled exception, PL/SQL does not roll back database work done by the subprogram.
Gary Myers-The amazing disappearing row trick

17-How to find reasons excessive LIO?
Tanel Poder-Finding the reasons for excessive logical IOs

18-How to configure direct NFS on Solaris
Glenn Fawcett-Direct NFS access to Sun Storage 7410 with Oracle 11g and Solaris… configuration and verifcation

19-Oracle and NFS compilation of Kevin Closson
Kevin Closson-Words About Oracle Direct NFS On Sun Storage 7410 And Chip Multithreading Technology (CMT) For Oracle Database 11g Release 2.

20-How to get report of PL/SQL codes using buggy exception
Timo Raitalaakso-PLSQL Warnings

21-How does changing password profile works when the password expire period is already activate?
Robert Geiger-Analysis of Oracle password expiry

22-How to configure FSFO(Fast Start Failover) for 11G Data Guard with Dataguard Broker?
Jim Czuprynski-Fast-Start Failover in Oracle 11g Data Guard

23-How to use transportable tablespaces for moving tablespace from 9i to 11G?
Luis Moreno Campos-How to transport a tablespace from 9i to 11g

24-Orion tool only works when full path is given-Bug on 11GR2
Kevin Closson-Oracle Database 11g Release 2 Includes The Orion I/O Test Tool, But You Better Get That Full Path Name Right.

25-Alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring
Lucas Jellama-Alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring

26-Action to take without applying CPU for vulnerable packages
Paul M Wright-DAMS for Post and PRE-CPU Change Management

27-Why revoking Public execute from a package is not enough for vulnarable packages?
Pete Finnegan-Revoking PUBLIC Execute on SYS.DMP_SYS

28-Online free MSSQL 2008 training for Oracle DBA’s
MSDN-SQL Server 2008 for Oracle DBA

Blogroll Report 20/11/2009 – 27/11/2009 –>

1 Comment »

  1. […] Blogroll Report 20/11/2009-27/11/2009 Filed under: Blogroll Report — coskan @ 7:04 pm <—- Blogroll Report 13/11/2009 – 20/11/2009 […]

    Pingback by Blogroll Report 20/11/2009-27/11/2009 « Coskan’s Approach to Oracle — December 12, 2009 @ 7:04 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: Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

Blog at

%d bloggers like this: